Tool Search: MT Extracts
The Course Extract contains information related to course data. This extract matches the Course Upload import file.
Course Extract EditorTool Rights
Read - Generate extract.
Write - N/A
Add - N/A
Delete - N/A
Report Logic
This report can run against a district’s active year as well as any prior year and in both District Edition and State Edition against District Edition data.
File Formats
The extract can be generated in the following formats:
- State Format (TSV)
- HTML
- CSV
- XML
Use the State Format when all data has been reviewed for accuracy and information is ready to be uploaded. Use one of the other formats for data review and testing.
Generate Extract
- Select the Course option from the Extract Type dropdown list.
- Select the desired Format from the dropdown list.
- Choose the desired calendar(s) from the Calendar list.
- Click the Generate Report button. The extract displays in a new window in the selected format.
Example
Course Extract HTML ExampleLayout
Header Layout
| Data Element | Description |
|---|---|
| Record Type | The abbreviation for the type of file generated. This reports as HD. Alphanumeric, 2 characters (HD) |
| Date | The most recent date a change was made on the file or the date the file was generated. Date field, 10 characters (MM/DD/YYYY) |
| Time | The most recent time a change was made on the file or the date the file was generated. Time field, 8 characters (HH:MM:SS) |
| Version | The most current version of the file interface specification and references to the application system. This field reports as MT9.1. Alphanumeric, 5 characters (MT9.1) |
Extract Layout
| # | Data Element | Description | Location |
|---|---|---|---|
| 1 | Record Type | The abbreviation for the type of file generated. This reports as CU. Alphanumeric, 2 characters (CU) | N/A |
| 2 | District Number | The unique identifier assigned to the district by the OPI. String, 4 characters | District Information > State District Number District.number |
| 3 | School Number | The unique identifier assigned to the school by the OPI. String, 4 characters | School Information > State School Number School.number |
| 4 | Calendar Number | The unique calendar identifier. String, 3 characters | Calendar > Number Calendar.number |
| 5 | Course Number | The number assigned to the course. String, 13 characters | Course Information > Course Number Course.number |
| 6 | Course Name | The name of the course. Alphanumeric, 30 characters | Course > Course Name Course.name |
| 7 | SCED Subject Area | The SCED subject area number assigned to the course. Numeric, 2 digits | Course Information > SCED Subject Area Course.scedSubjectArea |
| 8 | SCED Course Identifier | The SCED course identifier assigned to the course. Numeric, 3 digits | Course > SCED Course Identifier Course.scedCourseID |
| 9 | SCED Lowest Grade | The lowest grade level offered for a specific course. String, 3 characters | Course Information > SCED Lowest Grade Course.scedLowestGrade |
| 10 | SCED Highest Grade | The highest grade level offered for a specific course. String, 3 characters | Course Information > SCED Lowest Grade Course.scedHighestGrade |
| 11 | Available Carnegie Unit Credit | The amount of credit available to a student who successfully meets the objectives of the course. It is a measure of "seat time" rather than a measure of attainment of the course objectives. String, 5 characters (XX.XX) - Always reports 2 characters after the decimal | Course Information > Available Carnegie Unit Credit Course.scedAvailableCredit |
| 12 | SCED Course Level | The secondary course's level of rigor. String, 2 characters | Course Information > SCED Course Level Course.scedCourseLevel |
| 13 | SCED Sequence | The manner in which schools may break up complex content. String, 2 characters | Course Information > SCED Sequence Course.scedSequenceNum |
| 14 | SCED Sequence Total | The total possible sequence. String, 2 characters | Course Information > SCED Sequence Course.scedSequenceMax |
| 15 | Distance Class | Indicates this is a distance learning course. String, 1 character (Y or N) | Course Information > Distance Class Course.distanceCode |
| 16 | Filler | N/A | N/A |
| 17 | Type | The course type. Must report as DC or CC. Alphanumeric, 2 characters | Course Information > State-Defined > Type Course.type |
| 18 | Alternate Ed Program | Indicates this is an alternate education program course. String, 1 character (Y or N) | Course Information > Alternate Ed Program CustomCourse.value |
| 19 | Institution | The higher-level education institution that offers the course. Only reports when a Type is selected. Alphanumeric | Course Information > State-Defined > Institution Course.enrollmentLocation |
| 20 | College Credit Equivalent | The number of college credits a higher-level education institution would award upon successful completion of the course. Only reports when a Type is selected. Numeric | Course Information > State-Defined > College Credit Equivalent Course.postSecondaryCredits |
| 21 | Credit Type | The term system used at the higher-level education institution offering the course. Only reports when a Type is selected. Alphanumeric | Course Information > State-Defined > Credit Type Course.termType |
| 22 | CTE Pathway | The pathway this course applies to for CTE certification. Alphanumeric | Course Information > State-Defined > CTE Pathway Course.programType |
| 23 | Year | The end year of the course. String, 4 characters (YYYY) | Calendar > School Year School.year |
