Time Cards Ready To Transfer Extracts
To extract approved time card data for transfer to a third-party payroll application, you can use the Time Cards Ready To Transfer Extracts extract. The extract includes these parameters:
- Assignment Number
- Consumer
- Effective Date
- From Approval Date
- LDG or Business Unit
- Person Number
- Start Date
It also includes this three-level group hierarchy:
Level | Object Name | Description | User Entity |
---|---|---|---|
1 | Time Card Ready To Transfer | A group of hours for a person over the time card period | HWM_EXT_TIMECARD_XFR_UE |
2 | Calculated Time Card | A group of hours calculated from reported time, for a person over the time card period | HWM_EXT_TIMECARD_ENTRY_XFR_UE |
3 | Time Entry Attributes | Additional information that applies to the calculated time entry, such as the project name, payroll time type, and department | HWM_EXT_TIMEENTRY_ATTRB_UE |
Extract Transferred Entries with Adjustments
To include previously transferred time card and entries that got adjusted later, you can copy and adjust this extract. Here's an example of how you can add the code to the copied extract definition:
----- ----- ----- HWM_EXT_TIMEENTRY_PREV_XFR_UE (new UE - previous time entry transferred)
----- ----- ----- ----- HWM_EXT_TIMEENTRY_ATTRB_UE (existing UE - current attributes)
You can link the HWM_EXT_TIMEENTRY_PREV_XFR_UE user entity to the existing HWM_EXT_TIMECARD_ENTRY_XFR or HWM_EXT_TIMEENTRY_PREV_XFR user entity by Time Record Group Id, Version, and Time Consumer.
These user entities include the database item (DBI) that identifies the time consumer:
- HWM_EXT_TIMECARD_XFR_TCSMR_CODE
- HWM_EXT_TIMECARD_ENTRY_XFR_TCSMR_CODE
- HWM_EXT_TIMEENTRY_XFR_TCSMR_CODE
- HWM_EXT_TIMEENTRY_PREV_XFR_TCSMR_CODE
The extract uses the DBI to link a group hierarchy level to the next lower level (n and n-1). The DBI also filters the levels for the same time consumer code.
Submit Extract Instance Process
You don't have to select a consumer if your extract definition includes the user entities with the time consumer DBI.
- If you leave the Consumer field blank, the process extracts time entry data for all time consumers.
- If you select a time consumer, the process extracts data associated with only that time consumer.