SPEC_WORKFLOW_STEP_HX

Description:

This table contains information about the workflow step history of a specimen.

Primary Key

Column Name	Ordinal Position
SPECIMEN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	SPECIMEN_ID	VARCHAR	No
	The unique identifier (.1 item) for the specimen record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	CM_PHY_OWNER_ID	VARCHAR	No
	The Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
4	TEST_ID	VARCHAR	No
	The unique ID of the test which was performed with this workflow step.
5	WORKFLOW_STEP_RECORD_ID	NUMERIC	No
	The unique ID of the workflow step.
6	WORKFLOW_STEP_RECORD_ID_RECORD_NAME	VARCHAR	No
	The name of the node record.
7	WORKFLOW_STEP_TYPE_RECORD_ID	VARCHAR	No
	The unique ID of the event type corresponding to the workflow step.
8	WORKFLOW_STEP_TYPE_RECORD_ID_RECORD_NAME	VARCHAR	No
	The name of the event template.
9	COMPLETE_UTC_DTTM	DATETIME (UTC)	No
	The date and time at which the workflow step action occurred.
10	COMPLETE_USER_ID	VARCHAR	No
	The unique ID of the user responsible for the workflow step action.
11	COMPLETE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
12	WORKFLOW_STEP_RESULT_ID	VARCHAR	No
	The unique ID of the result snapshot taken when the user completed the workflow step.
13	WORKFLOW_STEP_ACTION_C_NAME	VARCHAR	No
	Stores the workflow step action May contain organization-specific values: No Category Entries: Completed Added Overridden Changed Replaced
14	WORKFLOW_STEP_EVENT_RECORD_ID	VARCHAR	No
	Stores the event associated with the workflow step action
15	WORKFLOW_STEP_EVENT_RECORD_ID_RECORD_NAME	VARCHAR	No
	The name of the event template.