Time Entries Ready To Transfer Extracts
To extract unapproved but appropriately prepared time entry data for transfer to a third-party payroll application, you can use the Time Entries 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 two-level group hierarchy:
Level | Object Name | Description | User Entity |
---|---|---|---|
1 | Time Entry Ready To Transfer | A range of time defined by start and stop times or a time duration on the time card | HWM_EXT_TIMEENTRY_XFR_UE |
2 | Time Entry Attributes | Additional information that applies to a 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 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_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_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.