This page (revision-10) was last changed on 26-Nov-2021 10:22 by jmyers

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
10 26-Nov-2021 10:22 5 KB jmyers to previous
9 26-Nov-2021 10:22 5 KB jmyers to previous | to last EMAIL_ADDRESS ==> EMAIL_ADDRESS(Disambiguation)
8 26-Nov-2021 10:22 5 KB JMyers to previous | to last
7 26-Nov-2021 10:22 5 KB JEscott to previous | to last
6 26-Nov-2021 10:22 5 KB JEscott to previous | to last
5 26-Nov-2021 10:22 5 KB JEscott to previous | to last
4 26-Nov-2021 10:22 5 KB JEscott to previous | to last
3 26-Nov-2021 10:22 5 KB JEscott to previous | to last
2 26-Nov-2021 10:22 1 KB JEscott to previous | to last
1 26-Nov-2021 10:22 1 KB JEscott to last

Page References

Incoming links Outgoing links
INF_CV_LOCATIONS
INF_CV_LOCATIONS

Version management

Difference between version and

At line 6 changed 33 lines
||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]| |
||Column name||Data Type / Size||Mand.||Notes
|[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded.
|[LOCATION_CODE]|Varchar2(16)|Y|Validation: Must be a unique location code.
|[PARENT_LOCATION|LOCATION_CODE]|Varchar2(16)| |Validation: This department code must have been previously defined.
|[DESCRIPTION]|Varchar2(50)| |
|[LANGUAGE_CODE]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_LANGUAGE_CODE]. Derivation: Will be derived from the [LANGUAGE_CODE] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined. Suggestion: Most users will load this field with “ENG” for English.
|[ADDRESS_LINE_1]|Varchar2(50)| |Derivation: Will be derived from the [ADDRESS_LINE_1] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[ADDRESS_LINE_2]|Varchar2(50)| |Derivation: Will be derived from the [ADDRESS_LINE_2] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[LOCALITY]|Varchar2(50)| |Derivation: Will be derived from the [LOCALITY] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[STATE_PROVINCE_CODE]|Varchar2(16)| |Validation: Must be a valid state code or province code, for the [COUNTRY_CODE] indicated on [P2K_CM_STATE_PROVINCES]. If you provide a [STATE_PROVINCE_CODE], then you must provide a [COUNTRY_CODE]. Derivation: Will be derived from the [STATE_PROVINCE_CODE] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[COUNTRY_CODE]|Varchar2(16)| |Validation: Must be a valid country code on [P2K_CM_COUNTRIES]. If you provide a [STATE_PROVINCE_CODE], then you must provide a [COUNTRY_CODE].
|[ZIP_POSTAL]|Varchar2(16)| |Validation: Must be formatted in the correct format, for the country indicated. Derivation: Will be derived from the [ZIP_POSTAL] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[MAIL_ADDRESS_LINE_1]|Varchar2(50)| |
|[MAIL_ADDRESS_LINE_2]|Varchar2(50)| |
|[MAIL_LOCALITY]|Varchar2(50)| |
|[MAIL_STATE_PROVINCE_CODE]|Varchar2(16)| |Validation: Must be a valid state code or province code, for the [COUNTRY_CODE] indicated on [P2K_CM_STATE_PROVINCES]. If you provide a [STATE_PROVINCE_CODE], then you must provide a [COUNTRY_CODE].
|[MAIL_COUNTRY_CODE]|Varchar2(16)| |Validation: Must be a valid country code on [P2K_CM_COUNTRIES]. If you provide a [STATE_PROVINCE_CODE], then you must provide a [COUNTRY_CODE].
|[MAIL_ZIP_POSTAL]|Varchar2(16)| |Validation: Must be formatted in the correct format, for the country indicated for the mailing address
|[PHONE_NUMBER]|Varchar2(20)| |Validation: Must be formatted in the correct format, for the country indicated by the physical location. Derivation: Will be derived from the [PHONE_NUMBER] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined
|[PHONE_EXTENSION]|Varchar2(16)| |Derivation: Will be derived from the [PHONE_EXTENSION] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined
|[ALT_PHONE_NUMBER]|Varchar2(20)| |Validation: Must be formatted in the correct format, for the country indicated by the physical location. Derivation: Will be derived from the [ALT_PHONE_NUMBER] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[ALT_PHONE_EXTN]|Varchar2(16)| |Derivation: Will be derived from the [ALT_PHONE_EXTN] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[FAX_NUMBER]|Varchar2(20)| |Validation: Must be formatted in the correct format, for the country indicated by the physical location. Derivation: Will be derived from the [FAX_NUMBER] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[EMAIL_ADDRESS]|Varchar2(50)| |Derivation: Will be derived from the [EMAIL_ADDRESS] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[GEO_CODE]|Varchar2(16)| |Validation: The GEO Code must be a valid GEO code on the [P2K_CM_TAX_JURISDICTIONS] table. If the [STATE_PROVINCE_CODE] is provided, then the [GEO_CODE] must be within that specific state, as well. Derivation: Will be derived from the [DTX_ID] for the [PARENT_LOCATION|LOCATION_CODE], if a [PARENT_LOCATION|LOCATION_CODE] has been defined.
|[BILINGUAL_REGION]|Varchar2(30)| |
|[BILINGUAL_LOCATION]|Varchar2(4)| |
|[CMA_CODE]|Varchar2(30)| |
|[INCLUDE_ALL_IN_UENH]|Varchar2(4)| |
|[CREATE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CREATE_USER]|Varchar2(30)| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CHANGE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CHANGE_USER]|Varchar2(30)| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
This page (revision-10) was last changed on 26-Nov-2021 10:22 by jmyersTop