DOCS_RCVD_DETAILS_2

Description: |
This record provides details about received documents including audit request information.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
DOCUMENT_ID | 1 |
CONTACT_DATE_REAL | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | DOCUMENT_ID | NUMERIC | No |
This item stores the Received Document record ID.
2 | CONTACT_DATE_REAL | FLOAT | No |
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3 | CONTACT_SERIAL_NUM | NUMERIC | No |
The contact serial number (CSN) for the document received record
4 | HISTORICAL_DOCUMENT_INFO_ID | VARCHAR | No |
Historical document information (DCS) records for the object.
5 | PAT_GEN_IDN_C_NAME | VARCHAR | No |
Patient gender identity for the patient associated with the incoming document.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Transgender Female
Transgender Male
Not Listed
Choose not to disclose
Nonbinary
Genderqueer
6 | PAT_SAAB_C_NAME | VARCHAR | No |
Patient sex assigned at birth for the patient associated with the incoming document.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Not recorded on birth certificate
Choose not to disclose
Uncertain
7 | SOURCE_RFL_ID | NUMERIC | No |
When receiving a referral complete message for an encounter in another organization, this item links the encounter document to the initiating referral record.
8 | HAS_INSURANCE_INFO_YN | VARCHAR | No |
Indicates whether or not this contact has insurance updates.
May contain organization-specific values: No
Category Entries:
No
Yes
9 | AUTHOR_NATL_PROV_IDENT | VARCHAR | No |
The National Provider ID of the author.
10 | ERX_PATIENT_LANGUAGE_C_NAME | VARCHAR | No |
This item represents the patient's preferred language for the external prescription.
May contain organization-specific values: Yes
11 | ERX_PREVENT_RENEWAL_YN | VARCHAR | No |
This item represents whether refill requests should not be sent to the authorizing provider for this external prescription.
The category values for this column were already listed for column: HAS_INSURANCE_INFO_YN
12 | AUDIT_SOURCE_RFL_ID | NUMERIC | No |
Stores history of Source Referral ID.
13 | UPDATE_NOTIF_TYPE_C_NAME | VARCHAR | No |
If the received message was an Update Notification, this column describes the event that triggered the Update Notification.
May contain organization-specific values: No
Category Entries:
Encounter Close
Encounter Addendum
Encounter Moved From
Encounter Moved To
Result Added
Result Removed
Coverage Added
Coverage Removed
Result Edited
Immediate Patient-Level Event
Delayed Patient-Level Event
Inpatient Discharge
Coding Completed
Charges Filed
Claim Accepted
Manual Review Complete
Program Added/Edited
Study Link Event
Study Unlink Event
Inpatient Admission
Patient Merge
Program Delete
Demographics Changed
CAnD PPC Roster Added
CAnD Roster Period Change
Payer/Plan Mapping Add
Service Area Opt In
Periodic CAnD Backfill
Trigger Updates Patient Subset Utility
Unknown
14 | PEHX_SRC_MYPT_ID | VARCHAR | No |
The MyChart user who answered the history question for the contact.
15 | PEHX_SRC_USER_ID | VARCHAR | No |
The user who answered the history question in non-captive mode for the contact.
16 | PEHX_SRC_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
17 | HAS_MED_HX_INFO_YN | VARCHAR | No |
This column indicates whether the contact stores discrete medical history information.
The category values for this column were already listed for column: HAS_INSURANCE_INFO_YN
18 | ERX_MIXTURE_FORM_C_NAME | VARCHAR | No |
This column stores the mixture form of a mixture-based medication.
May contain organization-specific values: Yes
19 | EVENT_CE_NOTIFICATN_TYP_C_NAME | VARCHAR | No |
This item describes the type of event which the message represents and is used for displaying the event type in In Basket messages. This item is only set for Event Notifications.
May contain organization-specific values: No
Category Entries:
Ambulatory Encounter
Inpatient Discharge
Patient Arrived at ED/Obs
Hospital Outpatient Visit
Inpatient Admission
Patient Dismissed from ED
Patient Discharged from ED/Obs
Emergency
General
Surgery Complete
Other
20 | PUSH_MESSAGE_TYPE_C_NAME | VARCHAR | No |
The incoming message type category ID for the Received Direct messages.
May contain organization-specific values: No
Category Entries:
Continuity of Care Document
Incoming Message Reply
Continuity of Care Record
Referral Complete
Referral
Referral Supporting Document By Initiator
360x Referral Request
360x Referral Decline
360x Referral Accept
360x Referral Outcome
360x Referral Cancel
360x Referral Cancel Confirmation
360x Interim Consultation Note
360x New Appointment
360x Reschedule Appointment
360x Cancel Appointment
360x No-show Notification
Professional Billing Exchange
Reject
Event Notification
InBasket
ADT Notification
On-Demand CCD
SMTP
XCA Deferred Response
GWN Reject
Kill Referral
Update Notification
Additional Detail
External Order Supporting Document
External Order Supporting Document Notification
Telehealth
Unknown
21 | PEHX_SRC_PAT_ENC_CSN_ID | NUMERIC | No |
Stores the contact serial number (CSN) of the encounter a history question submission is associated with.
22 | HAS_ICU_STAY_UPD_YN | VARCHAR | No |
Indicates whether the external document record contact has updated ICU stay data.
The category values for this column were already listed for column: HAS_INSURANCE_INFO_YN
23 | FHIR_BINARY_URL | VARCHAR | No |
Contains the URL at which the attachment content can be retrieved
24 | IMR_REPLY_RCVD_INST_UTC_DTTM | DATETIME (UTC) | No |
Instant the most recent reply was received from the remote organization
25 | RELATES_TO | VARCHAR | No |
Stores the content of the RelatesTo header from a direct message.
26 | REPLYTO_ADDRESS_EXT_ADDR_ID | NUMERIC | No |
The unique ID of the External Address record to which replies to this message should go. This item is only populated for messages sent through Direct SMTP.
27 | REPLYTO_ADDRESS_EXT_ADDR_ID_MIXED_DIRECT_ADDR | VARCHAR | No |
Formatted like an email address, this is how Direct messaging knows where to send a message. This item is stored in mixed case to use in display in addressing.
28 | MATCH_UPDATE_ON_UTC_DTTM | DATETIME (UTC) | No |
The date and time when the patient record match is updated for a Received Document.
29 | PAT_NAME_PREFIX | VARCHAR | No |
This column contains the title associated with the patient's name.
30 | EXT_MED_COVERAGE_IDENT | VARCHAR | No |
This item stores the coverage ID of the patient under each PBM.
31 | PAT_COUNTY_C_NAME | VARCHAR | No |
The county of the patient's address from the received document. NOTE: Not all DXR use cases discretely parse this item.
May contain organization-specific values: Yes
32 | PAT_LIVING_STAT_C_NAME | VARCHAR | No |
Holds status information about whether the patient is deceased. NOTE: Not all DXR use cases discretely parse this item.
May contain organization-specific values: No
Category Entries:
Alive
Deceased
Not A Patient
33 | PAT_DEATH_DATE | DATETIME | No |
Holds information about when the patient died if known in the received document. NOTE: Not all DXR use cases discretely parse this item.
34 | PAT_MARITAL_STAT_C_NAME | VARCHAR | No |
Holds discrete marital status information from the received document.
May contain organization-specific values: No
Category Entries:
Annulled
Divorced
Interlocutory
Legally Separated
Married
Polygamous
Never Married
Domestic partner
Widowed
Unknown
Common Law
Unmarried
35 | PAT_MARITAL_STAT_TEXT | VARCHAR | No |
Holds the display name of the received document for remapping purposes.
36 | HAS_NOTE_SECTION_YN | VARCHAR | No |
This item indicates whether the contact stores note section data.
The category values for this column were already listed for column: HAS_INSURANCE_INFO_YN
37 | HAS_TREAT_RESTR_UPD_YN | VARCHAR | No |
Indicates whether the contact stores treatment restrictions
The category values for this column were already listed for column: HAS_INSURANCE_INFO_YN
38 | CLINICAL_NOTE_CSN_ID | NUMERIC | No |
The unique contact serial number of the Clinical Note contact containing the text retrieved as a part of this received document's contact.
39 | DOCUMENT_TITLE | VARCHAR | No |
Free text title of a received document
40 | EXTERNAL_ORDER_NET_IDENT | VARCHAR | No |
The external order ID. This is used to link the document (DXR) to an order in the local organization by matching the value stored in this field to an order with the same unique external order ID (I ORD 30600).
41 | INT_FAILURE_REASON_C_NAME | VARCHAR | No |
Reason for document failure
May contain organization-specific values: No
Category Entries:
Document already received from Epic organization