SPEC_CHG_TRGR_TRACE

Description:

This table contains trace information about a specimen's billing actions related to triggering a charge.

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	ORDER_ID	NUMERIC	No
	The unique ID of the order associated with the charge trace on the specimen.
5	TRACE_DTTM	DATETIME (Local)	No
	The date and time when the charge on the specimen was triggered.
6	USER_ID	VARCHAR	No
	The unique ID of the user whose action triggered the charge on the specimen.
7	USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	CHG_TRG_TRC_ACT_C_NAME	VARCHAR	No
	The charge trigger trace action category ID for the specimen. May contain organization-specific values: No Category Entries: Trigger Charge Send Void Message (All Charges) Send Void Message (Addl Billing) Update Order Update Specimen Create Charge Drop Charge Into Router Retrieve Primary PX Evaluate Trigger Context Evaluate Trigger Rule Evaluate Triggered Charges Retrieve Additional Charge Px Void Charge Update Charge Request Charge Trigger Process Charge Trigger
9	TRACE_COMMENT	VARCHAR	No
	The charge trigger trace comment entered by the system about the trigger action.
10	TEST_LINE	INTEGER	No
	The test line that the charge on the specimen is associated with.
11	RECORD_INFO	VARCHAR	No
	The trace information for a charge triggered on the specimen.