S_TX_DISTRICT_RFT_S (ver 19.6.2.0)
This table is a stand-alone table that stores TSDS Residential Facility information.
Column Name | Version | Data Type | Description |
---|---|---|---|
ID | 19.6.2.0 | Number(11,0) | Primary key. |
Active_Date | 19.6.2.0 | Date | The date the facility became active. |
Address | 19.6.2.0 | Varchar2(100) | The facility's physical street address. |
City | 19.6.2.0 | Varchar2(100) | The city element of the facility's physical address. |
Comments | 19.6.2.0 | Varchar2(500) | Comments. |
Contact_Email | 19.6.2.0 | Varchar2(255) | The facility contact email address. |
Contact_First | 19.6.2.0 | Varchar2(60) | The facility contact's first name. |
Contact_Last | 19.6.2.0 | Varchar2(60) | The facility contact's last name. |
Contact_Phone | 19.6.2.0 | Varchar2(50) | The facility contact phone number. |
E1627_RF_ID | 19.6.2.0 | Varchar2(6) | The unique residential facility identification number registered with the Texas Education Agency. |
Inactive_Date | 19.6.2.0 | Date | The date the facility became inactive. |
Mailing_Address | 19.6.2.0 | Varchar2(100) | The street element of the facility's mailing address. |
Mailing_City | 19.6.2.0 | Varchar2(100) | The city element of the facility's mailing address. |
Mailing_State | 19.6.2.0 | Varchar2(2) | The state element of the facility's mailing address. |
Mailing_Zip | 19.6.2.0 | Varchar2(10) | The zip code element of the facility's mailing address. |
RF_Name | 19.6.2.0 | Varchar2(100) | The name of the residential facility. |
Secure | 19.6.2.0 | Varchar2(1) | Indication as to whether this is a secure facility. |
State | 19.6.2.0 | Varchar2(2) | The state element of the facility's physical address. |
Status | 19.6.2.0 | Varchar2(1) | The operating status of the facility: Active or Inactive. |
Total_Students | 19.6.2.0 | Number(4,0) | The average total number of students served in the facility. |
Zip | 19.6.2.0 | Varchar2(10) | The zip code element of the facility's physical address. |