APPEAL_GRV_STEP_COMPLETE

Description: |
This table contains information about when workflow steps were completed for a given appeal or grievance.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
APPEAL_GRV_ID | 1 |
LINE | 2 |

Column Information

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