1. HCM Data Loading Business Objects
  2. Example of Loading User-Defined Tables for Matched Row Values

Example of Loading User-Defined Tables for Matched Row Values

Vision Corporation wants to use a user-defined table to define schedules for their employees. All workers in the company work on a 10 hour a day, four day in a week rotating schedule. The company has these four schedules.

  • Monday - Thursday

  • Tuesday - Friday

  • Wednesday - Saturday

  • Thursday - Sunday

As this image shows, this user-defined table contains the schedules available in the organization. The rows contain the name of a day of the week and the columns contain the schedule. The values represent the number of hours to work each day in a schedule.

This user-defined table contains the schedules available in the organization.

Use this .dat file to create a user-defined table to store values for worker's schedules. 


METADATA|UserDefinedTable|UserTableCode|RangeOrMatch|UserKeyUnits|UserRowTitle|UserTableName|LegislativeDataGroupName
METADATA|UserDefinedTableColumn|UserColumnCode|DataType|UserColumnName|UserTableCode|LegislativeDataGroupName|FormulaName
METADATA|UserDefinedTableRow|DisplaySequence|EffectiveEndDate|EffectiveStartDate|RowHighRange|RowLowRangeOrName|UserTableCode|LegislativeDataGroupName|RowName
METADATA|UserDefinedTableColumnInstance|EffectiveEndDate|EffectiveStartDate|Value|LegislativeDataGroupName|UserColumnCode|RowLowRangeOrName|UserTableCode
MERGE|UserDefinedTable|VISION_UDT_MATCHED_ROW|M|T|Days Of The Week|VISION_UDT_MATCHED_ROW|US Legislative Data Group
MERGE|UserDefinedTableColumn|MONDAY_TO_THURSDAY|N|Monday_to_Thursday|VISION_UDT_MATCHED_ROW|US Legislative Data Group|
MERGE|UserDefinedTableColumn|TUESDAY_TO_FRIDAY|N|Tuesday_to_Friday|VISION_UDT_MATCHED_ROW|US Legislative Data Group|
MERGE|UserDefinedTableColumn|WEDNESDAY_TO_SATURDAY|N|Wednesday_to_Saturday|VISION_UDT_MATCHED_ROW|US Legislative Data Group|
MERGE|UserDefinedTableColumn|THURSDAY_TO_SUNDAY|N|Thursday_to_Sunday|VISION_UDT_MATCHED_ROW|US Legislative Data Group|
MERGE|UserDefinedTableRow|10|4712/12/31|2019/06/14||MONDAY|VISION_UDT_MATCHED_ROW|US Legislative Data Group|Monday
MERGE|UserDefinedTableRow|20|4712/12/31|2019/06/14||TUESDAY|VISION_UDT_MATCHED_ROW|US Legislative Data Group|Tuesday
MERGE|UserDefinedTableRow|30|4712/12/31|2019/06/14||WEDNESDAY|VISION_UDT_MATCHED_ROW|US Legislative Data Group|Wednesday
MERGE|UserDefinedTableRow|40|4712/12/31|2019/06/14||THURSDAY|VISION_UDT_MATCHED_ROW|US Legislative Data Group|Thursday
MERGE|UserDefinedTableRow|50|4712/12/31|2019/06/14||FRIDAY|VISION_UDT_MATCHED_ROW|US Legislative Data Group|Friday
MERGE|UserDefinedTableRow|60|4712/12/31|2019/06/14||SATURDAY|VISION_UDT_MATCHED_ROW|US Legislative Data Group|Saturday
MERGE|UserDefinedTableRow|70|4712/12/31|2019/06/14||SUNDAY|VISION_UDT_MATCHED_ROW|US Legislative Data Group|Sunday
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|10|US Legislative Data Group|MONDAY_TO_THURSDAY|MONDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|10|US Legislative Data Group|MONDAY_TO_THURSDAY|TUESDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|10|US Legislative Data Group|MONDAY_TO_THURSDAY|WEDNESDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|10|US Legislative Data Group|MONDAY_TO_THURSDAY|THURSDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|0|US Legislative Data Group|MONDAY_TO_THURSDAY|FRIDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|0|US Legislative Data Group|MONDAY_TO_THURSDAY|SATURDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|0|US Legislative Data Group|MONDAY_TO_THURSDAY|SUNDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|0|US Legislative Data Group|TUESDAY_TO_FRIDAY|MONDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|10|US Legislative Data Group|TUESDAY_TO_FRIDAY|TUESDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|10|US Legislative Data Group|TUESDAY_TO_FRIDAY|WEDNESDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|10|US Legislative Data Group|TUESDAY_TO_FRIDAY|THURSDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|10|US Legislative Data Group|TUESDAY_TO_FRIDAY|FRIDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|0|US Legislative Data Group|TUESDAY_TO_FRIDAY|SATURDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|0|US Legislative Data Group|TUESDAY_TO_FRIDAY|SUNDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|0|US Legislative Data Group|WEDNESDAY_TO_SATURDAY|MONDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|0|US Legislative Data Group|WEDNESDAY_TO_SATURDAY|TUESDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|10|US Legislative Data Group|WEDNESDAY_TO_SATURDAY|WEDNESDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|10|US Legislative Data Group|WEDNESDAY_TO_SATURDAY|THURSDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|10|US Legislative Data Group|WEDNESDAY_TO_SATURDAY|FRIDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|10|US Legislative Data Group|WEDNESDAY_TO_SATURDAY|SATURDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|0|US Legislative Data Group|WEDNESDAY_TO_SATURDAY|SUNDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|0|US Legislative Data Group|THURSDAY_TO_SUNDAY|MONDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|0|US Legislative Data Group|THURSDAY_TO_SUNDAY|TUESDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|0|US Legislative Data Group|THURSDAY_TO_SUNDAY|WEDNESDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|10|US Legislative Data Group|THURSDAY_TO_SUNDAY|THURSDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|10|US Legislative Data Group|THURSDAY_TO_SUNDAY|FRIDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|10|US Legislative Data Group|THURSDAY_TO_SUNDAY|SATURDAY|VISION_UDT_MATCHED_ROW
MERGE|UserDefinedTableColumnInstance|4712/12/31|2019/06/14|10|US Legislative Data Group|THURSDAY_TO_SUNDAY|SUNDAY|VISION_UDT_MATCHED_ROW

Related Topics