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 NUMERIC No
This column stores the unique identifier for the service area associated with the hospital billing transaction on the hospital account.
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.