TimeCardsAllActiveWorkers
The view that returns time card data for all active workers in the organization. It consolidates current worker time records to provide a comprehensive overview of attendance and worked hours across departments.
Columns
| Name | Type | References | Description |
| AssociateOID [KEY] | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate within the ADP system. This Id links time card entries to the correct worker profile across HR and payroll records. |
| WorkerID [KEY] | String | The unique Id that represents the worker to whom the time card belongs. This Id ensures that time tracking aligns with the employee's assignment and payroll data. | |
| TimeCardID [KEY] | String | The unique Id for the time card record. This Id differentiates one time card submission from another for audit and reporting purposes. | |
| PersonLegalName | String | The worker's full legal name as maintained in the core Human Resources (HR) system. This value is used for display and verification on payroll and compliance documents. | |
| PersonLegalFamilyName1 | String | The worker's primary family name that is recorded in the legal documentation. This family name provides a consistent basis for employee identification in reports. | |
| PersonLegalFormattedName | String | The formatted version of the worker's legal name that is displayed in official reports and user interfaces. This version of the name follows the organization's preferred naming conventions. | |
| ProcessingStatusCodeValue | String | The code value that indicates the current processing status of the time card (for example, 'Pending', 'Approved', or 'Processed'). | |
| ProcessingStatusCodeShortName | String | The short name that corresponds to the value for the processing status code. This name provides a simplified label for display within reports or dashboards. | |
| periodCodeValue | String | The code value that represents the payroll or time card period. Supported values include current, next, previous, and so on. The code value determines which pay cycle the record belongs to. | |
| periodCodeShortName | String | The short name for the payroll or time card period code. This name is used for quick reference in user interfaces and reporting tools. | |
| periodCodeLongName | String | The long name for the payroll or time card period code. This name provides a detailed, descriptive label that helps users interpret period-based data. | |
| TimePeriodStartDate | String | The start date of the time card period. This date defines the first day of the payroll or reporting timeframe captured in this record. | |
| TimePeriodEndDate | String | The end date of the time card period. This date defines the last day of the payroll or reporting timeframe associated with this record. | |
| TimePeriodPeriodStatus | String | The current status of the time period (for example, Open, Closed, or Locked). This status determines whether time entries for that period can be modified. | |
| PositionID | String | The unique Id that represents the worker's position or job role within the organization. This Id allows linkage between time worked and labor costing or departmental budgeting. | |
| ExceptionCounts | String | The collection of exception counts that summarize issues that are detected in the time card (for example, missed punches or overtime violations). This field supports payroll validation and compliance reviews. | |
| PeriodTotals | String | The aggregated totals for the entire time card period, including total hours worked, leave, and overtime. This aggregation provides a summarized view for payroll calculation. | |
| DailyTotals | String | The daily totals of hours and related time data within the period. This field enables managers to review work distribution and detect anomalies in attendance. | |
| TotalPeriodTimeDuration | String | The total time duration that is recorded across the entire time period. This field includes all payable and non-payable time and is used for labor and cost reporting. | |
| HomeLaborAllocations | String | The set of labor allocation records that associate worked hours with cost centers or departments. This field ensures proper labor costing within financial and HR systems. | |
| Actions | String | The available system or user actions that are associated with the time card record, (for example, submit, approve, or reject). These actions define workflow options and state transitions. |