Activity Transactions
The Activity Transactions entity represents the activity on which each employee worked. The activity itself is referenced in the Activityentity. The activity transaction, or activity segment, represents both the hourly and duration types of employee activities. Any reported result for the segment, such as quantity completed, is also provided in the Activity Transactions entity.
Supported Dataview types
|
Employee Dataview |
Business Structure Dataview |
|---|---|
|
X |
Data granularity
Provides one row per Employee per activity segment start time in a selected time period.
Columns
|
Label |
Description |
Key |
|---|---|---|
|
Accepted |
True if this activity segment has been accepted. |
WORK_ACTIVITY_SEGMENT_ACCEPTED |
|
Activity Processed Segment ID |
Identifier for calculated activity segment |
WORK_ACTIVITY_PROCESSED_SEGMENT_ID |
|
Activity Segment Day Divide |
Day divide indicator:
|
WORK_ACTIVITY_PROCESSED_SEGMENT_DAY_DIVIDE |
|
Activity Segment Direct Earned Hours |
Earned hours calculated for this segment if they are for a direct activity. |
WORK_ACTIVITY_TRANSACTION_EFFICIENCY_DIRECT_EARNED_HOURS |
|
Activity Segment Earned Hours |
Calculated earned hours for this segment or sub-segment ( Standard Rate * Quantity). |
WORK_ACTIVITY_TRANSACTION_EFFICIENCY_EARNED_HOURS |
|
Activity Segment Efficiency |
Percent efficiency calculated for this segment. |
WORK_ACTIVITY_TRANSACTION_EFFICIENCY_EFFICIENCY |
|
Activity Segment Efficiency Allocated Hours |
Allocated hours allocated for this raw segment for efficiency. |
WORK_ACTIVITY_TRANSACTION_EFFICIENCY_ALLOCATED_HOURS |
|
Activity Segment Efficiency Direct Allocated Hours |
Amount of time in this transaction that was directly allocated, as calculated for efficiency. |
WORK_ACTIVITY_TRANSACTION_EFFICIENCY_DIRECT_ALLOCATED_HOURS |
|
Activity Segment Efficiency Quantity |
Quantity used in calculating the efficiency. |
WORK_ACTIVITY_TRANSACTION_EFFICIENCY_QUANTITY |
|
Activity Segment ID |
Activity segment identifier associated with this processed segment:
|
WORK_ACTIVITY_PROCESSED_SEGMENT_ACTIVITY_SEGMENT_ID |
|
Activity Segment Total Allocated Hours |
Total allocated hours summed up to the raw segment, or processed segment if no raw segment is available. |
WORK_ACTIVITY_PROCESSED_SEGMENT_RAW_SEGMENT_ALLOCATED_HOURS |
|
Activity Segment Total Direct Allocated Hours |
Total direct allocated hours summed up to the raw segment, or processed segment if no raw segment is available. |
WORK_ACTIVITY_PROCESSED_SEGMENT_RAW_SEGMENT_ALLOCATED_DIRECT_HOURS |
|
Actual End Date Time |
Activity transaction end time. |
WORK_ACTIVITY_PROCESSED_SEGMENT_END_DATE_TIME |
|
Actual End Timezone |
The timezone associated with this activity segment. |
WORK_ACTIVITY_PROCESSED_SEGMENT_END_TIMEZONE |
|
Actual Start Date Time |
Actual start time associated with this activity segment. |
WORK_ACTIVITY_PROCESSED_SEGMENT_START_DATE_TIME |
|
Actual Start Timezone |
Actual start timezone associated with this activity segment. |
WORK_ACTIVITY_PROCESSED_SEGMENT_START_TIMEZONE |
|
Adjusted End Date Time |
Adjusted end time associated with this activity segment. |
WORK_ACTIVITY_PROCESSED_SEGMENT_ROUNDED_END_DATE_TIME |
|
Adjusted End Timezone |
Adjusted end timezone associated with this activity segment. |
WORK_ACTIVITY_PROCESSED_SEGMENT_ROUNDED_END_TIMEZONE |
|
Adjusted Start Date Time |
Adjusted start time associated with this activity segment. |
WORK_ACTIVITY_PROCESSED_SEGMENT_ROUNDED_START_DATE_TIME |
|
Adjusted Start Timezone |
Adjusted start timezone associated with this activity segment. |
WORK_ACTIVITY_PROCESSED_SEGMENT_ROUNDED_START_TIMEZONE |
|
Allocated Hours |
The amount of time in this segment that was allocated. |
WORK_ACTIVITY_PROCESSED_SEGMENT_ALLOCATED_SECONDS |
|
Apply Date |
Date on which this activity segment was applied to totals. |
WORK_ACTIVITY_PROCESSED_SEGMENT_APPLY_DATE |
|
Auto Resolved |
Activity segment is auto resolved. |
WORK_ACTIVITY_PROCESSED_SEGMENT_AUTO_RESOLVED |
|
Comments & Notes |
A list of comments and notes associated with this activity segment. |
WORK_ACTIVITY_SEGMENT_COMMENTS_AND_NOTES |
|
Concurrent Indicator |
This activity segment was concurrent with another activity segment. |
WORK_ACTIVITY_PROCESSED_SEGMENT_CONCURRENT |
|
Data Source ID |
The source that created this activity. |
WORK_ACTIVITY_SEGMENT_DATA_SOURCE_ID |
|
Date Time Result Value |
The date/time value entered for the result segment. If more than one date/time result was entered, this value is their sum. |
WORK_ACTIVITY_RESULT_SEGMENT_DATETIME_RESULT |
|
Decimal Result Value |
The decimal value entered for this activity segment. If more than one decimal result was entered, this value is their sum. |
WORK_ACTIVITY_RESULT_SEGMENT_FLOATING_DECIMAL_RESULT |
|
Deducted Hours |
The amount of deducted time for this activity segment. |
WORK_ACTIVITY_PROCESSED_SEGMENT_DEDUCTED_SECONDS |
|
Direct Indicator |
The activity segment is an activity that is chargeable. |
WORK_ACTIVITY_SEGMENT_DIRECT |
|
Duration Order |
Because duration activity segments do not have a start time, the system orders them by the time at which they were entered by the user. The order of an activity segment can be changed from the timecard through the Reorder Activity function. |
WORK_ACTIVITY_SEGMENT_DURATION_ORDER |
|
Duration Result Value |
The expected quantity to be completed during the standard hour |
WORK_ACTIVITY_RESULT_SEGMENT_TIME_ RESULT |
|
Employee Approval Status |
Indicates employee approval status for activity segment |
WORK_ACTIVITY_PROCESSED_SEGMENT_EMPLOYEE_APPROVAL_STATUS |
|
Empty Transfer |
If true, transfer was empty. |
WORK_ACTIVITY_SEGMENT_EMPTY_TRANSFER |
|
Event Type |
Activity segment event type |
WORK_ACTIVITY_PROCESSED_SEGMENT_EVENT_TYPE |
|
Form Code |
Activity segment generated by a Form execution either through the clock or the Web |
WORK_ACTIVITY_FORM_CODE |
|
Form Description |
Form description. |
WORK_ACTIVITY_FORM_DESCRIPTION |
|
Form Type |
Type of form: for example, Start/Stop. |
WORK_ACTIVITY_FORM_TYPE |
|
Idle |
Activity segment is idle. |
WORK_ACTIVITY_PROCESSED_SEGMENT_IDLE |
|
Manager Approval Status |
Indicates manager approval status for activity segment |
WORK_ACTIVITY_PROCESSED_SEGMENT_MANAGER_APPROVAL_STATUS |
|
Mismatched |
Activity segment is mismatched. |
WORK_ACTIVITY_SEGMENT_MISMATCHED |
|
Missing Results |
Activity segment is missing results. |
WORK_ACTIVITY_SEGMENT_MISSING_RESULTS |
|
Money Amount |
The money amount associated with this activity segment. |
WORK_ACTIVITY_PROCESSED_SEGMENT_MONEY_AMOUNT |
|
Numeric Result Value |
The numeric value entered for this activity segment. If more than one numeric result was entered, this value is their sum. |
WORK_ACTIVITY_RESULT_SEGMENT_NUMERIC_RESULT |
|
Open Segment Indicator |
Indicates the activity segment is currently open |
WORK_ACTIVITY_TRANSACTION_SEGMENT_OPEN_INDICATOR |
|
Orphan Indicator |
Activity segment is an orphan. |
WORK_ACTIVITY_PROCESSED_SEGMENT_ORPHAN |
|
Overage Duration |
The amount of time this segment had overage. |
WORK_ACTIVITY_PROCESSED_SEGMENT_OVERAGE_DURATION_IN_SECONDS |
|
Overallocated |
Activity segment is overallocated. |
WORK_ACTIVITY_PROCESSED_SEGMENT_OVERALLOCATED |
|
Raw Segment Duration |
The duration amount for this duration type activity. |
WORK_ACTIVITY_SEGMENT_DURATION_IN_SECONDS |
|
Raw Segment Duration Date |
The date of this duration type activity. |
WORK_ACTIVITY_SEGMENT_DURATION_DATE |
|
Standard Cost |
The standard cost amount for this activity. |
WORK_ACTIVITY_SEGMENT_STANDARD_COST_AMOUNT |
|
Standard Hours |
The standard hours associated with this activity. |
WORK_ACTIVITY_SEGMENT_STANDARD_HOURS |
|
Standard Quantity |
The standard quantity associated with this activity. |
WORK_ACTIVITY_SEGMENT_STANDARD_QUANTITY |
|
Standard Rate |
The standard rate amount associated with this activity. |
WORK_ACTIVITY_SEGMENT_STANDARD_RATE_AMOUNT |
|
Standard Seconds |
The standard seconds associated with this activity. |
WORK_ACTIVITY_SEGMENT_STANDARD_SECONDS |
|
System Generated End Indicator |
This segment was generated by the system (for example, end time for Stop-Only transaction). |
WORK_ACTIVITY_PROCESSED_SEGMENT_SYSTEM_END_INDICATOR |
|
System Generated Start Indicator |
This segment was generated by the system(for example, start time for Stop-Only transaction). |
WORK_ACTIVITY_PROCESSED_SEGMENT_SYSTEM_START_INDICATOR |
|
Text Result Value |
The text value entered for this activity segment. If more than one text result was entered, this value is their sum. |
WORK_ACTIVITY_RESULT_SEGMENT_TEXT_RESULT |
|
Time Result Value |
Expected quantity to be completed in the standard hour. | |
|
Work Item ID |
The activity segment work item identifier. |
WORK_ACTIVITY_PROCESSED_SEGMENT_WORK_ITEM_ID |
|
Work Rule Name |
The name used to identify the work rule |
WORK_ACTIVITY_SEGMENT_WORK_RULE |
Related entities
Core entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category |
|---|---|---|---|---|---|
| X |
Relationship
|
One-to-One |
One-to-Many |
|---|---|
|
Activity |
Employee |