Examples of Loading Market Data Location List and Job List

Here are examples of how you can load the Market Data Location List and Market Data Job List objects using HCM Data Loader. A supplier of market data, such as Hay, provides the object data.

Create a Market Data Location List

Here's how you can create five locations with location mappings. The file identifies these objects using source keys.

METADATA|MktLocationList|SourceSystemOwner|SourceSystemId|VendorCode|SurveyLocationCode|SurveyLocationName|Status
MERGE|MktLocationList|VISION|LOC_HAY_AKR|HAY|AKR|Akron, OH|A
MERGE|MktLocationList|VISION|LOC_HAY_ALB|HAY|ALB|Albany, NY|A
MERGE|MktLocationList|VISION|LOC_HAY_ALL|HAY|AKR|Allentown, PA|A
MERGE|MktLocationList|VISION|LOC_HAY_ALQ|HAY|ALQ|Albuquerque, NM|A
MERGE|MktLocationList|VISION|LOC_HAY_CHI|HAY|CHI|Chicago, IL|A

METADATA|MktLocationMapping|SourceSystemOwner|SourceSystemId|SurveyLocationId(SourceSystemId)|LocationId(SourceSystemId)|VendorCode
MERGE|MktLocationMapping|VISION|LM_HAY_AKR|LOC_HAY_AKR|HAM_OH|HAY
MERGE|MktLocationMapping|VISION|LM_HAY_ALB|LOC_HAY_ALB|ALBANY_NY|HAY
MERGE|MktLocationMapping|VISION|LM_HAY_ALL|LOC_HAY_ALL|BUTLER_PA|HAY
MERGE|MktLocationMapping|VISION|LM_HAY_ALQ|LOC_HAY_ALQ|ALB_NM|HAY
MERGE|MktLocationMapping|VISION|LM_HAY_CHI|LOC_HAY_CHI|CHI_IL|HAY

When multiple internal locations map to a single external location, you need to create the mapping. You can do that as part of the import or later, using the Supplier Surveys task in the Compensation work area. You can optionally create mappings between a single internal location and a single external location.

Create a Market Data Job List

Here's how you can create seven jobs. The file identifies these objects using source keys.

METADATA|MktJobList|SourceSystemOwner|SourceSystemId|VendorCode|VendorJobCode|Description|VendorJobTitle|VendorJobDescrChar|Status|JobId(SourceSystemId)|JobFamilyId(SourceSystemId)|JobFunctionId(SourceSystemId)|CareerLevelId(SourceSystemId)|CareerStreamId(SourceSystemId)|OtherLevelId(SourceSystemId)
MERGE|MktJobList|VISION|HAY-ACCT_CA|HAY|HAY-ACCT_CA|Cost accountant match job notes|Cost Accountant|Cost Accountant job|A|VIS_PAY_CA|JF_HAY_AC-COS|JFN_HAY_ACCT|||
MERGE|MktJobList|VISION|HAY-ACCT_PA|HAY|HAY-ACCT_PA||Payables Accountant|Payables Accountant job|A|VIS_PAY_PA|JF_HAY_AC-PAY|JFN_HAY_ACCT|||
MERGE|MktJobList|VISION|HAY-ASSOC_ENG|HAY|HAY-ASSOC_ENG||Associate Engineer|Associate Engineer job|A|VIS_IT_AENG||JFN_HAY_IT||CS_HAY_CONT|
MERGE|MktJobList|VISION|HAY-ENG|HAY|HAY-ENG||Engineer|Engineer job|A|VIS_IT_ENG||JFN_HAY_IT||CS_HAY_JOUR|
MERGE|MktJobList|VISION|HAY-PLUM|HAY|HAY-PLUM||Plumber 1|Apprentice Plumber 1 job|A||||CL_HAY_APPR||
MERGE|MktJobList|VISION|HAY-ASSOC_CONSLT|HAY|HAY-ASSOC_CONSLT||Associate Consultant|Associate Consultant job|A|VIS_ASSOC_CONS|||||OL_HAY_1
MERGE|MktJobList|VISION|HAY-CONSLT|HAY|HAY-CONSLT||Consultant|Consultant job|A|VIS_CONS|||||OL_HAY_2

You can map survey jobs to internal jobs using the Market Data Job List object or the Supplier Surveys task.