S_TX_CONTACTS_S (ver 14.2.2)

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.