Student Lite 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 Student Lite 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-14 | NYSSIS and NYS Reporting | 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) | 15-24 | NYSSIS and NYS Reporting | School Year Prompt-06-30 | N/A |
4 | *STUDENT ID (SCHOOL DISTRICT STUDENT ID) | 25-36 | NYSSIS and NYS Reporting | reg_entry_with.student_id Use 9 numeric characters, left padded with zeros Ex. 51972 = 000051972 | |
5 | *LAST NAME SHORT (STUDENT'S LAST NAME) | 37-61 | NYSSIS and NYS Reporting | reg.last_name | Registration > Entry & Reports > Student Demographic > Registration: Last Name |
6 | *FIRST NAME SHORT (STUDENT'S FIRST NAME) | 62-76 | NYSSIS and NYS Reporting | reg.first_name | Registration > Entry & Reports > Student Demographic > Registration: First Name |
7 | MIDDLE INITIAL (STUDENT'S MIDDLE INITIAL) | 77 | NYSSIS and NYS Reporting | reg.middle_name | Registration > Entry & Reports > Student Demographic > Registration: Middle Name (first character) |
8 | *CURRENT GRADE LEVEL (GRADE LEVEL) | 78-79 | NYSSIS | reg_entry_with.grade See Grade Level Table. If 13 or 14 then reg_programs.program_value | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Grade |
9 | HOME ROOM | 80-85 | Local use only | reg.homeroom_primary | Registration > Entry & Reports > Student Demographic > Registration: Primary Homeroom |
10 | *BIRTH DATE (DATE OF BIRTH) | 86-95 | Local use only | reg.birthdate | Registration > Entry & Reports > Student Demographic > Registration: Birth Date |
11 | *GENDER CODE (GENDER DESCRIPTION) | 96-101 | NYSSIS and NYS Reporting | reg.gender | Registration > Entry & Reports > Student Demographic > Registration: Gender |
12 | *ETHNIC CODE SHORT (RACE 1 CODE) | 102-103 | NYSSIS and NYS Reporting | reg_ethnicity.Ethnic_Code Where reg_ethnicity.Ethnicity_Order = 1 or, reg_personal.Ethnic_Code Validate against regtb_ethnicity.state_code_equiv | Registration > Entry & Reports > Student Demographic > Personal: Race (if more than one, where Order = 1) |
13 | HOME LANGUAGE CODE (HOME LANGUAGE DESCRIPTION) | 104-119 | NYSSIS and NYS Reporting | reg.language | Registration > Entry & Reports > Student Demographic > Registration: Home Language |
14 | CHALLENGE TYPE | 120-149 | Leave blank | N/A | |
15 | LEVEL OF INTEGRATION | 150-164 | Leave blank | N/A | |
16 | LEP PARTICIPATION | 165-167 | Leave blank | N/A | |
17 | +DURATION OF LEP (YEARS ENROLLED IN A BILINGUAL OR ESL PROGRAM) | 168-169 | reg_personal.ell_years If "Use LEP Program for LEP Duration" prompt is checked then it will be calculated value from LEP Eligibility (difference between Start date and End date, if End date is NULL then today's date). Else reg_personal.ell_years | Registration > Entry & Reports > Student Demographic > Personal: ELL Years Or, If Use LEP Program for LEP Duration checked on prompt screen then calculated from Start and End Dates from Registration > Entry & Reports > Student Demographic > Programs: Program where State Code Equiv = "0231" | |
18 | +POST GRADUATE ACTIVITY (POSTGRADUATE PLAN DESCRIPTION) | 170-199 | NYS Reporting for P-Tech Students (4026) & Smart Scholars-ECHS (4037) | reg_academic.exp_grad_plan | Registration > Entry & Reports > Student Demographic > Academic: Expected Graduation Plans |
19 | STUDENT STATUS | 200 | Local use only | reg.current_status | Registration > Entry & Reports > Student Demographic > Registration: Current Year Status |
20 | +LAST STATUS DATE | 201-210 | Local use only | reg_entry_with.withdrawal_date If NULL or > Run Date, then Run Date | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Withdrawal Date |
21 | POVERTY CODE | 211 | Leave blank | N/A | |
22 | POPULATION CODE | 212 | Leave blank | N/A | |
23 | MOBILITY CODE | 213 | Leave blank | N/A | |
24 | +DIPLOMA TYPE CODE (CREDENTIAL TYPE DESCRIPTION) | 214-216 | NYS Reporting | reg_academic.code using regtb_diplomas.state_code_equiv | Registration > Entry & Reports > Student Demographic > Academic: Diploma Type |
25 | PROGRAM SERVICES CODE | 217 | Leave blank | N/A | |
26 | +GRADE 09 ENTRY DATE (FIRST DATE OF ENTRY INTO GRADE 9) | 218-227 | NYSSIS and NYS Reporting | reg.grade_9_date BLANK if "12/31/1899" Or "01/01/1900" | Registration > Entry & Reports > Student Demographic > Registration: Date Entered Grade 9 |
27 | +SERVICE PROVIDER (BACKMAPPING BEDS CODE) | 228-247 | If Back Map BEDS Screen and Back Map BEDS Field are selected, the value fetched from the User Defined Screen or the Program based on the selection made for Back Map BEDS Screen and Back Map BEDS Field. | Registration > Entry & Reports > Student Demographic > Programs: Program and field selected on Prompt screen | |
28 | INOCULATION DATE (IMMUNIZATION DATE FOR FIRST POLIO VACCINATION) | 248-257 | Leave blank | N/A | |
29 | ADDRESS 1 (STUDENT'S ADDRESS LINE 1) | 258-287 | NYSSIS and NYS Reporting | reg_contact.street_number + reg_contact.street_prefix + reg_contact.street_name + reg_contact.street_suffix where reg_stu_contact.contact_type = 'P' and reg_stu_contact.contact_priority = '0' | Registration > Entry & Reports > Student Demographic > Addresses panel: House Number + Street Prefix + Street Name + Street Suffix |
30 | ADDRESS 2 (STUDENT'S ADDRESS LINE 2) | 288-317 | NYSSIS and NYS Reporting | reg_contact.complex + reg_contact.apartment | Registration > Entry & Reports > Student Demographic > Addresses panel: Complex + Apartment |
31 | CITY (STUDENT'S ADDRESS CITY) | 318-342 | NYSSIS and NYS Reporting | reg_contact.city | Registration > Entry & Reports > Student Demographic > Addresses panel: City |
32 | STATE (STUDENT'S ADDRESS STATE CODE) | 343-344 | NYSSIS and NYS Reporting | reg_contact.state | Registration > Entry & Reports > Student Demographic > Addresses panel: State |
33 | ZIP CODE (STUDENT'S ADDRESS ZIP CODE) | 345-354 | NYSSIS and NYS Reporting | reg_contact.zip | Registration > Entry & Reports > Student Demographic > Addresses panel: Zip Code |
34 | HOME PHONE (PHONE AT PRIMARY RESIDENCE) | 355-368 | NYSSIS | reg_stu_contact.phone | Registration > Entry & Reports > Student Demographic > Phone panel: Phone Number |
35 | PRIMARY GUARDIAN NAME (STUDENT'S GUARDIAN ONE NAME) | 369-408 | NYSSIS | reg_contact.first_name + reg_contact.last_name where reg_stu_contact.contact_type = 'G' and reg_stu_contact.contact_priority = '1' | Registration > Entry & Reports > Student Demographic > Contacts: First Name + Last Name for Contact with Priority of 1 |
36 | ALTERNATE GUARDIAN NAME (STUDENT'S GUARDIAN TWO NAME) | 409-448 | NYSSIS | reg_contact.first_name + reg_contact.last_name where reg_stu_contact.contact_type = 'G' and reg_stu_contact.contact_priority = '2' | Registration > Entry & Reports > Student Demographic > Contacts: First Name + Last Name for Contact with Priority of 2 |
37 | PLACE OF BIRTH (STUDENT'S PLACE OF BIRTH) | 449-498 | Local use only | reg_personal.birth_city + reg_personal.birth_state + reg_personal.birth_country | Registration > Entry & Reports > Student Demographic > Personal: City of Birth + State of Birth + Country of Birth |
38 | +INITIAL US ENTRY DATE (DATE OF ENTRY INTO UNITED STATES) | 499-508 | If Entry Into US Screen and Entry Into US Field are selected, the value fetched from the User Defined Screen or the Program based on the selection made for Entry Into US Screen and Entry Into US Field. | Registration > Entry & Reports > Student Demographic > Programs: Program and field selected on Prompt screen | |
39 | +YEARS IN US SCHOOLS (YEARS IN UNITED STATES SCHOOLS) | 509-512 | Local use only | {School Year (Prompt)} - Year(reg.us_enroll_date) if Month(reg.us_enroll_date) < 7, then + 1 | Calculated from Registration > Entry & Reports > Student Demographic > Registration: US Enrollment Date |
40 | +COUNTRY OF ORIGIN CODE (COUNTRY OF ORIGIN) | 513-516 | reg_personal.origin_country | Registration > Entry & Reports > Student Demographic > Personal: Country of Origin | |
41 | *DISTRICT CODE OF RESIDENCE | 517-524 | NYS Reporting | ||
42 | *HISPANIC ETHNICITY INDICATOR (HISPANIC/LATINO ETHNICITY INDICATOR) | 525-527 | NYSSIS and NYS Reporting | reg_personal.Hispanic | Registration > Entry & Reports > Student Demographic > Personal: Hispanic/Latino Ethnicity |
43 | +RACE 2 CODE | 528-531 | NYSSIS and NYS Reporting | reg_ethnicity.Ethnic_Code Where reg_ethnicity.Ethnicity_Order = 2 Validated against regtb_ethnicity.state_code_equiv | Registration > Entry & Reports > Student Demographic > Personal: Race where Order = 2 |
44 | +RACE 3 CODE | 532-535 | NYSSIS and NYS Reporting | reg_ethnicity.Ethnic_Code Where reg_ethnicity.Ethnicity_Order = 3 Validated against regtb_ethnicity.state_code_equiv | Registration > Entry & Reports > Student Demographic > Personal: Race where Order = 3 |
45 | +RACE 4 CODE | 536-539 | NYSSIS and NYS Reporting | reg_ethnicity.Ethnic_Code Where reg_ethnicity.Ethnicity_Order = 4 Validated against regtb_ethnicity.state_code_equiv | Registration > Entry & Reports > Student Demographic > Personal: Race where Order = 4 |
46 | +RACE 5 CODE | 540-543 | NYSSIS and NYS Reporting | reg_ethnicity.Ethnic_Code Where reg_ethnicity.Ethnicity_Order = 5 Validated against regtb_ethnicity.state_code_equiv | Registration > Entry & Reports > Student Demographic > Personal: Race where Order = 5 |
47 | *HOMELESS (HOMELESS INDICATOR) | 544-546 | Local use only | reg_programs.program_value where state_code_equiv = 'HOMELESS' | Registration > Entry & Reports > Student Demographic > Programs: Program where State Code Equiv = "HOMELESS" |
48 | *MIGRANT STATUS (MIGRANT INDICATOR) | 547-554 | NYS Reporting | reg_programs.program_value where state_code_equiv = 'MIGRANT' | Registration > Entry & Reports > Student Demographic > Programs: Program where State Code Equiv = "MIGRANT" |
49 | IMMIGRANT INDICATOR | 555-557 | Local use only | reg_programs.program_value where state_code_equiv = 'IMMIGRANT' Or, reg_personal.immigrant | Registration > Entry & Reports > Student Demographic > Programs: Program where State Code Equiv = "IMMIGRANT" Or, Registration > Entry & Reports > Student Demographic > Personal: Immigrant |
50 | *NEGLECTED OR DELINQUENT (NEGLECTED OR DELINQUENT INDICATOR) | 558-560 | NYS Reporting | reg_programs.program_value where state_code_equiv = 'ATRISK' | Registration > Entry & Reports > Student Demographic > Programs: Program where State Code Equiv = "ATRISK" |
51 | +HOMELESS PRIMARY NIGHTTIME RESIDENCE | 561-568 | Leave blank | N/A | |
52 | NATIVE LANGUAGE | 569-584 | Leave blank | N/A | |
53 | +CAREER PATH CODE | 585-604 | NYS Reporting | reg_user.field_value where screen_number = 10900 and field_number = 2 | Registration > Entry & Reports > Student District Defined > NY Graduation Information: Career Path Code |
54 | +GUIDANCE COUNSELOR DISTRICT CODE | 605-624 | 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 Leave blank if you selected Exclude Guidance Counselor Information when you ran the download for Student Lite. |
55 | GUIDANCE COUNSELOR | 625-636 | NYS Reporting | reg_staff.staff_state_id converted from reg.counselor | Registration > Entry & Reports > Student Demographic > Registration: Counselor Administration > Registration Setup > Building > Staff > Staff Information panel: Staff State ID Leave blank if you selected Exclude Guidance Counselor Information when you ran the download for Student Lite. |
56 | +COUNTY OF RESIDENCE | NYS Reporting for P-Tech Students (4026) | |||
57 | +EDUCATION LEVEL OF PARENT | NYS Reporting for P-Tech Students (4026) and Smart Scholars ECHS (4037) | |||
58 | +CRISIS IMPACT CODE (STUDENT DISPLACED BY DISASTER) | NYS Reporting | |||
59 | +CRISIS NAME (DISASTER NAME) | NYS Reporting |