Examples of Loading Market Data Segments and Survey Composites
Here are examples of how you can load market data segments and survey composites using HCM Data Loader.
Market Data Segments
Here's how you can load the market data segments using HCM Data Loader.
METADATA|MktSegment|SegmentId|SegmentCode|SegmentName|StatusCode|SegmentDescr|MiscText1|MiscText2|MiscText3|SourceSystemOwner|SourceSystemId
MERGE|MktSegment||SEG889|Segment 889|A|San Mateo|ExampleABC|ExampleDEF|ExampleGHI|VISION|SEG889
METADATA|MktSegmentLocation|SegmentId|SegmentCode|LocationId|LocationCode|SetCode|SourceSystemOwner|SourceSystemId
MERGE|MktSegmentLocation||SEG889||A1 Location|COMMON|VISION|SEG889
Market Data Survey Composites
Here's how you can load market data survey composites using HCM Data Loader. You can load these composites with either market segments or internal locations, but not both.
METADATA|MktComposite|JobId|JobCode|MarketSegmentId|MarketSegmentCode|LocationId|LocationCode|CountryCode|CompTypeId|CompensationTypeCode|CurrencyCode|StartDate|EndDate|TenPercent|TwentyPercent|TwentyFivePercent|ThirtyPercent|FortyPercent|FiftyPercent|SixtyPercent|SeventyPercent|SeventyFivePercent|EightyPercent|NintyPercent|OneHundredPercent|AverageMean|SetCode
MERGE|MktComposite||JOBCD2||SEG889||A1 Location|US||BAS|USD|2001/02/02|2020/01/01|10|20|25|30|40|50|60|70|75|80|90|100|55|Common