Skip to main content
Skip table of contents

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_Category18.2.0Varchar2(5)The subject area for the course; used for TREX and the AAR.
Abbrev_Course_Name15.10.3

Varchar2(50)

The abbreviated course name from Code Table C022 PEIMS Data Standards. Migrated from [Courses.abbrev_course_name].
Additional_Explain_Code15.10.3Varchar2(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_Sequence16.9.0Varchar2(1)Identifies the information needed to determine the course sequence code for sections.
CPR_REQ23.6.2Number(1,0)Identifies the course as meeting the graduation requirement for CPR based on course completion records.
CREDIT_RECOVERY23.9.3Number(1,0)Identifies the course as a credit recovery course.
E0747_Population_Served17.8.0Varchar2(2)The population served for the course.
E1055_Class_Type17.8.0Varchar2(2)Indicates the Class Type of the course for the Fall PEIMS Staff Responsibilities collection.
E107215.10.3Varchar2(2)The non-campus based instruction code for this course. Migrated from [Courses.E1072].
E108115.10.3Number(11,0)The number of college credit hours earned for a dual credit course. Migrated from [Courses.E1081].

E1183

15.10.3Number(11,0)The number of parts for this course. Migrated from [Courses.E1183].
E118615.10.3Varchar2(2)The TSDS Subject Area code. Migrated from [Courses.E1186].
E1193_0215.10.3Number(1,0)Identifies the course is Advanced Placement. Migrated from [Courses.E1193_02].
E1193_0315.10.3Number(1,0)Identifies the course is a Core Subject. Migrated from [Courses.E1193_03].
E1193_0515.10.3Number(1,0)Identifies the course is Dual Credit. Migrated from [Courses.E1193_05].
E1193_0615.10.3Number(1,0)Identifies the course is Gifted and Talented. Migrated from [Courses.E1193_06].
E1193_0915.10.3Number(1,0)Identifies the course is IB. Migrated from [Courses.E1193_09].

E1193_11

15.10.3Number(1,0)Identifies the course is Pre-AP. Migrated from [Courses.E1193_11].
E1193_1215.10.3Number(1,0)Identifies the course is Pre-IB. Migrated from [Courses.E1193_12].
E1440_Homeroom_Section20.4.3Number(1,0)Identifies the course is used as a homeroom section for the ECDS collection.
E1579_PK_Curricula17.2.0Varchar2(2)Identifies the Pre-K curricula used for this course.
E1597_OnRamps17.8.0Varchar2(1)Indicates that the course is an OnRamps dual credit course.
E1011_Dual_Credit17.8.0Varchar2(1)Indicates the course is a dual credit course.
E1057_Monthly_Minutes18.7.0Number(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_Indicator17.8.0Varchar2(1)Indicates if the career tech course is taught as part of an Advanced Technical Credit program.
E1604_Days_Taught_Week_118.7.0Number(11,0)The number of days the PE class meets during the first week of October.
E1605_Days_Taught_Week_218.7.0Number(11,0)The number of days the PE class meets during the second week of October.
E1606_Days_Taught_Week_318.7.0Number(11,0)The number of days the PE class meets during the third week of October.
E1607_Days_Taught_Week_418.7.0Number(11,0)The number of days the PE class meets during the fourth week of October.
E1608_Minutes_Taught_Week_118.7.0Number(11,0)The number of minutes the PE class meets during the first week of October.
E1609_Minutes_Taught_Week_218.7.0Number(11,0)The number of minutes the PE class meets during the second week of October.
E1610_Minutes_Taught_Week_318.7.0Number(11,0)The number of minutes the PE class meets during the third week of October.
E1611_Minutes_Taught_Week_418.7.0Number(11,0)The number of minutes the PE class meets during the fourth week of October.
E1614_ELO_Type19.6.1.0Varchar2(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_Minutes19.6.1.0Number(11,0)Indicates the number of minutes scheduled for an Expanded Learning Opportunity (ELO) each day.
ELO_Category19.6.1.0Varchar2(2)Indicates the ELO category.
Exclude_From_AAR17.11.0Number(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_09015.10.3Number(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.

ExcludeFromDashboard15.1.1Number(1,0)Indicates if the course should be excluded from the Dashboards collection. Value is 1 if the course is excluded.
Explain_Code15.10.3Varchar2(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_Combined18.7.0Varchar2(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_REQ23.6.2Number(1,0)Identifies the course as meeting the graduation requirement for Peace Officer Instruction based on course completion records.
SPEECH_REQ23.6.2Number(1,0)Identifies the course as meeting the graduation requirement for Speech based on course completion records.
Vocational_Contact_Hours15.10.3Number(11,0)Identifies the number of vocational contact hours this course receives. Migrated from [Courses.TX_Vocational_Contact_Hrs].




JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.