|
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. |
|
|