This is version 1 2 3 4 5 6 7 8 9 10 11 12 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

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 name	Data Type / Size	Mand.	Notes
ID	Number(10)	ID
FIRST_NAME	Varchar2(50)	Y
LAST_NAME	Varchar2(50)	Y
USER_NAME	Varchar2(30)
PERSON_CODE	Varchar2(16)
RELATION	Varchar2(30)
EMPLOYER	Varchar2(50)
GENDER	Varchar2(30)
GOVERNMENT_CODE	Varchar2(16)
BIRTH_DATE	Date()	DATE
LANGUAGE_CODE	Varchar2(30)
MIDDLE_NAME	Varchar2(50)
SALUTATION	Varchar2(30)
RANK	Varchar2(30)
ADDRESS_LINE_1	Varchar2(50)
ADDRESS_LINE_2	Varchar2(50)
LOCALITY	Varchar2(50)
STATE_PROVINCE_CODE	Varchar2(16)
COUNTRY_CODE	Varchar2(16)
ZIP_POSTAL	Varchar2(16)
MAIL_ADDRESS_LINE_1	Varchar2(50)
MAIL_ADDRESS_LINE_2	Varchar2(50)
MAIL_LOCALITY	Varchar2(50)
MAIL_STATE_PROVINCE_CODE	Varchar2(16)
MAIL_COUNTRY_CODE	Varchar2(16)	CODE
MAIL_ZIP_POSTAL	Varchar2(16)
PHONE_NUMBER	Varchar2(20)
PHONE_EXTENSION	Varchar2(16)
ALT_PHONE_NUMBER	Varchar2(20)
ALT_PHONE_EXTN	Varchar2(16)
CELLULAR_NUMBER	Varchar2(20)
FAX_NUMBER	Varchar2(20)
EMAIL_ADDRESS	Varchar2(50)
SECURITY_LEVEL	Varchar2(30)
PRIVATE_ITEM	Varchar2(4)
CONTACT_TITLE	Varchar2(50)
GOVT_CODE_ORIGIN	Varchar2(30)
CONTACT_TYPE	Varchar2(30)
CREATE_DATE	Date()
CREATE_USER	Varchar2(30)
CHANGE_DATE	Date()
CHANGE_USER	Varchar2(30)