Alias: IVECT#

The INF_CV_CONTACTS table is used to import employee contacts and general contacts into the software data structures. Contacts refer to people who have an indirect relationship with the organization, about whom information needs to be stored. There are two kinds of contacts, general contacts and employee contacts. Employee contacts are usually emergency contacts, spouses, dependants and beneficiaries, directly associated with an employee. General contacts are usually people from outside of the organization such as trainers and instructors, sponsors, plan administrators, representatives, recruiters etc.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
FIRST_NAMEVarchar2(50)VARCHAR50Y
LAST_NAMEVarchar2(50)VARCHAR50Y
USER_NAMEVarchar2(30)VARCHAR30
PERSON_CODEVarchar2(16)CODE
RELATIONVarchar2(30)VARCHAR30
EMPLOYERVarchar2(50)VARCHAR50
GENDERVarchar2(30)VARCHAR30
GOVERNMENT_CODEVarchar2(16)CODE
BIRTH_DATEDate()DATE
LANGUAGE_CODEVarchar2(30)VARCHAR30
MIDDLE_NAMEVarchar2(50)VARCHAR50
SALUTATIONVarchar2(30)VARCHAR30
RANKVarchar2(30)VARCHAR30
ADDRESS_LINE_1Varchar2(50)ADDRESS
ADDRESS_LINE_2Varchar2(50)ADDRESS
LOCALITYVarchar2(50)ADDRESS
STATE_PROVINCE_CODEVarchar2(16)CODE
COUNTRY_CODEVarchar2(16)CODE
ZIP_POSTALVarchar2(16)POSTAL CODE
MAIL_ADDRESS_LINE_1Varchar2(50)ADDRESS
MAIL_ADDRESS_LINE_2Varchar2(50)ADDRESS
MAIL_LOCALITYVarchar2(50)ADDRESS
MAIL_STATE_PROVINCE_CODEVarchar2(16)CODE
MAIL_COUNTRY_CODEVarchar2(16)CODE
MAIL_ZIP_POSTALVarchar2(16)POSTAL CODE
PHONE_NUMBERVarchar2(20)TELEPHONE
PHONE_EXTENSIONVarchar2(16)VARCHAR16
ALT_PHONE_NUMBERVarchar2(20)TELEPHONE
ALT_PHONE_EXTNVarchar2(16)VARCHAR16
CELLULAR_NUMBERVarchar2(20)TELEPHONE
FAX_NUMBERVarchar2(20)TELEPHONE
EMAIL_ADDRESSVarchar2(50)EMAIL
SECURITY_LEVELVarchar2(30)VARCHAR30
PRIVATE_ITEMVarchar2(4)VARCHAR4
CONTACT_TITLEVarchar2(50)DESCRIPTION
GOVT_CODE_ORIGINVarchar2(30)VARCHAR30
CONTACT_TYPEVarchar2(30)VARCHAR30
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30
This particular version was published on 26-Nov-2021 10:22 by JEscott.Top