S_MI_CRS_TSDL_X (ver 15.8.0)
This table is an extension of the [Courses] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 15.8.0 | Number(10,0) | Primary key that relates the extended table back to the [Courses] table. |
| CollegeCredits | 18.8.0 | Number(24,10) | Number of college credits. |
| CrsFundingPrgm | 21.2.2.0 | Varchar2(5) | Course Funding Program code. |
CourseType | 15.8.0 | Varchar2(12) | Course Type code. Migrated from [Courses.MI_Course_Type]. |
| Eligible64bCourse | 18.8.0 | Number(1,0) | Obsolete - SR 20.5.2.0. Flags the section as 64b eligible. |
ExcludeTSDL | 15.8.0 | Varchar2(1) | Used to exclude Course record from TSDL submission. Migrated from [Courses.MI_TSDL_Exclude]. As of version 18.8.0, this field changed from Number(1,0) to Varchar2(1). |
| MSIXCourseSectionID | 17.8.0 | Varchar2(2) | Used to describe the duration of the course taken for Migrant students. |
NCESCourseID | 15.8.0 | Varchar2(12) | Obsolete - SR 21.8.2.0 Course ID code. Migrated from [Courses.MI_Course_ID]. |
| NCESSubjectArea | 15.8.0 | Varchar2(12) | Obsolete - SR 21.8.2.0 Course Subject Area code. Migrated from [Courses.MI_Subject_Area_Code]. |
| SCEDcourseCode | 20.8.2.0 | Varchar2(6) | Course ID code. Replacing the SCED 1 Course ID code [NCESCourseID] starting in the 2020-2021 year. |
| SCEDsubjectCode | 20.8.2.0 | Varchar2(2) | Course Subject Area code. Replacing the SCED 1 Subject Area code [NCESSubjectArea] starting in the 2020-2021 year. |
| VirtualDelivery | 15.8.0 | Varchar2(4) | Virtual Delivery method. |