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
0