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.