S_AZ_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 |
| CCLCProgramCourse | 18.6.0 | Number(1,0) | 21st CCLC Program Course. Indicates that this course is used in reporting CCLC Program Attendance records. |
| CIPProgramNumber | 17.10.0 | Varchar(20) | The CIP Number for the vocational program. |
| ConcurEnroll | 15.8.0 | Varchar2(1) | Indicates the section is a college course attended by students prior to high school graduation for which they are not receiving high school credit. Migrated from [Courses.AZ_ConcurEnroll]. |
CourseDuration | 14.3.0 | Number(11,0) | The total number of minutes of instructional time for the course. |
| CourseLevel | 15.8.0 | Varchar2(10) .......... | An indication of the level of rigor in a course. Migrated from [Courses.AZ_CourseLevel]. |
| CTECert | 15.8.0 | Varchar2(1) | Indicates the course is part of a career or technical education program leading to a specific technical certification. Migrated from [Courses.AZ_CTECert]. |
| DualCredit | 15.8.0 | Varchar2(1) | Indicates if students enrolled in the course are concurrently enrolled in a post-secondary institution and receiving credit at both levels. Migrated from [Courses.AZ_DualCredit]. |
| EOC_AssessmentCodeType | 16.7.1 | Varchar2(5) | End of Course Assessment Code. |
| ExcludeSTC | 15.8.0 | Number(11,0) | An indicator that the course is excluded from AZ Student-Teacher-Course Connection reports. Migrated from [Courses.AZ_ExcludeSTC]. |
| HighGrade | 15.8.0 | Varchar2(2) | Highest grade level of students either enrolled in the course or for which the course is targeted. Migrated from [Courses.AZ_HighGrade]. |
| InstSet | 15.8.0 | Varchar2(10) | The instructional setting for the course. Migrated from [Courses.AZ_InstSet]. |
| LowGrade | 15.8.0 | Varchar2(2) | Lowest grade level of students either enrolled in the course or for which the course is targeted. Migrated from [Courses.AZ_LowGrade]. |
| MinutesPerWeek | 20.5.2.0 | Number(11,0) | The total number of minutes per week for a course. |
| ReqGrad | 15.8.0 | Varchar2(1) | This indicates the course is one of the required courses a student must take to meet graduation requirements. Migrated from [Courses.AZ_ReqGrad]. |
| SequenceOfCourse | 17.4.0 | Number(11,0) | The sequence of the course. Populate if the section or course is the 2nd+ part of a sequence of parts for a course. |
| StandardID | 15.8.0 ...... | Varchar2(20) | Populated if using Standards instead of Traditional grades for the course. Migrated from [Courses.AZ_StandardID]. |