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 |