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