Pre-ID File Layouts
Field Name | Length | Where in eSchoolPlus? | Notes/Issues |
|---|---|---|---|
Administration | 8 | Test + Period + Last 2 of School Year For example, WRFALL19, NRFALL19, WRSPRG19, and NRSPRG19 would be reported for the 2019 school year | |
Student Last Name | 11 | reg.last_name | |
Student First Name | 9 | reg.first_name | |
Student Middle Initial | 1 | reg.middle_name | |
Login ID | 60 | NULL | |
Division Code | 3 | schd_ms.district using reg_district.state_code_equiv | |
School Code | 4 | schd_ms.building using reg_building.state_code_equiv | |
Test Code | 6 | Test Type selected from download prompt | |
Group Name | 20 | schd_ms_session.primary_staff using reg_staff to get reg_staff.last_name + schd_ms_session.start_period | |
Group Code | 10 | NULL | |
Date of Birth | 8 | reg.birthdate | MMDDYYYY |
Grade | 2 | reg.grade using reg_grade.state_code_equiv | |
State Testing Identifier (STI) | 10 | reg_personal.state_report_id | |
Ethnicity: Hispanic | 1 | reg_personal.hispanic | |
Race | 2 | reg_user (screen = 210, field = 1) | |
Military Connected Student Code | 1 | Reg_programs.program_value where program_id='MILCON' | |
Student Number | 12 | reg.student_id | |
Initial Primary Nighttime Residence Code | 1 | Reg_programs.program_value where program_id='NIGHT' | |
Foster Care | 1 | Reg_programs.program_value where program_id='FOST' | |
N-Code/ Economically Disadvantaged | 1 | Reg_programs.program_value where program_id='DISADV' | |
ELL Test Tier | 1 | Not reported | |
ELL Overall Proficiency Level | 2 | Not reported | |
ELL Literacy Proficiency Level | 2 | Not reported | |
Disability Status | 2 | Reg_programs.program_value where program_id='DISAB' | |
Temporary Condition | 1 | Not reported | |
Formerly LEP | 1 | Not reported | |
X-Code-B | 1 | NULL | |
X-Code-C | 1 | NULL | |
X-Code-D | 1 | NULL | |
SOA Adjustment – LEP | 1 | Not reported | |
SOA Adjustment – Transfer | 1 | Not reported | |
AYP Adjustment – A | 1 | Reg_programs.program_value where program_id='ESL' | If Service Code = 1 or 2 AND reg.dist_enroll_date 9/30 or earlier of current school year |
AYP Adjustment – B | 1 | Reg_programs.program_value where program_id='ESL' | If Service Code = 1 or 2 AND reg.dist_enroll_date is 10/1 or later of current school year AND reg.state_enroll_date is 10/1 or earlier of current school year |
AYP Adjustment – C | 1 | Reg_programs.program_value where program_id='ESL' | If Service Code = 1 or 2 AND reg.state_enroll_date is 10/1 or later of current school year |
AYP Adjustment – D | 1 | Reg_programs.program_value where program_id='ESL' | If Service Code is 1 or 2 AND reg.us_enroll_date is less than 1 year |
Special Code A | 1 | NULL | |
Special Code B | 1 | NULL | |
Special Code C | 1 | NULL | |
RP-Code | 1 | Not reported | |
Local Use Data - Student | 9 | NULL | |
Local Use Data – Test | 9 | NULL | |
Online Testing | 1 | Not reported | |
Recovery | 1 | Not reported | |
Retest | 1 | Not reported | |
D-Code | 1 | Not reported | |
Term Grad | 1 | If reg_academic.graduation_year = current school_year, then report 'Y' | |
Project Graduation | 1 | Not reported | |
Retest for College Readiness | 1 | NULL | |
Z-Code-A | 1 | NULL | |
Z-Code-B | 1 | NULL | |
Z-Code-C | 1 | NULL | |
Code VTLN | 15 | schd_ms_session.primary_staff using reg_staff to get reg_staff.staff_state_id | |
Code TLN | 40 | schd_ms_session.primary_staff using reg_staff to get reg_staff.last_name | |
Code TFN | 25 | schd_ms_session.primary_staff using reg_staff to get reg_staff.first_name | |
End of Record | 1 | Always 'Y' |