Examples of Loading Extended Lookup Codes
You use extended lookup codes to provide subcategories for lookup codes. The associated lookup codes must already exist when you load Extended Lookup objects using HCM Data Loader.
If the lookup codes are for specific legislations, then you can supply extended lookup codes for those legislations only. For example, if a lookup code has the +FR tag, then you can supply extended lookup codes for the FR legislation code only. This topic provides examples showing how to load Extended Lookup objects using HCM Data Loader.
Creating Extended Lookup Codes
This example ExtendedLookupCode.dat file creates extended lookup codes for the CONTRACT_TYPE lookup type. It identifies the extended lookup codes using source keys.
METADATA|ExtendedLookupCode|SourceSystemOwner|SourceSystemId|LookupType|LookupCode|LegislationCode|ExtendedLookupCode|ExtendedLookupCodeName
MERGE|ExtendedLookupCode|VISION|ELC_CONTRACT_LIMITED|CONTRACT_TYPE|5|NO|L|Limited Contract
MERGE|ExtendedLookupCode|VISION|ELC_CONTRACT_DIRECTOR|CONTRACT_TYPE|FR_CEO_MANDATE|FR|DC|Director Contract
Loading Translated Extended Lookup Code Names
Supply the names of extended lookup codes in the language of the user who's loading them. You supply an ExtendedLookupCodeTranslation.dat file to translate the names of extended lookup codes into other enabled languages once the codes exist. This example translates the name of an existing extended lookup code. It identifies the code by its source key.
METADATA|ExtendedLookupCodeTranslation|SourceSystemOwner|SourceSystemId|Language|ExtendedLookupCodeName
MERGE|ExtendedLookupCodeTranslation|VISION|ELC_CONTRACT_LIMITED|FR|Contrat a Duree Limitee
Deleting Extended Lookup Codes
You can delete Extended Lookup objects using HCM Data Loader. This example ExtendedLookupCode.dat file deletes specific extended lookup codes for the CONTRACT_TYPE lookup code. It identifies the extended lookup codes using source keys.
METADATA|ExtendedLookupCode|SourceSystemOwner|SourceSystemId
DELETE|ExtendedLookupCode|VISION|ELC_CONTRACT_LIMITED
DELETE|ExtendedLookupCode|VISION|ELC_CONTRACT_DIRECTOR