S_TX_SERVICE_ID_S (ver 20.3.2.0)
This table is a stand-alone table that stores state course codes from the TEA C022 Service ID Table
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 20.3.2.0 | Number(19,0) | Primary Key. |
| COURSE_ABBREVIATION | 20.3.2.0 | Varchar2(50) | The abbreviated course name. |
| COURSE_TRANSLATION | 20.3.2.0 | Varchar2(2000) | The full name and description of the course. |
| COURSE_UNITS | 20.3.2.0 | Varchar2(10) | The course units - typically the credit hours that a student can earn. |
| CTE_COURSE | 20.3.2.0 | Varchar2(1) | Indication if the course is considered a funded Career and Technology (CTE) course for high school (H) or middle school (M). |
| CTE_FUND_TIER | 22.11.3 | Number(11,0) | The CTE Fund Tier of the CTE Course. |
| CTE_FUND_WEIGHT | 22.11.3 | Number(25,10) | The CTE Fund Weight of the CTE Course. |
| ELIG_FOR_HS | 20.3.2.0 | Number(1,0) | Indication if the course is eligible for high school credit. |
| SERVICE_ID | 20.3.2.0 | Varchar2(8) | The TEA Service ID for the courses (state course code). |
| SHORT_DESC | 20.3.2.0 | Varchar2(1000) | The short name for the course. |
| YEARID | 20.3.2.0 | Number(11,0) | The Year ID for the record such as Year ID 29, which refers to the 2019-20 school year. The number is equal to starting year of the school year, minus 1990. |