RFL_PAYER_NOTIF_ADMSN

Description: |
This table contains information about notifications of admissions associated with an encounter.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
REFERRAL_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | REFERRAL_ID | NUMERIC | No |
The unique identifier (.1 item) for the referral 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 | NOTF_MSG_TYPE_C_NAME | VARCHAR | No |
The type of admission notification sent to the payer organization.
May contain organization-specific values: No
Category Entries:
Inpatient Admission Notification
Advanced Procedure Notification
Inpatient Discharge Notification
Observation Admission Notification
Observation Discharge Notification
4 | NOTIF_MSG_SENT_UTC_DTTM | DATETIME (UTC) | No |
The sent instant (in UTC) for the specified payer notification message.
5 | NOTIF_MSG_REC_UTC_DTTM | DATETIME (UTC) | No |
The instant (in UTC) for the notification response received from the payer notification message that was previously sent.
6 | NOTF_MSG_STATU_C_NAME | VARCHAR | No |
The status for the payer notification message, including Sent, Processed, Error, Manually Resolved, etc.
May contain organization-specific values: No
Category Entries:
Sent
Received
Processed
Missing Info
Error
Filtered
Manually Resolved
Pending
Failed to Send
Failed to Update Authorization
7 | NOTIF_REF_NUM | VARCHAR | No |
The reference number associated to the payer notification message.
8 | NOTIF_ADT_SOURCE_C_NAME | VARCHAR | No |
The source of how Notice of Admission filed utilization management data into the referral.
May contain organization-specific values: No
Category Entries:
Payer Platform Automated NOA External Admission ADT
Tapestry NOA External Admission ADT
Tapestry NOA Internal Admission EPT
External NOA ADT Notification
9 | NOTIF_ADT_SOURCE_ORG_ID | NUMERIC | No |
The source organization of the Notice of Admission notification.
10 | NOTIF_ADT_SOURCE_ORG_ID_EXTERNAL_NAME | VARCHAR | No |
Organization's external name used as the display name on forms and user interfaces.