Skip to main content
Skip table of contents

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 ###.##

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.