NJ SMART Assessment File Layout
For the NJ SMART Pre-ID submission file, the following table shows the New Jersey Department of Education field numbers, field names, the eSchoolPlus Tables and Columns, and database source fields.
Position in file/ NJ DOE Number | Field Name | Where in eSchoolPlus | Notes |
---|---|---|---|
1/1 | Local Identification Number | Registration > Entry & Reports > Student Demographic > Registration: Student ID field (reg.student_id) | Required |
2/2 | State Identification Number | Registration > Entry & Reports > Student Demographic > Personal: State ID field (reg_personal.state_report_id) | Required 10-digit state identification number. |
3/3 | First Name | Registration > Entry & Reports > Student Demographic > Registration: First Name field (reg.first_name) | Required Periods are not allowed. The file does accept apostrophes and hyphens. |
4/5 | Last Name | Registration > Entry & Reports > Student Demographic > Registration: Last Name field (reg.last_name) | Required Periods are not allowed. The file does accept apostrophes and hyphens. |
5/8 | Date Of Birth | Registration > Entry & Reports > Student Demographic > Registration: Birth Date field (reg.birthdate) | Required YYYYMMDD format |
6/78 | Section 504 | Registration > Entry & Reports > Student Demographic > Personal: 504 Plan field (reg_personal.section_504_plan) or, If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > NJ504 – NJ Section 504: Section 504 Plan field. (The system looks in reg_program_column for the program__id and field_number associated with state_code_equiv=NJ504PLAN. The submission file uses the corresponding reg_programs.value). | Required Valid values are Y (for Yes) or N (for No) |
7/79 | SE/504 Setting Accommodation | Registration > Entry & Reports > Student District Defined > NJ Section 504: SE 504 Setting Accom field (reg_user.field_value for screen_number=950 and field_number=1). or, If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > NJ504 – NJ Section 504: SE 504 Setting Accom field. (The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJ504SETNG. The submission file uses the corresponding reg_programs.value). | Required Valid values are Y (for Yes) or N (for No) |
8/80 | SE/504 Schedule Accommodation | Registration > Entry & Reports > Student District Defined > NJ Section 504: SE 504 Schedule Accom field (reg_user.field_value for screen_number=950 and field_number=2). or, If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > NJ504 – NJ Section 504: SE 504 Schedule Accom field. (The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJ504SCHED. The submission file uses the corresponding reg_programs.value). | Required Valid values are Y (for Yes) or N (for No) |
9/81 | SE/504 Test Material Accommodation | Registration > Entry & Reports > Student District Defined > NJ Section 504: SE 504 Test Material Accom field (reg_user.field_value for screen_number=950 and field_number=3). or , If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > NJ504 – NJ Section 504: SE 504 Test Material Accom field. (The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJ504MAT. The submission file uses the corresponding reg_programs.value). | Required Valid values are Y (for Yes) or N (for No) |
10/82 | SE/504 Test Procedure Accommodation | Registration > Entry & Reports > Student District Defined > NJ Section 504: SE 504 Test Procedure Accom field (reg_user.field_value for screen_number=950 and field_number=4). or, If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > NJ504 – NJ Section 504: SE 504 Test Procedure Accom field. (The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJ504PROC. The submission file uses the corresponding reg_programs.value). | Required Valid values are Y (for Yes) or N (for No) |
11/83 | APA Science Test | Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: APA Science Test field (reg_user.field_value for screen_number=951 and field_number=1). or , If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: APA Science Test field. (The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJSCIENCE. The submission file uses the corresponding reg_programs.value). | Required Valid values are Y (for Yes) or N (for No) |
12/84 | APA Math Test | Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: APA Math Test field (reg_user.field_value for screen_number=951 and field_number=2). or, If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: APA Math Test field. (The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJMATH. The submission file uses the corresponding reg_programs.value). | Required Valid values are Y (for Yes) or N (for No) |
13/85 | APA Language Test | Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: APA Language Test field (reg_user.field_value for screen_number=951 and field_number=3). or, If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: APA Language Test field. (The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJLANG. The submission file uses the corresponding reg_programs.value). | Required Valid values are Y (for Yes) or N (for No) |
14/86 | LEP Exempt From Taking LAL | Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: LEP Exempt from Taking LAL field (reg_user.field_value for screen_number=951 and field_number=4). or, If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: LEP Exempt from Taking LAL field. (The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJLEPLAL. The submission file uses the corresponding reg_programs.value). | Required Valid values are Y (for Yes) or N (for No) |
15/87 | Time In District Less Than One Year | Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Time in District Less than 1 Year field (reg_user.field_value for screen_number=951 and field_number=6). or, If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: Time in District Less than 1 Year field. (The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJDISTRICT. The submission file uses the corresponding reg_programs.value). | Required Y = Yes, student has been enrolled in the state assessment accountable (AYP) district for less than 1 year N = No. Student has been enrolled in the state assessment accountable (AYP) district for more than 1 year |
16/102 | Time In School Less Than One Year | Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Time in School Less than 1 Year field (reg_user.field_value for screen_number=951 and field_number=5). or, If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: Time in School Less than 1 Year field. (The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJSCHOOL. The submission file uses the corresponding reg_programs.value). | Required Y = Yes, student has been enrolled in the state assessment accountable (AYP) school for less than 1 year N = No. Student has been enrolled in the state assessment accountable (AYP) school for more than 1 year |
17/91 | State Assessment Testing Site County | Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: State Testing Site County field (reg_user.field_value for screen_number=951 and field_number=7). or, If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: State Assessment Testing Site County field. (The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJTCOUNTY. The submission file uses the corresponding reg_programs.value). | Required For a listing of valid County Codes, refer to http://www.nj.gov/education/njsmart/download/school_codes.xls |
18/91 | State Assessment Testing Site District | Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: State Testing Site District field (reg_user.field_value for screen_number=951 and field_number=8). or, If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: State Assessment Testing Site District field. (The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJTDIST. The submission file uses the corresponding reg_programs.value). | Required For a listing of valid District Codes, refer to http://www.nj.gov/education/njsmart/download/school_codes.xls |
19/104 | State Assessment Testing Site School | Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: State Testing Site School field (reg_user.field_value for screen_number=951 and field_number=9). or If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: State Assessment Testing Site School field. (The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJTSCHOOL. The submission file uses the corresponding reg_programs.value). | Required For a listing of valid School Codes, refer to http://www.nj.gov/education/njsmart/download/school_codes.xls |
20/105 | State Assessment Accountable County | Registration > Entry & Reports > Student District Defined > NJ Smart Info: County – Attending field (reg_user.field_value for screen_number=990 and field_number=2). | Required This code must match one of the CDS codes for Resident, Receiving, or Attending County from the student's SID submission record. |
21/106 | State Assessment Accountable District | Administration > General Setup > District > District: State Equivalency Code field (reg_district.state_code_equiv) or, If a program override exists, the value comes from Registration > Entry & Reports > Student District Defined > NJ Smart Info: District – Resident (Override) field (reg_user.field_value for screen_number=990 and field_number=4). | Required This code must match one of the CDS codes for Resident, Receiving, or Attending District from the student's SID submission record. |
22/107 | State Assessment Accountable School | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building field (Based on the reg_entry_with.building, the submission uses the corresponding reg_building.state_code_equiv) or, If a program override exists, the value comes from Registration > Entry & Reports > Student District Defined > NJ Smart Info: School - Attending (Override) field (reg_user.field_value for screen_number=990 and field_number=5). | Required This code must match one of the CDS codes for Resident, Receiving, or Attending School from the student's SID submission record. |
23/170 | Examiner SMID Day 1 | Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Examiner Staff ID Day 1 field (reg_user.field_value for screen_number=951 and field_number=10). Or , Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Out of Dist Exam SMID Day 1 field (reg_user.field_value for screen_number = 951 and field_number = 15) | Required You either have to have a staff member selected for Examiner Staff ID Day 1 through Day 5, or enter the appropriate SMID for Out of Dist Exam SMID Day 1 through Day 5. |
24/171 | Examiner SMID Day 2 | Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Examiner Staff ID Day 1 field (reg_user.field_value for screen_number=951 and field_number=11). Or, Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Out of Dist Exam SMID Day 1 field (reg_user.field_value for screen_number = 951 and field_number = 16) | Required You either have to have a staff member selected for Examiner Staff ID Day 1 through Day 5, or enter the appropriate SMID for Out of Dist Exam SMID Day 1 through Day 5. |
25/172 | Examiner SMID Day 3 | Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Examiner Staff ID Day 1 field (reg_user.field_value for screen_number=951 and field_number=12). Or, Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Out of Dist Exam SMID Day 1 field (reg_user.field_value for screen_number = 951 and field_number = 17) | Required You either have to have a staff member selected for Examiner Staff ID Day 1 through Day 5, or enter the appropriate SMID for Out of Dist Exam SMID Day 1 through Day 5. |
26/173 | Examiner SMID Day 4 | Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Examiner Staff ID Day 1 field (reg_user.field_value for screen_number=951 and field_number=13). Or, Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Out of Dist Exam SMID Day 1 field (reg_user.field_value for screen_number = 951 and field_number = 18) | Required You either have to have a staff member selected for Examiner Staff ID Day 1 through Day 5, or enter the appropriate SMID for Out of Dist Exam SMID Day 1 through Day 5. |
27/174 | Examiner SMID Day 5 | Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Examiner Staff ID Day 1 field (reg_user.field_value for screen_number=951 and field_number=14). Or, Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Out of Dist Exam SMID Day 1 field (reg_user.field_value for screen_number = 951 and field_number = 19) | Required You either have to have a staff member selected for Examiner Staff ID Day 1 through Day 5, or enter the appropriate SMID for Out of Dist Exam SMID Day 1 through Day 5. |