PAT_ENC_PAYOR_NOTF
Description:
This table extracts the payor notification status information.

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_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4 PAT_ENC_DATE_REAL FLOAT No
A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the 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.
5 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
6 MSG_TYPE_C_NAME VARCHAR No
The type of notification that is sent to the payor.
May contain organization-specific values: No
Category Entries:
Inpatient Admission Notification
Advanced Procedure Notification
Inpatient Discharge Notification
Observation Admission Notification
Observation Discharge Notification
7 COVERAGE_ID NUMERIC No
The coverage ID for the notification message sent to the payor
8 PAYOR_ID_PAYOR_NAME VARCHAR No
The name of the payor.
9 BENEFIT_PLAN_ID_BENEFIT_PLAN_NAME VARCHAR No
The name of the benefit plan record.
10 MSG_SENT_DTTM DATETIME (UTC) No
Instant that notification message has been sent in UTC
11 MSG_RECEIVED_DTTM DATETIME (UTC) No
Instant that notification response has been received in UTC
12 MSG_STATUS_C_NAME VARCHAR No
Notification message status.
May contain organization-specific values: No
Category Entries:
Sent
Received
Processed
Missing Info
Error
Filtered
Manually Resolved
Pending
Failed to Send
13 NOTE_ID VARCHAR No
ID of the note that corresponds with the notification message.
14 USER_COMMENT VARCHAR No
The user-entered text when manually verifying notification status.
15 NOTIF_REFERENCE_NUMBER VARCHAR No
Notification reference ID
16 REASON_CODE VARCHAR No
Notification message status reason code
17 NOTIF_ORGANIZATION_ID NUMERIC No
Notification organization ID
18 NOTIF_ORGANIZATION_ID_EXTERNAL_NAME VARCHAR No
Organization's external name used as the display name on forms and user interfaces.