NJ SMART Optional Submission – Credits Earned Information File Layout
For the NJ SMART Optional submission's Credits Earned 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 or commas 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 or commas 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 | Cumulative High School Credits | Mark Reporting > Entry & Reports > Student > Transcript Summary: Total Earned Credit field (mr_stu_gpa.cum_earn_credit) | Required Acceptable formats are #.##, ##.##, or ###.## |
7/NA | High School GPA Basis | Administration > Registration Setup > Building District Defined > High School GPA Basis: High School GPA Basis field (reg_user_building.field_value where screen_number = 100 and field_number = 1) | Required Acceptable formats are #.##, ##.##, or ###.## |
8/NA | Cumulative High School GPA | Based on your entry in the Run NJ Optional Submission File page's Non-Weighted GPA Type field (mr_stu_gpa.cur_gpa where Non-Weighted GPA Type = mr_stu_gpa.gpa_type) | Required Acceptable formats are #.##, ##.##, or ###.## |
9/NA | Cumulative Weighted High School GPA | Based on your entry in the Run NJ Optional Submission File page's Weighted GPA Type field (mr_stu_gpa.cur_gpa where Weighted GPA Type = mr_stu_gpa.gpa_type) | Required Acceptable formats are #.##, ##.##, or ###.## |