S_TX_CRS_X (ver 14.4.0)
This table is an extension of the Courses table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 14.4.0 | Number(11,0) | A foreign key that relates the extended table to the [Courses] table. |
| AAR_Subject_Category | 18.2.0 | Varchar2(5) | The subject area for the course; used for TREX and the AAR. |
| Abbrev_Course_Name | 15.10.3 | Varchar2(50) | The abbreviated course name from Code Table C022 PEIMS Data Standards. Migrated from [Courses.abbrev_course_name]. |
| 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 [Courses.TX_Add_Explain_Code]. |
| Course_Sequence | 16.9.0 | Varchar2(1) | Identifies the information needed to determine the course sequence code for sections. |
| CPR_REQ | 23.6.2 | Number(1,0) | Identifies the course as meeting the graduation requirement for CPR based on course completion records. |
| CREDIT_RECOVERY | 23.9.3 | Number(1,0) | Identifies the course as a credit recovery course. |
| E0747_Population_Served | 17.8.0 | Varchar2(2) | The population served for the course. |
| E1055_Class_Type | 17.8.0 | Varchar2(2) | Indicates the Class Type of the course for the Fall PEIMS Staff Responsibilities collection. |
| E1072 | 15.10.3 | Varchar2(2) | The non-campus based instruction code for this course. Migrated from [Courses.E1072]. |
| E1081 | 15.10.3 | Number(11,0) | The number of college credit hours earned for a dual credit course. Migrated from [Courses.E1081]. |
E1183 | 15.10.3 | Number(11,0) | The number of parts for this course. Migrated from [Courses.E1183]. |
| E1186 | 15.10.3 | Varchar2(2) | The TSDS Subject Area code. Migrated from [Courses.E1186]. |
| E1193_02 | 15.10.3 | Number(1,0) | Identifies the course is Advanced Placement. Migrated from [Courses.E1193_02]. |
| E1193_03 | 15.10.3 | Number(1,0) | Identifies the course is a Core Subject. Migrated from [Courses.E1193_03]. |
| E1193_05 | 15.10.3 | Number(1,0) | Identifies the course is Dual Credit. Migrated from [Courses.E1193_05]. |
| E1193_06 | 15.10.3 | Number(1,0) | Identifies the course is Gifted and Talented. Migrated from [Courses.E1193_06]. |
| E1193_09 | 15.10.3 | Number(1,0) | Identifies the course is IB. Migrated from [Courses.E1193_09]. |
E1193_11 | 15.10.3 | Number(1,0) | Identifies the course is Pre-AP. Migrated from [Courses.E1193_11]. |
| E1193_12 | 15.10.3 | Number(1,0) | Identifies the course is Pre-IB. Migrated from [Courses.E1193_12]. |
| E1440_Homeroom_Section | 20.4.3 | Number(1,0) | Identifies the course is used as a homeroom section for the ECDS collection. |
| E1579_PK_Curricula | 17.2.0 | Varchar2(2) | Identifies the Pre-K curricula used for this course. |
| E1597_OnRamps | 17.8.0 | Varchar2(1) | Indicates that the course is an OnRamps dual credit course. |
| E1011_Dual_Credit | 17.8.0 | Varchar2(1) | Indicates the course is a dual credit course. |
| E1057_Monthly_Minutes | 18.7.0 | Number(11,0) | The Staff monthly minutes associated with this course; used as an override if the school's bell schedule does not accurately reflect the staff minutes. |
| E1058_ATC_Indicator | 17.8.0 | Varchar2(1) | Indicates if the career tech course is taught as part of an Advanced Technical Credit program. |
| 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. |
| ELO_Category | 19.6.1.0 | Varchar2(2) | Indicates the ELO category. |
| Exclude_From_AAR | 17.11.0 | Number(1,0) | Indicates if the course should be excluded from the Academic Achievement Record (AAR). Value is 1 if the course is excluded. |
| Exclude_From_090 | 15.10.3 | Number(1,0) | Indicates if the course should be excluded from the Create 090 Records process. Value is 1 if the course is excluded. This serves to exclude the course in the Fall PEIMS Staff Responsibilities collection and the Summer PEIMS collection. Migrated from [Courses.TX_ExcludeFrom090]. |
ExcludeFromTREx | 14.4.0 | Number(1,0) | Indicates if the course should be excluded from TREx. Value is 1 if the course is excluded. |
| ExcludeFromDashboard | 15.1.1 | Number(1,0) | Indicates if the course should be excluded from the Dashboards collection. Value is 1 if the course is excluded. |
| Explain_Code | 15.10.3 | Varchar2(2) | No longer used as of the July 2018 state reporting release; replaced by Explanation_Code_Combined. The explanation code that identifies the type of course. Migrated from [Courses.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. |
| PEACEOFF_REQ | 23.6.2 | Number(1,0) | Identifies the course as meeting the graduation requirement for Peace Officer Instruction based on course completion records. |
| SPEECH_REQ | 23.6.2 | Number(1,0) | Identifies the course as meeting the graduation requirement for Speech based on course completion records. |
| Vocational_Contact_Hours | 15.10.3 | Number(11,0) | Identifies the number of vocational contact hours this course receives. Migrated from [Courses.TX_Vocational_Contact_Hrs]. |