School Entry Exit File Layout
The following table shows field numbers, field names, the eSchoolPlus Tables and Columns and where the data is coming from in eSchoolPlus for the School Entry/Exit file.
* = Required for all students
+ = Required only for specified students
Field # | FIELD NAME from eScholar template(DATA ELEMENT NAME)as used by NYSED, if different from eScholar name | Positions | NYS or Local Purpose | eSchoolPlus Table.Column | Where in eSchoolPlus? |
|---|---|---|---|---|---|
1 | *DISTRICT CODE (DISTRICT OF RESPONSIBILITY CODE) | 1 - 8 | NYS Reporting | reg_district.state_code_equiv | Administration > General Setup > District > District: State Equivalency Code |
2 | *LOCATION CODE (BUILDING OF ENROLLMENT CODE) | 9 - 20 | NYS Reporting and NYSSIS | reg_building.building | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building or, Registration > Entry & Reports > Student Demographic > Programs: Program where State Code Equiv = "NYALTACC" |
3 | *SCHOOL YEAR DATE (SCHOOL YEAR) | 21 - 30 | NYS Reporting and NYSSIS | School Year Prompt-06-30 | N/A |
4 | *STUDENT ID (SCHOOL DISTRICT STUDENT ID) | 31 - 42 | NYS Reporting and NYSSIS | reg_entry_with.student_id | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Student ID |
5 | *SCHOOL ENTRY DATE (ENROLLMENT ENTRY DATE) | 43 - 52 | NYS Reporting | reg_entry_with.entry_date | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Entry Date |
6 | *SCHOOL ENTRY TYPE CODE (REASON FOR BEGINNING ENROLLMENT CODE) | 53 - 58 | NYS Reporting | reg_entry_with.entry_code using regtb_entry.state_code_equiv | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Entry Code |
7 | SCHOOL ENTRY COMMENT | 59 - 98 | Local use only | N/A | |
8 | *ENROLLMENT GRADE LEVEL (GRADE LEVEL) | 99 - 100 | NYS Reporting | If "Use State Code Equiv. for Grade" prompt is checked: reg_grade.state_code_equiv where reg_grade.code = reg_entry_with.grade Else, reg_entry_with.grade or, reg_programs.program_value where state_code_equiv = 'UNGRA', if value is 13 or 14 | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Grade Or, Registration > Entry & Reports > Student Demographic > Programs where State Code Equiv = "UNGRA" |
9 | RESIDENCE STATUS CODE | 101 - 112 | Leave blank | N/A | |
10 | ENROLL CHANGE CODE | 113 - 124 | Leave blank | N/A | |
11 | SCHOOL EXIT DATE (ENROLLMENT EXIT DATE) | 125 - 134 | NYS Reporting | reg_entry_with.withdrawal_date | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Withdrawal Date |
12 | SCHOOL EXIT TYPE CODE (REASON FOR ENDING ENROLLMENT CODE) | 135 - 140 | NYS Reporting | reg_entry_with.withdrawal_code | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Withdrawal Code |
13 | SCHOOL EXIT COMMENT | 141 - 180 | Local use only | Leave blank | N/A |
14 | DISTRICT CODE OF RESIDENCE | 181 - 200 | Leave blank | N/A | |
15 | ENROLLED AT SCHOOL YEAR START INDICATOR | 201 – 203 | Leave blank | N/A | |
16 | LOCATION CODE OF RESIDENCE | 204 – 215 | Leave blank | N/A | |
17 | SCHOOL CHOICE TRANSFER INDICATOR | 216 – 218 | Leave blank | N/A | |
18 | GRADE LEVEL PROGRAM TYPE CODE | 219 – 238 | Leave blank | N/A | |
19 | CLASS OF YEAR CODE | 239 – 258 | Leave blank | N/A | |
20 | EMPLOYED INDICATOR | 259 – 278 | Leave blank | N/A | |
21 | DISPLACED STUDENT INDICATOR | 279 – 281 | Leave blank | N/A | |
22 | PRIMARY ENROLLMENT LOCATION INDICATOR | 282 – 284 | Leave blank | N/A | |
23 | PROMOTION RETENTION REASON CODE` | 285 – 309 | Leave blank | N/A |