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