MD - MCC Report
Data Element | Field Name | Field Length | Start Position | End Position | eSchoolplus Table.Column | Download Table.Column | Where in eSchoolPLUS |
---|---|---|---|---|---|---|---|
1 | Academic Year | 4 | 1 | 4 | The current school year | ||
2 | LEA Number | 2 | 5 | 6 | reg_district.state_code_equiv | MD_MCC.DISTRICT | Administration > General Setup > District > District: State Equivalency Code |
3 | SCED Subject Area Code | 2 | 7 | 8 | SCHD_COURSE_USER.FIELD_Value where SCREEN_NUMBER=300 and FIELD_NUMBER=1 (respective SCED_VALUE of the MSDE_VALUE in MDTB_MSDE_TO_SCED_SUBJ table) | MD_MCC.SUBJECT_AREA | Scheduling > Courses > Building Courses > MD State Reporting: MSDE Subject Code |
4 | SCED Course Number | 3 | 9 | 11 | mr_crsequ_det.STATE_ID (last 3 digits of the state course) | MD_MCC.COURSE_NUMBER | Scheduling > Courses > Building Courses > Building Course Catalog> State Course Information - 2024: State Course |
5 | Course Level | 4 | 12 | 15 | SCHD_COURSE_USER.FIELD_Value where SCREEN_NUMBER=300 and FIELD_NUMBER=17 | MD_MCC.COURSE_LEVEL | Scheduling > Courses > Building Courses > MD State Reporting: Course Level |
6 | Course Level Characteristic | 4 | 16 | 19 | SCHD_COURSE_USER.FIELD_Value where SCREEN_NUMBER=300 and FIELD_NUMBER=19 | MD_MCC.COURSE_LEVEL_CHARACTERSITIC | Scheduling > Courses > Building Courses > MD State Reporting: Course Level Charactersitic |
7 | Grade Span | 4 | 20 | 23 | SCHD_COURSE_USER.FIELD_Value where SCREEN_NUMBER=300 and FIELD_NUMBER=6 & SCHD_COURSE_USER.FIELD_Value where SCREEN_NUMBER=300 and FIELD_NUMBER=7 | MD_MCC.GRADE_SPAN | Scheduling > Courses > Building Courses > MD State Reporting: Lower Grade Span & Upper Grade span |
8 | SCED Course Sequence Number | 2 | 24 | 25 | mr_crsequ_det.EQUIV_SEQUENCE | MD_MCC.SEQUENCE_OF_COURSE | Scheduling > Courses > Building Courses > Building Course Catalog> State Course Information - 2024: Part Number |
9 | SCED Course Sequence Total | 2 | 26 | 27 | mr_crsequ_det.equiv_parts | MD_MCC.SEQUENCE_TOTAL | Scheduling > Courses > Building Courses > Building Course Catalog> State Course Information - 2024: Number of Parts |
10 | Filler (new changes for SY2023) | 4 | 28 | 31 |
|
|
|
11 | Local Course Code | 10 | 32 | 41 | schd_course.course | MD_MCC.LEA_COURSE_CODE | Scheduling > Courses > Building Courses > Building Course Catalog> Course |
12 | Local Course Title | 55 | 42 | 96 | schd_course.Description | MD_MCC.LEA_COURSE_TITLE | Scheduling > Courses > Building Courses > Building Course Catalog> Name |
13 | Local Course Description | 1000 | 97 | 1096 | schd_course.Long_Description | MD_MCC.LEA_COURSE_DESC | Scheduling > Courses > Building Courses > Building Course Catalog> General Course Information > Description |
14 | Filler (new changes for SY2023) | ||||||
15 | Local Course Credits | 5 | 1101 | 1105 | schd_course.credit | MD_MCC.LEA_COURSE_CREDITS | Scheduling > Courses > Building Courses > Building Course Catalog > Mark Reporting Information: Credit |
16 | Course Grade Point Average Applicability Flag | 1 | 1106 | 1106 | If Local Course Credits >0 and not 0.00 then Y Else N | MD_MCC.GPA_APPLICABILITY | |
17 | Course Content Standards | 2 | 1107 | 1108 | SCHD_COURSE_USER.FIELD_Value where SCREEN_NUMBER=300 and FIELD_NUMBER=8 | MD_MCC.CONTENT_STANDARDS | Scheduling > Courses > Building Courses > MD State Reporting: Course Content Standard |
18 | Filler (new changes for SY2023) | 5 | 1109 | 1113 |
|
|
|
19 | High School Course Requirement Flag | 1 | 1114 | 1114 | SCHD_COURSE_USER.FIELD_Value where SCREEN_NUMBER=300 and FIELD_NUMBER=10 | MD_MCC.HS_REQUIRED | Scheduling > Courses > Building Courses > MD State Reporting: HS Course Requirement |
20 | K-12 End of Course Requirement | 1 | 1115 | 1115 | SCHD_COURSE_USER.FIELD_Value where SCREEN_NUMBER=300 and FIELD_NUMBER=11 | MD_MCC.K12_EOC | Scheduling > Courses > Building Courses > MD State Reporting: EOC Exam |
21 | Filler (new changes for SY2023) | 1 | 1116 | 1116 | |||
23 | Filler | 100 | 1117 | 1216 |
|
|
|
24 | Filler | 1 | 1217 | 1217 |
|
|
|
24 | Filler (new changes for SY2023) | 4 | 1218 | 1221 |
|
|
|
25 | Course Delivery type | SCHD_COURSE_USER.FIELD_Value where SCREEN_NUMBER=300 and FIELD_NUMBER=14 (respective state code equiv in MDTB_DELIVERY_TYPE table) | MD_MCC.DELIVERY_TYPE | Scheduling > Courses > Building Courses > MD State Reporting: Delivery Type | |||
26 | Instructional Language | 3 | 1224 | 1226 | SCHD_COURSE_USER.FIELD_Value where SCREEN_NUMBER=300 and FIELD_NUMBER=15 (respective state code equiv in MDTB_INSTR_LANG table) | MD_MCC.INSTRUCTIONAL_LANG | Scheduling > Courses > Building Courses > MD State Reporting: Instructional Language |
27 | Filler | 1 | 1227 | 1227 |
|
|
|
28 | Integrated Postsecondary Education Data System ID for the Institution of Higher Education (IPEDS ID) | 6 | 1228 | 1233 | SCHD_COURSE_USER.FIELD_Value where SCREEN_NUMBER=300 and FIELD_NUMBER=16 (respective state code equiv in MDTB_IPEDS_SCHOOL table) | MD_MCC.SCHOOL_CODE | Scheduling > Courses > Building Courses > MD State Reporting: IPEDS School Code |