Access to ELL Pre-ID Submission File Layout
Students are included in this file based on having an active program record for the program with State Equivalency Code of NJLEP. This is the LEP field in the NJ Tracking program, accessed through Registration > Entry & Reports > Student Demographic > Programs.
Position in File/NJ DOE Number | Field Name | Where in eSchoolPlus | Notes |
|---|---|---|---|
1/221 | State Name Abbreviation | Administration > General Setup > District > District: State field (reg_district.state) | Required This needs to be NJ. |
2/222 | District Name | Administration > General Setup > District > District > Preferences panel: State Equivalency Code (reg_district.state_code_equiv) | Optional Unless blank, this must correspond to the district name submitted from the combination of County Code Attending and District Code Attending. |
3/223 | District Number | If the student has an Attending District override value, use Registration > Entry & Reports > Student District Defined > NJ Smart Info: District – Attending (override) (reg_user.field_value where screen_number = 990 and field_number = 7) Otherwise, use Administration > General Setup > District > District > Preferences panel: State Equivalency Code (reg_district.state_code_equiv) | Required This needs to match District Code Attending from the student's SID Management record. |
4/224 | School Name | Administration > Registration Setup > Building > Building Definition: Building Name field (reg_building.name) | Optional This needs to correspond to the school name from the submitted combination of these fields: County Code Attending, District Code Attending, and School Code Attending. |
5/225 | School Number | If the student has an Attending School override value, use Registration > Entry & Reports > Student District Defined > NJ Smart Info: School – Attending (override) (reg_user.field_value where screen_number = 990 and field_number = 5) Otherwise, use Administration > Registration Setup > Building > Building Definition > Preferences panel: State Equivalency Code field (reg_building.state_code_equiv) | Required This needs to match School Code Attending from the student's SID Management record. |
6/5 | Last Name | Registration > Entry & Reports > Student Demographic > Registration: Last Name field (reg.last_name) | Required Periods are not accepted. You can use apostrophes and hyphens. |
7/3 | First Name | Registration > Entry & Reports > Student Demographic > Registration: First Name field (reg.first_name) | Required Periods are not accepted. You can use apostrophes and hyphens. |
8/225 | Middle Initial | First letter from Registration > Entry & Reports > Student Demographic > Registration: Middle Name field (first letter from reg.middle_name) | Optional |
9/8 | Date of Birth | Registration > Entry & Reports > Student Demographic > Registration: Birth Date field (reg.birthdate) | Required MMDDYYYY format |
10/7 | Gender | Registration > Entry & Reports > Student Demographic > Registration: Gender field (reg.gender) | Optional |
11/2 | State Identification Number | Registration > Entry & Reports > Student Demographic > Personal: State ID field (reg_personal.state_report_id) | Required 10-digit state identification number. |
12/1 | Local Identification Number | Registration > Entry & Reports > Student Demographic > Registration: Student ID field (reg.student_id) | Required |
13/32 | Grade Level | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Grade field (reg_entry_with.grade). Converted to State Equivalency Code from Administration > General Setup > District > Validation Tables > Registration > Grades (reg_grade.state_code_equiv where reg_entry_with.grade = reg_grade.code) | Required For a list of the valid state code equivalents, refer to the latest NJ DOE State Submission Student Data Handbook.. |
14/13 | Ethnicity | Based on Registration > Entry & Reports > Student Demographic > Personal: Hispanic/Latino Ethnicity field (reg_personal.hispanic) | Required If Yes, report H = Hispanic or Latino – a person of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish background regardless of race. If No, report N = Not Hispanic or Latino |
15/14 | Race American Indian | Calculated based on Registration > Entry & Reports > Student Demographic > Personal: Race field (reg_ethnicity.ethnic_code). Calculation looks whether reg_ethnicity.ethnic_code= regtb_ethnicity.state_code_equiv of I for American Indian/Alaska Native. | Required Y = American Indian or Alaska Native – a person having origins tracing to the original inhabitants of North and South America (including Central America) and who maintains tribal affiliation or community attachment. N = Not American Indian or Alaska Native |
16/15 | Race Asian | Calculated based on Registration > Entry & Reports > Student Demographic > Personal: Race field (reg_ethnicity.ethnic_code). Calculation looks whether reg_ethnicity.ethnic_code= regtb_ethnicity.state_code_equiv of A for Asian. | Required Y = Asian – a person having origins in the Far East, or any Southeast Asian or Indian subcontinent. N = Not Asian |
17/16 | Race Black | Calculated based on Registration > Entry & Reports > Student Demographic > Personal: Race field (reg_ethnicity.ethnic_code). Calculation looks whether reg_ethnicity.ethnic_code= regtb_ethnicity.state_code_equiv of B for Black/ African American. | Required Y = Black or African American N = Not Black or African American |
18/17 | Race Pacific | Calculated based on Registration > Entry & Reports > Student Demographic > Personal: Race field (reg_ethnicity.ethnic_code). Calculation looks whether reg_ethnicity.ethnic_code= regtb_ethnicity.state_code_equiv of P for Pacific Islander. | Required Y = Native Hawaiian or Other Pacific Islander N = Not Native Hawaiian or Other Pacific Islander |
19/18 | Race White | Calculated based on Registration > Entry & Reports > Student Demographic > Personal: Race field (reg_ethnicity.ethnic_code). Calculation looks whether reg_ethnicity.ethnic_code= regtb_ethnicity.state_code_equiv of W for White. | Required Y = White N = Not white |
20/117 | Home Language | Registration > Entry & Reports > Student Demographic > Registration: Home Language field (reg.language). Converted to State Code Equiv from Administration > General Setup > District > Validation Tables > New Jersey State Reporting > Native Language (njtb_native_lang.state_code_equiv where reg.language = njtb_native_lang.code) | Required This needs to match the Home Language from the student's State submission record. |
21/111 | First Entry Date into a US School | Registration > Entry & Reports > Student Demographic > Registration: US Enrollment Date field (reg.us_enroll_date) | This date cannot be greater than three years ago if the student's Immigrant Status = Y. Format MMDDYYYY |
22/227 | Length of Time in ELL Program | This is calculated based on an ELL student's program time in the eSchoolPlus program with State Equivalency Code of NJLEP. All of the student's time is counted. Registration > Entry & Reports > Student Demographic > Personal: ESL program field (reg_programs.start_date and end_date for program_id mapping to reg_program_column.state_code_equiv = NJLEP). | This is reported in years and only as a whole number. Partial years are rounded down. So one year and ten months is reported as 01. A kindergarten student is reported as 00. |
23/228 | Title III Status | Set this field based on the student having an active program record for the eSchoolPlus program with State Equivalency Code of NJCLASS. Registration > Entry & Reports > Student Demographic > Personal: Classification field (Check reg_programs.start_date and end_date for program_id mapping to reg_program_column.state_code_equiv = NJCLASS). | Optional If the student is active in the NJCLASS program, this value is Y. Otherwise, use N. |
24/44 | Migrant Status | If this is program-tracked for the student, the submission takes the reg_programs.value based on the program_id and field_number from reg_program_column where state_code_equiv=NJMIG. If the value is not program-tracked, the value comes from Registration > Entry & Reports > Student Demographic > Personal: Migrant field (reg_personal.migrant). | Optional Values are M (for Migrant) or N (for No). Unless this is blank, the field needs to match the SID file's Migrant Status. |
25/229 | IEP Status | Registration > Entry & Reports > Student Demographic > Personal: Classification field (reg_programs.field_value for program_id mapping to reg_program_column where state_code_equiv = NJCLASS) | Optional |
26/78 | Section 504 | First, use the program setting for the eSchoolPlus program with State Equivalency Code of NJ504PLAN. Registration > Entry & Reports > Student Demographic > Programs > NJ504: Section 504 Plan field (reg_programs.field_value for program_id mapping to reg_program_column where state_code_equiv = NJ504PLAN). If this program value does not exist or if it is not linked to the Personal page's 504 Plan field, use Registration > Entry & Reports > Student Demographic > Personal: 504 Plan field (reg_personal.section_504_plan). | Optional |
27/230 | ESL Program Type NAS | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: ESL Program Type NAS field (reg_user.field_value where screen_number = 1001 and field_number = 1) | Optional |
28/231 | ESL Program Type CAT | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: ESL Program Type CAT field (reg_user.field_value where screen_number = 1001 and field_number = 2) | Optional |
29/232 | ESL Program Type CBE | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: ESL Program Type CBE field (reg_user.field_value where screen_number = 1001 and field_number = 3) | Optional |
30/233 | ESL Program Type DBE | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: ESL Program Type DBE field (reg_user.field_value where screen_number = 1001 and field_number = 4) | Optional |
31/234 | ESL Program Type HLA | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: ESL Program Type HLA field (reg_user.field_value where screen_number = 1001 and field_number = 5) | Optional |
32/235 | ESL Program Type PDE | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: ESL Program Type PDE field (reg_user.field_value where screen_number = 1001 and field_number = 6) | Optional |
33/236 | ESL Program Type SEI | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: ESL Program Type SEI field (reg_user.field_value where screen_number = 1001 and field_number = 7) | Optional |
34/237 | ESL Program Type SEN | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: ESL Program Type SEN field (reg_user.field_value where screen_number = 1001 and field_number = 8) | Optional |
35/238 | ESL Program Type TBI | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: ESL Program Type TBI field (reg_user.field_value where screen_number = 1001 and field_number = 9) | Optional |
36/239 | ESL Program Type TWI | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: ESL Program Type TWI field (reg_user.field_value where screen_number = 1001 and field_number = 10) | Optional |
37/240 | Support Delivery Model NA | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Support Delivery Model NA field (reg_user.field_value where screen_number = 1001 and field_number = 11) | Optional |
38/241 | Support Delivery Model IS | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Support Delivery Model IS field (reg_user.field_value where screen_number = 1001 and field_number = 12) | Optional |
39/242 | Support Delivery Model PO | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Support Delivery Model PO field (reg_user.field_value where screen_number = 1001 and field_number = 13) | Optional |
40/243 | Support Delivery Model PR | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Support Delivery Model PR field (reg_user.field_value where screen_number = 1001 and field_number = 14) | Optional |
41/244 | Support Delivery Model SC | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Support Delivery Model SC field (reg_user.field_value where screen_number = 1001 and field_number = 15) | Optional |
42/245 | Special Accommodations MC | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations MC field (reg_user.field_value where screen_number = 1001 and field_number = 16) | Optional |
43/246 | Special Accommodations RA | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations RA field (reg_user.field_value where screen_number = 1001 and field_number = 17) | Optional |
44/247 | Special Accommodations ES | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations ES field (reg_user.field_value where screen_number = 1001 and field_number = 18) | Optional |
45/248 | Special Accommodations LP | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations LP field (reg_user.field_value where screen_number = 1001 and field_number = 19) | Optional |
46/249 | Special Accommodations BR | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations BR field (reg_user.field_value where screen_number = 1001 and field_number = 20) | Optional |
47/315 | Special Accommodations SD | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations SD field (reg_user.field_value where screen_number = 1001 and field_number = 21) | Optional |
48/316 | Special Accommodations LH | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations LH field (reg_user.field_value where screen_number = 1001 and field_number = 22) | Optional |
49/317 | Special Accommodations RL | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations RL field (reg_user.field_value where screen_number = 1001 and field_number = 23) | Optional |
50/318 | Special Accommodations IH | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations IH field (reg_user.field_value where screen_number = 1001 and field_number = 24) | Optional |
51/319 | Special Accommodations RI | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations RI field (reg_user.field_value where screen_number = 1001 and field_number = 25) | Optional |
52/320 | Special Accommodations SR | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations SR field (reg_user.field_value where screen_number = 1001 and field_number = 26) | Optional |
53/250 | State Defined Operational Data | N/A |
|
54/251 | District Defined Operational Data | N/A |
|
55/252 | Online or Paper Test | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Online or Paper Test field (reg_user.field_value where screen_number = 1001 and field_number = 27) | Optional |
56/253 | Alternate ACCESS Tester | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Alternate ACCESS Tester field (reg_user.field_value where screen_number = 1001 and field_number = 28) | Optional |
57/254 | Tier for Paper Tests | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Tier for Paper Tests field (reg_user.field_value where screen_number = 1001 and field_number = 29) | Optional |
58/321 | Special Accommodations WD | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations WD field (reg_user.field_value where screen_number = 1001 and field_number = 30) | Optional |
59/322 | Special Accommodations AC | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations AC field (reg_user.field_value where screen_number = 1001 and field_number = 31) | Optional |
60/323 | Special Accommodations RD | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations RD field (reg_user.field_value where screen_number = 1001 and field_number = 32) | Optional |
61/324 | Special Accommodations BW | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations BW field (reg_user.field_value where screen_number = 1001 and field_number = 33) | Optional |
62/325 | Special Accommodations AT | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations AT field (reg_user.field_value where screen_number = 1001 and field_number = 34) | Optional |
63/326 | Special Accommodations NS | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations NS field (reg_user.field_value where screen_number = 1001 and field_number = 35) | Optional |
64/327 | Special Accommodations ET | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations ET field (reg_user.field_value where screen_number = 1001 and field_number = 36) | Optional |
65/328 | Special Accommodations EM | Registration > Entry & Reports > Student District Defined > NJ SMART Access for ELL: Special Accommodations EM field (reg_user.field_value where screen_number = 1001 and field_number = 37) | Optional |