DOC_INFORMATION

Description:

The DOC_INFORMATION table contains information about documents, including scanned and electronically signed documents.

Primary Key

Column Name	Ordinal Position
DOC_INFO_ID	1

Column Information

	Name	Type	Discontinued?
1	DOC_INFO_ID	VARCHAR	No
	The unique ID of the document information record.
2	DOC_INFO_TYPE_C_NAME	VARCHAR	No
	The type of document described by this document information. May contain organization-specific values: Yes Category Entries: Other Waveform Strip Annotation Advance Directives and Living Will Power of Attorney HIPAA Notice of Privacy National POLST Form Clinical Unknown Patient Photo Study Attachment for Report Study Attachment DICOM Study DICOM Series DICOM Image ECG Spirometry Holter Authorization to Release Protected Health Information HIM Release of Information Output Kanta Informing Kanta Consent to Data Sharing Kanta Denial of Consent to Data Sharing Kanta PikaXML CHF Kanta GWN Disclosure Auth Kanta Secondary Use Prohibition Generated Form Organ Donation Will Living Will Consent Form Vaccine Information Statement ABN Waiver Discharge Instruction Release of Information Behavior Contract Clinical References Attachment External Medication Information Consent After Visit Summary Summary of Care CMS IM for Patient Signature CMS IM Copy of Signed Detailed Notice of Discharge Communication Verbal Consent Referral Implied Consent Unverified Proxy Video Visit After Visit Summary Lab Result Scan Lab Requisition Scan Lab Result Document Lab Managed Result Scan Lab Managed Requisition Scan Lab Instrument Image Lab External Image Encounter Dictation History Dictation Order Dictation Clinician Jot Clinical Note Import View Private Medications Consent FMK Med Card PDF FMK Dose Dispensing PDF Research Consent Research Data Capture Plan of Care E-Sig Form Plan of Care Snapshot CCAPS Profile Report PDF Safety Plan Hospice Election EOB Payment / Check Historic Transaction Historic Correspondence Billing Correspondence My Files Document PDF Report PDF Letter Prov Comm E-Letter PDF Prospective Auth Dental Tooth Chart Dental Baseline Dental Perio Chart Member Attachment Coverage Attachment Coverage ID Card Coverage Enrollment Application Coverage COB Information AP Claim Attachment AP Claim Image Vendor Contract Attachment Vendor Attachment Benefit Plan Attachment CRM Attachment Appeal or Grievance Attachment PB Account Attachment Referral Attachment Referral Notification Document Authorization Notification Document Payer Notification Document Payer Approval Document Payer Notification of Extension Document Payer Request for Information Document Payer Denial Document Payer Cancellation Document Provider Attachment Employer Group Attachment Case Management Attachment Broadcast Message Attachment Member Appointment of Representative Form Tapestry Payer Exchange Clinical Attachment Managed Care Periodic Explanation of Benefits Managed Care Periodic Summary EOB Medical Policy Biometric Enrollment PDR Authorization PDR Disclaimer MOON Obsolete Type 1 Community Upload Account Request Attachment HH Care Summary Proof of Assets Proof of Expenses Patient Entered Attachment Patient Entered Drawing MyChart COVID-19 Vaccination Record Document MyChart Test Results Record Document Electronic Prior Authorization Attachment Sent via Secure Chat MDS CMS PDF Unused Self-Pay Consent Estimate Visit Auto Pay Consent Financial Arrangement Endoscopy Image Endoscopy Anatomical Diagram Child Resistant Cap Waiver Rx Prescription Rx Prescription Sale E-Signature Rx Prescription Dispense Customer ID Rx Dispense Prep Image Rx CNR Image ED Patient Billing Extract Imaging Order Key Image Object Screening Form Annotated Cardiology Image Archived Procedural Result IRF-PAI THL Form Filler Derm Clinical Image Pedigree Image Occ Med Form Spreadsheet Report Data Clinical Spreadsheet Report Data CE Point of Care Auth CE Prospective Auth CE Persistent Point of Care Auth CE Auth Form (Scanned) System-Retrieved CE Auth Form E-Signed CE Auth Form PDF CE Auth Form CE Attachment MyChart-Signed CE Auth Form Document Generation Template External Administration External Clinical External Billing External Insurance Card External Insurance-Related Form External Patient Consent External ROI / HIM Consent External Legal Document External Living Will External DNR External Power of Attorney External Legal Letter External Photo ID External Birth Certificate External Death Certificate External Misc Administration External Medication External Medication Order Report External Medication Reconciliation External Prescription List External Radiology and Imaging External Cardiology Imaging External Endoscopy Imaging External OB/GYN Imaging External Dental Imaging External Oncology Imaging External Lab External Procedure External Referral Request / Referral Report External Other Order External Note External Consult Note External H&P Note External Progress Note External Procedure Note External Operative Note External Nurse Note External ED Note External Cardiology Note External GI Note External Oncology Note External Behavior Health Note External Referral Note External Physical Therapy Note External Occupational Therapy Note External OB/GYN Note External Clinical Consent External Procedure Consent External Anesthesia Consent External Surgical Consent External Abortion Consent External Sterilization Consent External Organ Donation Consent External Research Consent External Photographic Image External Wound Care Image External Dermatology Image External Plastic Surgery Image External Flowsheet External Physician Letter External Patient Summary External Discharge Summary External Transfer Summary External Immunization Summary External Labor and Delivery Summary External Physical Therapy Summary External Occupational Therapy Summary External After Visit Summary External Patient Reported Information External Questionnaire External Patient Upload External Patient History External Patient Education and Instructions External Discharge Instructions External Evaluation and Plan External Transplant Evaluation External Risk Assessment External Physical Therapy Treatment Plan External Occupational Therapy Treatment Plan External Oncology Treatment Plan External Case Management External Episode Summary External Surgical Treatment Plan External Misc Clinical Auto-filled Result Image Waiver of Liability for Claim Appeal AN Patient Billing Extract Hospice Non-Covered Documentation Face Sheet Capture Patient-Created Image Patient-Created Audio Patient-Created Video Patient-Created Text Continuing Care Options Continuing Care Preferences Dental Soft Tissue Obsolete Type 2
3	DOC_STAT_C_NAME	VARCHAR	No
	The current status of the document described by this document information. May contain organization-specific values: Yes Category Entries: Unknown Received Not Received Accepted Error Replaced Outdated
4	DOC_DESCR	VARCHAR	No
	A short free text description of the document described by this document information.
5	DOC_RECV_TIME	DATETIME (Local)	No
	The date and time the document described by this document information was received.
6	RECV_BY_USER_ID	VARCHAR	No
	The employee who received the document described by this document information. This ID may be encrypted.
7	RECV_BY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	PAT_REP	VARCHAR	No
	The free text name of the person who legally represents the patient described by this document information.
9	DT_ON_DOC	DATETIME	No
	The date which appears on the document described by this document information.
10	DOC_EXPIR_TIME	DATETIME (Local)	No
	The date and time the document described by this document information expires.
11	DOC_LOC	VARCHAR	No
	A short free text description of the location of the paper copy of the document described by this document information.
12	IS_SCANNED_YN	VARCHAR	No
	Specifies whether there is a scanned image version of the document described by this document information. May contain organization-specific values: No Category Entries: No Yes
13	SCAN_TIME	DATETIME (Local)	No
	The date and time the document described by this document information was scanned.
14	SCAN_BY_USER_ID	VARCHAR	No
	The employee who scanned the document described by this document information. This ID may be encrypted.
15	SCAN_BY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
16	SCAN_DEP_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
17	SCAN_FILE	VARCHAR	No
	The file name of the scanned image version of the document described by this document information.
18	IS_ESIGNED_YN	VARCHAR	No
	Specifies whether the document described by this document information has been electronically signed. The category values for this column were already listed for column: IS_SCANNED_YN
19	ESIGN_TIME	DATETIME (Local)	No
	The date and time the document described by this document information was electronically signed.
20	WITNESS_BY_USER_ID	VARCHAR	No
	The employee who witnessed the electronic signing of the document described by this document information. This ID may be encrypted.
21	WITNESS_BY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
22	ESIGN_DEP_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
23	ESIGN_HTML_FILE	VARCHAR	No
	The file name of either the template HTML file of the document to be electronically signed prior to it being electronically signed or the unique file name of the HTML file of the electronically signed document described by this document information.
24	DOC_REQ_DT	DATETIME	No
	The date when a copy of the type of document described by this document information was requested.
25	IS_REQ_YN	VARCHAR	No
	Specifies whether the type of document described by this document information was requested. The category values for this column were already listed for column: IS_SCANNED_YN
26	DOC_EFF_TIME	DATETIME (Local)	No
	The date and time the document described by this document information becomes effective.
27	IS_EFF_YN	VARCHAR	No
	Specifies whether the document is in effect. The category values for this column were already listed for column: IS_SCANNED_YN
28	DOC_DISCL_DT	DATETIME	No
	The date when a copy of the document described by this document information was last disclosed.
29	DOC_REVOK_DT	DATETIME	No
	The date when the type of document described by this document information was revoked.
30	IS_REVOK_YN	VARCHAR	No
	Specifies whether the document was revoked. The category values for this column were already listed for column: IS_SCANNED_YN
31	DOC_LOCATION_C	VARCHAR	No
	The category entry for the location of the document. May contain organization-specific values: Yes
32	DOC_PT_ID	VARCHAR	No
	The unique ID of the patient associated with the document record.
33	DOC_CSN	NUMERIC	No
	This stores the contact serial number of the encounter that this record is attached to, if applicable.
34	DOC_CLM_ID	NUMERIC	No
	Stores Claim (CLM) ID for the claim that the document is associated with, used by Tapestry.
35	DOC_CVG_ID	NUMERIC	No
	Stores Coverage (CVG) ID for the coverage that the document is associated with, used by Tapestry.
36	DOC_NCS_ID	NUMERIC	No
	Stores customer service (NCS) ID for the customer relationship management (CRM) that the document is associated with, used by Tapestry.
37	DOC_NMM_ID	NUMERIC	No
	Stores the case master (NMM) ID for the case that the document is associated with, used by Tapestry.
38	DOC_RFL_ID	NUMERIC	No
	Stores Referral (RFL) ID for the Referral that the document is associated with, used by Tapestry.
39	DOC_SER_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
40	RECORD_STATE_C_NAME	VARCHAR	No
	The record state category number for the document record. May contain organization-specific values: No Category Entries: Inactive Deleted Hidden Inactive and Hidden Deleted and Hidden
41	SOURCE_ETX_ID	VARCHAR	No
	Stores the SmartText (ETX) ID that this document (DCS) record was created from.
42	SOURCE_ETX_ID_SMARTTEXT_NAME	VARCHAR	No
	The name of the SmartText record.
43	DOC_HNO_ID	VARCHAR	No
	The unique ID of the note record associated with this document.
44	SCAN_LWS_ID_WORKSTATION_NAME	VARCHAR	No
	This is the internal workstation name.
45	ESIG_SIGNED_BY	VARCHAR	No
	eSignature of person document was signed by.
46	ESIGNED_REL_C_NAME	VARCHAR	No
	The relationship between the patient and the person who signed the form (self, parent, spouse, etc.). May contain organization-specific values: Yes
47	DOC_SRVC_DTTM	DATETIME (Local)	No
	The service date and time of the document.
48	SCAN_INST_DTTM	DATETIME (Local)	No
	This item stores the most clinically relevant date for the document. From top to bottom, it looks to the service date/time (I DCS 246/247), the order prioritized instant (I ORD 24), the encounter date, and the import date/time (I DCS 310/315).
49	DOC_STORAGE_LVL_C_NAME	VARCHAR	No
	The level at which the document is attached to the patient's record. For example, the document could be stored at the patient, encounter, or hospital account level. May contain organization-specific values: No Category Entries: Patient Encounter Hospital Account Not Patient Linked Unindexed
50	SOURCE_DOC	VARCHAR	No
	The identifier for the document (DCS) record's source document. This column is only populated for DCS records of type Discharge Attachments. If the document was created from a SmartText (ETX) record, this column contains the ID of that ETX record. If the document was created from an HTML document in the References Activity, this column contains the unique identifier from the CRS.mdb file.
51	DOC_CREAT_DEPT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
52	PT_ENT_DRAW_STAT_C_NAME	VARCHAR	No
	Holds the status of the documents (DCS) record - Is it ready to show? May contain organization-specific values: No Category Entries: In Progress Completed
53	PT_ENT_DRAWING_CMT	VARCHAR	No
	Holds any associated comments from a patient-entered drawing question. Only present for documents (DCS) records of type 32010 used by MyChart and Welcome.
54	PHOTO_APPROVED_C_NAME	VARCHAR	No
	Whether or not this document (DCS) record is in the history of the patient's photos. If not, includes the reason the photo was rejected. May contain organization-specific values: Yes Category Entries: Approved Photo Denied - Unknown Denied - Other Denied - User Error Denied - Inappropriate / Innocent Denied - Inappropriate / Abusive Denied - Suspected Fraud Denied - Confirmed Fraud
55	PHOTO_APRV_APPL_C_NAME	VARCHAR	No
	The application that processed the approval/denial of the photo. May contain organization-specific values: No Category Entries: Demographics Canto/Haiku EDI Kiosk In Basket Cadence Prelude MyChart
56	WEB_USER_ID	VARCHAR	No
	This item holds the ID of the MyChart user who created this document record, for patient-generated document records.
57	NEED_ENC_YN	VARCHAR	No
	This item is used to denote whether a document needs to be attached to an encounter or not. For Patient level documents this would always be No. For encounter level documents, depending on whether it is attached or detached from an encounter, this would say No or Yes respectively. The category values for this column were already listed for column: IS_SCANNED_YN
58	PERFORMING_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
59	ESIG_TMPLT_USED	NUMERIC	No
	Stores a link to the template used to sign the document
60	TMPLT_SF_CNTCT	NUMERIC	No
	Contact of the SmartForm used to collect information for this document.
61	RESEARCH_STUDY_ID_RESEARCH_STUDY_NAME	VARCHAR	No
	The name of the research study record.
62	FT_CONSENT_PROCS	VARCHAR	No
	Stores free text procedures for consent documents
63	ORIGINAL_DOC_ID	VARCHAR	No
	Stores the link to the original (unannotated) document.
64	DOC_SPECIALTY_C_NAME	VARCHAR	No
	This item can be extended to hold possible values for the specialty that a document can be associated with. May contain organization-specific values: Yes
65	DOC_SRVR_NAME_C_NAME	VARCHAR	No
	This item stores the desktop integration (FDI) record that was used for scanning the document. May contain organization-specific values: Yes
66	DOC_SOURCE_INFO_C_NAME	VARCHAR	No
	Determines the source of the document rather than the document's type. May contain organization-specific values: No Category Entries: Unspecified Incoming Ancillary Results and Orders Interface Care Everywhere Query and Retrieve Care Everywhere Push Care Everywhere Print for Patient Order Supporting Document Chart Gateway Query Toggle Navigator Authorization Toggle Navigator Snapshot Received DICOM Image MyChart Advance Care Planning Upload Link Health Maintenance Upload MyChart Questionnaire Upload MyChart Insurance Card Upload Front MyChart Insurance Card Upload Back MyChart Insurance Card Upload Both Sides MyChart E-Visit Upload Link Account Request Attachment MyChart Financial Assistance Upload MyChart Immunization Upload MyChart Message Attachment from Patient MyChart Proxy Access Request MyChart Patient Instructions Attachment MyChart COVID-19 Vaccination Record Download MyChart Lab Requisition Download MyChart Test Results Record Download MyChart Preventive Care Attestation Upload Incoming Network Interface Lab Instrument Image Lab External Image Lab Image Mobile Jot Activity Automatic Patient Education Research Data Capture My Files Export Communication PDF Clinical Case Management PDF Regenerated Communication PDF Shell Communication PDF FMK Medication Card FMK Dose Dispense Card Referral Scan Referral Authorization Unlinked Referral Document Tapestry ID Card Generation Tapestry Authorization Additional Information Attachment Tapestry Link Additional Information Attachment Tapestry 275 Claim Attachment Tapestry 275 Authorization Attachment Tapestry Da Vinci PAS Additional Information Attachment Tapestry Payer Exchange Clinical Attachment Managed Care Periodic Explanation of Benefits Batch Managed Care Periodic Summary Batch Tapestry Native Scan Payer Notification Communication Consent Tapestry Link Online Enrollment Attachment Binary Document Transfer Claim RFI Document Community Upload Community Order Upload Community Referral Upload Community CRM Upload Enter/Edit Results Scan HH Care Summary Mobile Diagram Annotation Clinical Mobile Media Capture Electronic Prior Authorization Attachment Secure Chat Media Secure Chat Media - Linked to Chart Long Term Care PDFs Release of Information Estimate Payment Collection Consent Waveform Device Image Ambulatory Pharmacy Sale Ambulatory Pharmacy Scan Ambulatory Pharmacy Fax Pharmacy Preparation Image Archived Procedural Result Shell Procedural Result PDF Cardiology Annotated Image Linked Wound Image Generated Form Document Builder - Communication Management Document Builder - Case Management Document Builder - Referrals Document Builder - Electronic Prior Authorization Pedigree Reporting Workbench Payer Platform Wound Boundary Annotation Social Care Calculation MyChart Bedside MyChart Bedside Friends & Family Update Upload MyChart Bedside Friends & Family E-Card Continued Care Patient Choice Specialty Plan Of Care E-Signature
67	RX_CUST_ID_TYPE_C_NAME	VARCHAR	No
	This item contains the categories for the types of customer ID documents used to pick up prescriptions from outpatient pharmacies. May contain organization-specific values: Yes Category Entries: Driver's License Passport Employee ID State ID Military ID Alien Registration Card Institution Other
68	RX_CUST_ID_NUM	VARCHAR	No
	This item contains the customer ID number.
69	CE_SERVICE_START_DATE	DATETIME	No
	Service start date for a received Care Everywhere external authorization
70	CE_SERVICE_END_DATE	DATETIME	No
	Service end date for a received Care Everywhere external authorization
71	DOC_PND_APRV_STAT_C_NAME	VARCHAR	No
	Holds status of document undergoing review May contain organization-specific values: No Category Entries: Pending Approval Rejected
72	DOC_REJ_RSN_C_NAME	VARCHAR	No
	Denial reason May contain organization-specific values: Yes Category Entries: Invalid signature Missing documentation Inconsistent documentation Illegible Invalid form Missing signature Relationship doesn't match document Relationship not supported by current documentation Contact name and document do not match
73	DOC_REJ_RSN_TEXT	VARCHAR	No
	Rejection reason freetext
74	COMM_ORIG_LRP_ID	VARCHAR	No
	This item stores the original report (LRP) ID when a report is converted to a PDF.
75	COMM_ORIG_LRP_ID_REPORT_NAME	VARCHAR	No
	The name of the report
76	CREATED_STUDY_AMENDMENT	INTEGER	No
	The ID of the research study amendment considered to be the consent version signed for Research Consent type document (DCS) records. Use the RESEARCH_STUDY_ID column to link to RESEARCH_VERSION_INFO table which has the user-entered version number (STUDY_VERSION) as well as other information.
77	EFF_STUDY_AMENDMENT	INTEGER	No
	The ID of the research study amendment considered to be the current effective version for Research Consent type document (DCS) records. Use the RESEARCH_STUDY_ID column to link to RESEARCH_VERSION_INFO table which has the user-entered version number (STUDY_VERSION) as well as other information.