DTX_ALL
Description:
This table contains information common across all detail transaction (DTX) records in the system for filtering purposes.

Primary Key
Column Name Ordinal Position
TX_ID 1

Column Information
Name Type Discontinued?
1 TX_ID NUMERIC No
The unique identifier for the transaction record.
2 TX_TYPE_C_NAME VARCHAR No
The type of the transaction.
May contain organization-specific values: No
Category Entries:
Incoming Receipt
PCP Capitation
Specialty Capitation
AP Claims Adjustment
Withhold Adjustment
General Adjustment
Other Reimbursement
PCP Capitation Adjustment
Specialty Capitation Adjustment
Employer Group Reimbursement
3 TX_STATUS_C_NAME VARCHAR No
The status of the transaction.
May contain organization-specific values: No
Category Entries:
Loaded
Reconciled
Calculated
AP Batched
Paid
Void
New
Fully Invoiced