Example of Loading Retropay for Late Hires Event Action

The event action creates a payroll action for the late hire, causing the employee to appear in the process results for that payroll with the action status as Retroactively Added.

Calculate retroactive pay for late hires using the enhanced RetroPay Late Hire solution. This feature automates the calculation of retroactive earnings for late hires by removing the need for manual intervention. Also, you can view the late hire details for an employee using the payroll flow and checklist. You can now configure the event action to enable the Evaluate Late Hires flow pattern to:
  • Evaluate late hires automatically
  • Create a net pay result
  • Create retro event notifications
This lets late hires to be processed within the Recalculate Payroll for Retroactive Changes process. This flow pattern contains two tasks:
  • Calculate Payroll for Late Hire
  • Late Hire Retropay Notification
These tasks replace the need to manually enter an element entry against the late hire, as the Late Hire Retropay Notification task automatically creates the notification. You can now view the late hire details for an employee using the Person Results and Payroll Checklist pages.

Use the sample HCM Data Loader (.DAT file) to enable all or some of these events:

  • Create Flow: If set to 'Y', generates the Evaluate Late Hire flow pattern with its Calculate Payroll for Late Hire and Late Hire Retropay Notification tasks.
  • Hire Date Later: If set to 'Y', the retroactive net pay result is generated when an employee's hire date is later than the payroll process date.
  • Run Payroll Relationship Group: If set to 'Y', the retroactive net pay result is generated even when the original payroll was run with a payroll relationship group.
  • Additional Assignments: If set to 'Y', the retroactive net pay result is generated when a late assignment is added to a payroll relationship.

Important pages:

  • Use the View Flows, Process Results and Person Results pages to view the flow results.
  • Use the View Flows page to drill down to the Evaluate Late Hires details.
  • Use the Person Results page to drill down to the Calculate Payroll for Late Hires details.

Perform the following steps to enable the flow:

  1. Create a new Event Group for your Legislative data group. Follow the steps mentioned in the topic Example of Loading Retropay for Late Hires Event Groups
  2. Create a new Event Action for your Legislative data group.
    Note: Even if you are currently using the Late Hire functionality, you still need to create a new Event Action.

    Use this reference data as template to update your new event action:

    METADATA|EventAction|EventActionCode|EffectiveStartDate|EffectiveEndDate|EventActionName|EventActionTypeCode|ActionSubmission|ProcessMode|AutoApprove|Description|LegislativeDataGroupName
    METADATA|EventGroupAction|EventActionCode|EffectiveStartDate|EffectiveEndDate|EventGroupCode
    MERGE|EventAction|<Event_Action_Code>|1950/01/01|4712/12/31|<Event_Action_Name>|ORA_CREATE_RUN_REL_ACTIONS|SYNC|AUTO|N|<Event_Action_Description>|<Legislative Data Group Name>
    MERGE|EventGroupAction|<Event_Action_Code>|1950/01/01|4712/12/31|<Event_Group_Code>

    Update Event Action in the reference data with following details:

    • Replace <Event_Action_Code> with event action code, such as MY_EVENT_ACTION
    • Replace <Event_Action_Name> with event action name, such as My_Event_Action
    • Replace <Event_Action_Description> with event action description, such as My Event Action
    • Replace <Legislative Data Group Name> with LDG Name, such as US Legislative Data group
    • Replace <Event_Group_Code> with event group code, such as the above example of MY_EVENT_GROUP
    • Zip the modified template as EventAction.zip.
  3. Upload EventGroup.zip and EventAction.zip using HDL.
  4. Create Event Action HDL files to set the Evaluate Late Hires flow pattern functionality using these samples:

    Sample 1: Only enable flow, Y|N|N|N

    METADATA|EventAction|FLEX:PAY_EVENT_ACTIONS_DDF|CreateFlow(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|HireDateLater(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|RunPayRelationshipGroup(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|AdditionalAssignments(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|EventActionCode|EffectiveStartDate|EffectiveEndDate|EventActionName|EventActionTypeCode|LookbackTimeDefinitionCode|ActionSubmission|ProcessMode|AutoApprove|LegislativeDataGroupId
    MERGE|EventAction|ORA_CREATE_RUN_REL_ACTIONS|Y|N|N|N|RetroLateHire|1950/01/01|4712/12/31|RetroLateHire|ORA_CREATE_RUN_REL_ACTIONS||SYNC|MANUAL|Y|300100003140635

    Sample 2: Enable flow with Hire Date Later, Y|Y|N|N

    METADATA|EventAction|FLEX:PAY_EVENT_ACTIONS_DDF|CreateFlow(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|HireDateLater(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|RunPayRelationshipGroup(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|AdditionalAssignments(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|EventActionCode|EffectiveStartDate|EffectiveEndDate|EventActionName|EventActionTypeCode|LookbackTimeDefinitionCode|ActionSubmission|ProcessMode|AutoApprove|LegislativeDataGroupId
    MERGE|EventAction|ORA_CREATE_RUN_REL_ACTIONS|Y|Y|N|N|RetroLateHire|1950/01/01|4712/12/31|RetroLateHire|ORA_CREATE_RUN_REL_ACTIONS||SYNC|MANUAL|Y|300100003140635

    Sample 3: Enable flow with Run Payroll Relationship Group, Y|N|Y|N

    METADATA|EventAction|FLEX:PAY_EVENT_ACTIONS_DDF|CreateFlow(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|HireDateLater(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|RunPayRelationshipGroup(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|AdditionalAssignments(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|EventActionCode|EffectiveStartDate|EffectiveEndDate|EventActionName|EventActionTypeCode|LookbackTimeDefinitionCode|ActionSubmission|ProcessMode|AutoApprove|LegislativeDataGroupId
    MERGE|EventAction|ORA_CREATE_RUN_REL_ACTIONS|Y|N|Y|N|RetroLateHire|1950/01/01|4712/12/31|RetroLateHire|ORA_CREATE_RUN_REL_ACTIONS||SYNC|MANUAL|Y|300100003140635

    Sample 4: Enable flow with Additional Assignments, Y|N|N|Y

    METADATA|EventAction|FLEX:PAY_EVENT_ACTIONS_DDF|CreateFlow(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|HireDateLater(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|RunPayRelationshipGroup(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|AdditionalAssignments(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|EventActionCode|EffectiveStartDate|EffectiveEndDate|EventActionName|EventActionTypeCode|LookbackTimeDefinitionCode|ActionSubmission|ProcessMode|AutoApprove|LegislativeDataGroupId
    MERGE|EventAction|ORA_CREATE_RUN_REL_ACTIONS|Y|N|N|Y|RetroLateHire|1950/01/01|4712/12/31|RetroLateHire|ORA_CREATE_RUN_REL_ACTIONS||SYNC|MANUAL|Y|300100003140635

    Zip the modified template as EvaluateLateHire.zip.

  5. Upload EvaluateLateHire.zip using HDL.
Note: Original payroll must have a run type of Regular.