S_ID_SEC_X (ver 14.4.0)
This is an extension of the Sections table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| SectionsDCID | 14.4.0 | Number(10,0) | Primary Key |
| AmtCredit | 14.8.2 | Number(25,10) | Cost in dollars of Credits for this section, if different from course. |
| AP | 15.7.0 | Varchar2(5) | AP Course Override (Y/N/null). Migrated from [Sections.ID_AP]. |
| AssignmentCode | 15.7.0 | Varchar2(12) | Primary Teacher Assignment Code. Migrated from [Sections.ID_AssignmentCode]. |
| ClassLevel | 15.7.0 | Varchar2(5) | Class Level Override (1 char code). Migrated from [Sections.ID_ClassLevel]. |
| CollegeCredits | 14.8.2 | Number(25,10) | Credits offered for this section, if different from course. |
| CollegeID | 14.8.2 | Varchar2(4) | Code for the college that offered the credit for this section, if different from course. |
| ContractNo | 15.7.0 | Number(11,0) | Contract Number for Primary Teacher. Migrated from [Sections.ID_ContractNo]. |
| CoTeach2AssignmentCode | 15.7.0 | Varchar2(12) | Third Teacher Assignment Code. Migrated from [Sections.ID_CoTeach2AssignmentCode]. |
| CoTeach2ContractNo | 15.7.0 | Number(11,0) | Third Teacher Contract Number. Migrated from [Sections.ID_CoTeach2ContractNo]. |
| CoTeach2EndDate | 15.7.0 | Date | Third Teacher Assignment End Date. Migrated from [Sections.ID_CoTeach2EndDate]. |
| CoTeach2FTE | 15.7.0 | Number(25,10) | Third Teacher FTE. Migrated from [Sections.ID_CoTeach2FTE]. |
| CoTeach2HQDate | 15.7.0 | Date | No longer in use. Migrated from [Sections.ID_CoTeach2HQDate]. |
| CoTeach2HQT | 15.7.0 | Varchar2(5) | No longer in use. Migrated from [Sections.ID_CoTeach2HQT]. |
| CoTeach2MeansToHQT | 15.7.0 | Varchar2(5) | No longer in use. Migrated from [Sections.ID_CoTeach2MeansToHQT]. |
| CoTeach2NoncertHours | 15.7.0 | Number(25,10) | Third Teacher Non-certified Hours per week. Migrated from [Sections.ID_CoTeach2NoncertHours]. |
| CoTeach2NoncertRate | 15.7.0 | Number(25,10) | Third Teacher Non-certified Rate. Migrated from [Sections.ID_CoTeach2NoncertRate]. |
| CoTeach2NoncertWeeks | 15.7.0 | Number(11,0) | Third Teacher Non-certified Weeks. Migrated from [Sections.ID_CoTeach2NoncertWeeks]. |
| CoTeach2QualOverride | 15.7.0 | Varchar2(5) | No longer in use. Migrated from [Sections.ID_CoTeach2QualOverride]. |
| CoTeach2StaffId | 15.7.0 | Varchar2(20) | Third Teacher Idaho Staff ID. Migrated from [Sections.ID_CoTeach2StaffId]. |
| CoTeach2StartDate | 15.7.0 | Date | Third Teacher Assignment Start Date. Migrated from [Sections.ID_CoTeach2StartDate]. |
| CoTeach2TeachingRole | 15.7.0 | Varchar2(5) | Third Teacher Teaching Role (1 char code). Migrated from [Sections.ID_CoTeach2TeachingRole]. |
| CoTeachAssignmentCode | 15.7.0 | Varchar2(12) | Second Teacher Assignment Code. Migrated from [Sections.ID_CoTeachAssignmentCode]. |
| CoTeachContractNo | 15.7.0 | Number(11,0) | Second Teacher Contract Number. Migrated from [Sections.ID_CoTeachContractNo]. |
| CoTeachEndDate | 15.7.0 | Date | Second Teacher Assignment End Date. Migrated from [Sections.ID_CoTeachEndDate]. |
| CoTeachFTE | 15.7.0 | Number(25,10) | Second Teacher FTE. Migrated from [Sections.ID_CoTeachFTE]. |
| CoTeachHQDate | 15.7.0 | Date | No longer in use. Migrated from [Sections.ID_CoTeachHQDate]. |
| CoTeachHQT | 15.7.0 | Varchar2(5) | No longer in use. Migrated from [Sections.ID_CoTeachHQT]. |
| CoTeachMeansToHQT | 15.7.0 | Varchar2(5) | No longer in use. Migrated from [Sections.ID_CoTeachMeansToHQT]. |
| CoTeachNoncertHours | 15.7.0 | Number(25,10) | Second Teacher Non-certified Hours per week. Migrated from [Sections.ID_CoTeachNoncertHours]. |
| CoTeachNoncertRate | 15.7.0 | Number(25,10) | Second Teacher Non-certified Rate. Migrated from [Sections.ID_CoTeachNoncertRate]. |
| CoTeachNoncertWeeks | 15.7.0 | Number(11,0) | Second Teacher Non-certified Weeks. Migrated from [Sections.ID_CoTeachNoncertWeeks]. |
| CoTeachQualOverride | 15.7.0 | Varchar2(5) | No longer in use. Migrated from [Sections.ID_CoTeachQualOverride]. |
| CoTeachStaffId | 15.7.0 | Varchar2(20) | Second Teacher Idaho Staff ID. Migrated from [Sections.ID_CoTeachStaffId]. |
| CoTeachStartDate | 15.7.0 | Date | Second Teacher Assignment Start Date. Migrated from [Sections.ID_CoTeachStartDate]. |
| CoTeachTeachingRole | 15.7.0 | Varchar2(5) | Second Teacher Teaching Role (1 char code). Migrated from [Sections.ID_CoTeachTeachingRole]. |
| CourseCode | 15.7.0 | Varchar2(12) | State Course Code Override. Migrated from [Sections.ID_CourseCode]. |
| CourseContract | 15.7.0 | Varchar2(5) | Provider Contract in Place (Y/N/null). Migrated from [Sections.ID_CourseContract]. |
| CourseStandards | 15.7.0 | Varchar2(5) | Course Standards Override (1 char code). Migrated from [Sections.ID_CourseStandards]. |
| CourseType | 15.7.0 | Varchar2(5) | ISEE Course Type Override (1 char code). Migrated from [Sections.ID_CourseType]. |
| DualCredit | 15.7.0 | Varchar2(5) | Dual Credit Override (Y/N/null). Migrated from [Sections.ID_DualCredit]. |
| Eightin6CourseCost | 14.4.0 | Number(11,0) | Whole number (integer) cost of 8in6 for the given section. |
| EndDate | 15.7.0 | Date | Primary Teacher Assignment End Date. Migrated from [Sections.ID_EndDate]. |
| FTE | 15.7.0 | Number(25,10) | FTE for primary teacher. Migrated from [Sections.ID_FTE]. |
| GradeLevel | 15.7.0 | Varchar2(5) | Grade Level Override (2 char code). Migrated from [Sections.ID_GradeLevel]. |
| HQDate | 15.7.0 | Date | No longer in use. Migrated from [Sections.ID_HQDate]. |
| HQT | 15.7.0 | Varchar2(5) | No longer in use. Migrated from [Sections.ID_HQT]. |
| IB | 15.7.0 | Varchar2(5) | IB Course Override (Y/N/null). Migrated from [Sections.ID_IB]. |
| InstrSetting | 15.7.0 | Varchar2(5) | No longer in use. Migrated from [Sections.ID_InstrSetting]. |
| InstructionalSetting | 15.7.0 | Varchar2(5) | Instructional Setting Override (2 char code). Migrated from [Sections.ID_InstructionalSetting]. |
| MeansToHQT | 15.7.0 | Varchar2(5) | No longer in use. Migrated from [Sections.ID_MeansToHQT]. |
| MinsWeek | 15.7.0 | Number(11,0) | Minutes per Week (average for each week). Migrated from [Sections.ID_MinsWeek]. |
| NoncertHours | 15.7.0 | Number(25,10) | Primary Teacher Non-certified Hours per week. Migrated from [Sections.ID_NoncertHours]. |
| NoncertRate | 15.7.0 | Number(25,10) | Primary Teacher Non-certified Rate. Migrated from [Sections.ID_NoncertRate]. |
| NoncertWeeks | 15.7.0 | Number(11,0) | Primary Teacher Non-certified Weeks. Migrated from [Sections.ID_NoncertWeeks]. |
| ProviderInstructor1 | 15.7.0 | Varchar2(20) | Provider Instructor 1 ID. Migrated from [Sections.ID_ProviderInstructor1]. |
| ProviderInstructor1Name | 15.7.0 | Varchar2(100) | Provider Instructor 1 Name. Migrated from [Sections.ID_ProviderInstructor1Name]. |
| ProviderInstructor2 | 15.7.0 | Varchar2(20) | Provider Instructor 2 ID. Migrated from [Sections.ID_ProviderInstructor2]. |
| ProviderInstructor2Name | 15.7.0 | Varchar2(100) | Provider Instructor 2 Name. Migrated from [Sections.ID_ProviderInstructor2Name]. |
| ProviderSchool | 15.7.0 | Varchar2(8) | Provider School ID. Migrated from [Sections.ID_ProviderSchool]. |
| ProviderSchoolName | 14.8.2 | Varchar2(50) | Name of school providing section for enrollment. |
| QualOverride | 15.7.0 | Varchar2(5) | No longer in use. Migrated from [Sections.ID_QualOverride]. |
| StartDate | 15.7.0 | Date | Primary Teacher Assignment Start Date. Migrated from [Sections.ID_StartDate]. |
| TeachingRole | 15.7.0 | Varchar2(5) | Primary Teacher Teaching Role (1 char code). Migrated from [Sections.ID_TeachingRole]. |
| TechPrep | 15.7.0 | Varchar2(5) | Tech Prep Override (Y/N/null). Migrated from [Sections.ID_TechPrep]. |
| creditRecovery | 17.9.0 | Varchar2(5) | Credit Recovery (Y/N). |
ExcludefromFTE | 19.2.0 | Boolean | Indicates whether or not the section is excluded from FTE. |
FTEOverride | 19.4.1.0 | Boolean | Indicates whether or not the Teacher's FTE is an override. |
CoTchFTEOverride | 19.4.1.0 | Boolean | Indicates whether or not the Co-Teacher's FTE is an override. |
CoTch2FTEOverride | 19.4.1.0 | Boolean | Indicates whether or not the second Co-Teacher's FTE is an override. |