GUAR_PMT_SCORE_HX

Description: |
Contains information on the guarantor Payment History Score. Each line contains factors that contributed to the score for one billing system for one guarantor.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ACCOUNT_ID | NUMERIC | No |
The unique identifier (.1 item) for the guarantor 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 | LAST_CALCULATED_UTC_DTTM | DATETIME (UTC) | No |
The last instant at which this payment history score was updated.
4 | BILLING_SYSTEM_C_NAME | VARCHAR | No |
The billing system of the payment history score in this line.
May contain organization-specific values: No
Category Entries:
Professional Billing
Hospital Billing
Hospital & Professional Billing
External
5 | SCORE | INTEGER | No |
The payment history score for a guarantor based on their self-pay history (PB, HB or EB score).
6 | NUM_ACCTS | INTEGER | No |
Number of accounts used to calculate the guarantor's payment history score.
7 | NUM_BAD_DEBT_ACCTS | INTEGER | No |
The number of accounts sent to bad debt in the history range for the guarantor's payment history score.
8 | BAD_DEBT_BALANCE | NUMERIC | No |
The total balance sent to bad debt for this guarantor in the payment history score's history window.
9 | NUM_UNCOLL_ACCTS | INTEGER | No |
Number of accounts with uncollectable balance for the guarantor in the payment history score history window.
10 | UNCOLL_BALANCE | NUMERIC | No |
The total uncollectable balance for this guarantor in the payment history score history window.
11 | AVG_SP_LEVEL_C_NAME | VARCHAR | No |
The guarantor's average self-pay level in the PB payment history score history window.
May contain organization-specific values: No
Category Entries:
Level 1
Level 2
Level 3
Level 4
Level 5
Level 6
Level 7
Level 8
Level 9
Level 10
12 | MAX_SP_LEVEL_C_NAME | VARCHAR | No |
The highest self-pay level at account close (or bad debt outsource) for the guarantor in the payment history score history window.
The category values for this column were already listed for column: AVG_SP_LEVEL_C_NAME
13 | NUM_MISSED_PAYMENTS | INTEGER | No |
The number of missed payments by the guarantor in the payment history score history range.
14 | NUM_MISSED_PP_PAYMENTS | INTEGER | No |
The number of missed payment plan payments by the guarantor in the payment history score history window.
15 | HAS_PAID_ONLINE_YN | VARCHAR | No |
Whether the guarantor has paid online to this billing system in the payment history score history window.
May contain organization-specific values: No
Category Entries:
No
Yes
16 | LAST_CALCULATED_LOCAL_DTTM | DATETIME (Local) | No |
The last instant at which this payment history score was updated.