STMT_CONS_SP_ACCT_DETAIL
Description:
This table contains information about insourced hospital accounts 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 stmt/det 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 CONS_SP_HAR_PREV_PAT_BAL NUMERIC No
This stores the patient balance as of the last statement for a received self-pay hospital account.
4 CONS_SP_HAR_NEW_CHG_AMT NUMERIC No
Stores the amount of new charges on a received self-pay account for this statement.
5 CONS_SP_HAR_NEW_PMT_AMT NUMERIC No
Stores the amount of new payments on a received self-pay account for this statement.
6 CONS_SP_HAR_NEW_ADJ_AMT NUMERIC No
Stores the amount of new adjustments on a received self-pay account for this statement.
7 CONS_SP_HAR_NEW_INS_PMT_AMT NUMERIC No
Stores the amount of new insurance payments on a received self-pay account for this statement.
8 CONS_SP_HAR_NEW_INS_ADJ_AMT NUMERIC No
Stores the amount of new insurance adjustments on a received self-pay account for this statement.
9 CONS_SP_HAR_NEW_PAT_PMT_AMT NUMERIC No
Stores the amount of new patient payments on a received self-pay account for this statement.
10 CONS_SP_HAR_NEW_PAT_ADJ_AMT NUMERIC No
Stores the amount of new patient adjustments on a received self-pay account for this statement.
11 CONS_SP_HAR_TOT_CHG_AMT NUMERIC No
Stores the total charges for a received self-pay account.
12 CONS_SP_HAR_TOT_PMT_AMT NUMERIC No
Stores the total payments for a received self-pay account.
13 CONS_SP_HAR_TOT_ADJ_AMT NUMERIC No
Stores the total adjustments for a received self-pay account.
14 CONS_SP_HAR_TOT_INS_PMT_AMT NUMERIC No
Stores the total insurance payments for a received self-pay account.
15 CONS_SP_HAR_TOT_INS_ADJ_AMT NUMERIC No
Stores the total insurance adjustments for a received self-pay account.
16 CONS_SP_HAR_TOT_PAT_PMT_AMT NUMERIC No
Stores the total patient payments for a received self-pay account.
17 CONS_SP_HAR_TOT_PAT_ADJ_AMT NUMERIC No
Stores the total patient adjustments for a received self-pay account.
18 CONS_SP_HAR_CURR_PAT_BAL NUMERIC No
Stores the current balance for a received self-pay account.
19 CONS_SP_HAR_CURR_DUE NUMERIC No
Stores the current amount due for a received self-pay account.
20 CONS_SP_HAR_PREV_INS_BAL NUMERIC No
This stores the insurance balance as of the last statement for a received self-pay hospital account.
21 CONS_SP_HAR_CURR_INS_BAL NUMERIC No
This stores the insurance balance of the current statement for a received self-pay hospital account.
22 CONS_SP_HAR_NEW_PAT_DISCNT_ADJ NUMERIC No
This stores the new patient discounts for the current statement for a received self-pay hospital account.
23 CONS_SP_HAR_TOT_PAT_DISCNT_ADJ NUMERIC No
This stores the total patient discounts for the current statement for a received self-pay hospital account.