OPTE Course File Layout

CTE Program Strand Code

3

Y

Y

563 - 565

schd_ms_user.field_value screen_number = 700 field_number = 2

or_crs_opte_down.program_strand

CTE Class Number

17

Y

N

566 - 582

schd_ms_user.field_value where screen_number=700 and field_number=15
or,

 schd_ms.course where schd_ms_user.field_value=Y where screen_number=700 and field_number=1

or_crs_opte_down.class_number

CTE Section Number

3

Y

Y

583 - 585

Last character of schd_ms_mp.marking_period plus schd_ms.course_section

or_crs_opte_down.section

CTE Course Grade Code

1

Y

N

586 - 586

Obtained from mr_stu_marks.mark_value based on the Mark Type defined in reg_user_district.field_value where screen_number=700 and field_number=2 and the grade obtained is cross walked to state codes as needed by ODE.

or_crs_opte_down.course_grade

CTE Credits

5

Y

Y

587 - 591

MR_STU_HDR.MR_STU_HDR.earn_override if Oveerride is set to 'Y'. Else MR_STU_HDR.earn_credit.

or_crs_opte_down.credit_code