S_TX_STU_CTEPS_C (23.7.3)
This table is a child of the Students table and holds CTE Programs of Study records as calculated by TEA.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 23.7.3 | Number(11,0) | A foreign key that relates the child table record to the parent record in Students. |
COMMENTS | 23.7.3 | Varchar2(100) | Optional comment for the record. |
CTE_IND | 23.7.3 | Varchar2(1) | The CTE Indicator Code for the student’s Program of Study. |
FED_CAREER_CLUSTER | 23.7.3 | Varchar2(3) | The Federal Career Cluster for the Program of Study. |
PROG_STUDY | 23.7.3 | Varchar2(3) | The CTE Program of Study. |
STATE_CAREER_CLUSTER | 23.7.3 | Varchar2(3) | The State Career Cluster for the Program of Study. |
STATE_REG_PROG | 23.7.3 | Varchar2(1) | Indicates if the Program of Study is statewide (S) or regional (R). |
SYS_COMMENT | 23.7.3 | Varchar2(100) | System comment; typically populated with the date and timestamp of the record import. |
YEARID | 23.7.3 | Number(11,0) | The academic year ID for the record. |