Student Class Grade Detail File Layout

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