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

Example of Loading User-Defined Tables for a Range of Row Values

Let's consider this example. Each year, your organization offers stock options to its employees. The amount of stocks depend on the years of service and the job category of the employee receiving them.

As this image shows, the user-defined table contains stock option allocations by job category and years of service. The rows represent a range of years of service during which employees receive the same number of stock options. The columns contain the job categories. And the values represent the number of stock options awarded to the specified job category during the specified years of service.

The user-defined table contains stock option allocations by job category and years of service.

Use this .dat file to load your stock option allocations.

METADATA|UserDefinedTable|LegislativeDataGroupName|UserTableCode|RangeOrMatch|UserKeyUnits|UserRowTitle|UserTableName
MERGE|UserDefinedTable|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|R|N|Years of Service|Employee Stock Options by Job Category and Length of Service

METADATA|UserDefinedTableColumn|LegislativeDataGroupName|UserTableCode|UserColumnCode|UserColumnName|DataType|FormulaName
MERGE|UserDefinedTableColumn|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|EXECUTIVE|Executive|N|
MERGE|UserDefinedTableColumn|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|MANAGER|Manager|N|
MERGE|UserDefinedTableColumn|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|TECHNICAL|Technical|N|
MERGE|UserDefinedTableColumn|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|CLERICAL|Clerical|N|

METADATA|UserDefinedTableRow|LegislativeDataGroupName|UserTableCode|DisplaySequence|RowName|EffectiveStartDate|EffectiveEndDate|RowLowRangeOrName|RowHighRange
MERGE|UserDefinedTableRow|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|10|1|2019/01/01|4712/12/31|1|3
MERGE|UserDefinedTableRow|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|20|4|2019/01/01|4712/12/31|4|5
MERGE|UserDefinedTableRow|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|30|6|2019/01/01|4712/12/31|6|8
MERGE|UserDefinedTableRow|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|40|9|2019/01/01|4712/12/31|9|10
MERGE|UserDefinedTableRow|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|50|11|2019/01/01|4712/12/31|11|15
MERGE|UserDefinedTableRow|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|60|16|2019/01/01|4712/12/31|16|20
MERGE|UserDefinedTableRow|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|70|21|2019/01/01|4712/12/31|21|69

METADATA|UserDefinedTableColumnInstance|LegislativeDataGroupName|UserTableCode|RowLowRangeOrName|UserColumnCode|EffectiveStartDate|EffectiveEndDate|Value
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|1|EXECUTIVE|2019/01/01|4712/12/31|1000
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|4|EXECUTIVE|2019/01/01|4712/12/31|2000
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|6|EXECUTIVE|2019/01/01|4712/12/31|3000
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|9|EXECUTIVE|2019/01/01|4712/12/31|4000
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|11|EXECUTIVE|2019/01/01|4712/12/31|5000
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|16|EXECUTIVE|2019/01/01|4712/12/31|6000
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|21|EXECUTIVE|2019/01/01|4712/12/31|10000
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|1|MANAGER|2019/01/01|4712/12/31|500
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|4|MANAGER|2019/01/01|4712/12/31|1000
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|6|MANAGER|2019/01/01|4712/12/31|1500
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|9|MANAGER|2019/01/01|4712/12/31|2000
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|11|MANAGER|2019/01/01|4712/12/31|2500
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|16|MANAGER|2019/01/01|4712/12/31|3000
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|21|MANAGER|2019/01/01|4712/12/31|5000
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|1|TECHNICAL|2019/01/01|4712/12/31|250
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|4|TECHNICAL|2019/01/01|4712/12/31|500
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|6|TECHNICAL|2019/01/01|4712/12/31|750
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|9|TECHNICAL|2019/01/01|4712/12/31|1000
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|11|TECHNICAL|2019/01/01|4712/12/31|1250
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|16|TECHNICAL|2019/01/01|4712/12/31|1500
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|21|TECHNICAL|2019/01/01|4712/12/31|2500
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|1|CLERICAL|2019/01/01|4712/12/31|125
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|4|CLERICAL|2019/01/01|4712/12/31|250
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|6|CLERICAL|2019/01/01|4712/12/31|375
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|9|CLERICAL|2019/01/01|4712/12/31|500
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|11|CLERICAL|2019/01/01|4712/12/31|625
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|16|CLERICAL|2019/01/01|4712/12/31|750
MERGE|UserDefinedTableColumnInstance|US Legislative Data Group|EMP_STOCK_OPT_BY_JOB_CAT_AND_LOS|21|CLERICAL|2019/01/01|4712/12/31|1250

Related Topics