1. HCM Data Loading Business Objects
  2. Example of Loading Payroll Time Cards

Example of Loading Payroll Time Cards

Use HCM Data Loader to import time cards from a third-party time collection system to the Payroll cloud.

Let's look at this example. Recently,Vision Corp has acquired a company and imports the acquired employees' approved time to Payroll for payments.

Note:
  • When creating Payroll time cards, you have the option to pass rate information for a time entry. You can either pass the Rate Name, Rate Definition ID or Rate Value. If you pass the Rate Value, you must also include the Periodicity.
  • The Payroll TimeCard object doesn’t support date-effective updates.

This PayrollTimeCard.dat file uses source keys to import approved time entries into the Oracle Payroll Cloud:

METADATA|PayrollTimeCard|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|AssignmentId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|TimeCardId
MERGE|PayrollTimeCard|VISION|9999890|Vision Corporation US LDG|HDL034233|2020/01/11|2020/01/18|6
METADATA|TimeEntry|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|AssignmentId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|TimeCardInstanceId(SourceSystemId)|TimeType|Time|UnitOfMeasure|TimeCardId|TimeEntryId|Periodicity|Factor|RateDefinitionId|RateValue|Segment1
MERGE|TimeEntry|VISION|8888812|Vision Corporation US LDG|HDL034233|2020/01/11|2020/01/11|9999890|NB_ZHRX_OTL_CDRM|8.0|H_DECIMAL3|6|6|HOURLY|1.0|300100122876642|7.0|101
MERGE|TimeEntry|VIRX_OSION|8888813|Vision Corporation US LDG|HDL034233|2020/01/12|2020/01/12|9999890|NB_ZHRX_OTL_CDRM|8.0|H_DECIMAL3|6|7|HOURLY|1.0|300100122876642|7.0|102
MERGE|TimeEntry|VISION|8888814|Vision Corporation US LDG|HDL034233|2020/01/13|2020/01/13|9999890|NB_ZHRX_OTL_CDRM|8.0|H_DECIMAL3|6|8|HOURLY|1.0|300100122876642|7.0|101
MERGE|TimeEntry|VISION|8888815|Vision Corporation US LDG|HDL034233|2020/01/14|2020/01/14|9999890|NB_ZHTL_CDRM|8.0|H_DECIMAL3|6|9|HOURLY|1.0|300100122876642|7.0|101
METADATA|TimeEntryProperty|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|AssignmentId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|PayrollTimeItemId(SourceSystemId)|TimeType|PropertyName|PropertyValue|TimeCardId|TimeEntryId|TimeCardInstanceId(SourceSystemId)
MERGE|TimeEntryProperty|VISION|777712|Vision Corporation US LDG|HDL034233|2020/01/11|2020/01/11|8888812|NB_ZHRX_OTL_CDRM|NB_ZHRX_OTL_CDRM_State|12|6|6|9999890

This example uses user keys to reference the time card data.

METADATA|PayrollTimeCard|LegislativeDataGroupName|AssignmentNumber|EffectiveStartDate|EffectiveEndDate|TimeCardId
MERGE|PayrollTimeCard|Vision Corporation US LDG|E15CDRM|2020/01/11|2020/01/18|6
METADATA|TimeEntry|LegislativeDataGroupName|AssignmentNumber|EffectiveStartDate|EffectiveEndDate|TimeType|Time|UnitOfMeasure|TimeCardId|TimeEntryId|Periodicity|Factor|RateName|RateValue|Segment1
MERGE|TimeEntry|Vision Corporation US LDG|E15CDRM|2020/01/11|2020/01/11|NB_ZHRX_OTL_CDRM|8.0|H_DECIMAL3|6|6|HOURLY|1.0|COST_PROCESS_ELEMENT|7.0|101
METADATA|TimeEntryProperty|LegislativeDataGroupName|AssignmentNumber|EffectiveStartDate|EffectiveEndDate|PropertyName|PropertyValue|TimeType|TimeCardId|TimeEntryId
MERGE|TimeEntryProperty|Vision Corporation US LDG|E15CDRM|2020/01/11|2020/01/11|NB_ZHRX_OTL_CDRM_State|12|NB_ZHRX_OTL_CDRM|6|6

Related Topics