SPAHRS File Layout Independent Contract Upload Name: Size: Independent Contract Upload 2300 bytes Key Length: Comments: * XX.PROD.PH.AXXXX.F070.PH7808 (file name)
Field DATA Field No Field Name - Description SPAHRS AGENCY NUMBER A unique identifier for a Mississippi State Government Agency. CONTRACTOR TYPE Independent Contractor APPROVAL ROUTE Category of contract Size Usage From Thru Format/Constant/Remarks
1 2 3
4 2 2
C C C
1 5 7
4 6 8 must equal 'IC' see attachment
4
SSN/VENDOR Identification of the contractor. ORIGIN START DATE Date of original contract which will never change even on renewal. ORIGIN END DATE Agreement end date which does not change over a period of time. CONTRACT SERVICE TYPE Identifies the type of service performed. AGREEMENT AMOUNT The total amount from the contract agreement CONTRACTUAL SERVICES AMT The requested expenditure allocated to contract services
11
C
9
19
must be valid Vendor number for Independent Contractor and Tax Identification Number for Contract Worker in SAAS
5
8
N
20
27
YYYYMMDD
6
8
N
28
35
YYYYMMDD
7
3
C
36
38
8
11
N
39
49
9
11
N
50
60
see attachment implied decimal. $ 25,000.00 will be entered as 00002500000 implied decimal. $ 25,000.00 will be entered as 00002500000
SPAHRS File Layout IC Contractors.xls
Last Updated 06/19/2009
Page: 1 of 7
SPAHRS File Layout Independent Contract Upload Name: Size: Independent Contract Upload 2300 bytes Key Length: Comments: * XX.PROD.PH.AXXXX.F070.PH7808 (file name)
Field DATA Field No Field Name - Description GENERAL FUND PCT The percent of the requested amount monies allocated from the total contract. FEDERAL FUND PCT The percent of the requested amount monies allocated from the total contract. OTHER FUND PCT The percent of the requested amount monies allocated from the total contract amount. NUMBER OF PERSONNEL The number of contract personnel requested by the requesting Agency. PROPRIETORSHIP Indicates if a contractor is classified as a (I) Individual or (C) company SERVICE DESCRIPTION Detailed description of contractual services to be performed. JUSTIFICATION Assessment of current personnel records. QUALIFICATION Description of qualifications that make it best suited to perform this task. Size Usage From Thru Format/Constant/Remarks
10
3
N
61
63
10 % will be entered as 010 25% will be entered as 025 & 100% will be entered as 100. 10 % will be entered as 010 25% will be entered as 025 & 100% will be entered as 100. 10 % will be entered as 010 25% will be entered as 025 & 100% will be entered as 100.
11
3
N
64
66
12
3
N
67
69
13
5
N
70
74
5 persons are entered as 00005
14
1
C
75
75
'I' = individual
'C' company
15
700
C
76
775
16
700
C
776
1475
User can enter up to 700 character s to describe service to be provided User can enter up to 700 characters to justify the need for hiring contractor User can enter up to 350 characters to describe qualifications needed to perform the task
17
350
C
1476
1825
SPAHRS File Layout IC Contractors.xls
Last Updated 06/19/2009
Page: 2 of 7
SPAHRS File Layout Independent Contract Upload Name: Size: Independent Contract Upload 2300 bytes Key Length: Comments: * XX.PROD.PH.AXXXX.F070.PH7808 (file name)
Field DATA Field No Field Name - Description DISAPPROVE CONSEQUENCE Consequences of the contract being disapproved. FILLER Blank field for future expansion. Size Usage From Thru Format/Constant/Remarks
18
350
C
1826
2175
User can enter up to 350 characters to provide reason for disapproval leave this blank do not enter data in this field
19 20 21
125 0 0
C
2176 2301 0
2300 2300 2300
XX = AGENCY PREFIX "A" REQUIRED CHARCTER XXXX = SPAHRS AGENCY NUMBER PH7808 = FILE NAME
SPAHRS File Layout IC Contractors.xls
Last Updated 06/19/2009
Page: 3 of 7
SPAHRS IC Contract Approval Route Codes
Approval Route Codes
Code
A1 A2 C2 E1 E2 F1 F2 I1 I2 L1 L2 P1 S2 T1
Description
STATE AUDITOR - SPB APPROVAL REQUIRED STATE AUDITOR - NO SPB APRPOVAL REQUIRED INTER-AGENCY CONTRACT (ROUTE: OPTIONAL AGENCY APPROVAL) EXCLUDE SERVICES (CONTRACTS ROUTED TO PSCRB) EXCLUDE SERVICES - NO PSCRB APPROVAL REQUIRED DFA - SPB APPROVAL REQUIRED DFA - NO SPB APPROVAL REQUIRED INFORMATION TECHNOLOGY SERVICES (CONTRACTS ROUTED TO SPB) INFORMATION TECHNOLOGY SERVS.(CONTRACTS NOT ROUTED TO PSCRB ATTORNEY GENERAL'S OFFICE (CONTRACTS ROUTED TO SPB) ATTORNEY GENERAL'S OFFICE (CONTRACTS NOT ROUTED TO SPB) STATE PERSONNEL BOARD (CONTRACTS ROUTED TO SPB) SYSTEM APPROVED AUTOMATICALLY NOTIFY STATE PERSONNEL BOARD OF TERMINATION-KC
Last Updated 06/19/2009
Page 4 of 7
SPAHRS File Layout IC Contract Service Types
Contract Service Types Service Type ACC ACT AC1 AC2 ADM ADV AGR ANI ANS APP ARC ARE ART ATH ATT AUC AUD BAR BRO BUS BUT CAR CBK CHI CLA CLK CLL CN1 CN2 CN3 CON COS COU CSW DEN DFI DIE DRA DRU EDU ELE ELT ENG ENT ESC EVC EVL EXP FAG Description Accountants Accounting Technician Actors Actuaries Administrative Assistant Advertising related occupations Agricultural related occupations Animators Answering service Appraisers Architects Art Evaluators Artisan Athletic Event Officials Attorneys Auctioneers Auditors Barbers Broadcasters Bus Drivers Butchers Carpenters Custodial Bank Child Care occupations Claims Adjustors/Processors Clerks Calligrapher Construction - Building Construction - Road Construction - Other Consultants Cosmetologists Court Reporters Customer Service Worker Dentists Deaf Interpreters Dieticians Drafters Drug Testing Educational Consultants Electricians Election Task Force Personnel Engineers Entertainers MESC-Computer Services Evacuation Consultant Evaluators Expert Witnesses Fiscal Agent
Last Updated 06/19/2009
Page 5 of 7
SPAHRS File Layout IC Contract Service Types
FA1 FA2 FA3 FA4 FIN FIS FLY FOR FUN GRA HEA IFS INF INP INS ISP IT1 IT2 IV1 IV2 IV3 LAN LA1 LA2 LEG LEO LIB MAN MED MEQ MIC MOD MPF MSE MSS MUS NEW NU1 NU2 NU3 OFF OPT OTH PAI PCW PFA PHM PHO PHY PIL PLG POL
Facility - Prisons Facility - Schools Facility - Office Building Facility - Other Financial Advisors Fishery related occupations Flying Services (Spraying) Forestry related occupations Funeral or Mortuary Services Graphic Designers Health Care occupations Institutional Food Services Information Tech Services (computer-related occus. Inspectors Instructors Information Specialist Interpreters Interior Designers Inventory Officers Investigators Investment Managers Land Surveyors Laboratory Testers Laborers Legal Services Law Enforcement Librarians Managers Medical personnel Preventive Maint. of Equipment and Major Appliance Microfilming/copying services (priced per unit) Moderators Personnel --Maintain Physical Facilities & Grounds Preventive Maint./Repair/Install of Special Equip. Preventive Maint.- Spec. Safety/Security/Elec Equi Musicians Newspaper Clipping Services Nurses Nurses, Licensed Practical Nurse Practitioners Office Assistants Optometrists Other (Miscellaneous occupations) Painters Prior Year Contract Worker DFA Pilots Pharmacists Photographers Physicians Pilots Paralegals Polygraph Services
Last Updated 06/19/2009
Page 6 of 7
SPAHRS File Layout IC Contract Service Types
PRD PRO PSL PST PSY PUB RAD REC REG REP ROD SCI SEC SEU SOC SPE SPP STI SUR TDL TEA TEC TEM TES THP TOW TRN TRS TRV TSP TYP TYS UTL VET WAR WRI X29
Producer Professional - Other Personnel Personnel Technician Psychologists Public Relations Radio Dispatchers Receptionist/Switchboard Operators Regulatory Reporters Rodeo participants Scientists Secretaries Security Service Workers Social Workers Speakers Speech Pathologists Student Interns Surveyors Temporary Day Laborers Teachers Technicians Temporary Services Test Monitors/Vendors Therapists Tower Observers Trainers Transportation Travel Counselors Transcriptionists Typists and Typewriting-machine Operators Typesetting (no printing) Utility Rate Experts Veterinarians Warehouse Workers Writers INTER-AGENCY CONTRACT
Last Updated 06/19/2009
Page 7 of 7