S_TX_CONTACTS_S (ver 14.2.2)
This table is a standalone table and stores contact information for Texas students.
Column Name | Version | Data Type | Description |
---|---|---|---|
ID | 14.2.2 | Number(11,0) | Primary Key that indicates the unique parent ID. |
Contact_DOB | 14.2.2 | Date | Contact's date of birth. |
Employer | 14.2.2 | Varchar2(30) | Contact's employer. |
First_Name | 14.2.2 | Varchar2(75) | Contact's first name. |
Gender | 14.2.2 | Varchar2(6) | Gender of contact. |
Hispanic | 14.2.2 | Varchar2(6) | Indicates the contact's Hispanic/Latino status. Value is Yes if the contact is Hispanic. |
Home_Address_1 | 14.2.2 | Varchar2(40) | First line of the address of the contact's principal physical residence. |
Home_Address_2 | 14.2.2 | Varchar2(40) | Second line of the address of the contact's principal physical residence. |
Home_Address_3 | 14.2.2 | Varchar2(40) | Third line of the address of the contact's principal physical residence. |
Home_City | 14.2.2 | Varchar2(30) | City of the contact's principal physical address. |
Home_Phone | 14.2.2 | Varchar2(24) | Contact's home phone number. Include area code. |
Home_State | 14.2.2 | Varchar2(3) | State of the contact's principal physical address. |
Home_Zip_Code | 14.2.2 | Varchar2(17) | ZIP code of the contact's principal physical address. |
Job_Title | 14.2.2 | Varchar2(30) | Contacts' job title. |
Last_Name | 14.2.2 | Varchar2(75) | Contact's last name. |
Mailing_Address_1 | 14.2.2 | Varchar2(40) | First line of the contact's principal mailing address. |
Mailing_Address_2 | 14.2.2 | Varchar2(40) | Second line of the contact's principal mailing address. |
Mailing_Address_3 | 14.2.2 | Varchar2(40) | Third line of the contact's principal mailing address. |
Mailing_City | 14.2.2 | Varchar2(30) | City of the contact's principal mailing address. |
Mailing_State | 14.2.2 | Varchar2(2) | State of the contact's principal mailing address. |
Mailing_Zip_Code | 14.2.2 | Varchar2(17) | ZIP code of the contact's principal mailing address. |
Middle_Name | 14.2.2 | Varchar2(75) | Contact's middle name. |
Mobile_Phone | 14.2.2 | Varchar2(24) | Contact's mobile phone number. Include area code. |
Name_Prefix | 14.2.2 | Varchar2(20) | Contact Name Prefix Codes. |
Name_Suffix | 14.2.2 | Varchar2(10) | Contact Name Suffix Codes. |
Oral_Language_Code | 14.2.2 | Varchar2(16) | The code for the specific language or dialect that the contact uses to communicate orally. |
Personal_Email | 14.2.2 | Varchar2(128) | Contact's personal email address. Must be valid email address. |
Race_American_Indian | 14.2.2 | Varchar2(6) | Value is Yes if the contact indicates race code of American Indian. |
Race_Asian | 14.2.2 | Varchar2(6) | Value is Yes if the contact indicates race code of Asian. |
Race_Black | 14.2.2 | Varchar2(6) | Value is Yes if the contact indicates race code of Black. |
Race_Native_Hawaiian | 14.2.2 | Varchar2(6) | Value is Yes if the contact indicates race code of Native Hawaiian. |
Race_White | 14.2.2 | Varchar2(6) | Value is Yes if the contact indicates race code of White. |
Responsible_For | 14.2.2 | Varchar2(5) | Value is Yes if this contact is responsible for the student associated with this record. |
Work_Email | 14.2.2 | Varchar2(128) | Contact's work email address. Must be valid email address. |
Work_Phone | 14.2.2 | Varchar2(24) | Contact's work phone number. Include area code. |
Written_Language_Code | 14.2.2 | Varchar2(16) | The code for the specific language or dialect that the contact uses to communicate in writing. |