|
Name |
Type |
Discontinued? |
|
1 |
FIN_ASST_CASE_ID |
NUMERIC |
No |
|
|
|
The unique identifier for the financial assistance case 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 |
UPDATE_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
The date and time (in UTC time zone) when an update was made. |
|
|
4 |
UPDATE_USER_ID |
VARCHAR |
No |
|
|
|
The unique ID of the user who made the update. |
|
|
5 |
UPDATE_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
6 |
UPDATE_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
The category ID of the financial assistance case status after an update was made. |
May contain organization-specific values: No |
Category Entries: |
In Progress |
Closed |
Waiting For Patient |
Decided |
Completed |
|
|
7 |
UPDATE_APPL_PROVD_DATE |
DATETIME |
No |
|
|
|
The application provided date on the financial assistance case after an update was made. |
|
|
8 |
UPDATE_APPL_SIGNED_DATE |
DATETIME |
No |
|
|
|
The application signed date on the financial assistance case after an update was made. |
|
|
9 |
UPDATE_CONTACT_ACCOUNT_ID |
NUMERIC |
No |
|
|
|
The unique ID of the primary contact (guarantor) of the financial assistance case after an update was made. |
|
|
10 |
UPDATE_NOTE_ID |
VARCHAR |
No |
|
|
|
Stores the unique ID of the note record that contains the comment entered as part of this row. This will only be populated if the user manually entered a comment for the financial assistance case. |
|
|
11 |
UPDATE_NOTE_SUMMARY |
VARCHAR |
No |
|
|
|
Stores a brief description of the changes made between this row and the last row. |
|
|