Generating TimeRecord HDL File from Vendor Source using HDL Transformation Formula

Summary:

We need to generate a TimeRecord HDL file based on a source file provided by a vendor.

Content (please ensure you mask any confidential information):

Consider the source file contains two records for a specific employee, detailed as follows:

Source File
2024-10-21,000101,0800,1700
2024-10-22,000101,0800,1700

Expected HDL File Structure:

The required HDL file consists of two objects: TimeRecordGroup and TimeRecord. The structure is outlined below:

• TimeRecordGroup:METADATA|TimeRecordGroup|GroupType|ResourceType|PersonNumber|AssignmentNumber|TcStartTime|TcStopTime
  MERGE|TimeRecordGroup|RPTD_TIME|PERSON|000101|E000101|2021/10/20 00:00:00|2021/10/26 23:59:59
• TimeRecord:METADATA|TimeRecord|GroupType|ResourceType|PersonNumber|AssignmentNumber|TcStartTime|TcStopTime|OrderEntered|StartTime|StopTime|TmRecType|Measure|UnitOfMeasure
  MERGE|TimeRecord|RPTD_TIME|PERSON|000101|E000101|2021/10/20 00:00:00|2021/10/26 23:59:59|1|2021/10/21 08:00:00|2021/10/21 17:00:00|RANGE|9|HR