S_OH_CONTACTVALIDATE_S (ver 14.6.3)
This table is a standalone table and stores the contact information used during validation portion of the contact conversion mapping process.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 14.6.3 | Number(11,0) | Primary Key. |
| CANPICKUP | 14.6.3 | VarChar2(1) | Data point, flag identifying a contact who can pick up associated student, used in the validation process of the contact conversion mapping process. |
| CONTACT_SEQUENCE | 14.6.3 | Number(11,0) | Data point, order in which a contact is notified, used in the validation process of the contact conversion mapping process. |
| COPY_OF_CORRESPONDENCE | 14.6.3 | VarChar2(1) | Data point, flag identifying a contact who can receive correspondence associated student, used in the validation process of the contact conversion mapping process. |
| CUSTODIAL_FLAG | 14.6.3 | VarChar2(1) | Data point, flag identifying a contact as custodian, used in the validation process of the contact conversion mapping process. |
| EMAIL_HOME | 14.6.3 | VarChar2(60) | Data point, home email address, used in the validation process of the contact conversion mapping process. |
| EMAIL_OTHER | 14.6.3 | VarChar2(60) | Data point, other email address, used in the validation process of the contact conversion mapping process. |
| EMAIL_PERSONAL | 14.6.3 | VarChar2(60) | Data point, personal email address, used in the validation process of the contact conversion mapping process. |
| EMAIL_WORK | 14.6.3 | VarChar2(60) | Data point, work email address, used in the validation process of the contact conversion mapping process. |
| EMERGENCY_CONTACT | 14.6.3 | VarChar2(1) | Data point, flag identifying a contact as an emergency contact, used in the validation process of the contact conversion mapping process. |
| EMPLOYER | 14.6.3 | VarChar2(60) | Data point, contact employer, used in the validation process of the contact conversion mapping process. |
| FIRST_NAME | 14.6.3 | VarChar2(45) | Data point, contact first name, used in the validation process of the contact conversion mapping process. |
| GENDER | 14.6.3 | VarChar2(1) | Data point, gender of contact, used in the validation process of the contact conversion mapping process. |
| JOB_TITLE | 14.6.3 | VarChar2(25) | Data point, contact job title, used in the validation process of the contact conversion mapping process. |
| LAST_NAME | 14.6.3 | VarChar2(45) | Data point, contact last name, used in the validation process of the contact conversion mapping process. |
| LEGAL_GUARDIANSHIP_FLAG | 14.6.3 | VarChar2(1) | Data point, flag identifying a contact as the legal guardian, used in the validation process of the contact conversion mapping process. |
| LINK_ID | 14.6.3 | Number(11,0) | Internal ID used for combining multiple contact records during the contact conversion mapping process |
| MAILING_ADDRESS_LINE_1 | 14.6.3 | VarChar2(60) | Data point, mailing address line 1, used in the validation process of the contact conversion mapping process. |
| MAILING_ADDRESS_LINE_2 | 14.6.3 | VarChar2(60) | Data point, mailing address line 2, used in the validation process of the contact conversion mapping process. |
| MAILING_CITY | 14.6.3 | VarChar2(30) | Data point, mailing address city, used in the validation process of the contact conversion mapping process. |
| MAILING_COUNTRY_CODE | 14.6.3 | VarChar2(2) | Data point, mailing address country code, used in the validation process of the contact conversion mapping process. |
| MAILING_COUNTY_CODE | 14.6.3 | VarChar2(2) | Data point, mailing address county code, used in the validation process of the contact conversion mapping process. |
| MAILING_POSTAL_CODE | 14.6.3 | VarChar2(11) | Data point, mailing address postal code, used in the validation process of the contact conversion mapping process. |
| MAILING_STATEPROVINCE_CODE | 14.6.3 | VarChar2(2) | Data point, mailing address state code , used in the validation process of the contact conversion mapping process. |
| MIDDLE_NAME | 14.6.3 | VarChar2(30) | Data point, middle name, used in the validation process of the contact conversion mapping process. |
| NOTES | 14.6.3 | VarChar2(4000) | Data point, notes , used in the validation process of the contact conversion mapping process. |
| OTHER_ADDRESS_LINE_1 | 14.6.3 | VarChar2(60) | Data point, other address line 1, used in the validation process of the contact conversion mapping process. |
| OTHER_ADDRESS_LINE_2 | 14.6.3 | VarChar2(60) | Data point, other address line 2, used in the validation process of the contact conversion mapping process. |
| OTHER_CITY | 14.6.3 | VarChar2(30) | Data point, other address city, used in the validation process of the contact conversion mapping process. |
| OTHER_COUNTRY_CODE | 14.6.3 | VarChar2(2) | Data point, other address country code, used in the validation process of the contact conversion mapping process. |
| OTHER_COUNTY_CODE | 14.6.3 | VarChar2(2) | Data point, other address county code, used in the validation process of the contact conversion mapping process. |
| OTHER_POSTAL_CODE | 14.6.3 | VarChar2(11) | Data point, other address postal code, used in the validation process of the contact conversion mapping process. |
| OTHER_STATEPROVINCE_CODE | 14.6.3 | VarChar2(2) | Data point, other address state code , used in the validation process of the contact conversion mapping process. |
| PHONE_CELL | 14.6.3 | VarChar2(20) | Data point, cell phone , used in the validation process of the contact conversion mapping process. |
| PHONE_CELL_EXT | 14.6.3 | VarChar2(10) | Data point, cell phone extension , used in the validation process of the contact conversion mapping process. |
| PHONE_HOME | 14.6.3 | VarChar2(20) | Data point, home phone , used in the validation process of the contact conversion mapping process. |
| PHONE_HOME_EXT | 14.6.3 | VarChar2(10) | Data point, home phone extension , used in the validation process of the contact conversion mapping process. |
| PHONE_OTHER | 14.6.3 | VarChar2(20) | Data point, other phone , used in the validation process of the contact conversion mapping process. |
| PHONE_OTHER_EXT | 14.6.3 | VarChar2(10) | Data point, other phone extension , used in the validation process of the contact conversion mapping process. |
| PHONE_WORK | 14.6.3 | VarChar2(20) | Data point, work phone , used in the validation process of the contact conversion mapping process. |
| PHONE_WORK_EXT | 14.6.3 | VarChar2(10) | Data point, work phone extension , used in the validation process of the contact conversion mapping process. |
| PHYSICAL_ADDRESS_LINE_1 | 14.6.3 | VarChar2(60) | Data point, physical address line 1, used in the validation process of the contact conversion mapping process. |
| PHYSICAL_ADDRESS_LINE_2 | 14.6.3 | VarChar2(60) | Data point, physical address line 2, used in the validation process of the contact conversion mapping process. |
| PHYSICAL_CITY | 14.6.3 | VarChar2(30) | Data point, physical address city, used in the validation process of the contact conversion mapping process. |
| PHYSICAL_COUNTRY_CODE | 14.6.3 | VarChar2(2) | Data point, physical address country code, used in the validation process of the contact conversion mapping process. |
| PHYSICAL_COUNTY_CODE | 14.6.3 | VarChar2(2) | Data point, physical address county code, used in the validation process of the contact conversion mapping process. |
| PHYSICAL_POSTAL_CODE | 14.6.3 | VarChar2(11) | Data point, physical postal code, used in the validation process of the contact conversion mapping process. |
| PHYSICAL_STATEPROVINCE_CODE | 14.6.3 | VarChar2(2) | Data point, physical address state code , used in the validation process of the contact conversion mapping process. |
| PREFIX_NAME | 14.6.3 | VarChar2(6) | Data point, name prefix, used in the validation process of the contact conversion mapping process. |
| RELATIONSHIP_CODE | 14.6.3 | VarChar2(4) | Data point, contact relationship to student, used in the validation process of the contact conversion mapping process. |
| STUDENTS_DCID | 14.6.3 | Number(11,0) | A foreign key that relates the extended table to the [Students] table. |
| SUFFIX_NAME | 14.6.3 | VarChar2(6) | Data point, name suffix , used in the validation process of the contact conversion mapping process. |