S_NY_CONTACTS (ver 13.9.0)
This table is a standalone table and stores contact information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 13.9.0 | Number (11,0) | Primary Key |
First_Name | 13.9.0 | Varchar2 (75) | Contact's first name |
Gender | 13.9.0 | Varchar2 (6) | Gender of contact |
Home_Address_1 | 13.9.0 | Varchar2 (40) | First line of the address of the contact's principal physical residence |
Home_Address_2 | 13.9.0 | Varchar2 (40) | Second line of the address of the contact's principal physical residence |
Home_Address_3 | 13.9.0 | Varchar2 (40) | Third line of the address of the contact's principal physical residence |
Home_City | 13.9.0 | Varchar2 (30) | City of the contact's principal physical address |
Home_Country_Code | 13.9.0 | Varchar2 (4) | Country of the contact's principal physical address |
Home_Phone | 13.9.0 | Varchar2 (24) | Contact's home phone number. Include area code |
Home_State | 13.9.0 | Varchar2 (3) | State of the contact's principal physical address |
Home_State_County_Name | 13.9.0 | Varchar2 (30) | County of the contact's principal physical address |
Home_Zip_Code | 13.9.0 | Varchar2 (17) | ZIP code of the contact's principal physical address |
Last_Name | 13.9.0 | Varchar2 (75) | Contact's last name |
Mailing_Address_1 | 13.9.0 | Varchar2 (40) | First line of the contact's principal mailing address |
Mailing_Address_2 | 13.9.0 | Varchar2 (40) | Second line of the contact's principal mailing address |
Mailing_Address_3 | 13.9.0 | Varchar2 (40) | Third line of the contact's principal mailing address |
Mailing_City | 13.9.0 | Varchar2 (30) | City of the contact's principal mailing address |
Mailing_Country_Code | 13.9.0 | Varchar2 (4) | Country of the contact's principal mailing address |
Mailing_State | 13.9.0 | Varchar2 (3) | State of the contact's principal mailing address |
Mailing_State_County_Name | 13.9.0 | Varchar2 (30) | County of the contact's principal mailing address |
Mailing_Zip_Code | 13.9.0 | Varchar2 (17) | ZIP code of the contact's principal mailing address |
Middle_Name | 13.9.0 | Varchar2 (75) | Contact's middle name |
Mobile_Phone | 13.9.0 | Varchar2 (24) | Contact's mobile phone number. Include area code |
Name_Prefix | 13.9.0 | Varchar2 (20) | Contact Name Prefix Codes |
Name_Suffix | 13.9.0 | Varchar2 (10) | Contact Name Suffix Codes |
Oral_Language_Code | 13.9.0 | Varchar2 (16) | The code for the specific language or dialect that the contact uses to communicate orally |
Personal_Email | 13.9.0 | Varchar2 (250) | Contact's personal email address. Must be valid email address |
Primary_Contact_ID | 13.9.0 | Varchar2 (9) | Unique identifier assigned to the contact by the Local Education Agency (LEA) reporting the data |
State_Contact_ID | 13.9.0 | Varchar2 (10) | Contact ID provided by contact at time of proof of identity |
WhenCreated | 13.9.0 | Date | Date the record was created |
WhenModified | 13.9.0 | Date | Date the record was last modified |
WhoCreated | 13.9.0 | Varchar2 (100) | The ID of the user who created the record |
WhoModified | 13.9.0 | Varchar2 (100) | The ID of the user who last modified the record |
Work_Email | 13.9.0 | Varchar2 (250) | Contact's work email address. Must be valid email address |
Work_Phone | 13.9.0 | Varchar2 (24) | Contact's work phone number. Include area code |
Written_Language_Code | 13.9.0 | Varchar2 (16) | The code for the specific language or dialect that the contact uses to communicate in writing |