S_TX_ASKTED_S (ver 23.4.1)
This table is a stand-alone table that stores the Texas school directories from the TEA AskTED application.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 23.4.1.0 | Number(19,0) | Primary Key. |
DISTRICT_NAME | 23.4.1.0 | Varchar2(75) | District Name |
DISTRICT_NUMBER | 23.4.1.0 | Varchar2(6) | District Number |
DISTRICT_TYPE | 23.4.1.0 | Varchar2(20) | District Type, such as Charter or Independent |
INSTRUCTION_TYPE | 23.4.1.0 | Varchar2(30) | Instruction Type, such as Regular Instructional |
SCHOOL_NAME | 23.4.1.0 | Varchar2(75) | School Name |
SCHOOL_NUMBER | 23.4.1.0 | Varchar2(9) | School Number (CDC) |
SCHOOL_STATUS | 23.4.1.0 | Varchar2(10) | School Status, such as Active |
VERSION | 23.4.1.0 | Varchar2(5) | AskTED Directory Version, such as F2018 (fall 2018) or S2022 (spring 2022) |