PAYOR_COMM_HX
Description:
The PAYOR_COMM_HX table contains a history of communications sent to payers by inpatient case managers. This data is from the Payer Communication navigator section. Each row represents a communication that was sent to a payer.
If no communication was sent to a specific payer, a row will appear for that payer with the current fax, phone number, and contact name. In addition, a row will also be displayed for any fax, phone number, and/or contact name updates, if the update happened after sending the last communication. Therefore, the last row for a given payer contains the most current contact information for them.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 PAT_ENC_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 AGENCY_ID VARCHAR No
The unique ID of the payor communication recipient.
6 AGENCY_ID_AGENCY_NAME VARCHAR No
The name of the agency.
7 ROI_ID VARCHAR No
The unique ID of the release of information disclosure record; the disclosure stores all information about the communication itself, such as sending time and user.
8 LRP_ID VARCHAR No
The unique ID of the report that was sent to the payor. This column is always populated when a report is sent, but should only be used as a fallback if no Release of Information (ROI) is available in ROI_ID (such as in an IntraConnect scenario). Starting in the May 2023 version, this item extracted by this column will no longer be populated.
9 LRP_ID_REPORT_NAME VARCHAR No
The name of the report
10 SENT_DTTM DATETIME (UTC) No
The instant that the report was sent. This column is always populated when a report is sent, but should only be used as a fallback if no Release of Information (ROI) is available in ROI_ID (such as in an IntraConnect scenario).
11 OVERRIDE_FAX VARCHAR No
The fax number that was used or will be used for faxing the communication.
12 OVERRIDE_PHONE VARCHAR No
The phone number for the recipient at the time the communication was sent, or the most current phone number for the recipient.
13 COMM_MODE_C_NAME VARCHAR No
Method by which the communication was sent.
May contain organization-specific values: No
Category Entries:
Fax
Save to File
Electronic Authorization Message
14 OVERRIDE_CT_NAME VARCHAR No
The contact person name for the recipient at the time the communication was sent, or the most current contact person name for the recipient.
15 ORIG_SEND_LN INTEGER No
If this line documents a resent report, this column includes the LINE number (in this table) of the line documenting the original sending of that report. This column is NULL on lines documenting an original sending.
16 COMM_MEMO_NOTE_ID VARCHAR No
This column contains the note ID of a note containing user comments about the related communication sent to the payer.
17 IS_CUSTOM_DOCUMENT_YN VARCHAR No
This indicates whether the communication included a custom document generated using document builder.
May contain organization-specific values: No
Category Entries:
No
Yes
18 ECA_REQUEST_REALTIME_TX_CSN_ID NUMERIC No
The contact serial number of the realtime transaction record generated for an electronic authorization request in Payer Comm.