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

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

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
17 26-Nov-2021 10:22 3 KB rforbes to previous
16 26-Nov-2021 10:22 3 KB jmyers to previous | to last
15 26-Nov-2021 10:22 3 KB jmyers to previous | to last EMAIL_ADDRESS ==> EMAIL_ADDRESS(Disambiguation)
14 26-Nov-2021 10:22 3 KB JMyers to previous | to last
13 26-Nov-2021 10:22 3 KB JMyers to previous | to last
12 26-Nov-2021 10:22 3 KB JMyers to previous | to last
11 26-Nov-2021 10:22 3 KB JMyers to previous | to last
10 26-Nov-2021 10:22 3 KB JMyers to previous | to last
9 26-Nov-2021 10:22 8 KB JMyers to previous | to last
8 26-Nov-2021 10:22 7 KB JMyers to previous | to last
7 26-Nov-2021 10:22 6 KB JMyers to previous | to last
6 26-Nov-2021 10:22 1 KB JMyers to previous | to last
5 26-Nov-2021 10:22 1 KB JMyers to previous | to last
4 26-Nov-2021 10:22 1 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 4 KB JMyers to previous | to last
1 26-Nov-2021 10:22 5 KB JMyers to last

Page References

Incoming links Outgoing links
IVDLN
IVDLN

Version management

Difference between version and

At line 1 changed one line
!!!LOCATION INTERFACE FILE
(INF_CV_LOCATIONS)
At line 3 changed one line
The Location Interface File screen is used to import location codes into the software data structures.
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.
At line 5 changed one line
Location Interface File data is maintained on the [INF_CV_LOCATIONS] table.
Tables loaded: [P2K_CM_LOCATIONS]
At line 7 removed 28 lines
;[ID|ID]:This field uniquely identifies the location record within the data base.
;[Location|LOCATION_CODE]:This field identifies the location to the organization.
;[Parent Location|PARENT_LOCATION]:If the location is a sub-section of any higher-level location, the code for that higher-level location will be held in this field.
;[Description|DESCRIPTION]:This field holds a short description of the location.
;[|LANGUAGE_CODE]:
;[Address 1|ADDRESS_LINE_1]:‘Address 1’ provides the street address for the location.
;[Address 2|ADDRESS_LINE_2]:‘Address 2’ provides the PO box number or suite number for the location.
;[City/Town|LOCALITY]:This field provides the city, district or township of the location.
;[State, Country|STATE_PROVINCE_CODE]:This field displays the state or province description with the applicable country concatenated at the end.
;[Country Name|COUNTRY_CODE]:This field provides the country of the location.
;[Zip Code|ZIP_POSTAL]:This field displays the mailing code.
;[Mailing Address 1|MAIL_ADDRESS_LINE_1]:‘Address 1” is the street mailing address for the location.
;[Mailing Address 2|MAIL_ADDRESS_LINE_2]:‘Address 2’ is the PO box number or suite number mailing address for this location.
;[Mailing City/Town|MAIL_LOCALITY]:This field provides the city, district or township mailing address for this location.
;[Mailing State|MAIL_STATE_PROVINCE_CODE]:This field holds the state or province description with the applicable country concatenated at the end.
;[Mailing Country|MAIL_COUNTRY_CODE]:This field provides the country mailing address of the location.
;[Mailing Zip Code|MAIL_ZIP_POSTAL]:This field displays the mailing code.
;[Phone #|PHONE_NUMBER]:This field displays the main phone number of the location.
;[Phone Extn|PHONE_EXTENSION]:This field displays the extension for the main phone number.
;[Alt Phone #|ALT_PHONE_NUMBER]:This field displays an alternate phone number for this location.
;[Alt Phone Ext.|ALT_PHONE_EXTN]:This is the extension for the alternate phone number.
;[Fax #|FAX_NUMBER]:This field holds the main fax number for this location.
;[E-mail|EMAIL_ADDRESS(Field)]:This is the email address or domain name for the locations.
;[Tax Jurisdiction|GEO_CODE]:This field will display the GEO code of the city, county, state or province used for taxation purposes.
;[Bilingual Region|BILINGUAL_REGION]:For Canadian installations: If the location is in a bilingual region, that region is indicated here.
;[Bilingual Location|BILINGUAL_LOCATION]:This field indicates if the location is in a bilingual region. (E.g., Ottawa where both French and English are working languages.)
;[Location|CMA_CODE]:This field holds the CMA Code (Census Metropolitan Area) used in the locations.
;[Include All in UENH|INCLUDE_ALL_IN_UEHN]:This field indicates of the Create New Hires Interface File ([UENH]) contains information on new hires, re-hires and employees who have returned to work from an unpaid leave status within a specified period of time.
At line 8 added 34 lines
!!Table Columns
\\
||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|INCLUDE_ALL_IN_UEHN]|Varchar2(4)| |
[{If var='loginstatus' contains 'authenticated'
At line 37 changed 2 lines
![Notes|Edit:Internal.IVDLN]
[{InsertPage page='Internal.IVDLN' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.IVDLN]
[{InsertPage page='Internal.IVDLN' default='Click to create a new discussion page'}]
At line 46 added one line
}]
This page (revision-17) was last changed on 26-Nov-2021 10:22 by rforbesTop