Database Schema for Handbook 2024-2025

Back to List
View Source Document for Table 'nonemployee_contractor'

Finance - Contracted Non-Employee (NE)

[nonemployee_contractor]

ID Element Name Type Size Values Cycle

Key

NE0010

Fiscal Year - The fiscal year that this reporting represents:
For the 2024-2025 reporting year fy must be = 35

fy Num 2 Table 9
NE0020

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

9 = August 31st
 
cycle Num 2 Table 9
NE0030

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:

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

Vendor NumberThe vendor identification number

vendor_number Alpha 8 9
NE0050

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
NE0060

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
NE0070

Degree DescriptionDescription of degree

desc_degree Alpha 30 9
NE0080

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
NE0090

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
NE0100

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