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

Primary Key
Column Name Ordinal Position
DOCUMENT_ID 1

Column Information
Name Type Discontinued?
1 DOCUMENT_ID VARCHAR No
The unique identifier (.1 item) for the document record.
2 DOC_RDI_ID NUMERIC No
Stores the linked form (RDI) that contains key-value pairs.
3 COMM_ORIG_RDI_ID NUMERIC No
This item stores the original form (RDI) ID when a form is converted to a PDF.
4 RSH_LAST_UPDATE_USER_ID VARCHAR No
The last user who updated the research data capture form.
5 RSH_LAST_UPDATE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
6 RSH_LAST_UPDATE_UTC_DTTM DATETIME (UTC) No
The last instant this data capture form was updated.
7 RSH_FORM_STAT_C_NAME VARCHAR No
Used to indicate whether or not all of the required fields on an esignature document's smartform have been completed.
May contain organization-specific values: No
Category Entries:
New
In Progress
Void
Complete
Error
Rejected
8 DOC_SPEC_TYPE_C_NAME VARCHAR No
The document specialty for a document (DCS) record.
May contain organization-specific values: Yes
9 DOC_SUBSPECIALTY_C_NAME VARCHAR No
This item stores the document subspecialty for a document (DCS) record
May contain organization-specific values: Yes
10 TMPLT_SF_FORM_ID VARCHAR No
The unique ID of the SmartForm used to collect information for this document. Should be used in conjunction with DOC_INFORMATION.TMPLT_SF_CNTCT to identify the SmartForm Record.
11 TMPLT_SF_FORM_ID_FORM_NAME VARCHAR No
The name of the form associated with the questionnaire.
12 RSH_FORM_NAME VARCHAR No
The instance name for the research data capture form.
13 DOCUMENT_USAGE_C_NAME VARCHAR No
The document usage category ID for the document record.
May contain organization-specific values: No
Category Entries:
Financial Assistance Patient
Financial Assistance Case
14 BLOB_CATEGORY_C_NAME VARCHAR No
The blob category for the document.
May contain organization-specific values: Yes
Category Entries:
SCAN
VOICE
ANNOTATION
VIDEO
RAW DEPTH MAP
ECG
SPIRO
HOLTER RESULT
HOLTER ANALYSIS
WAVEFORM STRIP
ESIG
Virtual Authorization
PHOTO
LINK
DOCUMENT
REPORT VIEWER
CHF
DICOM Study
DICOM Series
DICOM Image
TEMPORARY
15 RX_CUST_ID_OWNER_NAM_RECORD_ID VARCHAR No
This item contains a pointer to the name record of the owner of the customer ID used to pick up the prescriptions for the patient from outpatient pharmacies.
16 ESIG_ACCESSIBLE_PDF_FILE VARCHAR No
Stores the file name for the accessible PDF of this document on the BLOB.
17 SERIES_SEQ_NUM INTEGER No
The sequence number of the series in a DICOM study (attribute 0020,0011).
18 PS_SERIES_UID VARCHAR No
The instance UID of the series that has the presentation state for the image.
19 PS_UID VARCHAR No
The presentation state instance UID for the image.
20 IMAGE_SEQUENCE_NUM INTEGER No
The image sequence number within the series (attribute 0020,0013).
21 IMG_SLCT_TYPE_C_NAME VARCHAR No
The category ID indicating how the DICOM image associated with the record was selected, including if it was computer selected or marked as a key image.
May contain organization-specific values: No
Category Entries:
None
Computer Selected
Key Image
22 FILE_CREATION_TIME VARCHAR No
Stores the timestamp in HL7 format of when the file was created on the blob or DMS server.
23 FILE_LAST_UPD_TIME VARCHAR No
Timestamp in HL7 format of when the image was last updated.
24 FILE_TYPE VARCHAR No
Mime type of the image/document.
25 CLN_DOC_SRC_APT_PAT_ENC_CSN_ID NUMERIC No
The appointment that a Document Information (DCS) record was attached to before it was moved to a Clinical Documentation Only encounter.
26 ENROLL_ID NUMERIC No
The unique ID of the research study association that has been linked to this document.
27 FILE_CREATION_DTTM DATETIME (UTC) No
Stores the file creation time of the document on the Web Blob Server (WBS)
28 DEFERRED_GEN_STATUS_C_NAME VARCHAR No
The deferred generation status category ID for the document. This field is only used for deferred generation documents.
May contain organization-specific values: No
Category Entries:
Not Started
In Progress
Complete
Failed
29 DOC_TX_ID NUMERIC No
Stores ETR ID for the service-line on a claim that the document is associated with, used by Tapestry
30 START_DOC_PERIOD_DATE DATETIME No
Start date of document period.
31 END_DOC_PERIOD_DATE DATETIME No
End date of document period.
32 CLM_ATTACH_CTL_NUM VARCHAR No
Attachment control number for electronic attachments. This is used to identify electronic attachments for a claim in an ANSI X12 275.
33 CLM_PROV_ACCT_NUM VARCHAR No
Provider submitted account number for electronic attachments. This is used to identify electronic attachments for a claim in an ANSI X12 275.
34 CLAIM_VENDOR_NPI NUMERIC No
NPI of the vendor sent in ANSI X12 275. This is used to identify electronic attachments for a claim in an ANSI X12 275.
35 COPIED_FROM_DOCUMENT_ID VARCHAR No
This item links to the original DCS record that this record was copied from.
36 DOCUMENT_IDENT_SOURCE_C_NAME VARCHAR No
Indicates whether the identifier for this document, which is stored in item 350, is a native Epic identifier, or an identifier assigned by external system. When this item is set to 1-Native, the identifier refers to binary data that was uploaded through the Blob service. If the identifier was generated by an external system, this item is set to 2-External. If this item is set to 0-Unknown or not set, then other items must be used to determine if item 350 is a Blob or external identifier.
May contain organization-specific values: No
Category Entries:
Unknown
Native
External
37 EOB_MEMBER_SHARE_AMOUNT NUMERIC No
Total amount a member is responsible for, for all the claims included in an Explanation of Benefits document.
38 DOC_SOURCE_ROI_ID VARCHAR No
Stores the ROI ID used to generate a composite document (DCS). A composite document represents one or more contexts which is included in the ROI.
39 RX_CUST_ID_BIRTH_DATE DATETIME No
The date of birth of the customer ID holder.
40 RX_CUST_ID_CITY VARCHAR No
The city component of the address from the customer ID.
41 RX_CUST_ID_STATE_C_NAME VARCHAR No
The state component of the address from the customer ID.
May contain organization-specific values: Yes
42 RX_CUST_ID_ZIP VARCHAR No
The postal code component of the address from the customer ID.
43 RX_CUST_ID_COUNTY_C_NAME VARCHAR No
The county component of the address from the customer ID.
May contain organization-specific values: Yes
44 RX_CUST_ID_COUNTRY_C_NAME VARCHAR No
The country component of the address from the customer ID.
May contain organization-specific values: Yes
45 RX_CUST_ID_DISTRCT_C_NAME VARCHAR No
The district component of the address from the customer ID.
May contain organization-specific values: Yes
46 RX_CUST_ID_HOUSE_NUM VARCHAR No
The house number component of the address from the customer ID.
47 CREATED_BY_USER_ID VARCHAR No
The user who created the document.
48 CREATED_BY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
49 CREATED_INST_UTC_DTTM DATETIME (UTC) No
The date and time the document was created.
50 INDEXED_BY_USER_ID VARCHAR No
The user who indexed the document.
51 INDEXED_BY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
52 INDEXED_INST_UTC_DTTM DATETIME (UTC) No
The date and time the document was indexed.
53 DOC_APPEAL_GRV_ID NUMERIC No
Stores the TAG ID for the appeal or grievance that the document is associated with.
54 DEPTH_CAPT_STATUS_C_NAME VARCHAR No
Whether depth information was captured on an image, or why depth was unable to be obtained. Only applies to images.
May contain organization-specific values: No
Category Entries:
None
Not depth capable
Depth captured
No depth, but depth capable device
55 LINK_DEPTH_DCS_ID VARCHAR No
Stores the ID for the DCS record of the depth map taken with the image.
56 DEPTH_ACCURACY_C_NAME VARCHAR No
Depth map accuracy measured on mobile when taking a wound image.
May contain organization-specific values: No
Category Entries:
Relative
Absolute
57 DEPTH_QUALITY_C_NAME VARCHAR No
Depth map quality measured on mobile when taking a wound image.
May contain organization-specific values: No
Category Entries:
Low
High