GUAR_PMT_SCORE_HB_HX
Description:
This table contains HB Guarantor Payment Score history items.

Primary Key
Column Name Ordinal Position
ACCOUNT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ACCOUNT_ID NUMERIC No
This column stores the unique identifier 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 SCORE_DATE DATETIME No
This item will store the date of the score.
4 SCORE INTEGER No
This history item will store the self-pay score.
5 AVG_SP_LEVEL_C_NAME VARCHAR No
This history item will store the average self-pay level for the score.
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
6 UNCOLL_BALANCE_YN VARCHAR No
This history item will store if there has been any uncollectable balance.
May contain organization-specific values: No
Category Entries:
No
Yes
7 ONLINE_PMT_YN VARCHAR No
This history item will store if a payment through MyChart or another electronic portal was used for scoring.
The category values for this column were already listed for column: UNCOLL_BALANCE_YN