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.
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.
Supported Dataview/RDO Type
| Employee | Business Structure | Employee - Time Series | Business Structure - Time Series | Work Unit | Work Unit - Time Series |
|---|---|---|---|---|---|
Columns
| Time Item ID | Activity total time item ID. | WORK_ACTIVITY_TOTAL_TIME_ITEM_ID | String | No |
| Activity Paycode Total Days | Activity Total Amount by Day | WORK_ACTIVITY_TOTAL_DAYS | Number | No |
| Activity Paycode Total Hours | Activity total amount. | WORK_ACTIVITY_TOTAL_AMOUNT | Number | No |
| Activity Paycode Total Wages | Activity total wages. | WORK_ACTIVITY_TOTAL_WAGES | Number | No |
| Activity Processed Segment ID | Activity processed segment associated with this total. | WORK_ACTIVITY_TOTAL_PROCEESD_SEGMENT_ID | String | No |
| Activity Segment ID | A system generated unique number that identifies the activity total activity. | WORK_ACTIVITY_TOTAL_ACTIVITY_ID | String | No |
| Apply Date | Activity total apply date. | WORK_ACTIVITY_TOTAL_APPLY_DATE | Date | No |
| Start Date Time | Activity total start date/time. | WORK_ACTIVITY_TOTAL_START_DATE_TIME | DateTime | No |
Related Entities
Core Entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category | Activity | Work Unit | Work Group | Procedure Code |
|---|---|---|---|---|---|---|---|---|---|
Relationship
| Core Entity | Relationship |
|---|---|
| Activity | One to One |
| Employee | One to Many |
| Paycode | One to One |
| Labor Category | One to One |
| Organizational Job | One to One |