ORD_PROV_AUD_TRLS

Description:

This table stores the authorizing provider audit trail for orders.

Primary Key

Column Name	Ordinal Position
ORDER_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ORDER_ID	NUMERIC	No
	The unique identifier for the order record.
2	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3	PROV_AUDIT_USER_ID	VARCHAR	No
	The unique user ID of the authorizing provider from the audit trail.
4	PROV_AUDIT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
5	PROV_AUDIT_INSTANT	DATETIME (Local)	No
	The instant that the associated authorizing provider was recorded in the order record.
6	PROV_AUDIT_SER_ID	VARCHAR	No
	The provider ID of the authorizing provider from the audit trail.
7	PROV_AUDIT_POOL_ID	NUMERIC	No
	The unique identifier for registry record representing the group of users who are responsible for a cosignature requirement on the order record.
8	PROV_AUDIT_POOL_ID_REGISTRY_NAME	VARCHAR	No
	The name of the In Basket registry in the HIP master file.
9	PROV_AUDIT_TYPE_C_NAME	VARCHAR	No
	The type of provider from the audit trail. May contain organization-specific values: No Category Entries: Authorizing Provider Ordering Provider Supervising Provider
10	PROV_AUDIT_ACTION_C_NAME	VARCHAR	No
	The action from the audit trail. May contain organization-specific values: No Category Entries: Discontinue Attending Assigned Manual Correction Order Signed Order Pended Update On Transfer