Activity Paycode Totals
Each activity segment that employees perform is analyzed by the Background Processor to determine such values as the number of allocated hours and cost. These values are available in the Activity Paycode Totals entity.
Supported Dataview types
| Employee Dataview | Business Structure Dataview |
|---|---|
| X |
Data granularity
Multiple rows per activity segment per employee. Each row represents the amount and cost allocated for each pay code such as regular and overtime.
Columns
| Label | Description | Key |
|---|---|---|
| Time Item ID | Activity total time item ID. | WORK_ACTIVITY_TOTAL_TIME_ITEM_ID |
| Activity Paycode Total Days | Activity Total Amount by Day | WORK_ACTIVITY_TOTAL_DAYS |
| Activity Paycode Total Hours | Activity total amount. | WORK_ACTIVITY_TOTAL_AMOUNT |
| Activity Paycode Total Wages | Activity total wages. | WORK_ACTIVITY_TOTAL_WAGES |
| Activity Processed Segment ID | Activity processed segment associated with this total. | WORK_ACTIVITY_TOTAL_PROCEESD_SEGMENT_ID |
| Activity Segment ID | A system generated unique number that identifies the activity total activity. | WORK_ACTIVITY_TOTAL_ACTIVITY_ID |
| Apply Date | Activity total apply date. | WORK_ACTIVITY_TOTAL_APPLY_DATE |
| Start Date Time | Activity total start date/time. | WORK_ACTIVITY_TOTAL_START_DATE_TIME |
Core entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category | Activity |
|---|---|---|---|---|---|---|
| X | X | X | X | X |
Relationship
| One-to-One | One-to-Many |
|---|---|
|
Organizational Job Paycode Labor Category Activity |
Employee |