|
Name |
Type |
Discontinued? |
|
1 |
APPEAL_GRV_ID |
NUMERIC |
No |
|
|
|
The unique identifier (.1 item) for the appeal/grievance 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 |
APPEAL_GRV_WKFL_STEP_C_NAME |
VARCHAR |
No |
|
|
|
The category ID of the workflow step that was completed. |
May contain organization-specific values: No |
Category Entries: |
Intake (Tapestry Link) |
Intake |
Submission |
Initial Review |
MD Review |
External Decision |
Finalize |
Completed |
|
|
4 |
COMPLETED_USER_ID |
VARCHAR |
No |
|
|
|
The unique ID of the user that completed the workflow step. If this workflow step was queued for completion and later auto-completed, this is the user that queued the completion. |
|
|
5 |
COMPLETED_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
6 |
COMPLETED_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
When the workflow step was completed (in UTC). If this workflow step was queued for completion and later auto-completed, this is when the user queued the completion. |
|
|
7 |
COMPLETED_LOCAL_DTTM |
DATETIME (Attached) |
No |
|
|
|
When the workflow step was completed (in local time). If this workflow step was queued for completion and later auto-completed, this is when the user queued the completion. Stored in the time zone determined by column APPEAL_GRV.TAT_RPT_TIME_ZONE_C. |
|
|