TeamTimeCardsHomeLaborAllocations
The view that returns home-labor allocation data for team time cards. This view identifies how hours worked are distributed across home cost centers, locations, or projects. This view supports labor allocation and cost accounting.
Table Specific Information
Select
The connector uses the ADP API to process WHERE clause conditions built with the following column and operator. The ManagerOID is required to make a request and the rest of the filter is executed client side within the connector.
- ManagerOID supports the '=' comparison.
SELECT * FROM TeamTimeCardsHomeLaborAllocations WHERE ManagerOID = 'G3349PZGBADQY8H7'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate whose labor allocation is recorded for the time card. This Id links the allocation data to the associate's employment and payroll information in ADP. |
| WorkerID | String | The Id that identifies the worker that is associated with the home labor allocation. This Id connects the allocation entry to related payroll and scheduling records. | |
| TimeCardID | String | The Id that identifies the time card record for the associate. This Id distinguishes the labor allocation within the broader time card entry. | |
| AllocationCode | String | The code that identifies the home labor allocation (for example, a department, project, or cost center). This code determines where the associate's time is charged for payroll and reporting purposes. | |
| AllocationTypeCodeValue | String | The code that specifies the type of labor allocation (for example, Primary Department or Job Function). This value defines the classification of the work performed. | |
| AllocationTypeCodeShortName | String | The short descriptive name that corresponds to the labor-allocation type code. This field provides a readable label for display in time-tracking and payroll reports. | |
| ManagerOID | String |
Workers.AssociateOID | The Id that identifies the manager responsible for overseeing the associate's labor allocation. This Id links the allocation record to the manager's profile in ADP. |
| periodCodeValue | String | The code that identifies the time-tracking period that the allocation applies to (for example, Current, Next, or Previous). This code determines which payroll period the data belongs to. | |
| TimePeriodEndDate | String | The end date of the time card period that the allocation covers. This date marks when the payroll or work period concludes. |