DOCS_RCVD

Description:

High level information about received documents.

Primary Key

Column Name	Ordinal Position
DOCUMENT_ID	1

Column Information

	Name	Type	Discontinued?
1	DOCUMENT_ID	NUMERIC	No
	This item stores the Received Document record ID.
2	TYPE_C_NAME	VARCHAR	No
	Specifies the document type. May contain organization-specific values: Yes Category Entries: Clinical Summary Immunization Registry Document List Other Results Medications Encounter Summary External Dispenses Lab Results Continuity of Care Document Referral Summary Discharge Summary PNR Document List Emergency Department Summary External Document - PDF Associated Attachment Quality Reporting Document Architecture Continuity of Care Record Additional Attachment Letter Referral Care Plan Patient Agnostic Quality Reporting Document Architecture Patient Health Summary Patient Entered Data Constellation Update Variant List Labor and Delivery Summary Laboratory Reports Immunization Content Consultation Note Diagnostic Imaging Report History and Physical Note Operative Note Procedure Note Progress Note CDA Document Kanta Outsource Service Authorization Non-XML Document Binary Object Object List PNR Object List Kanta Historical Document ADT Interface Encounter External Discrete Data Composite Record Deduplicated Record Imaging Study Imaging List Bridges JSON Message Imported Document Clinical Note Note List NHSN Reporting Professional Billing Exchange Document Central Database Query External Communication Patient-Reported Information MyChart Non-Epic Record Patient-Initiated Request Patient Link Request Documents Request OLIS Clinical Correspondence Denmark - FMK medication Card Answer of Admission Admission Report Progress of Care Report Discharge Report MedCom Invalid Clinical Summary Invalid Immunization Registry Invalid Encounter List Invalid Other Results Invalid Medications Invalid Encounter Summary Invalid External Dispenses Invalid Lab Results Invalid Continuity of Care Document Invalid PNR Event List Invalid Continuity of Care Record Invalid Letter Invalid CE Referral Cosmos Misfile Message Cosmos Forwarded Misfile Message Cosmos Cloud Patient Message Cosmos Cloud Encounter Message Share Everywhere Message MedCom FHIR Clinical Analytics Overall Clinical Analytics Supplemental Analytics Overall Supplemental Analytics External Clinical Data Append Flatfile Delta Keep External Clinical Data Replace Flatfile Delta Removal Interfaced Result Bulk Supplemental Flat File External Claim Historical Claim SIU Interface Encounter Legacy Pharmacy Patient External E-Prescription Legacy Pharmacy Prescription External Prescription Discontinuation Request Prescription Hub Download External Interfaced Medications RxTransfer Request (Out) RxTransfer Response (In) Prescription Document RxTransfer Request (In) RxTransfer Response (Out) LTC RxFill NoteReader Extract Patient Level NoteReader Extract NLP Sig Data Ambient Session Data Ambient Nursing Session Audit DXS HL7v2 Message ADT Event Notification - HL7 v2 message ADT Event Notification - Plain Text message Payer ADT Event Notification - HL7 v2 message FHIR Search FHIR Read Dialysis Summary Oncology Summary Genomics Summary Norway Sick Leave Letter Norway BKM Claim Norway Sick Leave Dialog GP Patient List Subscription Health Plan Sourced Clinical Summary Coverage ID Card External FHIR Data Externally Calculated Outcome Cosmos Unreconciled Document List External Order Supporting Document Message External Payer Data HEDIS Medical Record Review Life Sciences Demographics
3	PAT_ID	VARCHAR	No
	The unique ID of the patient for this received document.
4	DOC_SOURCE_ORG_ID	NUMERIC	No
	Source organization record for this document
5	DOC_SOURCE_ORG_ID_EXTERNAL_NAME	VARCHAR	No
	Organization's external name used as the display name on forms and user interfaces.
6	DOC_SET	VARCHAR	No
	Specifies the Set ID for these documents.
7	ENC_EVENT_IDENT	VARCHAR	No
	The event identifier for the event contained in this document. Applies only to Encounter Summary records.
8	AUTHOR_INST_ID	NUMERIC	No
	Specifies the Author Institution that created the document.
9	AUTHOR_INST_ID_EXTERNAL_NAME	VARCHAR	No
	Organization's external name used as the display name on forms and user interfaces.
10	REPOSITORY_ID	VARCHAR	No
	The unique ID of the repository holding the received document.
11	INVLD_INSTANT_TM	DATETIME (Local)	No
	This item stores the instant this received document was invalidated.
12	DOCUMENT_FILE_NAME	VARCHAR	No
	Stores the file name for the document on the BLOB server
13	SENDER_REFERRALID	VARCHAR	No
	This item stores the referral ID for Care Everywhere Referral-type external document records as received from the outside organization. The format is OID^ID, where the ID is usually a record ID at the outside organization.
14	PHR_ID	NUMERIC	No
	The unique ID of the pharmacy that sent this received document.
15	PHR_ID_PHARMACY_NAME	VARCHAR	No
	The name of the pharmacy.
16	DOC_CONTENT_TYPE_C_NAME	VARCHAR	No
	Specifies the content type of the document. May contain organization-specific values: Yes Category Entries: Clinical Summary Document List Other Results Encounter Summary Lab Results Continuity of Care Document Referral Summary Discharge Summary LPR3 Document LPR3 Event Document Emergency Department Summary External Document - PDF External Document - Text Quality Reporting Document Architecture Continuity of Care Record Care Plan Overall Plan of Care Patient Health Summary Constellation Update Labor and Delivery Summary Laboratory Reports Immunization Content Consultation Note Diagnostic Imaging Report History and Physical Note Operative Note Procedure Note Progress Note Physician consulting Progress note Location Summary IRIS Ophthalmology Report Payer Document Endoscopy Registry Patient Level Quality Reporting Document Population Level Quality Reporting Document Professional Billing Exchange Document Cancer Registry Initial Public Health Case Report Outgoing Death Registry Reporting IHE VRDR Profile Outgoing NHCS Survey Documents Patient-Reported Information Specialist Letter Decision Support Request Cosmos Document Patient Level Cosmos Document Encounter Level Cosmos Document Unreconciled Data Encounter Level Cosmos Document Unreconciled Data Patient Level Treatment Document - eArchive Forms - eArchive Service Event - eArchive Finland eRx Kanta Social Care THL Registry Document THL Calculation Document Navitas Patient Summary Document Navitas Encounter Document Navitas Imaging Document USCDI CCD (Patient Level) USCDI CCD (Encounter Level) 2015 CCDS CCD Basisgegevensset Zorg (BgZ) Basisgegevensset Zorg (BgZ) - Encounter Clinical Analytics Overall Clinical Analytics Supplemental Analytics Overall Supplemental Analytics Transplant Episode Summary Comprehensive Care Coordination Summary Emergency department Note Note Outpatient Note Perioperative records Cardiology studies Transfer summary note Radiology studies Anesthesia records Dialysis Summary Oncology Summary Genomics Summary Health Plan Sourced Clinical Summary Patient Dialysis Summary Patient Oncology Summary Life Sciences Patient Level Update Life Sciences Restricted Data Exchange
17	EXTERNAL_EPT_CSN	NUMERIC	No
	For received documents from external systems that Epic rehosts, this stores the patient encounter Contact Serial Number (CSN).
18	ATTACHED_DOC_ID	VARCHAR	No
	This item stores the ID of the document record, which contains the attached document that was received.
19	EPISODE_UUID	VARCHAR	No
	Stores a UUID identifying an episode of care
20	RECORD_STATE_C_NAME	VARCHAR	No
	The record state category ID for this received document. May contain organization-specific values: No Category Entries: Invalid
21	DOC_EPSD_IDENT	VARCHAR	No
	The episode identifier of the episode contained in this document.
22	INVLD_USER_ID	VARCHAR	No
	The unique ID of the user that invalidated this received document.
23	INVLD_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
24	DOC_CONTENT_TYPE	VARCHAR	No
	This is the type of document stored in the record. For Care Everywhere Encounter Summaries, this is the type of encounter stored in this record.
25	CAN_HAVE_RESTRICTED_ENC_YN	VARCHAR	No
	Indicates if this Event List row could have restricted encounters May contain organization-specific values: No Category Entries: No Yes
26	EXT_MED_PBM_IDENT	VARCHAR	No
	This item stores the PBM ID for the patient.
27	RECEIVED_CLINICAL_NOTE_ID	VARCHAR	No
	The ID of the note record automatically created in the local chart from the received clinical note information.
28	RX_DOCUMENT_STATUS_C_NAME	VARCHAR	No
	This item tracks the status of a prescription document as it is being processed. May contain organization-specific values: No Category Entries: Not Linked to Patient Pending Order Entry Processed Deleted
29	COVERAGE_ID	NUMERIC	No
	This item stores the CVG ID for which document is being requested.
30	RESEARCH_ID_RESEARCH_STUDY_NAME	VARCHAR	No
	The name of the research study record.
31	DATA_ORIG_SRC_ORGANIZATION_ID	NUMERIC	No
	This item is set for documents that contain data that was forwarded from an organization external to the source organization in I DXR 70. This is used by Cosmos and Payor Platform to identify the source of unreconciled data.
32	DATA_ORIG_SRC_ORGANIZATION_ID_EXTERNAL_NAME	VARCHAR	No
	Organization's external name used as the display name on forms and user interfaces.
33	RX_TRANSFER_STATUS_C_NAME	VARCHAR	No
	This item is used during electronic prescription transfers between two pharmacies. This is the current status of the electronic prescription transfer. May contain organization-specific values: Yes Category Entries: New Pending Rx Entry Pending E-Transfer Scheduled Fill Pending Fill Fill Rejected Waiting For Approval Ready to Fill Fill Initiated Filled Ready to Verify Fill Rejected Verified Ready to Package Ready to Transport In Transit Received Waiting for Filling Pharmacies Ready to Dispense Dispense Documented Dispense Received from External System Dispensed Shipped Delivered Consult Completed Approved Refill Request Denied Refill Request Profiled Canceled Order Edited Flag Removed Returned to Stock Wasted Clinically Reviewed Clinical Changes Reviewed Charge Payment Bagged Toted Trucked Boxed Packaged Sealed Barcode Scan Patient Notification Abandoned Rx Sale Needs Tracking Number No Sale Completed Authentication Payment Amount Changed Invalidated Billing Item Prescription Revision Needed Prescription Revised IP Dispense Prepared IP Dispense Prep Started IP Dispense Prep Saved Work IP Dispense Prep Pending Final Review IP Reused For Another Dose Dispense Prep IP Reused From Previous Dose Dispense Prep IP Dispense Prep Partial Complete IP Dispense Prep Resumed IP Dispense Prep Stopped IP Dispense Prep Saved on Admin IP Dispense Checked IP Dispense Prep Partial Check IP Dispense Prep Revise IP Dispense Prep Requeued IP Dispense Rejected IP Dispense Prep Reuse Started IP Dispense Prep Reuse Stopped IP Queued For Dispense Check Without Prep IP Dispense Check Removed IP Dispense Check Started IP Second Dispense Check IP Dispense Final Label Check IP Final Label Check Deferred IP Final Label Check Overridden IP Added to Dispense Queue IP Printed From Dispense Queue IP Automatically Removed From Dispense Queue IP Manually Removed From Dispense Queue Rx Dispense Sent Rx Dispense Received Rx Cancel Tracking Action IP Dispense Prepared via Interface Download Request Pending Download Request Submitted Download Successful Download Request Rejected Download Request Canceled Download Error Download Not Attempted E-Transfer Request Pending Send E-Transfer Request Sent E-Transfer Request Sent Successfully E-Transfer Request Sending Error E-Transfer Request Approved E-Transfer Request Denied E-Transfer Pending Reconciliation E-Transfer Reconciled E-Transfer Confirmation Sent E-Transfer Confirmation Success E-Transfer Confirmation Error E-Transfer Request Received E-Transfer Response Pending Send E-Transfer Response Sent E-Transfer Response Sent Successfully E-Transfer Response Sending Error E-Transfer Response Denied E-Transfer Confirmation Received Sale Completed Sale Updated Sale Canceled Sale Price Override Approved Sale Pending Fee Sold in POS Waiting on Third Party Tax Exemption Applied Tax Exemption Removed Tax Charge Rx Inv Stock Location Overridden Rx Inv Stock Location Override Removed Not Dispensed HI Shipment Started HI Shipment Audited HI Dispensed HI Worksheet Printed HI New Revision HI Meds Staged HI Supplies Staged HI Meds Stage Checked HI Supplies Stage Checked HI Staged HI Stage Checked HI Meds Packed HI Supplies Packed HI Packed HI Ready To Ship HI Post Shipment Change HI In Transit HI Delivered HI Complete HI Canceled
34	RX_TRANSFER_TO_PHARMACY_ID	NUMERIC	No
	This item is used during electronic prescription transfers between two pharmacies. This is the pharmacy the prescription was transferred to.
35	RX_TRANSFER_TO_PHARMACY_ID_PHARMACY_NAME	VARCHAR	No
	The name of the pharmacy.
36	RX_TRANSFER_FROM_PHARMACY_ID	NUMERIC	No
	This item is used during electronic prescription transfers between two pharmacies. This is the pharmacy the prescription was transferred from.
37	RX_TRANSFER_FROM_PHARMACY_ID_PHARMACY_NAME	VARCHAR	No
	The name of the pharmacy.
38	RX_TRANSFER_TO_USER_ID	VARCHAR	No
	This item is used during electronic prescription transfers between two pharmacies. This is the user for the transfer to pharmacy that authorized the transfer.
39	RX_TRANSFER_TO_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
40	RX_TRANSFER_FROM_USER_NAME	VARCHAR	No
	This item is used during electronic prescription transfers between two pharmacies. This is the user for the transfer from pharmacy that authorized the transfer.
41	RX_TRANSFER_COMMENTS	VARCHAR	No
	This item is used during electronic prescription transfers between two pharmacies. This contains the comments associated with the transfer.
42	RX_TRANSFER_REQ_DOCUMENT_ID	NUMERIC	No
	The electronic prescription transfer request document associated with this electrionc prescription transfer response.
43	EXT_DEMOG_ID	NUMERIC	No
	Holds a pointer to the REQ record that holds the identifier and demographics that this external document was loaded with, linking this external document data record to an ID bundle.