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.