PB_DTL_TX_2
Description:
The PB_DTL_TX_2 table contains the detailed transactions associated with a billing account transaction.

Primary Key
Column Name Ordinal Position
PB_TX_ID 1

Column Information
Name Type Discontinued?
1 PB_TX_ID VARCHAR No
The unique identifier (.1 item) for the detail transaction record.
2 INV_CLM_TYPE_C_NAME VARCHAR No
Specify the source claim type associated with the detailed transaction.
May contain organization-specific values: Yes
Category Entries:
Unspecified Claim
Medical Claim
Pharmacy Claim
Dental Claim
Vision Claim
All
3 CLAIM_NUMBER VARCHAR No
Specify the identifier of the source claim associated with the detailed transaction.
4 SOURCE_CLAIM_ID NUMERIC No
Specify the claim from which this transaction originates.
5 SERVICE_DATE DATETIME No
Specify the service date of the source claim associated with the detailed transaction.
6 SELECTIVE_PLAN_GRP_ID VARCHAR No
Used to find outstanding detail transactions that aren't batched quickly. Used in places such as payment computing.
7 SELECTIVE_PLAN_GRP_ID_PLAN_GRP_NAME VARCHAR No
The name of the employer group record
8 CLAIM_PAYEE_C_NAME VARCHAR No
Specify the recipient type of the associated claim.
May contain organization-specific values: No
Category Entries:
Subscriber
Vendor
Member
Third Party
9 VENDOR_ID_VENDOR_NAME VARCHAR No
The name of the vendor.
10 THIRD_PARTY_VENDOR_ID_VENDOR_NAME VARCHAR No
The name of the vendor.
11 ASSOCIATED_REFUND_DTX_ID NUMERIC No
Specify the associated vendor refund transaction (DTX).
12 BALANCE_OFFSET_TRANSACTION_ID VARCHAR No
Specify that it offsets a balance carried by another PDX.
13 REALIZED_RCVRY_TRANSACTION_ID VARCHAR No
Points to the realized recovery transaction (PDX).
14 PREPAY_OFFSET_TRANSACTION_ID VARCHAR No
This item appears on the refund prepayment recovery transaction (PDX) and points to the realized recovery transaction (PDX) created when the vendor refund or recoupment is posted.
15 ASSOCIATED_VENDOR_CHECK_ID NUMERIC No
Specify the associated vendor check (APC) of the recoupment transaction (PDX).