NJ SMART Optional Submission – Discipline Information File Layout
For the NJ SMART Optional submission's Discipline Information file, the following table shows the STATE field numbers, field names, the eSchoolPlus Tables and Columns, and database sources.
Position in file/ NJ DOE Number | Field Name | Where in eSchoolPlus | Notes/Issues |
|---|---|---|---|
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/NA | Days Suspended Out of School | Based on your entry in the Run NJ Optional Submission File page's Out of School Suspension Code field (disc_off_action.actual_duration where Out of School Suspension Code = disc_off_action.action_code) | Required Whole number |
7/NA | Days in House Suspension | Based on your entry in the Run NJ Optional Submission File page's In House Suspension Code field (disc_off_action.actual_duration where In House Suspension Code = disc_off_action.action_code) | Required Whole number |