Alias: IVDLN#

(INF_CV_LOCATIONS)
Location information

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
LOCATION_CODEVarchar2(16)CODEY
PARENT_LOCATIONVarchar2(16)CODE
DESCRIPTIONVarchar2(50)DESCRIPTION
LANGUAGE_CODEVarchar2(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
FAX_NUMBERVarchar2(20)TELEPHONE
EMAIL_ADDRESSVarchar2(50)EMAIL
GEO_CODEVarchar2(16)CODE
BILINGUAL_REGIONVarchar2(30)VARCHAR30
BILINGUAL_LOCATIONVarchar2(4)VARCHAR4
CMA_CODEVarchar2(30)VARCHAR30
INCLUDE_ALL_IN_UENHVarchar2(4)VARCHAR4
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