S_ON_SEC_X ver 14.7.0
This table is an extension of the [Sections] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
SectionsDCID | 14.7.0 | Number(10,0) | Primary key that relates the extended table to the [Sections] table |
Register_Code | 14.7.0 | Varchar2(2) | Continuing Education Register Code |
| Previous_Year_Class | 14.8.0 | Varchar2(1) | Previous Year Class Flag |
| Course_Offering | 14.8.0 | Varchar2(2) | Continuing Education Register Course Offering Code |
| ConEd_Course_Type | 14.8.0 | Varchar2(2) | Continuing Education Register Course Type (not used as of ver 15.3.0) |
| ConEd_CompleteCrsLessons | 14.8.0 | Number(11,0) | Continuing Education Register Number Of Lessons/Work Units for a Completed Course |
| SmallClassAdjustmentEligible | 14.9.0 | Varchar2(1) | Continuing Education Register Eligible for Small Class Adjustment Flag |
| IS_NumberSessionsCompleteCrs | 14.10.1 | Number(11,0) | Independent Study Number of Scheduled Teacher Contact Sessions (required to complete course) - drop-down with range of 10 to 30 |
| IS_DurationSessionsMinutes | 14.10.1 | Number(11,0) | Independent Study Duration of each Scheduled Teacher Contact session (minutes) |
| IS_WorkUnitsCompleteCrs | 14.10.1 | Number(11,0) | Independent Study Number of Work Units (required to complete course) - drop-down with range of 1 to 30 |
| IsIndependentStudy_Class | 15.1.1 | Varchar2(1) | Independent Study Class flag for the purposes of the class based registers and independent study ADE calculation |
| ConEd_DeliveryCode | 15.2.0 | Varchar2(1) | Continuing Education Register Delivery Code |
| ConEd_InternationalLanguage | 15.3.0 | Varchar2(3) | Continuing Education International Language Code |
| ConEd_SectionStartDate | 16.3.0 | Date | Continuing Education Class Start Date |
| ConEd_SectionEndDate | 16.3.0 | Date | Continuing Education Class End Date |
| Campus | 16.3.0 | Varchar2(20) | Campus Number. Migrated from [Sections.ON_Campus]. |
| Class_Code | 16.3.0 | Varchar2(25) | Class Code. Migrated from [Sections.ON_Class_Code]. |
| Class_Name | 16.3.0 | Varchar2(80) | Class Name. Migrated from [Sections.ON_Class_Name]. |
| Class_Type | 16.3.0 | Varchar2(3) | Class Type Code. Migrated from [Sections.ON_Class_Type]. |
| Classroom_Type | 16.3.0 | Varchar2(3) | Classroom Type Code. Migrated from [Sections.ON_Classroom_Type]. |
| CombinedClass_Flag | 16.3.0 | Number(1,0) | Combined Class Flag. Migrated from [Sections.ON_CombinedClass_Flag]. |
| Delivery_Type | 16.3.0 | Varchar2(3) | Delivery Type Code. Migrated from [Sections.ON_Delivery_Type]. |
| Lang_Pgm_Type | 16.3.0 | Varchar2(1) | Language Program Type Code. Migrated from [Sections.ON_Lang_Pgm_Type]. |
| OtherLanguageDesc | 16.6.0 | Varchar2(100) | A description identifying the 'other' language. This field is used when ConEd_InternationalLanguage has a value of 'OTH'. |
| TimeOfDayType | 16.6.0 | Varchar2(2) | Time of Day for an International Language Elementary (ILE) class. |
| ILE_ConEd_DeliveryCode | 16.12.1 | Varchar2(1) | Continuing Education Register for International Language Elementary (ILE) Delivery Code |
| ConEd_SectionStartTime | 17.8.0 | Varchar2(10) | Continuing Education Class Start Time |
| ConEd_SectionEndTime | 17.8.0 | Varchar2(10) | Continuing Education Class End Time |
| ConEd_SectionInstrMinutes | 17.8.0 | Number(11,0) | Continuing Education Total Instruction Minutes |
| OthCrsInfo_Cred_Recovery | 19.9.2.0 | VarChar2(10) | Indicates whether course is Credit Recovery. Valid Values 1, NULL |
| OthCrsInfo_Ministry_Content | 19.9.2.0 | VarChar2(10) | Indicates whether course is Ministry Developed Content. Valid Values 2, NULL |
| OthCrsInfo_UpgradCrdtCourse | 20.7.2.0 | VarChar2(10) | Indicates whether course is Upgrading Credit Course. Valid Values 3, NULL |
| CalcRepeatsOnCrsNum | 20.11.2.0 | Number(1,0) | Calculate Repeats on Course Number Flag. |
| OthCrsInfo_Online | 22.10.3.0 | Varchar(10) | Indicates whether course is online. Valid Values 4, NULL |