1. HCM Data Loading Business Objects
  2. Examples of Loading Time Record Groups

Examples of Loading Time Record Groups

This topic shows how to create Time Record Group objects using HCM Data Loader.

Creating Time Record Groups

This example TimeRecordGroup.dat file creates two time record groups for the same assignment. It references the person and assignment by their user keys. 

METADATA|TimeRecordGroup|GroupType|ResourceType|PersonNumber|AssignmentNumber|TcStartTime|TcStopTime
MERGE|TimeRecordGroup|RPTD_TIME|PERSON|8153756|EEEE8153756|2010/02/01 00:00:01|2010/02/06 23:59:59
METADATA|TimeRecord|GroupType|ResourceType|PersonNumber|TcStartTime|TcStopTime|OrderEntered|StartTime|StopTime|TmRecType|AssignmentNumber|Measure|UnitOfMeasure
MERGE|TimeRecord|RPTD_TIME|PERSON|8153756|2010/02/01 00:00:01|2010/02/06 23:59:59|1|2010/02/01 09:00:01|2010/02/01 13:00:01|RANGE|EEEE8153756|4|HR
MERGE|TimeRecord|RPTD_TIME|PERSON|8153756|2010/02/01 00:00:01|2010/02/06 23:59:59|2|2010/02/02 09:00:01|2010/02/02 13:00:01|RANGE|EEEE8153756|4|HR
MERGE|TimeRecord|RPTD_TIME|PERSON|8153756|2010/02/01 00:00:01|2010/02/06 23:59:59|3|2010/02/03 09:00:01|2010/02/03 13:00:01|RANGE|EEEE8153756|4|HR
MERGE|TimeRecord|RPTD_TIME|PERSON|8153756|2010/02/01 00:00:01|2010/02/06 23:59:59|4|2010/02/04 09:00:01|2010/02/04 13:00:01|RANGE|EEEE8153756|4|HR
MERGE|TimeRecord|RPTD_TIME|PERSON|8153756|2010/02/01 00:00:01|2010/02/06 23:59:59|5|2010/02/05 09:00:01|2010/02/05 13:00:01|RANGE|EEEE8153756|4|HR
METADATA|TimeRecordGroupAttribute|GroupType|ResourceType|PersonNumber|TcStartTime|TcStopTime|AttributeName|AttributeDataType|AttributeStringValue
MERGE|TimeRecordGroupAttribute|RPTD_TIME|PERSON|8153756|2010/02/01 00:00:01|2010/02/06 23:59:59|Comment|String|Create Timecard for 2 week of year 2010
METADATA|TimeRepositoryAttribute|GroupType|ResourceType|PersonNumber|TcStartTime|TcStopTime|OrderEntered|AttributeName|AttributeDataType|AttributeStringValue|AttributeBigDecimalValue
MERGE|TimeRepositoryAttribute|RPTD_TIME|PERSON|8153756|2010/02/01 00:00:01|2010/02/06 23:59:59|1|PayrollTimeType|STRING|ZOTL_Regular|
MERGE|TimeRepositoryAttribute|RPTD_TIME|PERSON|8153756|2010/02/01 00:00:01|2010/02/06 23:59:59|1|LDG_ID|BIG_DECIMAL||202
MERGE|TimeRepositoryAttribute|RPTD_TIME|PERSON|8153756|2010/02/01 00:00:01|2010/02/06 23:59:59|2|PayrollTimeType|STRING|ZOTL_Regular|
MERGE|TimeRepositoryAttribute|RPTD_TIME|PERSON|8153756|2010/02/01 00:00:01|2010/02/06 23:59:59|2|LDG_ID|BIG_DECIMAL||202
MERGE|TimeRepositoryAttribute|RPTD_TIME|PERSON|8153756|2010/02/01 00:00:01|2010/02/06 23:59:59|3|PayrollTimeType|STRING|ZOTL_Regular|
MERGE|TimeRepositoryAttribute|RPTD_TIME|PERSON|8153756|2010/02/01 00:00:01|2010/02/06 23:59:59|3|LDG_ID|BIG_DECIMAL||202
MERGE|TimeRepositoryAttribute|RPTD_TIME|PERSON|8153756|2010/02/01 00:00:01|2010/02/06 23:59:59|4|PayrollTimeType|STRING|ZOTL_Regular|
MERGE|TimeRepositoryAttribute|RPTD_TIME|PERSON|8153756|2010/02/01 00:00:01|2010/02/06 23:59:59|4|LDG_ID|BIG_DECIMAL||202
MERGE|TimeRepositoryAttribute|RPTD_TIME|PERSON|8153756|2010/02/01 00:00:01|2010/02/06 23:59:59|5|PayrollTimeType|STRING|ZOTL_Regular|
MERGE|TimeRepositoryAttribute|RPTD_TIME|PERSON|8153756|2010/02/01 00:00:01|2010/02/06 23:59:59|5|LDG_ID|BIG_DECIMAL||202

This example demonstrates that:

  • The GroupType attribute value on all components must be RPTD_TIME.

  • The ResourceType attribute value on all components must be PERSON.

  • The TcStartTime and TcStopTime attribute values on all child components of the object must match those on the parent Time Record Group object.

  • You must supply the same value for the OrderEntered attribute on both the Time Repository Attribute component and its parent Time Record component.

Related Topics