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 Other 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 Payer/Plan Mapping Add Service Area Opt In 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 Patient Discharged Patient Arrived at ED Hospital Outpatient Visit Patient Admission Patient Dismissed from ED Patient Discharged from ED 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