ACCOUNT_CONS_SP_SA_BILL

Description: |
Applies only if you have enabled the consolidated balances functionality. Contains information about the guarantors and their balances that are sent to a different service area for billing to the guarantor.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ACCT_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ACCT_ID | NUMERIC | No |
The unique identifier (.1 item) for the account record.
2 | PB_CONS_SP_TOT_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total PB balance of the hospital accounts sent to a different service area for billing to the guarantor.
3 | PB_CONS_SP_PAT_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total PB self-pay balance of the hospital accounts sent to a different service area for billing to the guarantor.
4 | PB_CONS_SP_INS_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total PB insurance balance of the hospital accounts sent to a different service area for billing to the guarantor.
5 | PB_CONS_SP_CONTEST_PAT_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total PB contested self-pay balance of the hospital accounts sent to a different service area for billing to the guarantor.
6 | PB_CONS_SP_EXT_BD_PAT_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total PB external AR bad debt self-pay balance of the hospital accounts sent to a different service area for billing to the guarantor.
7 | PB_CONS_SP_EXT_BD_INS_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total PB external AR bad debt insurance balance of the hospital accounts sent to a different service area for billing to the guarantor.
8 | PB_CONS_SP_CONT_EXT_AR_PAT_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total PB contested external AR balance of the hospital accounts sent to a different service area for billing to the guarantor.
9 | PB_CONS_SP_EXT_AR_PAT_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total PB external AR self-pay balance of the hospital accounts sent to a different service area for billing to the guarantor.
10 | PB_CONS_SP_EXT_AR_INS_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total PB external AR insurance balance of the hospital accounts sent to a different service area for billing to the guarantor.
11 | PB_CONS_SP_UNDIST_INS_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total PB undistributed insurance credits sent to a different service area for billing to the guarantor.
12 | PB_CONS_SP_UNDIST_PAT_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total PB undistributed self-pay credits sent to a different service area for billing to the guarantor.
13 | CONS_SP_ACCT_ID | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The target guarantor in the target service area to whom the balances are sent for billing.
14 | HB_CONS_SP_TOT_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total HB balance of the hospital accounts sent to a different service area for billing to the guarantor.
15 | HB_CONS_SP_PREBILL_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total HB prebilled balance of the hospital accounts sent to a different service area for billing to the guarantor.
16 | HB_CONS_SP_INS_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total HB insurance balance of the hospital accounts sent to a different service area for billing to the guarantor.
17 | HB_CONS_SP_PAT_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total HB self-pay balance of the hospital accounts sent to a different service area for billing to the guarantor.
18 | HB_CONS_SP_UNDIST_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total HB undistributed balance of the hospital accounts sent to a different service area for billing to the guarantor.
19 | HB_CONS_SP_BAD_DEBT_PAT_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total HB bad debt self-pay balance of the hospital accounts sent to a different service area for billing to the guarantor.
20 | HB_CONS_SP_BAD_DEBT_INS_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total HB bad debt insurance balance of the hospital accounts sent to a different service area for billing to the guarantor.
21 | HB_CONS_SP_BAD_DEBT_UNDIST_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total HB bad debt undistributed balance of the hospital accounts sent to a different service area for billing to the guarantor.
22 | HB_CONS_SP_EXT_AR_INS_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total HB external AR insurance balance of the hospital accounts sent to a different service area for billing to the guarantor.
23 | HB_CONS_SP_EXT_AR_PAT_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total HB external AR self-pay balance of the hospital accounts sent to a different service area for billing to the guarantor.
24 | HB_CONS_SP_EXT_AR_UNDIST_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The total HB external AR undistributed balance of the hospital accounts sent to a different service area for billing to the guarantor.
25 | HB_CONS_SP_IN_PROG_PAT_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The HB self-pay balance of in progress accounts for the guarantor that are sent to a different service area, excluding hospital accounts in external AR or bad debt. In progress accounts are those that have not yet been billed to self-pay.
26 | HB_CONS_SP_IN_PROG_BD_PAT_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The HB self-pay balance of in progress bad debt accounts for the guarantor that are sent to a different service area. In progress accounts are those that have not yet been billed to self-pay.
27 | HB_CONS_SP_INPROG_EXTAR_PATBAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The HB self-pay balance of in progress external AR accounts for the guarantor that are sent to a different service area. In progress accounts are those that have not yet been billed to self-pay.
28 | HB_CONS_SP_CONTEST_PAT_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The HB self-pay balance of contested accounts for the guarantor that are sent to a different service area, excluding hospital accounts in external AR or bad debt.
29 | HB_CONS_SP_CONTEST_BD_PAT_BAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The HB bad debt self-pay balance of contested accounts for the guarantor that are sent to a different service area.
30 | HB_CONS_SP_CONTST_EXTAR_PATBAL | NUMERIC | No |
Applies only if you have enabled the consolidated balances functionality. The HB External AR self-pay balance of contested accounts for the guarantor that are sent to a different service area.