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. |