S_ID_CRS_X (ver 14.3.0)
This is an extension of the Courses table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| CoursesDCID | 14.3.0 | Number(10,0) | Primary Key |
| AmtCredit | 14.8.2 | Number(25,10) | Cost in dollars of Credits for course. |
| AP | 15.7.0 | Varchar2(5) | Advanced Placement flag (Y/N). Migrated from [Courses.ID_AP]. |
| ClassLevel | 15.7.0 | Varchar2(5) | Class Level (1 char code). Migrated from [Courses.ID_ClassLevel]. |
| CollegeCredits | 15.7.0 | Number(11,0) | Potential credits from college. Migrated from [Courses.ID_CollegeCredits]. |
| CollegeID | 14.8.2 | Varchar2(4) | Code for the college that offered the credit for the course. Migrated from [Courses.ID_CollegeID]. |
| CourseCode | 15.7.0 | Varchar2(12) | State Course Code. Migrated from [Courses.ID_CourseCode]. |
| CourseStandards | 15.7.0 | Varchar2(5) | Type of standards used (1 char code). Migrated from [Courses.ID_CourseStandards]. |
| CourseType | 15.7.0 | Varchar2(5) | ISEE Course Type (1 char code). Migrated from [Courses.ID_CourseType]. |
| Default_ExitReason | 14.3.0 | Varchar2(2) | Default (Override) Exit Reason when one not recorded in cc for Elem/MS enrollments. |
| DualCredit | 15.7.0 | Varchar2(5) | Dual Credit flag (Y/N). Migrated from [Courses.ID_DualCredit]. |
| Eightin6CourseCost | 15.7.0 | Number(11,0) | Course cost $. Migrated from [Courses.ID_8in6CourseCost]. |
| ExamCourse | 14.8.2 | Varchar2(1) | Y/N/X indicating this course uses Certification Examinations. |
| IB | 15.7.0 | Varchar2(5) | International Baccalaureate flag (Y/N). Migrated from [Courses.ID_IB]. |
| InstructionalSetting | 15.7.0 | Varchar2(5) | Instructional Setting (2 char code). Migrated from [Courses.ID_InstructionalSetting]. |
| ISAT_Type | 15.7.0 | Varchar2(5) | ISAT Course Type (2 char code). Migrated from [Courses.ID_ISAT_Type]. |
| MinsWeek | 15.4.0 | Number(11,0) | Course level minutes per week override. |
| PTE | 15.7.0 | Varchar2(5) | Professional Technical Education Status (1/null). Migrated from [Courses.WI_PTE]. |
| State_ExcludeFromReporting | 15.7.0 | Varchar2(5) | Exclude from state reporting indicator (1/null). Migrated from [Courses.State_ExcludeFromReporting]. |
| TechPrep | 15.7.0 | Varchar2(5) | Tech Prep indicator (Y/N). Migrated from [Courses.ID_TechPrep]. |
| CreditRecovery | 17.9.0 | varchar2(5) | Credit Recovery indicator (Y/N). |
| GradeLevel | 18.11.0 | varchar2(2) | Content Grade Level field at the Course level |
ExcludefromFTE | 19.2.0 | Boolean | Indicates whether the course is excluded from FTE |