Skip to main content
Skip table of contents

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

ID19.6.2.0Number(11,0)Primary key.
Active_Date19.6.2.0DateThe date the facility became active.
Address19.6.2.0Varchar2(100)The facility's physical street address.
City19.6.2.0Varchar2(100)The city element of the facility's physical address.
Comments19.6.2.0Varchar2(500)Comments.
Contact_Email19.6.2.0Varchar2(255)The facility contact email address.
Contact_First19.6.2.0Varchar2(60)The facility contact's first name.
Contact_Last19.6.2.0Varchar2(60)The facility contact's last name.
Contact_Phone19.6.2.0Varchar2(50)The facility contact phone number.
E1627_RF_ID19.6.2.0Varchar2(6)The unique residential facility identification number registered with the Texas Education Agency.
Inactive_Date19.6.2.0DateThe date the facility became inactive.
Mailing_Address19.6.2.0Varchar2(100)The street element of the facility's mailing address.
Mailing_City19.6.2.0Varchar2(100)The city element of the facility's mailing address.
Mailing_State19.6.2.0Varchar2(2)The state element of the facility's mailing address.
Mailing_Zip19.6.2.0Varchar2(10)The zip code element of the facility's mailing address.
RF_Name19.6.2.0Varchar2(100)The name of the residential facility.
Secure19.6.2.0Varchar2(1)Indication as to whether this is a secure facility.
State19.6.2.0Varchar2(2)The state element of the facility's physical address.
Status19.6.2.0Varchar2(1)The operating status of the facility: Active or Inactive.
Total_Students19.6.2.0Number(4,0)The average total number of students served in the facility.
Zip19.6.2.0Varchar2(10)The zip code element of the facility's physical address.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.