Example of Loading Market Data Survey Data
Here's an example of how you can load the Market Data Survey Data object using HCM Data Loader. A supplier of market survey data, such as Hay, provides the object data.
Loading Market Data Survey Data
Here's how you can load a single Market Data Survey Data object. It has a unique batch name, and it references jobs and locations that you defined before loading this object. The file identifies the Market Data Job List, Market Data Job Location, and Market Data Survey Data objects using source keys.
METADATA|MktSurveyData|SourceSystemOwner|SourceSystemId|VendorCode|SurveyCode|BatchName|CompensationTypeCode|JobListId(SourceSystemId)|VendorLocationId(SourceSystemId)|Industry|TenPercent|TwentyPercent|TwentyFivePercent|ThirtyPercent|FortyPercent|FiftyPercent|SixtyPercent|SeventyPercent|SeventyFivePercent|EightyPercent|NintyPercent|OneHundredPercent|AverageMean|Currency|CountryCode|ParticipatingIncumbants|ParticipatingCompanies
MERGE|MktSurveyData|VISION|HAY_ACCT_CA_CHI|HAY|2019|HAY_2019|BAS|HAY-ACCT_CA|LOC_HAY_CHI|All|10000|20000|25000|30000|40000|55000|60000|70000|75000|80000|90000|100000|50000|USD|US|653|5069Reference
The Loading Market Data Using HCM Data Loader document explains how you can load data using HCM Data Loader and HCM Spreadsheet Data Loader. The document (ID 2513871.1) is on My Oracle Support at https://support.oracle.com.