Skip to main content
Skip table of contents

Student Credit GPA File Layout

The following table shows field numbers, field names, the eSchoolPlus Tables and Columns and where the data is coming from in eSchoolPlus for the Student Credit GPA file.

* = Required for all records

+ = Required only for specified records

Field #

FIELD NAME from eScholar template (DATA ELEMENT NAME)as used by NYSED, if different from eScholar name

Positions

NYS or Local Purpose

eSchoolPlus Table.Column

Where in eSchoolPlus?

1

*DISTRICT CODE

(DISTRICT OF RESPONSIBILITY CODE)

1 – 8

NYS Reporting

reg_district.state_code_equiv

"NY" + first 6 characters of state_code_equiv

Administration > General Setup > District > District: State Equivalency Code

2

*SCHOOL YEAR DATE

9 – 18

NYS Reporting

Use June 30 of the reported school year. Ex: For 2013-14, use 2014-06-30.

Use the School Year entered on the NY Student Downloads page.

3

*STUDENT ID

(SCHOOL DISTRICT STUDENT ID)

19 – 30

NYS Reporting

mr_stu_gpa.student_id

Mark Reporting > Entry & Reports > Student > GPA Summary: ID field

4

*CREDIT GPA CODE

31 – 50

NYS Reporting

Report the word TOTAL

N/A

5

*REPORTING DATE

51 – 60

NYS Reporting

Use June 30 of the reported school year. Ex: For 2013-14, use 2014-06-30.

Use the School Year entered on the NY Student Downloads page.

6

*MARKING PERIOD CODE

61 – 100

NYS Reporting

Report NA

N/A

7

MARKING PERIOD CREDITS EARNED

101 – 108


Leave blank

N/A

8

MARKING PERIOD GPA

109 – 118


Leave blank

N/A

9

*CUMULATIVE CREDITS EARNED

119 – 126

NYS Reporting

Sum mr_stu_mp.earn_credit for courses where section_key maps to a Master Schedule course-section session with schd_ms.bldg_type that is set up in reg_user_building.field_value where screen_number = 2000 and field_number = 6

Mark Reporting > Entry & Reports > Student > Transcript Summary > click course Description link > Course Information panel: Earned Credit field

Scheduling > Courses > Course Sections > Master Schedule: Building Type associated with Marks Are field

Administration > Registration Setup > Building District Defined > NY State Information: Course Building Types field

10

*CUMULATIVE GPA

127 – 136

NYS Reporting

mr_stu_gpa.cum_gpa where gpa_type is set up for the building in reg_user_building.field_value with screen_number = 2000 and field_number = 5 for the most recent run_term_year in the school_year

Mark Reporting > Entry & Reports > Student > GPA Summary > click appropriate School Year link > Weighted Average/GPA section: Cumulative GPA field

Administration > Registration Setup > Building District Defined > NY State Information: Cumulative GPA Type

11

*TERM CODE

137 – 156

NYS Reporting

Report NA

N/A

12

MARKING PERIOD GRADE POINTS

157 – 163


Leave blank

N/A

13

CUMULATIVE GRADE POINTS

164 – 170


Leave blank

N/A

14

MARKING PERIOD LOCATION CODE

171 – 182


Leave blank

N/A

15

STUDENT CREDIT GPA COMMENT

183 – 432

NYS Reporting

reg_user_district.field_value where screen_number = 2000 and field_number = 3

Administration > General Setup > District District Defined > NY State Information: Student Credit GPA Comment field

16

*STUDENT GPA RANGE MINIMUM

433 – 442

NYS Reporting

reg_user_district.field_value where screen_number = 2000 and field_number = 1

Administration > General Setup > District District Defined > NY State Information: Minimum Possible GPA Value field

17

*STUDENT GPA RANGE MAXIMUM

443 – 452

NYS Reporting

reg_user_district.field_value where screen_number = 2000 and field_number = 2

Administration > General Setup > District District Defined > NY State Information: Maximum Possible GPA Value field

18

MARKING PERIOD CREDITS ATTEMPTED

453 – 460


Leave blank

N/A

19

*CUMULATIVE CREDITS ATTEMPTED

461 – 468

NYS Reporting

Sum mr_stu_mp.att_credit for courses where section_key maps to a Master Schedule course-section session with schd_ms.bldg_type that is set up in reg_user_building.field_value where screen_number = 2000 and field_number = 6

Mark Reporting > Entry & Reports > Student > Transcript Summary > click course Description link > Course Information panel: Attempted Credit field

Scheduling > Courses > Course Sections > Master Schedule: Building Type associated with Marks Are field

Administration > Registration Setup > Building District Defined > NY State Information: Course Building Types field

20

PROJECTED GRADUATION DATE

469 – 478


Leave blank

N/A

21

CLASS RANK

479 – 483


Leave blank

N/A

22

CLASS SIZE

484 – 488


Leave blank

N/A

23

PERCENTAGE CLASS RANK

489 – 494


Leave blank

N/A

24

CLASS RANK DATE

495 – 504


Leave blank

N/A

25

MARKING PERIOD SCHOOL YEAR DATE

505 – 514


Leave blank

N/A



JavaScript errors detected

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

If this problem persists, please contact our support.