|
Name |
Type |
Discontinued? |
|
| 1 |
FIN_ASST_TRACKER_ID |
NUMERIC |
No |
|
|
|
| The unique identifier for the decision record. |
|
|
| 2 |
RECORD_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
| The record status category ID for the decision. |
| May contain organization-specific values: No |
| Category Entries: |
| Soft Deleted |
| Hidden |
| Hidden and Soft Deleted |
|
|
| 3 |
FIN_ASST_PROGRAM_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the financial assistance program for the decision. |
|
|
| 4 |
FIN_ASST_PROGRAM_ID_PROGRAM_NAME |
VARCHAR |
No |
|
|
|
| The name of the financial assistance program record. |
|
|
| 5 |
FIN_ASST_CASE_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the financial assistance case associated with the decision. |
|
|
| 6 |
STATUS_C_NAME |
VARCHAR |
No |
|
|
|
| The status category ID for the decision. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Pending |
| Approved |
| Denied |
| Waiting for supervisor's approval |
| Pending Appeal |
| Overturned |
| Inactive |
| Entered in Error |
| Signed |
| Needs Review |
|
|
| 7 |
START_DATE |
DATETIME |
No |
|
|
|
| The date when the decision was approved. |
|
|
| 8 |
END_DATE |
DATETIME |
No |
|
|
|
| The end date for the decision. |
|
|
| 9 |
DECISION_VALID_C_NAME |
VARCHAR |
No |
|
|
|
| The validity type category ID for the decision. |
| May contain organization-specific values: No |
| Category Entries: |
| Fixed-term |
| Continuous |
| None |
|
|
| 10 |
DECISION_NOTE_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the note for the decision. |
|
|
| 11 |
REC_CREATION_DATE |
DATETIME |
No |
|
|
|
| The date when the decision was created. |
|
|
| 12 |
INST_OF_UPDATE_1_DTTM |
DATETIME (Local) |
No |
|
|
|
| Stores the instant the record was last locked/unlocked. |
|
|
| 13 |
DECISION_NEGATIVE_YN |
VARCHAR |
No |
|
|
|
| Indicates whether the decision tracker is negative, which denies application for support. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 14 |
PARENT_TRACKER_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the service decision a related decision is linked to. |
|
|
| 15 |
RESPONSIBLE_USER_ID |
VARCHAR |
No |
|
|
|
| The unique ID for the responsible user for the decision. |
|
|
| 16 |
RESPONSIBLE_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 17 |
DECISION_DEPARTMENT_ID_EXTERNAL_NAME |
VARCHAR |
No |
|
|
|
| The external name of the department record. This is often used in patient correspondence such as reminder letters. |
|
|
| 18 |
DECISION_COST_CENTER |
VARCHAR |
No |
|
|
|
| The cost center string generated for the decision. |
|
|
| 19 |
REG_ENCOUNTER_CSN_ID |
NUMERIC |
No |
|
|
|
| The unique contact serial number of the special encounter that stores registration information related to the service decision. |
|
|