S_KS_CRS_X (ver 14.8.2)
This table is an extension of the [Courses] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| COURSESDCID | 14.8.2 | Number(10,0) | Foreign Key |
| APIndicator_YN | 16.3.0 | VarChar2(1) | Is the course an AP course. Migrated from [Courses.KS_CRDC_AP_Indicator] |
| College_Career_Credits | 16.3.0 | VarChar2(1) | Course approved by the state for CTE credit. Migrated from [Courses.KS_KCC_CCCredits]. |
| CollegeCredits | 17.7.0 | Number (25,10) | The number of college credits earned for the dual credit course. |
| Course_Credit_Hours_Ovrd | 16.3.0 | VarChar2(3) | Override field for Credit Hours. Migrated from [Courses.KS_Crs_Credit_Hrs_Override]. |
| Course_Level | 16.3.0 | VarChar2(1) | Level of the course. Migrated from [Courses.KS_KCC_Level]. |
| Course_Section_Ovrd | 16.3.0 | VarChar2(30) | Override field Course Section field. Migrated from [Courses.KS_Crs_Sec_Override]. |
| Course_Sequence | 16.3.0 | Number(11,0) | Course sequence. Migrated from [Courses.KS_KCC_Sequence]. |
| Course_Term_Total | 16.3.0 | VarChar2(1) | Value for courses that require sequencing. Migrated from [Courses.KS_KCC_KCC_Term_Total] |
| Course_Term_Type | 16.3.0 | VarChar2(3) | Type of term for the course. Migrated from [Courses.KS_KCC_KCC_Term] |
| Course_Type | 16.3.0 | VarChar2(2) | Type of Course. Migrated from [Courses.KS_CrsType]. |
| Delivery_Type | 16.3.0 | VarChar2(1) | Primary mode of course delivery. Migrated from [Courses.KS_KCC_DeliveryType]. |
| Effective_Date | 16.3.0 | Date | The first day of the course. Migrated from [Courses.KS_KCC_Eff_Date]. |
| Expiration_Date | 16.3.0 | Date | The last day of the course. Migrated from [Courses.KS_KCC_Exp_Date] |
| KCC_Grade_Level | 16.3.0 | VarChar2(2) | The grade level of the course. Migrated from [Courses.KS_KCC_Grade]. |
| Local_Course_Desc | 16.3.0 | VarChar2(2000) | Local course description. Migrated from [Courses.KS_Courses_Desc]. |
| LocalCourseId | 16.3.0 | VarChar2(100) | The districts local course ID. Migrated from [Courses.KS_KCC_Subject]. |
QualAdmissions_Year | 14.8.2 | Number(11,0) | The school year the course was approved for qualifying admission by KSDE. |
| Qualified_Admission | 16.3.0 | VarChar2(1) | Does the course meet the standard for Qualified Admissions. Migrated from [Courses.KS_KCC_Qualified]. |
| Sequence_Total | 16.3.0 | Number(11,0) | Total Sequence of the course. Migrated from [Courses.KS_KCC_SeqTotal]. |
| StateCourseId | 16.3.0 | VarChar2(50) | State Course ID. Migrated from [Courses.KS_KCC_Identifier] |
| State_Course_Title | 16.3.0 | VarChar2(100) | State course title. Migrated from [Courses.KS_KCC_KCC_Title] |
| State_ExcludeFromReporting | 16.3.0 | Number(1,0) | Should the course be excluded from state reporting? Migrated from [Courses.KS_ExcludeFromRpting]. |
| StateSubjectArea | 16.3.0 | VarChar2(2) | State Subject Area of the course. Migrated from [Courses.KS_KCC_SubjectCode]. |
StateCourse_Descriptor | 14.8.2 | VarChar2(2000) | The description provided by the State for the course. |
| Target_Program | 16.3.0 | VarChar2(1) | Course is funded for SPED/ESOL. Migrated from [Courses.KS_KCC_SPED_ESOL]. |
| Course is work-based | 20.7.2.0 | VarChar2(2) | Indicate whether the Course is work-based or not. |