APPEAL_GRV_LETTER_GEN_HX
Description:
All successes, failures, and intermediate actions that occurred while generating letters.

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 CM_PHY_OWNER_ID VARCHAR No
The Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
4 HISTORY_KEY INTEGER No
GRP 5100 is sorted by occur instant, but if the TAG record is locked by a different process when we try to log an action, we will have to wait and try again later. This means that the occur instant may not exactly correlate the order in which certain lines were logged. This item keeps track of the technical order that actions were logged.
5 LETTER_HX_GUID VARCHAR No
The letter that caused this history action will have a matching GUID in I TAG 5020.
6 APPEAL_GRV_LETTER_ACT_C_NAME VARCHAR No
The action that occurred to cause this line to be logged.
May contain organization-specific values: No
Category Entries:
Letter Triggered
Recipient Verified
No Recipient
SmartText Resolved
Unresolved SmartText
PDF Created
Letter Queued for Batch Print
Letter Printed
Letter Canceled
Fax Queued
Fax Succeeded
Fax Failed
In Basket Message Sent
MyChart Message Sent
PDF Failed
MyChart Message Failed
In Basket Message Failed
Letter Resubmitted
No Delivery Method
Batch Print Request Failed
7 OCCUR_UTC_DTTM DATETIME (UTC) No
The instant that the action logged in I TAG 5103 occurred.
8 COMMITTING_USER_ID VARCHAR No
The logged in user of the process that caused this action to occur.
9 COMMITTING_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
10 LETTER_HX_COMMENT VARCHAR No
Any details that are too specific to be recorded with the history action (I TAG 5103), like specific error messages, can be recorded here.