Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'nonemployee_contractor'

Non-employee Contractors (NE)


ID Element Name Type Size Values Cycle



Fiscal Year - The fiscal year that this reporting represents:
For the 2021-2022 reporting year fy must be = 32

fy Num 2 Table 9

Cycle - The reporting cycle for which the data is submitted:

9 = August 31st
cycle Num 2 Table 9

LEA, School -Local Education Agency, the unique seven-digit number assigned by the ADE to identify individual county, district, schools, cooperatives, and vocational institutions. The first two digits represent the county, the second two digits represent the district, and the last three digits represent the individual school, for example:

60 = Pulaski County
01 = Little Rock School District
002 = Hall High School
lea Alpha 7 Appendix B,D 9

Vendor NumberThe vendor identification number

vendor_number Alpha 8 9

Job CodeNumber assigned by the ADE to each job assignment performed by a staff person. Only nurse job codes allowed at this time:

454 - LPN - Licensed Practical Nurse
455 - RN - Registered Nurse
457 - RNP - Registered Nurse Practitioner
460 - CNP - Certified Nurse Practitioner
461 - CRNA - Certified Registered Nurse Anesthetist
462 - CNS - Clinical Nurse Specialist
463 - LPTN - Licensed Psychiatric Technical Nurse
465 - CNM - Certified Nurse Mid-wife

job_code Alpha 6 9

DegreeThe highest degree received. (Only degrees for nurses allowed.)

AAS - Associate of Applied Science
ASN - Associate of Science In Nursing
BSN - Bachelor of Science in Nursing
DNP - Doctor of Nursing Practice
DPL - Diploma of Nursing
MSN - Master of Science in Nursing

degree Alpha 4 9

Degree DescriptionDescription of degree

desc_degree Alpha 30 9

Number of Contracted Non-EmployeesThe number of Contracted Non-Employee Nurses (head count) per vendor, job code, degree and status

nbr_contractors Num 4 #### 9

Contracted Non-employee Status - The employment status of the Contracted Non-Employee Nurses

 F - Full Time
 P - Part time

contractor_status Alpha 1 F/P 9

FTEThe Full Time Equivalents (FTE). The FTE must be greater than 0.00

contractor_fte Dec 3,2 #.## 9
No change Added Modified Deleted

Back to List