S_TX_SEC_X (ver 14.4.0)
This table is an extension of the Sections table.
Column Name | Version | Data Type | Description |
---|---|---|---|
SectionsDCID | 14.4.0 | Number(10,0) | A foreign key that relates the extended table to the [Sections] table. |
AAR_Subject_Category | 18.5.0 | Varchar2(5) | The subject area for the section; used for TREX and the AAR. |
Abbrev_Course_Name | 18.5.0 | Varchar2(50) | The abbreviated course name from Code Table C022 PEIMS Data Standards. |
Additional_Explain_Code | 15.10.3 | Varchar2(9) | No longer used as of the July 2018 state reporting release; replaced by Explanation_Code_Combined. Any additional explanation codes that identify the type of course. Migrated from [Sections.TX_Add_Explain_Code]. |
Alt_Course_Number | 15.10.3 | Varchar2(8) | An override to the course alternate course Number. Migrated from [Sections.alt_course_Number]. |
Credit_Recovery | 23.9.3 | Number(1,0) | Identifies the section as a credit recovery course section. |
E0721 | 15.10.3 | Varchar2(3) | The Role ID of the current lead teacher of the section. Migrated from [Sections.E0721]. |
E0747_Population_Served | 16.10.0 | Varchar2(2) | The population served for this section. |
E0948_Course_Seq_Calc | 22.11.1 | Varchar2(3) | The Calculated Course Sequence Code. |
E0948_Course_Seq_Override | 16.10.0 | Varchar2(1) | The Course Sequence Code override if different from course setting. |
E1011_Dual_Credit | 16.10.0 | Varchar2(1) | Indicates the section is a dual credit class. |
E1055_Class_Type | 16.10.0 | Varchar2(2) | Indicates the Class Type of this section for the Fall PEIMS Staff Responsibilities collection. |
E1056_ClassID_Override | 16.10.0 | Varchar2(14) | Indicates the unique section ID if an override of the calculated value. |
E1056_SectionIden_Calc | 22.6.1 | Varchar2(255) | The calculated unique Ed-Fi Section Identifier. |
E1056_SectionIden_Ovr | 22.6.1 | Varchar2(255) | The user-defined override for the unique Ed-Fi Section Identifier. |
E1057_Monthly_Minutes | 18.7.0 | Number(11,0) | The Staff monthly minutes associated with this section; used as an override if the school's bell schedule does not accurately reflect the staff minutes. |
E1058_ATC_Indicator | 16.10.0 | Varchar2(1) | Indicates if the career tech course is taught as part of an Advanced Technical Credit program. |
E1072_Non_Campus_Based_Instr | 16.10.0 | Varchar2(2) | Indicates the Non-Campus Based instruction code for this section if different from the course setting. |
E1081_College_Credit | 16.10.0 | Number(11,0) | Indicates the number of college credit hours received if the course is passed and is dual credit. |
E1363_Number_of_Parts | 16.10.0 | Number(11,0) | Indicates the part number of this section in reference to the course parts. This is used for the TSDS Dashboard. |
E1440_Homeroom_Section | 16.10.0 | Number(1,0) | Indicates if this section is a homeroom class for PK, KG, 1, and 2 grade for Early Childhood Data System collection. |
E1555_PK_School_Type | 17.2.0 | Varchar2(2) | Indicates the Pre-K School Type for this section. Use only as an override from the District or School setting. Deprecated as of the June 2020 release. |
E1558_Student_Instruction | 17.2.0 | Varchar2(2) | Indicates the Pre-K Student Instruction for this section. All students in this section will be Full Day, Half-day AM or Half-day PM. |
E1579_PK_Curricula | 17.2.0 | Varchar2(2) | Indicates the Pre-K Curricula used for this section. Use only as an override from the District or School setting. |
E1580_High_Qual_PK_Prog | 17.2.0 | Number(1,0) | Indicates the section is receiving funds from the High Quality Pre-K Program. Use only as an override from the District or School setting. |
E1597_OnRamps | 17.8.0 | Varchar2(1) | Indicates that the section is an OnRamps dual credit course section. |
E1604_Days_Taught_Week_1 | 18.7.0 | Number(11,0) | The number of days the PE class meets during the first week of October. |
E1605_Days_Taught_Week_2 | 18.7.0 | Number(11,0) | The number of days the PE class meets during the second week of October. |
E1606_Days_Taught_Week_3 | 18.7.0 | Number(11,0) | The number of days the PE class meets during the third week of October. |
E1607_Days_Taught_Week_4 | 18.7.0 | Number(11,0) | The number of days the PE class meets during the fourth week of October. |
E1608_Minutes_Taught_Week_1 | 18.7.0 | Number(11,0) | The number of minutes the PE class meets during the first week of October. |
E1609_Minutes_Taught_Week_2 | 18.7.0 | Number(11,0) | The number of minutes the PE class meets during the second week of October. |
E1610_Minutes_Taught_Week_3 | 18.7.0 | Number(11,0) | The number of minutes the PE class meets during the third week of October. |
E1611_Minutes_Taught_Week_4 | 18.7.0 | Number(11,0) | The number of minutes the PE class meets during the fourth week of October. |
E1614_ELO_Type | 19.6.1.0 | Varchar2(2) | Indicates the type of expanded learning opportunity (ELO) program offered at the campus or the type of expanded learning opportunity (ELO) participated in by the student. |
E1621_ELO_Minutes | 19.6.1.0 | Number(11,0) | Indicates the number of minutes scheduled for an Expanded Learning Opportunity (ELO) each day. |
E1626_Program_Eval_Type | 18.7.0 | Varchar2(1) | Indicates the type of program evaluation tool that is used for each High-Quality PK course/section. |
E1726 Child_Care_Operator | 23.8.1 | Varchar2(8) | The eight digit Child Care Operator number for the section; reported for the ECDS collection. |
EducationalEnvironment | 14.4.0 | Varchar2(40) | Used to define the environment of the section for absences. |
ELO_Category | 19.6.1.0 | Varchar2(2) | Indicates the ELO category. |
Exclude_CTE_Hrs_End_Date | 20.10.2 | Date | Indicates the End Date for excluding Vocational Hours for CTE funding for the section. Obsolete as of August 2021; replaced by similar field in the new S_TX_SEC_EXCLUDE_CTE_C table. |
Exclude_CTE_Hrs_Start_Date | 20.10.2 | Date | Indicates the Start Date for excluding Vocational Hours for CTE funding for the section. Obsolete as of August 2021; replaced by similar field in the new S_TX_SEC_EXCLUDE_CTE_C table. |
Exclude_From_090 | 16.9.6 | Number(1,0) | Indicates that this section should not be included in the Staff Association, Student Enrollment, Student Transcript, and Master Schedule Interchanges. This is an override from the course setting. |
Exclude_From_AAR | 17.11.0 | Number(1,0) | Indicates if the section should be excluded from the Academic Achievement Record (AAR). |
ExcludeFromTREx | 14.4.0 | Number(1,0) | Value is Yes if this section is excluded from TREx. |
Explain_Code | 15.10.3 | Varchar2(2) | No longer used as of the July 2018 state reporting release; replaced by Explanation_Code_Combined. Any additional explanation codes that identify the type of course. Migrated from [Sections.ExplanationCode]. |
Explanation_Code_Combined | 18.7.0 | Varchar2(100) | The Special Explanation Code(s) that identify the type of course; used in the AAR and TREx. As of the July 2018 state reporting release, this single field replaces the now obsolete Explain_Code and Additional_Explain_Code fields. |
Mixed_Grade_Level | 17.4.0 | Number(1,0) | Indicates the section enrollment is composed of students in mixed grade levels; used for elementary Montessori-type classrooms. |
Vocational_Contact_Hours | 15.10.3 | Number(11,0) | Identifies the Number of vocational contact hours this section receives. Migrated from [Sections.TX_Vocational_Contact_Hrs]. |