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.