Example of Loading Read-Only Project Costing Time Cards

This example TimeRecordGroup.dat file creates a Time card object with all of the applicable time entries for third-party historical time cards. The file identifies both the Time card object and the linked time entries by their source keys.

METADATA|TimeRecordGroup|GroupType|ResourceType|PersonNumber|TcStartTime|TcStopTime|AssignmentNumber
MERGE|TimeRecordGroup|TIME_RPTD|PERSON|468|2016/12/19 00:00:01|2016/12/25 23:59:59|E300000026957492-3
METADATA|TimeRecord|PersonNumber|ResourceType|TcStartTime|TcStopTime|GroupType|StartTime|StopTime|TmRecType|OrderEntered|UnitOfMeasure|Measure|AssignmentNumber
MERGE|TimeRecord|468|PERSON|2016/12/19 00:00:01|2016/12/25 23:59:59|TIME_RPTD|2016/12/20 09:00:01|2016/12/20 18:00:00|MEASURE|1|HR|8|E300000026957492-3
METADATA|TimeRepositoryAttribute|ResourceType|TcStartTime|TcStopTime|OrderEntered|GroupType|AttributeName|AttributeDataType|AttributeStringValue|AttributeLongValue|AttributeBigDecimalValue|AttributeDateValue|AttributeTimestampValue|AttributeUsageId|TimeRecordId|PersonNumber
MERGE|TimeRepositoryAttribute|PERSON|2016/12/19 00:00:01|2016/12/25 23:59:59|1|TIME_RPTD|PJC_PROJECT_ID|BIG_DECIMAL|||Attrib_Bg_Pjc_Id|||||468
MERGE|TimeRepositoryAttribute|PERSON|2016/12/19 00:00:01|2016/12/25 23:59:59|1|TIME_RPTD|PJC_TASK_ID|BIG_DECIMAL|||Attrib_Bg_Pjc_Task_Id|||||468
MERGE|TimeRepositoryAttribute|PERSON|2016/12/19 00:00:01|2016/12/25 23:59:59|1|TIME_RPTD|PJC_PROJECT_UNIT|BIG_DECIMAL|||Attrib_Bg_Pjc_Unit|||||468
MERGE|TimeRepositoryAttribute|PERSON|2016/12/19 00:00:01|2016/12/25 23:59:59|1|TIME_RPTD|PJC_EXPENDITURE_TYPE_ID|BIG_DECIMAL|||Attrib_Pjc_Exp_Id|||||468
MERGE|TimeRepositoryAttribute|PERSON|2016/12/19 00:00:01|2016/12/25 23:59:59|1|TIME_RPTD|PJC_EXPENDITURE_TYPE_NAME|STRING|Attrib_Pjc_Exp_Type_Name|||||||468
MERGE|TimeRepositoryAttribute|PERSON|2016/12/19 00:00:01|2016/12/25 23:59:59|1|TIME_RPTD|PJC_SYSTEM_LINKAGE_FUNCTION|STRING|Attrib_Pjc_System_Linkage|||||||468