STMT_CONS_SP_DETAIL

Description: |
This table contains information about insourced balances on your statement print and detail bill records.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PRINT_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PRINT_ID | NUMERIC | No |
The unique identifier (.1 item) for the stmt/det bill record.
2 | CONS_SP_PREV_PAT_BAL | NUMERIC | No |
Stores the total previous patient balance for all received self-pay accounts on the statement.
3 | CONS_SP_PREV_AMT_DUE | NUMERIC | No |
Stores the total previous amount due for all received self-pay accounts on the statement.
4 | CONS_SP_NEW_CHG_AMT | NUMERIC | No |
Stores the total new charges for all received self-pay accounts on the statement.
5 | CONS_SP_NEW_PMT_AMT | NUMERIC | No |
Stores the total new payments for all received self-pay accounts on the statement.
6 | CONS_SP_NEW_ADJ_AMT | NUMERIC | No |
Stores the total new adjustments for all received self-pay accounts on the statement.
7 | CONS_SP_NEW_INS_PMTS | NUMERIC | No |
Stores the new insurance payments for all received self-pay accounts on the statement.
8 | CONS_SP_NEW_INS_ADJS | NUMERIC | No |
Stores the new insurance adjustments for all received self-pay accounts on the statement.
9 | CONS_SP_NEW_PAT_PMTS | NUMERIC | No |
Stores the new patient payments for all received self-pay accounts on the statement.
10 | CONS_SP_NEW_PAT_ADJS | NUMERIC | No |
Stores the new patient adjustments for all received self-pay accounts on the statement.
11 | CONS_SP_TOT_CHG_AMT | NUMERIC | No |
Stores the total charges for all received self-pay accounts on the statement.
12 | CONS_SP_TOT_PMT_AMT | NUMERIC | No |
Stores the total payments for all received self-pay accounts on the statement.
13 | CONS_SP_TOT_ADJ_AMT | NUMERIC | No |
Stores the total adjustments for all received self-pay accounts on the statement.
14 | CONS_SP_CURR_PAT_BAL | NUMERIC | No |
Stores the current patient balance for all received self-pay accounts on the statement.
15 | CONS_SP_CURR_DUE_AMT | NUMERIC | No |
Stores the current amount due for all received self-pay accounts on the statement.
16 | CONS_SP_PREV_INS_BAL | NUMERIC | No |
Stores the previous insurance balance for all received self-pay accounts on the statement.
17 | CONS_SP_CURR_INS_BAL | NUMERIC | No |
Stores the current insurance balance for all received self-pay accounts on the statement.