HSP_TX_LINE_INFO

Description: |
This table contains Line level transactions information from Hospital Permanent Transactions (HTR).

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TX_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
This column stores the unique identifier for the hospital billing transaction.
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 | HSP_ACCOUNT_ID | NUMERIC | No |
This column stores the unique identifier for the hospital account.
4 | POST_DATE | DATETIME | No |
The post date for the transaction on the hospital account.
5 | SERV_AREA_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
6 | LL_REV_CODE_ID | NUMERIC | No |
This column stores the line-level revenue code for the hospital billing transaction on the hospital account.
7 | LL_REV_CODE_ID_REVENUE_CODE_NAME | VARCHAR | No |
The name of the revenue code.
8 | LL_CPT_CODE | VARCHAR | No |
This column stores the line-level CPT code for the hospital billing transaction on the hospital account.
9 | LL_MODIFIER | VARCHAR | No |
This column stores the line-level modifier info for the hospital billing transaction on the hospital account.
10 | LL_SERVICE_DATE | DATETIME | No |
This column stores the line-level service date for the hospital billing transaction on the hospital account.
11 | LL_BILLED_AMT | NUMERIC | No |
This column stores the line-level billed amount for the hospital billing transaction on the hospital account.
12 | LL_ALLOWED_AMT | NUMERIC | No |
This column stores the line-level allowed amount for the hospital billing transaction on the hospital account.
13 | LL_NOT_ALLOWED_AMT | NUMERIC | No |
This column stores the line-level not-allowed amount for the hospital billing transaction on the hospital account.
14 | LL_DED_AMT | NUMERIC | No |
This column stores the line-level deductible amount for the hospital billing transaction on the hospital account.
15 | LL_COINS_AMT | NUMERIC | No |
This column stores the line-level coinsurance amount for the hospital billing transaction on the hospital account.
16 | LL_COPAY_AMT | NUMERIC | No |
This column stores the line-level copay amount for the hospital billing transaction on the hospital account.
17 | LL_NON_COVERED_AMT | NUMERIC | No |
This column stores the line-level non-covered amount for the hospital billing transaction on the hospital account.
18 | LL_POSTED_AMT | NUMERIC | No |
This column stores the line-level posted amount for the hospital billing transaction on the hospital account.
19 | LL_ADJ_AMT | NUMERIC | No |
This column stores the line-level adjustment amount for the hospital billing transaction on the hospital account.
20 | LL_REASON_CODES | VARCHAR | No |
This column stores the line-level reason codes for the hospital billing transaction on the hospital account.
21 | LL_ACTIONS | VARCHAR | No |
This column stores the line-level action string for the hospital billing transaction on the hospital account.
22 | LL_CONTROL_NUMBER | VARCHAR | No |
This column stores the line-level control number for the hospital billing transaction on the hospital account.
23 | LL_QUANTITY | NUMERIC | No |
This column stores the line-level quantity from remittance payments.