INF_CV_REFERENCES
Back to current versionRestore this version

Alias: IVREF#

(INF_CV_REFERENCES)
References

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
CANDIDATE_CODEVarchar2(16)CODEY
REFERENCE_STATUSVarchar2(30)VARCHAR30Y
REFERENCE_TYPEVarchar2(30)VARCHAR30Y
COUNTRY_CODEVarchar2(16)CODE
STATE_PROVINCE_CODEVarchar2(16)CODE
DATE_CONTACTEDDate()DATE
COMPANY_NAMEVarchar2(50)VARCHAR50
CONTACT_NAMEVarchar2(50)VARCHAR50
CONTACT_TITLEVarchar2(50)DESCRIPTION
ADDRESS_LINE_1Varchar2(50)ADDRESS
ADDRESS_LINE_2Varchar2(50)ADDRESS
LOCALITYVarchar2(50)ADDRESS
ZIP_POSTALVarchar2(16)POSTAL CODE
PHONE_NUMBERVarchar2(20)TELEPHONE
PHONE_EXTENSIONVarchar2(16)VARCHAR16
ALT_PHONE_NUMBERVarchar2(20)TELEPHONE
ALT_PHONE_EXTENSIONVarchar2(16)VARCHAR16
FAX_NUMBERVarchar2(20)TELEPHONE
EMAIL_ADDRESSVarchar2(50)EMAIL
LANGUAGE_CODEVarchar2(30)VARCHAR30
AVAILABLE_TO_CONTACTVarchar2(4)VARCHAR4
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30