!!!Alias: IVDLN
The INF_CV_LOCATIONS table is used to import location codes and their attendant data into the software data structures.  Locations are user defined codes that uniquely identifies the location to the organization.

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]| |
|[LOCATION_CODE]|Varchar2(16)|[CODE]|Y|
|[PARENT_LOCATION]|Varchar2(16)|[CODE]| |
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[LANGUAGE_CODE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[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|VARCHARnn]| |
|[ALT_PHONE_NUMBER]|Varchar2(20)|[TELEPHONE]| |
|[ALT_PHONE_EXTN]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |
|[FAX_NUMBER]|Varchar2(20)|[TELEPHONE]| |
|[EMAIL_ADDRESS]|Varchar2(50)|[EMAIL]| |
|[GEO_CODE]|Varchar2(16)|[CODE]| |
|[BILINGUAL_REGION]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[BILINGUAL_LOCATION]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[CMA_CODE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[INCLUDE_ALL_IN_UENH]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[CREATE_DATE]|Date()|[DATE]| |
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CHANGE_DATE]|Date()|[DATE]| |
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |