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 Outside 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