BATCH_APPEAL_GRIEV_INFO
Description:
Contains appeals & grievance information for a batch.

Primary Key
Column Name Ordinal Position
BATCH_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 BATCH_ID NUMERIC No
The unique identifier (.1 item) for the batch 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 PAT_ID VARCHAR No
The member the appeal/grievance relates to.
4 COVERAGE_ID NUMERIC No
The coverage the appeal/grievance relates to.
5 APPEAL_GRV_TYPE_C_NAME NUMERIC No
The type of request/issue.
May contain organization-specific values: No
Category Entries:
Appeal
Grievance
Dismissal Review
6 AG_REVIEW_TYPE_C_NAME NUMERIC No
How the review for the appeal/grievance is conducted.
May contain organization-specific values: No
Category Entries:
Internal
External
7 APPEAL_SUBJECT_TYPE_C_NAME NUMERIC No
The type of thing that is being appealed.
May contain organization-specific values: No
Category Entries:
Authorization
Claim
8 SUBJECT_NOT_IN_SYSTEM_YN VARCHAR No
If the thing that is the subject of the appeal/grievance is not documented as a record in Epic.
May contain organization-specific values: No
Category Entries:
No
Yes