S_OH_CONTACTMAPPING_S (ver 14.6.3)
This table is a standalone table that describes the location of contact information used for the contact conversion mapping process.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 14.6.3 | Number(11,0) | Primary Key. |
| CONTACTRELATIONMAP_ID | 14.6.3 | Number(11,0) | A foreign key link to S_OH_CONTACTRELATIONMAP_S. |
| ADDRESS_LINE_1 | 14.6.3 | VarChar2(100) | Describes the location of address line 1. Used for contact conversion mapping process. |
| ADDRESS_LINE_2 | 14.6.3 | VarChar2(100) | Describes the location of address line 2. Used for contact conversion mapping process. |
| CANPICKUP | 14.6.3 | VarChar2(100) | Describes the location of the Can Pick Up Flag. Used for contact conversion mapping process. |
| CITY | 14.6.3 | VarChar2(100) | Describes the location of city. Used for contact conversion mapping process. |
| CONTACT_SEQUENCE | 14.6.3 | VarChar2(100) | Describes the location of sequence number of the contact. Used for contact conversion mapping process. |
| COPY_OF_CORRESPONDENCE | 14.6.3 | VarChar2(100) | Describes the location of copy of correspondence flag. Used for contact conversion mapping process. |
| COUNTRY_CODE | 14.6.3 | VarChar2(100) | Describes the location of country code. Used for contact conversion mapping process. |
| COUNTY_CODE | 14.6.3 | VarChar2(100) | Describes the location of county code. Used for contact conversion mapping process. |
| CUSTODIAL_FLAG | 14.6.3 | VarChar2(100) | Describes the location of custodial flag. Used for contact conversion mapping process. |
| EMAIL_HOME | 14.6.3 | VarChar2(100) | Describes the location of home email address. Used for contact conversion mapping process. |
| EMAIL_OTHER | 14.6.3 | VarChar2(100) | Describes the location of other email address. Used for contact conversion mapping process. |
| EMAIL_PERSONAL | 14.6.3 | VarChar2(100) | Describes the location of personal email address. Used for contact conversion mapping process. |
| EMAIL_WORK | 14.6.3 | VarChar2(100) | Describes the location of work email address. Used for contact conversion mapping process. |
| EMERGENCY_CONTACT | 14.6.3 | VarChar2(100) | Describes the location of emergency contact. Used for contact conversion mapping process. |
| EMPLOYER | 14.6.3 | VarChar2(100) | Describes the location of employer. Used for contact conversion mapping process. |
| FIRST_NAME | 14.6.3 | VarChar2(100) | Describes the location of first name. Used for contact conversion mapping process. |
| GENDER | 14.6.3 | VarChar2(100) | Describes the location of gender. Used for contact conversion mapping process. |
| JOB_TITLE | 14.6.3 | VarChar2(100) | Describes the location of job title. Used for contact conversion mapping process. |
| LASTFIRST_NAME | 14.6.3 | VarChar2(100) | Describes the location of lastfirst name. Used for contact conversion mapping process. |
| LAST_NAME | 14.6.3 | VarChar2(100) | Describes the location of last name. Used for contact conversion mapping process. |
| LEGAL_GUARDIANSHIP_FLAG | 14.6.3 | VarChar2(100) | Describes the location of legal guardianship flag. Used for contact conversion mapping process. |
| MAILING_ADDRESS_LINE_1 | 14.6.3 | VarChar2(100) | Describes the location of mailing address line 1. Used for contact conversion mapping process. |
| MAILING_ADDRESS_LINE_2 | 14.6.3 | VarChar2(100) | Describes the location of mailing address line 2. Used for contact conversion mapping process. |
| MAILING_CITY | 14.6.3 | VarChar2(100) | Describes the location of mailing address city. Used for contact conversion mapping process. |
| MAILING_COUNTRY_CODE | 14.6.3 | VarChar2(100) | Describes the location of mailing address country code. Used for contact conversion mapping process. |
| MAILING_COUNTY_CODE | 14.6.3 | VarChar2(100) | Describes the location of mailing address county code. Used for contact conversion mapping process. |
| MAILING_POSTAL_CODE | 14.6.3 | VarChar2(100) | Describes the location of mailing address postal code. Used for contact conversion mapping process. |
| MAILING_STATEPROVINCE_CODE | 14.6.3 | VarChar2(100) | Describes the location of mailing address state province code. Used for contact conversion mapping process. |
| MAPPING_DESCRIPTION | 14.6.3 | VarChar2(100) | Reference name for the record. |
| MIDDLE_NAME | 14.6.3 | VarChar2(100) | Describes the location of middle name. Used for contact conversion mapping process. |
| NOTES | 14.6.3 | VarChar2(100) | Describes the location of notes. Used for contact conversion mapping process. |
| OTHER_ADDRESS_LINE_1 | 14.6.3 | VarChar2(100) | Describes the location of other address line 1. Used for contact conversion mapping process. |
| OTHER_ADDRESS_LINE_2 | 14.6.3 | VarChar2(100) | Describes the location of other address line 2. Used for contact conversion mapping process. |
| OTHER_CITY | 14.6.3 | VarChar2(100) | Describes the location of other address city. Used for contact conversion mapping process. |
| OTHER_COUNTRY_CODE | 14.6.3 | VarChar2(100) | Describes the location of other address country code. Used for contact conversion mapping process. |
| OTHER_COUNTY_CODE | 14.6.3 | VarChar2(100) | Describes the location of other address county code. Used for contact conversion mapping process. |
| OTHER_POSTAL_CODE | 14.6.3 | VarChar2(100) | Describes the location of other address postal code. Used for contact conversion mapping process. |
| OTHER_STATEPROVINCE_CODE | 14.6.3 | VarChar2(100) | Describes the location of other address state province code. Used for contact conversion mapping process. |
| PHONE_CELL | 14.6.3 | VarChar2(100) | Describes the location of cell phone. Used for contact conversion mapping process. |
| PHONE_CELL_EXT | 14.6.3 | VarChar2(100) | Describes the location of cell phone ext. Used for contact conversion mapping process. |
| PHONE_HOME | 14.6.3 | VarChar2(100) | Describes the location of home phone. Used for contact conversion mapping process. |
| PHONE_HOME_EXT | 14.6.3 | VarChar2(100) | Describes the location of home phone ext. Used for contact conversion mapping process. |
| PHONE_OTHER | 14.6.3 | VarChar2(100) | Describes the location of other phone. Used for contact conversion mapping process. |
| PHONE_OTHER_EXT | 14.6.3 | VarChar2(100) | Describes the location of other phone ext. Used for contact conversion mapping process. |
| PHONE_WORK | 14.6.3 | VarChar2(100) | Describes the location of work phone. Used for contact conversion mapping process. |
| PHONE_WORK_EXT | 14.6.3 | VarChar2(100) | Describes the location of work phone ext. Used for contact conversion mapping process. |
| POSTAL_CODE | 14.6.3 | VarChar2(100) | Describes the location of postal code. Used for contact conversion mapping process. |
| PREFIX_NAME | 14.6.3 | VarChar2(100) | Describes the location of prefix name. Used for contact conversion mapping process. |
| RELATIONSHIP_CODE | 14.6.3 | VarChar2(100) | Describes the location of relationship code. Used for contact conversion mapping process. |
| STATEPROVINCE_CODE | 14.6.3 | VarChar2(100) | Describes the location of state province code. Used for contact conversion mapping process. |
| SUFFIX_NAME | 14.6.3 | VarChar2(100) | Describes the location of suffix. Used for contact conversion mapping process. |