APPEAL_GRV_SUBJECT_RESULT
Description:
This table contains information about the subject and result of an appeal.

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 SUBJECT_CLAIM_ID NUMERIC No
The unique ID of the claim that is under appeal.
4 RESULT_CLAIM_ID NUMERIC No
The unique ID of the claim created as a result of the appeal to effectuate the appeal decision.
5 APPEAL_DECISION_C_NAME VARCHAR No
The appeal decision category ID for the appeal/grievance subject.
May contain organization-specific values: No
Category Entries:
Upheld
Overturned
Partially Overturned
Dismissed
Closed
Upheld Dismissal
Vacated Dismissal
6 RESULT_FREE_TEXT VARCHAR No
Stores a free text result ID for an appeal or grievance.
7 SUBJECT_FREE_TEXT VARCHAR No
The name or ID of an appeal or grievance subject that does not correspond to a record that is in the system.
8 IND_EFFEC_INST_UTC_DTTM DATETIME (UTC) No
The instant that the appeal decision was effectuated. For claim appeals, this is the date/time the result claim was paid in UTC. This is only populated if the subject claim required effectuation based on the decision. If the subject claim is external, then this will be filled out manually during the appeal workflow. Otherwise the system will calculate it automatically.
9 IND_EFFEC_INST_LOCAL_DTTM DATETIME (Attached) No
The instant that the appeal decision was effectuated. For claim appeals, this is the date/time the result claim was paid, in local time based on time zone of the appeal/grievance. This is only populated if the subject claim required effectuation based on the decision. If the subject claim is external, then this will be filled out manually during the appeal workflow. Otherwise the system will calculate it automatically.