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


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 Level	Activity level for this activity.	CORE_WORK_ACTIVITY_DEFINITION_LEVEL	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
Actual Start Date	Actual start date for this activity.	CORE_WORK_ACTIVITY_DEFINITION_ACTUAL_START_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
Completed Percentage	Percentage of the activity that has been completed.	CORE_WORK_ACTIVITY_DEFINITION_COMPLETED_PERCENT	Number	No
Completed Quantity	Completed quantity so far for this activity.	CORE_WORK_ACTIVITY_DEFINITION_COMPLETED_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
Labor Quantity Allocation Type	Either Even, All, Zero, or Quantity Complete	CORE_WORK_ACTIVITY_DEFINITION_LABOR_QUANTITY_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
Parent Activity Name	Name of the parent activity.	CORE_WORK_ACTIVITY_DEFINITION_PARENT_QUALIFIER	String	No
Priority Type	Priority type for this activity. Either High, Medium, Low, or Urgent.	CORE_WORK_ACTIVITY_DEFINITION_PRIORITY_TYPE_QUALIFIER	Enum	No
Process Type	Process type for this activity. Either None, Setup or Run	CORE_WORK_ACTIVITY_DEFINITION_PROCESS_TYPE_QUALIFIER	Enum	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 Complete Date	Revised scheduled completion date for the activity.	CORE_WORK_ACTIVITY_DEFINITION_REVISED_COMPLETE_DATE	Date	No
Revised Start Date	Revised scheduled start date for the activity.	CORE_WORK_ACTIVITY_DEFINITION_REVISED_START_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
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
Unaccounted Quantity	Quantity due to unaccounted activity.	CORE_WORK_ACTIVITY_DEFINITION_UNACCOUNTED_QUANTITY	Number	No
User Defined Field 1	User defined field 1 for this activity	CORE_WORK_ACTIVITY_DEFINITION_USER_FIELD1	String	No
User Defined Field 2	User defined field 2 for this activity	CORE_WORK_ACTIVITY_DEFINITION_USER_FIELD2	String	No
User Defined Field 3	User defined field 3 for this activity	CORE_WORK_ACTIVITY_DEFINITION_USER_FIELD3	String	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
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

No related entities

Core Entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category	Activity	Work Unit	Work Group	Procedure Code

Relationship