Activity

The Activity entity is intended to be used with the Activity transactional entities. It contains a large number of properties that fully describe the activity definition and contain status information. All activity status attributes are available in this entity. Select the Activity entity after any of the transactional Activity entities in order to view the values selected from their data attribute columns.

Data Granularity

Provides one row per Activity Segment and Employee for the defined time period.

Supported Dataview/RDO Type

Employee Business Structure Employee - Time Series Business Structure - Time Series Work Unit Work Unit - Time Series

Columns
Unaccounted Quantity Quantity due to unaccounted activity. CORE_WORK_ACTIVITY_DEFINITION_UNACCOUNTED_QUANTITY Number No
User Defined Field 2 User defined field 2 for this activity CORE_WORK_ACTIVITY_DEFINITION_USER_FIELD2 String No
Completed Quantity Completed quantity so far for this activity. CORE_WORK_ACTIVITY_DEFINITION_COMPLETED_QUANTITY Number No
Activity Level Activity level for this activity. CORE_WORK_ACTIVITY_DEFINITION_LEVEL String No
Priority Type Priority type for this activity. Either High, Medium, Low, or Urgent. CORE_WORK_ACTIVITY_DEFINITION_PRIORITY_TYPE_QUALIFIER Enum No
Actual Start Date Actual start date for this activity. CORE_WORK_ACTIVITY_DEFINITION_ACTUAL_START_DATE Date No
Completed Percentage Percentage of the activity that has been completed. CORE_WORK_ACTIVITY_DEFINITION_COMPLETED_PERCENT Number No
Labor Quantity Allocation Type Either Even, All, Zero, or Quantity Complete CORE_WORK_ACTIVITY_DEFINITION_LABOR_QUANTITY_ALLOCATION_TYPE_QUALIFIER Enum No
Parent Activity Name Name of the parent activity. CORE_WORK_ACTIVITY_DEFINITION_PARENT_QUALIFIER String No
Process Type Process type for this activity. Either None, Setup or Run CORE_WORK_ACTIVITY_DEFINITION_PROCESS_TYPE_QUALIFIER Enum No
Revised Complete Date Revised scheduled completion date for the activity. CORE_WORK_ACTIVITY_DEFINITION_REVISED_COMPLETE_DATE Date No
Scheduled Complete Date Scheduled completion date for the activity. CORE_WORK_ACTIVITY_DEFINITION_SCHEDULED_COMPLETE_DATE Date No
Scheduled Start Date Scheduled start date for the activity. CORE_WORK_ACTIVITY_DEFINITION_SCHEDULED_START_DATE Date No
User Defined Field 4 User defined field 4 for this activity CORE_WORK_ACTIVITY_DEFINITION_USER_FIELD4 String No
Version Version of the activity. CORE_WORK_ACTIVITY_DEFINITION_VERSION String No
Activity Data Access Type Data access type associated with this activity. CORE_WORK_ACTIVITY_DEFINITION_ACTIVITY_DATA_ACCESS_TYPE String No
Activity Description Description of the activity. CORE_WORK_ACTIVITY_DEFINITION_DESCRIPTION String No
Activity Header Name Name of the header activity for this activity. CORE_WORK_ACTIVITY_DEFINITION_HEADER_QUALIFIER String No
Activity ID Unique identifier for an activity CORE_WORK_ACTIVITY_DEFINITION_ID String No
Activity Name Name of the activity. CORE_WORK_ACTIVITY_DEFINITION_NAME String No
Activity Name (Path) Fully qualified name of an activity. All parent activities will be listed. For example: /100/200/300/400. CORE_WORK_ACTIVITY_DEFINITION_COMBINED_NAME String No
Activity Result Template Name of the result template associated with this activity. CORE_WORK_ACTIVITY_DEFINITION_RESULT_TEMPLATE_QUALIFIER String No
Activity Search Name Searchable string for the activity. CORE_WORK_ACTIVITY_DEFINITION_SEARCH_NAME String No
Activity Type Type of the activity. Either Direct or Indirect. CORE_WORK_ACTIVITY_DEFINITION_HEADER_ACTIVITY_TYPE_QUALIFIER Enum No
Actual Complete Date Actual completion date for the activity. CORE_WORK_ACTIVITY_DEFINITION_ACTUAL_COMPLETE_DATE Date No
Auto Move Multiplier Amount by which the quantity will be multiplied when auto move is enabled. CORE_WORK_ACTIVITY_DEFINITION_AUTO_MOVE_MULTI_QUANTITY Number No
Completion Status Completion status of the activity. Either Incomplete, Complete, or Cancelled CORE_WORK_ACTIVITY_DEFINITION_COMPLETE_STATUS_QUALIFIER Enum No
Held Status Held status history. Either Never Held or Released, On Hold, or Released. CORE_WORK_ACTIVITY_DEFINITION_HELD_HISTORY Enum No
Labor Hours Allocation Type Either Even, All, Zero, or Complete CORE_WORK_ACTIVITY_DEFINITION_LABOR_HOURS_ALLOCATION_TYPE_QUALIFIER Enum No
Maximum Completion Hours Maximum completion hours for this activity. CORE_WORK_ACTIVITY_DEFINITION_MAX_COMPLETE_HOURS Number No
Maximum Hours Number of seconds that specifies the maximum duration of the activity. CORE_WORK_ACTIVITY_DEFINITION_MAX_DURATION_AMOUNT Number No
Minimum Completion Hours Minimum completion hours for this activity. CORE_WORK_ACTIVITY_DEFINITION_MIN_COMPLETE_HOURS Number No
Minimum Hours Number of seconds that specifies the minimum duration of the activity. CORE_WORK_ACTIVITY_DEFINITION_MIN_DURATION_AMOUNT Number No
Moved Quantity Moved quantity for this activity. CORE_WORK_ACTIVITY_DEFINITION_MOVED_QUANTITY Number No
Moved To Rework Quantity Number of items that were moved to reworked. CORE_WORK_ACTIVITY_DEFINITION_MOVED_TO_REWORK_QUANTITY Number No
Received Quantity Received quantity for this activity. CORE_WORK_ACTIVITY_DEFINITION_RECEIVED_QUANTITY Number No
Required Quantity Required quantity for this activity. CORE_WORK_ACTIVITY_DEFINITION_REQUIRED_QUANTITY Number No
Revised Start Date Revised scheduled start date for the activity. CORE_WORK_ACTIVITY_DEFINITION_REVISED_START_DATE Date No
Scrapped Quantity Scrapped quantity for this activity. CORE_WORK_ACTIVITY_DEFINITION_SCRAPPED_QUANTITY Number No
Sequence Number Sequence number for this activity. CORE_WORK_ACTIVITY_DEFINITION_SEQUENCE Number No
Sequence Validation Type Either Standard Sequence Validation or Run Sequence Validation. CORE_WORK_ACTIVITY_DEFINITION_HEADER_SEQUENCE_VALIDATION_TYPE_QUALIFIER Enum No
Standard Hours Standard hours for this activity. CORE_WORK_ACTIVITY_DEFINITION_STANDARD_HOURS Number No
Standard Quantity Standard quantity for this activity. CORE_WORK_ACTIVITY_DEFINITION_STANDARD_QUANTITY Number No
Standard Seconds Standard seconds for this activity. CORE_WORK_ACTIVITY_DEFINITION_STANDARD_SECONDS Number No
User Defined Field 1 User defined field 1 for this activity CORE_WORK_ACTIVITY_DEFINITION_USER_FIELD1 String No
User Defined Field 3 User defined field 3 for this activity CORE_WORK_ACTIVITY_DEFINITION_USER_FIELD3 String No
Work Week Apply Date The 9/80 Work Week apply date and time for totals as established by the overtime rule CORE_WORK_ACTIVITY_DEFINITION_WORK_WEEK_APPLY_DATE DateTime No

Related Entities

No related entities

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many