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