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#

(INF_CV_CONTACTS)
Stores all the important information regarding any

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID
FIRST_NAME	Varchar2(50)	VARCHAR50	Y
LAST_NAME	Varchar2(50)	VARCHAR50	Y
USER_NAME	Varchar2(30)	VARCHAR30
PERSON_CODE	Varchar2(16)	CODE
RELATION	Varchar2(30)	VARCHAR30
EMPLOYER	Varchar2(50)	VARCHAR50
GENDER	Varchar2(30)	VARCHAR30
GOVERNMENT_CODE	Varchar2(16)	CODE
BIRTH_DATE	Date()	DATE
LANGUAGE_CODE	Varchar2(30)	VARCHAR30
MIDDLE_NAME	Varchar2(50)	VARCHAR50
SALUTATION	Varchar2(30)	VARCHAR30
RANK	Varchar2(30)	VARCHAR30
ADDRESS_LINE_1	Varchar2(50)	ADDRESS
ADDRESS_LINE_2	Varchar2(50)	ADDRESS
LOCALITY	Varchar2(50)	ADDRESS
STATE_PROVINCE_CODE	Varchar2(16)	CODE
COUNTRY_CODE	Varchar2(16)	CODE
ZIP_POSTAL	Varchar2(16)	POSTAL CODE
MAIL_ADDRESS_LINE_1	Varchar2(50)	ADDRESS
MAIL_ADDRESS_LINE_2	Varchar2(50)	ADDRESS
MAIL_LOCALITY	Varchar2(50)	ADDRESS
MAIL_STATE_PROVINCE_CODE	Varchar2(16)	CODE
MAIL_COUNTRY_CODE	Varchar2(16)	CODE
MAIL_ZIP_POSTAL	Varchar2(16)	POSTAL CODE
PHONE_NUMBER	Varchar2(20)	TELEPHONE
PHONE_EXTENSION	Varchar2(16)	VARCHAR16
ALT_PHONE_NUMBER	Varchar2(20)	TELEPHONE
ALT_PHONE_EXTN	Varchar2(16)	VARCHAR16
CELLULAR_NUMBER	Varchar2(20)	TELEPHONE
FAX_NUMBER	Varchar2(20)	TELEPHONE
EMAIL_ADDRESS	Varchar2(50)	EMAIL
SECURITY_LEVEL	Varchar2(30)	VARCHAR30
PRIVATE_ITEM	Varchar2(4)	VARCHAR4
CONTACT_TITLE	Varchar2(50)	DESCRIPTION
GOVT_CODE_ORIGIN	Varchar2(30)	VARCHAR30
CONTACT_TYPE	Varchar2(30)	VARCHAR30
CREATE_DATE	Date()	DATE
CREATE_USER	Varchar2(30)	VARCHAR30
CHANGE_DATE	Date()	DATE
CHANGE_USER	Varchar2(30)	VARCHAR30