S_NY_CRS_X (ver 16.1.0)
This table is an extension of the [Courses] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 16.1.0 | Number(10,0) | Primary key that relates the extended table back to the [Courses] table. |
| AlternateCourseNumber | 16.1.0 | VarChar2(15) | State course code to include in eScholar reports. Migrates from [Courses]NY_AltCrs_Number. |
| AssessmentDate1 | 16.1.0 | Date | The start date of the first state assessment period associated with the course. Migrates from [Courses]NY_Crs_Assess_Dt. |
| AssessmentDate2 | 16.1.0 | Date | The start date of the second state assessment period associated with the course. Migrates from [Courses]NY_Crs_Assess_Dt2. |
| AssessmentDate3 | 16.1.0 | Date | The start date of the third state assessment period associated with the course. Migrates from [Courses]NY_Crs_Assess_Dt3. |
| State_ExcludeFromReporting | 16.1.0 | Number(1,0) | Indicates whether or not the course should be excluded from state reporting. Migrates from [Courses]NY_Exclude_State_Rpt. |
| ExcludeFromGradeReporting | 16.1.0 | Number(1,0) | Indicates whether or not the course should be excluded from state grade reporting. Migrates from [Courses]NY_ExcludeFromGradeReporting. |
| SummerSchool | 16.1.0 | Number(1,0) | Indicates whether or not the course was offered as a summer school course. Migrates from [Courses]NY_Is_SS_course. |
| RegentExam | 16.1.0 | Number(1,0) | Indicates whether or not the grade awarded for this course is affected by the regent exam. Migrates from [Courses]NY_RegentExam. |
| BocesReporting_TF | 17.1.0 | Number(1,0) | A flag/checkbox used to indicate that the class is a BOCES class. |
| BOVL_Code | 17.1.0 | VarChar2(6) | A freeform text field to enter the BOCES virtual location code. |
| PRIMARYINSTRUCTDELIVERYMETHOD | 17.8.0 | VarChar2(8) | A drop-down field to designate a course/section with a Primary Instruction Delivery Method. |
| PrimaryInstructLangCode | 18.8.0 | VarChar2(20) | An input text-field, which auto-completes the 'Home Language Codes' in the Courses page. |