S_GA_CRS_X (ver 14.2.2)
This table is an extension of the [Courses] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 14.2.2 | Number(10,0) | Primary key that relates the extended table back to the Courses table. |
CreditQualifier | 16.6.0 | Varchar2(10 | Indicates the course was awarded credits but was not taken in High School. Migrated from Courses.GA_Crs_CreditQualifier. |
CreditRecovery | 14.11.0 | Number(1,0) | Indicates this is a credit recovery course. |
DualEnroll | 16.6.0 | Varchar2(1) | Indicates the type of dual enrollment type assigned. Migrated from Courses.GA_Crs_Dual_Enroll. (Obsolete as of 2015-2016) |
Embedded_MainCrsDCID | 16.1.0 | Number(11,0) | Indicates that the course is embedded by associating a main course. |
EOC_Course | 16.6.0 | Number(1,0) | Indicate that the course should be included in the PreID Labels report when the Georgia MileStones EOC (12) test code is chosen on the PreID Labels run reports page. Migrated from Courses.GA_EOCT_Course. |
EOC_OnlineInd | 16.6.0 | Number(1,0) | Indicate that the Georgia MileStones EOC (12) test is being taken online. Migrated from Courses.GA_EOCT_OnlineInd. |
EOC_Purpose | 16.7.1 | Varchar2(2) | Indicates the purpose for taking EOC. |
FiscAgent | 16.6.0 | Varchar2(1) | Indicates the fiscal agent for the dual enrollment type. Migrated from Courses.GA_Crs_Fis_Agnt. (Obsolete as of 2015-2016) |
HSCreditApproved | 14.2.2 | Number(1,0) | Indicates a middle school course is approved for high school credit. |
InclusionCode | 16.2.1 | Varchar2(1) | Indicates the inclusion code to apply to all students enrolled in this course. |
LocEnroll | 16.6.0 | Varchar2(1) | Indicates where the course was taken. Known as Location of the Dual Enrollment Services. Migrated from Courses.GA_Crs_Loc_Enroll. |
NotContentCompleter | 14.4.2 | Number(1,0) | Indicates the course does not provide opportunity to learn entire course content (Content Completer = N). |
OnlineCourse | 15.10.0 | Number(1,0) | Indicates students of this course are receiving online instruction. |
SLOCourse | 14.8.2 | Number(1,0) | Indicates the course has Student Learning Objectives (SLO) defined. |
SLOMeasureType | 14.8.2 | Number(11,0) | Indicates measure type of courses SLO (individual student percentage or uniform rubric). |
SLOTarget | 14.10.0 | Number(11,0) | Indicates the SLO target chosen from values previously defined at District Level. |
State_ExcludeFromReporting | 16.6.0 | Number(1,0) | Indicates the course should not be included in state reports. Migrated from Courses.GA_ExcludeFromReporting. |
| Teacher_SSN_Override | 17.3.0 | Varchar2(9) | SSN Override for GNET Teachers in course level |
| Teacher_FirstName_Override | 17.3.0 | Varchar2(30) | Teacher Firstname override for GNET Teachers in course level |
| Teacher_LastName_Override | 17.3.0 | Varchar2(30) | Teacher Lastname override for GNET Teachers in course level |
WeightingInd | 16.6.0 | Varchar2(15) | Indicates the course is weighted and needs special consideration by the GaFutures/HOPE System. Migrated from Courses.GA_Crs_WeightingInd. |
| EOG_EOC_Math | 17.10 | varchar2(1) | Indicates whether the student is taken EOC assessment or not. |
| EOG_EOC_Science | 17.10 | Varchar2(1) | Indicates whether the student is taken EOC assessment or not. |
| Category_of_WBL_Program | 17.10 | Varchar2(1) | Indicates student's Work-Based Learning Program. |
| EIPDelivery | 17.10 | varchar2(2) | Indicates the Early Intervention Program delivery model. |
| ESOLDelivery | 17.10 | Varchar2(2) | Indicates the English for Speakers of Other Languages delivery model. |
| SPED_Delivery_Model | 17.10 | Varchar2(2) | Special Education delivery model used in this course. |
| GiftedDelivery | 17.10 | Varchar2(1) | Gifted delivery model used in course page. |
| GiftedContentArea | 17.10 | Varchar2(2) | Indicated the educational area for the gifted curriculum. |
| NoGradeExpected | 18.5.0 | Number(1,0) | This field indicates the student's "No Grade Expected" value. |
| EOG_EOC_ELA | 18.8.0 | Varchar2(1) | Indicates whether the student is taking the EOC assessment. |
| SpEd_PrimaryArea | 18.8.0 | Varchar2(1) | Indicates whether a student is receiving Special Education services in a particular course. |