Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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