STMT_ETR_DETAIL
Description:
This table stores information about Professional Billing transactions that are associated with a given statement.

Primary Key
Column Name Ordinal Position
PRINT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PRINT_ID NUMERIC No
The unique identifier (.1 item) for the statement print or detail bill 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 TX_ID NUMERIC No
The Professional Billing transaction ID.
4 PAT_ID VARCHAR No
The patient ID for the transaction.
5 COVERAGE_ID NUMERIC No
The coverage ID for the transaction.
6 PAYER_ID_PAYOR_NAME VARCHAR No
The name of the payor.
7 IS_ASSIGNED_TO_PAYER_YN VARCHAR No
Indicates whether or not the transaction is assigned to a payer.
May contain organization-specific values: No
Category Entries:
Yes
No
8 POST_DATE DATETIME No
The transaction post date.
9 SERVICE_DATE DATETIME No
The transaction service date.
10 DESCRIPTION VARCHAR No
The transaction description.
11 UNIT NUMERIC No
The transaction units.
12 AMT_DUE NUMERIC No
The transaction due amount.
13 DEBIT_ORIG_AMT NUMERIC No
The Professional Billing debit original amount.
14 CREDIT_ORIG_AMT NUMERIC No
The Professional Billing credit original amount.
15 DEBIT_HOLD_AMT NUMERIC No
The Professional Billing debit hold amount.
16 CREDIT_HOLD_AMT NUMERIC No
The Professional Billing credit hold amount.
17 ADJ_AMT NUMERIC No
The Professional Billing adjustment amount.
18 MATCH_TX_INS_PMT_AMT NUMERIC No
The Professional Billing matching transaction insurance payment amount.
19 MATCH_TX_PAT_PMT_AMT NUMERIC No
The Professional Billing matching transaction patient payment amount.
20 MATCH_TX_ADJ_AMT NUMERIC No
The Professional Billing matching transaction adjustment amount.
21 NOTES VARCHAR No
The Professional Billing notes.
22 HOLD_STATUS_C_NAME VARCHAR No
The Professional Billing hold status.
May contain organization-specific values: Yes
Category Entries:
Hold Entire Charge
Do Not Hold
Hold Insurance
Inform Only
Hold Assigned
Hold Ins-Recalc Original Charge
23 IS_NEW_TX_YN VARCHAR No
Indicates whether or not this is a new transaction.
May contain organization-specific values: No
Category Entries:
No
Yes
24 INS_AMT NUMERIC No
Insurance balance of a debit transaction.
25 PAT_AMT NUMERIC No
Patient amount of a debit transaction.
26 HSP_ACCOUNT_ID NUMERIC No
The hospital account ID for this professional transaction.
27 PURCHASE_SVC_AMT NUMERIC No
The purchased service amount.
28 PURCHASE_SVC_POS INTEGER No
The purchased service place of service name.