S_TX_CTE_IMPORT_S
This is a stand-alone table used for internal processing purposes by the Texas CTE Programs of Study Import Process.
Column Name | Version | Data Type | Description |
---|---|---|---|
ID | 23.12.2 | Number(19,0) | Primary Key |
Campus_ID | 23.12.2 | VarChar2(25) | TEA School Number |
CTE_Code | 23.12.2 | VarChar2(5) | CTE Indicator Code |
CTE_Code_Description | 23.12.2 | VarChar2(250) | CTE Indicator Code Description |
Fed_Career_Cluster | 23.12.2 | VarChar2(3 | Federal Career Cluster |
Grade_Level | 23.12.2 | Number(11,0) | Student Grade Level |
Import_File_Row_Number | 23.12.2 | Number(11,0) | Import File Row Number |
Import_Filename | 23.12.2 | VarChar2(260) | Import File Name |
Import_Status | 23.12.2 | VarChar2(50) | Status of the Import |
Prog_Study | 23.12.2 | VarChar2(3) | CTE Program of Study |
SchoolYear | 23.12.2 | Number(11,0) | School Year |
State_Career_Cluster | 23.12.2 | VarChar2(3) | State Career Cluster |
State_Reg_Prog | 23.12.2 | VarChar2(1) | State or Regional Program |
Student_Name | 23.12.2 | VarChar2(260) | Student Name |
Student_Number | 23.12.2 | Number(11,0) | Student Number |
Unique_Id | 23.12.2 | Number(11,0) | Student Unique ID |