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