Student Class Grade Detail 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 Class Grade Detail file.
* = Required for all students
+ = Required only for specified students
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 using schd_ms.district | Administration > General Setup > District > District: State Equivalency Code |
2 | *LOCATION CODE (BUILDING OF ENROLLMENT CODE) | 9 - 14 | NYS Reporting | schd_ms.building | Building from Master Schedule |
3 | *COURSE CODE | 15 – 39 | NYS Reporting | schd_course_user.field_value where screen_number = '2000' and field_number = '5' Or if there is no override, sched_ms.course | Scheduling > Courses > Course Sections > NY Course Information: Override Local Course Number Or if there is no override, Scheduling > Courses > Course Sections > Master Schedule: Course |
4 | *SCHOOL YEAR DATE (SCHOOL YEAR) | 40 - 49 | NYS Reporting | schd_ms.school_year. Use June 30 of the reported school year. Ex: For 2011-12, use 2012-06-30. | School Year from Master Schedule |
5 | *SUPPLEMENTARY COURSE DIFFERENTIATOR | 50 – 52 | NYS Reporting | Use N/A | |
6 | *SECTION CODE | 53 - 77 | NYS Reporting | schd_ms.course_section | Scheduling > Courses > Course Sections > Master Schedule: Course Section |
7 | *STUDENT ID (SCHOOL DISTRICT STUDENT ID) | 78 - 89 | NYS Reporting | reg.student_id | Registration > Entry & Reports > Student Demographic > Registration: Student ID |
8 | *GRADE DETAIL CODE | 90 – 109 | NYS Reporting | ||
9 | *REPORTING DATE | 110 – 119 | NYS Reporting | ||
10 | *MARKING PERIOD CODE | 120 – 139 | Local use only | ||
11 | DISPLAY GRADE | 140 – 159 | Local use only | ||
12 | ALPHA GRADE | 160 – 179 | Local use only | ||
13 | +NUMERIC GRADE | 180 - 186 | NYS Reporting | mr_level_marks.state_code_equiv only if you need to map a particular numeric value for local grading to a number on a 0-100 scale mr_stu_marks.mark_value if the mark does not have a State Code Equiv in Level Table Required for secondary level courses associated with Regents exams | Mark Reporting > Entry & Reports > Student > Transcript Summary>Marks field for Course If you need to map a building's locally-used mark value to a value on a 0-100 scale, Administration > Mark Reporting Setup > Setup > Level Table: State Code Equiv field If no State Code Equiv is found, the download uses the student's Marks value for the course. |
14 | *CLASS DETAIL OUTCOME CODE | 187 – 206 | NYS Reporting | For Pass (P) or Fail (F) | |
15 | GPA IMPACT CODE | 207 – 226 | Local use only | ||
16 | EVALUATOR 1 STAFF ID | 227 – 238 | |||
17 | STUDENT CLASS GRADE DETAIL COMMENT | 239 – 1262 | Local use only | ||
18 | COURSE INSTRUCTOR SNAPSHOT DATE | 1263 – 1272 | |||
19 | EVALUATOR 1 CONTROLLING DISTRICT CODE | 1273 – 1292 | |||
20 | *TERM CODE | 1293 – 1312 | NYS Reporting | ||
21 | *STATE ASSESSMENT INCLUDED INDICATOR | 1313 – 1315 | NYS Reporting | ||
22 | +CREDITS ATTEMPTED | 1316 – 1323 | NYS Reporting | ||
23 | +CREDITS EARNED | 1324 – 1331 | NYS Reporting | ||
24 | STUDENT CLASS CREDIT TYPE CODE | 1332 – 1351 | Local use only | ||
25 | DUAL/CONCURRENT CREDIT CODE | 1352 – 1371 | NYS Reporting | First, check for a Master Schedule district-defined page value. Schd_ms_user.field_value where schd_ms_user.screen_number = 2000 and field_number = 8 If there is no value at the Master Schedule level, check for a building Course Catalog district-defined page value. Schd_course_user.field_value where schd_course_user.screen_number = 2000 and field_number = 8 If there is no building Course Catalog value, check for a district Course Catalog value. Schd_course_user.field_value where building = -1, screen_number = 2000, and field_number = 8. If there is also no district Course Catalog value, leave this field blank. | First, check Scheduling > Courses > Course Sections > Master Schedule > NY Course Information: Dual Credit Code If there is no value at the Course Section level, check Scheduling > Courses > Building Courses > NY Course Information: Dual Credit Code If there is no building Course Catalog value, check Scheduling > Courses > District Courses > NY Course Information: Dual Credit Code |
26 | CUMULATIVE CLOCK TIME | 1372 – 1379 | |||
27 | EVALUATOR 2 STAFF ID | 1380 – 1391 | |||
28 | EVALUATOR 3 STAFF ID | 1392 – 1403 | |||
29 | EVALUATOR 2 CONTROLLING DISTRICT CODE | 1404 – 1423 | |||
30 | EVALUATOR 3 CONTROLLING DISTRICT CODE | 1424 – 1443 | |||
31 | INSTRUCTION TYPE CODE | 1444 – 1463 | Leave blank | N/A | |
32 | INSTRUCTION DELIVERY METHOD CODE | 1464 – 1483 | Leave blank | N/A | |
33 | INSTRUCTION MEDIUM TYPE CODE | 1484 – 1503 | Leave blank | N/A | |
34 | COURSE DELIVERY MODEL CODE | 1504 – 1523 | Leave blank | N/A | |
35 | COURSE COMPLETION INDICATOR | 1524 – 1526 | Leave blank | N/A | |
36 | +POSTSECONDARY CREDIT UNITS | 1527 – 1531 | Schd_stu_user.field_value where screen_number = 2010 and field_number = 7 | Scheduling > Student Schedules > Schedule Entry > click Course-Section description link > Date Range Detail panel > Other Course Information section > NY Course Override: Postsecondary Credit | |
37 | *CREDIT RECOVERY CODE | 1532 – 1551 | NYS Reporting | schd_stu_user.field_value where screen_number = '3000' and field_number = '1' Or, sched_user.field_value where screen_number = '3000' and field_number = '1' | First see if there is an override at the student course level: Scheduling > Student Schedules > Schedule Entry > click Course-Section description link > Date Range Detail panel > Other Course Information section > NY Course Credit Recovery: Credit Recovery Course box If there is no student override, use Scheduling > Courses > Course Sections > NY Course Credit Recovery: Credit Recovery Course box |
38 | STUDENT GRADE LEVEL CODE WHEN TAKEN | 1552 – 1576 | Leave blank | N/A | |
39 | GRADE STANDARD PERFORMANCE LEVEL CODE | 1577 - 1596 | Leave blank | N/A | |
40 | STUDENT DISTRICT CODE (COURSE DISTRICT) | NYS Reporting |