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