Activity Efficiency
The Activity Segment Efficiency entity shows the efficiency of the activity segment based on the allocated, earned hours and quantity. Two types of efficiency are calculated.
If the efficiency type = 0, the entity represents the efficiency of the activity segment as a whole.
If the efficiency type = 1, the entity shows the efficiency each time that a new quantity is added for the activity segment. This allows users to track the efficiency over the full duration of the activity segment.
Supported Dataview types
| Employee Dataview | Business Structure Dataview |
|---|---|
| X |
Data granularity
When the efficiency type = SEGMENT (0), the Activity Segment Efficiency entity provides one efficiency value per activity segment row. When the efficiency type = SUBSEGMENT (1), it provides many efficiency values to one activity sub-segment rows. The number of sub-segment rows reflects the number of times for which quantity results were reported.
Columns
| Label | Description | Key |
|---|---|---|
| Earned Hours | Calculated earned hours for this activity segment or sub-segment. | WORK_ACTIVITY_EFFICIENCY_EARNED_HOURS |
| Efficiency Activity Segment ID | Activity segment ID associated with this efficiency | WORK_ACTIVITY_EFFICIENCY_ACTIVITY_SEGMENT_ID |
| Efficiency Allocated Hours | Allocated hours that are used to calculate the efficiency of this activity segment or sub-segment. | WORK_ACTIVITY_EFFICIENCY_ALLOCATED_HOURS |
| Efficiency Quantity | Quantity used to calculate efficiency. | WORK_ACTIVITY_EFFICIENCY_QUANTITY |
| Segment Efficiency | Efficiency calculated for this activity segment or sub-segment. | WORK_ACTIVITY_EFFICIENCY_SEGMENT_EFFICIENCY |
| Segment Efficiency Type |
Segment or sub-segment type of efficiency. Either SEGMENT or SUBSEGMENT. |
WORK_ACTIVITY_EFFICIENCY_SEGMENT_EFFICIENCY_TYPE |
| Segment End Datetime | End date/time for this activity segment or sub-segment. | WORK_ACTIVITY_EFFICIENCY_SEGMENT_END_DATETIME |
| Segment End Timezone | Timezone for the end time of this activity segment or sub-segment. | WORK_ACTIVITY_EFFICIENCY_SEGMENT_END_TIME_ZONE |
| Segment Start Datetime | Start date/time for this activity segment or sub-segment. | WORK_ACTIVITY_EFFICIENCY_SEGMENT_START_DATETIME |
| Segment Start Timezone | Timezone for the start time of this activity segment or sub-segment. | WORK_ACTIVITY_EFFICIENCY_SEGMENT_START_TIME_ZONE |
Core entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category | Activity |
|---|---|---|---|---|---|---|
| X | X |
Relationship
| One-to-One | One-to-Many |
|---|---|
| Activity | Employee |