Skip to main content
Skip table of contents

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
If length is Not 8 or first character is Not "8", then "NY" + first 6 characters

Administration > General Setup > District > District: State Equivalency Code

2

*LOCATION CODE

(BUILDING OF ENROLLMENT CODE)

9 - 20

NYS Reporting and NYSSIS

reg_building.building

Check value for program with state_code_equiv 'NYALTACC'. If set then report reg_programs.program_value

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



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.