|
Name |
Type |
Discontinued? |
|
1 |
NOTE_ID |
VARCHAR |
No |
|
|
|
This column stores the unique identifier for the note record associated with a hospital account. |
|
|
2 |
HSP_ACCOUNT_ID |
NUMERIC |
No |
|
|
|
This column stores the unique identifier for the hospital account for which the account note was entered. |
|
|
3 |
NOTE_ENTRY_USER_ID |
VARCHAR |
No |
|
|
|
This column stores the unique identifier for the user who entered an account note associated with the hospital account. |
|
|
4 |
NOTE_ENTRY_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
5 |
NOTE_ENTRY_DT_TIME |
DATETIME (Local) |
No |
|
|
|
The date and time an account note was entered for a hospital account. |
|
|
6 |
BUCKET_ID |
NUMERIC |
No |
|
|
|
Hospital Liability Bucket linked to this note |
|
|
7 |
HNO_RECORD_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
Record type. |
May contain organization-specific values: No |
Category Entries: |
PB Guarantor Note |
PB Guarantor Letter |
PB Insurance Follow-up Letter |
PB Hospital Account Note |
PB Visit Account Letter |
CRM Letter |
CRM Envelope |
CRM Email |
HB Guarantor Note |
HB Hospital Account Note |
HB Guarantor Letter |
HB Hospital Account Letter |
HB Liability Bucket Letter |
HB Liability Bucket Note |
HB Contractual History Note |
EB Guarantor Note |
EB Appeal Letter |
EB Payer Policy |
Reg Financial Assistance Letter |
Reg Financial Assistance Tracker Note |
Reg Financial Assistance Case Note |
|
|
8 |
HAR_NOTE_ACCOUNT_ID |
NUMERIC |
No |
|
|
|
This column stores the unique identifier for the guarantor associated with the hospital account. It is only populated for hospital account-level notes. |
|
|