DOCS_RCVD_DETAILS

Description:

Details about received documents, including request audit 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_DATE	DATETIME	No
	The date of this contact in calendar format.
4	CONTACT_SERIAL_NUM	NUMERIC	No
	The unique contact serial number (CSN) of the Received Document contact. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
5	DOCUMENT_EXT	VARCHAR	No
	UUID for this document
6	DOCUMENT_ORIGIN_C_NAME	VARCHAR	No
	How the document was requested May contain organization-specific values: No Category Entries: Request Via Ticket Automated Document Request Unsolicited Document
7	DOCUMENT_DEP_ID	NUMERIC	No
	ID of the login department where the user was logged in when the document request was initiated
8	DOCUMENT_DESC	VARCHAR	No
	Free text description of the contents of the document
9	CEID	VARCHAR	No
	The patient Care Everywhere ID used for this request
10	STRUCT_TYPE_C_NAME	VARCHAR	No
	Data type of the document being stored May contain organization-specific values: No Category Entries: CDA
11	RECV_INST	DATETIME (Local)	No
	Instant the document was received from the remote organization
12	DOC_KIND_C_NAME	VARCHAR	No
	The kind of document being stored here May contain organization-specific values: No Category Entries: Outpatient Discharge Summarization Note Inpatient Discharge Summarization Note Transfer Summarization Note Summarization of Episode Note Referral Note Quality Measure Report Plan of care note Risk Assessment Document Labor and Delivery Summary Provider unspecified Operation Note Subsequent evaluation note Physician consulting Progress note Diagnostic Imaging Report Outgoing IRIS Ophthalmology Encounter Summary Supplemental Analytics Endoscopy study Physician Reporting to a Public Health Repository - Cancer Registry Initial Public Health Case Report Outgoing Death Registry Reporting IHE VRDR Profile National healthcare survey panel NAMCS Specialist Letter Patient summary Document Life Sciences Data Exchange Clinical Analytics Transplant Episode Summary Comprehensive Care Coordination Summary Dialysis Summary Oncology Summary Genomics Summary Health Plan Sourced Clinical Summary
13	REQUEST_REASON_C_NAME	VARCHAR	No
	Reason for initiating the document request May contain organization-specific values: No Category Entries: Other Automatic System Request PCP Review Emergency Visit Referral Scheduled Visit Urgent Care Walk In Admission Phone / E-mail Encounter Care Coordination Background Batch Request Background Verification Query Data Request Chart Gateway Batch Query Chart Gateway Targeted Query Patient Portal Initiated Chart Correction Chart Gateway Link Forwarded Query Switch from Standalone to Gateway Automatic Request to Repair Link Orders Anywhere Query Prior Authorization Payer Platform ADT Payer Platform Update Notification Payer Platform Scheduled Appointment Network Affiliation Patient Newly Enabled Book Anywhere Payer Coverage Finder Payer Platform Prep Data Automatic Query to Payer Before Appointment Reference Claim Link Payer Platform Member Estimates Life Sciences Study Enrollment Patient Coverage Linking Payer Coverage Finder - Foreground Claim Status - Foreground Claim Status - Background Treatment Payment Healthcare Operations System Administration Fraud Detection Psychotherapy Training Legal Disclosure Marketing Facility Directory Family Disclosure Individual Present Disclosure Emergency Disaster Relief Public Health Abuse Disclosure Health Oversight Disclosure Judicial Disclosure Law Enforcement Disclosure Deceased Disclosure Organ Donation Disclosure Research Disclosure Health Safety Threat Government Disclosure Workers Compensation Insurance or Disability Coverage Disclosure Request of the Individual
14	REQUEST_EXPLNATION	VARCHAR	No
	Free text explanation for requesting the document
15	REQUEST_VST_PRV_ID	VARCHAR	No
	The unique ID associated with the provider record for the search if the contact has no provider. This column is frequently used to link to the CLARITY_SER table.
16	RECORD_CREATE_INST	DATETIME (Local)	No
	Instant of creation
17	REC_CREATE_USR_ID	VARCHAR	No
	User
18	CONSENT_DOC_REC_ID	VARCHAR	No
	If authorization was required for this document request then the ID of the document information record (DCS) for the authorization will be stored here.
19	LETTER_CSN	NUMERIC	No
	Stores the Contact Serial Number (CSN) of the patient contact where additional information in this received document record is stored.
20	REFERRAL_ID	NUMERIC	No
	This item stores the referral record identifier for the referral on the local organization associated with this received document record.
21	LETTER_ID	VARCHAR	No
	This item stores the note record identifier of the letter associated with this received document record.
22	LETTER_NUM	INTEGER	No
	Stores the letter number of the letter associated with this external document record. The letter number corresponds to a line number in EPT related group 20200 which stores patient letters.
23	EOW_ID	VARCHAR	No
	The In Basket message (EOW) that triggered this request.
24	PAT_NAME	VARCHAR	No
	Patient name column. When a document is received from an external system, it will contain certain metadata supplied by the sending system regarding the document. This column contains the patient name that was received in the document's metadata.
25	PAT_FAMILY_NAME	VARCHAR	No
	Patient family name column. When a document is received from an external system, it will contain certain metadata supplied by the sending system regarding the document. This column contains the patient's family name that was received in the document's metadata.
26	PAT_NAME_SUFFIX	VARCHAR	No
	Patient name suffix column. When a document is received from an external system, it will contain certain metadata supplied by the sending system regarding the document. This column contains the patient's name's suffix that was received in the document's metadata.
27	PAT_CITY	VARCHAR	No
	The patient city received as a part of a document from an external system.
28	PAT_STATE_C_NAME	VARCHAR	No
	Patient state column. When a document is received from an external system, it will contain certain metadata supplied by the sending system regarding the document. This column contains the patient's state that was received in the document's metadata. May contain organization-specific values: Yes
29	PAT_ZIP	VARCHAR	No
	The patient's postal code. When a document is received from an external system, it contains certain metadata supplied by the sending system regarding the document. This column contains the patient's postal code that was received in the document's metadata.
30	PAT_COUNTRY_C_NAME	VARCHAR	No
	The patient country received as a part of a document from an external system. May contain organization-specific values: Yes
31	PAT_SEX_C_NAME	VARCHAR	No
	Patient sex column. When a document is received from an external system, it will contain certain metadata supplied by the sending system regarding the document. This column contains the patient's sex that was received in the document's metadata. May contain organization-specific values: Yes Category Entries: Female Male Unknown Nonbinary X Other
32	PAT_DOB_DT	DATETIME	No
	Patient date of birth column. When a document is received from an external system, it will contain certain metadata supplied by the sending system regarding the document. This column contains the patient's date of birth that was received in the document's metadata.
33	SUBSET_TITLE	VARCHAR	No
	Stores the title of the submission set received in an incoming Provide and Register message. Its value is supplied by the sending system.
34	SUBSET_CMT	VARCHAR	No
	Submission set comments column. This column stores the comments associated with a submission set received in an incoming Provide and Register message. Its value is supplied by the sending system.
35	AUTHOR_ID	VARCHAR	No
	Author ID column. This column stores the author ID associated with a document or submission set received in an incoming Provide and Register message. Its value is supplied by the sending system. This may be an ID from any codeset, and the codeset is not included in the document submission.
36	AUTHOR_NAME	VARCHAR	No
	Author name column. This column stores the author name associated with a document or submission set received in an incoming Provide and Register message. Its value is supplied by the sending system.
37	PAT_DEST_ID	VARCHAR	No
	The patient destination identifier for this external document received from the sending organization.
38	DEST_LOC_DXO_ID	NUMERIC	No
	The destination location organization record (DXO) ID to which the message is sent (set only if it is different from local organization record ID).
39	DEST_LOC_DXO_ID_EXTERNAL_NAME	VARCHAR	No
	Organization's external name used as the display name on forms and user interfaces.
40	CE_TOKEN	VARCHAR	No
	This column contains the patient Care Everywhere token from the source organization of the received document.
41	CREAT_INST_DTTM	DATETIME (Local)	No
	Instant the received document was created in the sender organization
42	PAT_SSN	VARCHAR	No
	Patient's Social Security Number (SSN) from an incoming message.
43	PAT_HOME_PH	VARCHAR	No
	Patient's home phone number.
44	PAT_WORK_PH	VARCHAR	No
	Patient's work phone number from an incoming message.
45	PAT_CELL_PH	VARCHAR	No
	Patient's mobile phone number.
46	SRC_LOC_DXO_ID	NUMERIC	No
	The document source location organization ID from which the message is sent. It is set only if it is different from the source organization ID (I DXR 70).
47	SRC_LOC_DXO_ID_EXTERNAL_NAME	VARCHAR	No
	Organization's external name used as the display name on forms and user interfaces.
48	ERX_CONTROLLED_YN	VARCHAR	No
	This column indicates whether the external e-prescription accepted through the incoming e-prescribing interface is for a controlled substance. May contain organization-specific values: No Category Entries: No Yes
49	INC_CONTEXT_C_NAME	VARCHAR	No
	The context of the submission set that contains the documents for a received Provide and Register message. May contain organization-specific values: Yes Category Entries: Referral Discharge General Communication Patient Initiated Emergency Discharge Inpatient Discharge Unknown Not Specified Medication Adherence Message Share Everywhere Message Healthy Planet Link Upload Update Notification External Order Processing Request Public Health Reporting Admission Event Notification Discharge Event Notification Referral Outcome Referral Interim Note Outpatient Event Notification General Event Notification External Order Supporting Document International Patient Link Request International Document Request
50	AUTHOR_ADDRESS	VARCHAR	No
	This item stores the address of the document author.
51	AUTHOR_PHONE	VARCHAR	No
	This item stores the phone number of the document author.
52	PAT_HOUSENUMBER	VARCHAR	No
	Patient's house number from an incoming message.