Tables [dbo].[Document]
A versioned storage for various kinds of documents (clinical notes, reminders, etc.)
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Document_DocumentID: DocumentIDIndexes TWstat_Document_AccessionNumber_PatientID_DocumentID, TWstat_Document_AuthoredDTTM_PatientID_DocumentID, TWstat_Document_ChartLocationDE_PatientID_DocumentID, TWstat_Document_DictatedDTTM_PatientID_DocumentID, TWstat_Document_DictationSystemJobNo_PatientID_DocumentID, TWstat_Document_EIEDTTM_PatientID_DocumentID, TWstat_Document_EIEID_PatientID_DocumentID, TWstat_Document_EXTSequenceID_PatientID_DocumentID, TWstat_Document_IDXDocumentTypeDE_PatientID_DocumentID, TWstat_Document_InterfaceID_PatientID_DocumentID, TWstat_Document_LastEditDTTM_PatientID_DocumentID, TWstat_Document_LastEditID_PatientID_DocumentID, TWstat_Document_NextAmendmentNumber_PatientID_DocumentID, TWstat_Document_NextVersionID_PatientID_DocumentID, TWstat_Document_OwnerID_PatientID_DocumentID, TWstat_Document_PhysicalManifestationDE_PatientID_DocumentID, TWstat_Document_PreviousVersionID_PatientID_DocumentID, TWstat_Document_Priority_PatientID_DocumentID, TWstat_Document_RecordedDTTM_PatientID_DocumentID, TWstat_Document_ServiceDTTM_PatientID_DocumentID, TWstat_Document_SiteDE_PatientID_DocumentID, TWstat_Document_Status_PatientID_DocumentID, TWstat_Document_TransactionDTTM_PatientID_DocumentID, TWstat_Document_TranscribedDTTM_PatientID_DocumentID, TWstat_Document_Transcriptionist_PatientID_DocumentID, TWstat_Document_VerificationRequiredFLAG_PatientID_DocumentID, TWstat_Document_VerifiedDTTM_PatientID_DocumentID, TWstat_Document_VerifiedID_PatientID_DocumentID(28)DocumentID[dbo].[uniqueid]9NOT NULLKey to the Document table
Indexes NIX_Document_ExtDocumentID_EXTSequenceID_INC_RecordedDTTM, NIX_Document_PhysicalManifestationDE_RecordedDTTM_WithIncludeColumns(2)EXTDocumentIDvarchar(255)255NULL allowedExternal document ID originating from an interface.  Shadowed in table DocumentIDGenerator, and sometimes in column AccessionNumber
Indexes NIX_Document_ExtDocumentID_EXTSequenceID_INC_RecordedDTTM, TWstat_Document_EXTSequenceID_PatientID_DocumentID(2)EXTSequenceIDvarchar(255)255NULL allowedExternal sequence, although typically zero.
Indexes NIX_Document_EncounterID_WithIncludeColumns, NIX_Document_NextVersionID_RecordedDTTM_WithIncludeColumns, NIX_Document_OriginatingDocumentID_NextVersionID_WithIncludeColumns, NIX_Document_PatientID_WithIncludeColumns, NIX_Document_PhysicalManifestationDE_RecordedDTTM_WithIncludeColumns, NIX_Document_RecordedDTTM_WithIncludeColumns_IsArchived, TWstat_Document_AccessionNumber_PatientID_DocumentID, TWstat_Document_AuthoredDTTM_PatientID_DocumentID, TWstat_Document_ChartLocationDE_PatientID_DocumentID, TWstat_Document_DictatedDTTM_PatientID_DocumentID, TWstat_Document_DictationSystemJobNo_PatientID_DocumentID, TWstat_Document_EIEDTTM_PatientID_DocumentID, TWstat_Document_EIEID_PatientID_DocumentID, TWstat_Document_EXTSequenceID_PatientID_DocumentID, TWstat_Document_IDXDocumentTypeDE_PatientID_DocumentID, TWstat_Document_InterfaceID_PatientID_DocumentID, TWstat_Document_LastEditDTTM_PatientID_DocumentID, TWstat_Document_LastEditID_PatientID_DocumentID, TWstat_Document_NextAmendmentNumber_PatientID_DocumentID, TWstat_Document_NextVersionID_PatientID_DocumentID, TWstat_Document_OwnerID_PatientID_DocumentID, TWstat_Document_PhysicalManifestationDE_PatientID_DocumentID, TWstat_Document_PreviousVersionID_PatientID_DocumentID, TWstat_Document_Priority_PatientID_DocumentID, TWstat_Document_RecordedDTTM_PatientID_DocumentID, TWstat_Document_ServiceDTTM_PatientID_DocumentID, TWstat_Document_SiteDE_PatientID_DocumentID, TWstat_Document_Status_PatientID_DocumentID, TWstat_Document_TransactionDTTM_PatientID_DocumentID, TWstat_Document_TranscribedDTTM_PatientID_DocumentID, TWstat_Document_Transcriptionist_PatientID_DocumentID, TWstat_Document_VerificationRequiredFLAG_PatientID_DocumentID, TWstat_Document_VerifiedDTTM_PatientID_DocumentID, TWstat_Document_VerifiedID_PatientID_DocumentID(34)PatientID[dbo].[uniqueid]9NULL allowedPoints to the patient that this document belongs to.
Indexes NIX_Document_NextVersionID_RecordedDTTM_WithIncludeColumns, NIX_Document_PatientID_WithIncludeColumns, NIX_Document_PhysicalManifestationDE_RecordedDTTM_WithIncludeColumns, NIX_Document_RecordedDTTM_WithIncludeColumns_IsArchived(4)AuthorID[dbo].[uniqueid]9NULL allowedPoints to the author of this document.
Indexes NIX_Document_NextVersionID_RecordedDTTM_WithIncludeColumns, NIX_Document_PatientID_WithIncludeColumns, TWstat_Document_IDXDocumentTypeDE_PatientID_DocumentID(3)IDXDocumentTypeDE[dbo].[dict_id]5NOT NULLPoints to IDX_Document_Type_DE.  Major type (Notes, Results, Correspondence, Encounter Form)
Indexes NIX_Document_EncounterID_WithIncludeColumns, NIX_Portal_Document_LastEditDTTM_WithIncludeColumns, NIX_Document_NextVersionID_RecordedDTTM_WithIncludeColumns, NIX_Document_OriginatingDocumentID_NextVersionID_WithIncludeColumns, NIX_Document_PatientID_WithIncludeColumns, NIX_Document_RecordedDTTM_WithIncludeColumns_IsArchived(6)DocumentTypeDE[dbo].[dict_id]5NOT NULLPoints to Document_Type_DE.  Useful for grouping various kinds of documents
Indexes NIX_Document_EncounterID_WithIncludeColumns, NIX_Portal_Document_LastEditDTTM_WithIncludeColumns, NIX_Document_NextVersionID_RecordedDTTM_WithIncludeColumns, NIX_Document_OriginatingDocumentID_NextVersionID_WithIncludeColumns, NIX_Document_PatientID_WithIncludeColumns, NIX_Document_PhysicalManifestationDE_RecordedDTTM_WithIncludeColumns, NIX_Document_RecordedDTTM_WithIncludeColumns_IsArchived, TWstat_Document_PhysicalManifestationDE_PatientID_DocumentID(8)PhysicalManifestationDE[dbo].[dict_id]5NOT NULLPoints to PhysicalManifestation_DE.  Describes the file type of the document body, or the module used (e.g. v11 note, PDF, TIF, RTF)
Indexes TWstat_Document_NextAmendmentNumber_PatientID_DocumentIDNextAmendmentNumberint4NOT NULL(1)A sequence to indicate a subsequent amendment.
EditableChunkvarchar(max)maxNULL allowedobsolete (see EditableChunkCompressed)
UneditableChunkvarchar(max)maxNULL allowedobsolete (see UnEditableChunkCompressed)
Indexes NIX_Document_ExtDocumentID_EXTSequenceID_INC_RecordedDTTM, NIX_Portal_Document_LastEditDTTM_WithIncludeColumns, NIX_Document_NextVersionID_RecordedDTTM_WithIncludeColumns, NIX_Document_PatientID_WithIncludeColumns, NIX_Document_PhysicalManifestationDE_RecordedDTTM_WithIncludeColumns, NIX_Document_RecordedDTTM_WithIncludeColumns_IsArchived, TWstat_Document_RecordedDTTM_PatientID_DocumentID(7)RecordedDTTMdatetime8NOT NULLThe system time when the row was inserted (not the clinical "recorded" time)
Indexes NIX_Portal_Document_LastEditDTTM_WithIncludeColumns, NIX_Document_NextVersionID_RecordedDTTM_WithIncludeColumns, NIX_Document_PatientID_WithIncludeColumns, TWstat_Document_LastEditDTTM_PatientID_DocumentID(4)LastEditDTTMdatetime8NULL allowedThe time when the document was last edited.
Indexes TWstat_Document_LastEditID_PatientID_DocumentIDLastEditID[dbo].[uniqueid]9NULL allowedPoints to the user who last edited the document.
Indexes TWstat_Document_VerifiedDTTM_PatientID_DocumentIDVerifiedDTTMdatetime8NULL allowedThe time when the document was verified.
Indexes NIX_Document_NextVersionID_RecordedDTTM_WithIncludeColumns, NIX_Document_PatientID_WithIncludeColumns, TWstat_Document_VerifiedID_PatientID_DocumentID(3)VerifiedID[dbo].[uniqueid]9NULL allowedPoints to the user who verified the document.
Indexes TWstat_Document_EIEDTTM_PatientID_DocumentIDEIEDTTMdatetime8NULL allowedThe time when the document was invalidated.  (01/01/1900 means NULL)
Indexes NIX_Document_EncounterID_WithIncludeColumns, NIX_Portal_Document_LastEditDTTM_WithIncludeColumns, NIX_Document_NextVersionID_RecordedDTTM_WithIncludeColumns, NIX_Document_OriginatingDocumentID_NextVersionID_WithIncludeColumns, NIX_Document_PatientID_WithIncludeColumns, TWstat_Document_EIEID_PatientID_DocumentID(6)EIEID[dbo].[uniqueid]9NULL allowedPoints to the user who invalidated the document.
Indexes TWstat_Document_PreviousVersionID_PatientID_DocumentIDPreviousVersionID[dbo].[uniqueid]9NOT NULL(0)Points to the previous version of the document.  When zero, this is the start of the version chain.
Indexes NIX_Document_EncounterID_WithIncludeColumns, NIX_Document_NextVersionID_RecordedDTTM_WithIncludeColumns, NIX_Document_OriginatingDocumentID_NextVersionID_WithIncludeColumns, NIX_Document_PatientID_WithIncludeColumns, NIX_Document_PhysicalManifestationDE_RecordedDTTM_WithIncludeColumns, NIX_Document_RecordedDTTM_WithIncludeColumns_IsArchived, TWstat_Document_NextVersionID_PatientID_DocumentID(7)NextVersionID[dbo].[uniqueid]9NOT NULL(0)Points to the next version of the document.  When zero, this is the end of the version chain.
Indexes NIX_Document_AccessionNumber_INC_OriginatingDocumentID, NIX_Portal_Document_LastEditDTTM_WithIncludeColumns, NIX_Document_PhysicalManifestationDE_RecordedDTTM_WithIncludeColumns, TWstat_Document_AccessionNumber_PatientID_DocumentID(4)AccessionNumbervarchar(255)255NULL allowedFor scanned images, starts with "AIC" and the subsequent digits point to column DocumentID in table Impact..Doc_Header
Indexes NIX_Document_EncounterID_WithIncludeColumns, NIX_Portal_Document_LastEditDTTM_WithIncludeColumns, NIX_Document_NextVersionID_RecordedDTTM_WithIncludeColumns, NIX_Document_OriginatingDocumentID_NextVersionID_WithIncludeColumns, NIX_Document_PatientID_WithIncludeColumns, NIX_Document_PhysicalManifestationDE_RecordedDTTM_WithIncludeColumns, NIX_Document_RecordedDTTM_WithIncludeColumns_IsArchived(7)EncounterID[dbo].[uniqueid]9NOT NULLPoints to the Encounter that this document is associated with.
Indexes TWstat_Document_Transcriptionist_PatientID_DocumentIDTranscriptionistvarchar(255)255NULL allowedWho transcribed this document
Indexes TWstat_Document_TranscribedDTTM_PatientID_DocumentIDTranscribedDTTMdatetime8NULL allowedWhen the transcribing occurred.
Indexes TWstat_Document_DictatedDTTM_PatientID_DocumentIDDictatedDTTMdatetime8NULL allowedWhen the dictation occurred.
Indexes TWstat_Document_VerificationRequiredFLAG_PatientID_DocumentIDCheck Constraints CK_Document_VerificationRequiredFLAG_Yes_Or_No : ([VerificationRequiredFLAG]='N' OR [VerificationRequiredFLAG]='Y')VerificationRequiredFLAG[dbo].[BOOL]1NULL allowedIs verification of the document required?  (typically when author is not a provider)
BinaryChunkvarbinary(max)maxNULL allowedImage
Indexes NIX_Document_EncounterID_WithIncludeColumns, NIX_Portal_Document_LastEditDTTM_WithIncludeColumns, NIX_Document_NextVersionID_RecordedDTTM_WithIncludeColumns, NIX_Document_OriginatingDocumentID_NextVersionID_WithIncludeColumns, NIX_Document_PatientID_WithIncludeColumns, NIX_Document_PhysicalManifestationDE_RecordedDTTM_WithIncludeColumns, NIX_Document_RecordedDTTM_WithIncludeColumns_IsArchived, TWstat_Document_Status_PatientID_DocumentID(8)Statusvarchar(50)50NULL allowed('Unsigned')Textual status term; may be a compound  (e.g. "Amended, Signed")
Indexes TWstat_Document_ChartLocationDE_PatientID_DocumentIDForeign Keys FK_Document_Chart_Location_DE: [dbo].[Chart_Location_DE].ChartLocationDEChartLocationDE[dbo].[dict_id]5NOT NULL(0)Key to the Chart_Location_DE table.
Indexes NIX_Portal_Document_LastEditDTTM_WithIncludeColumns, NIX_Document_NextVersionID_RecordedDTTM_WithIncludeColumns, NIX_Document_OriginatingDocumentID_NextVersionID_WithIncludeColumns, NIX_Document_PatientID_WithIncludeColumns, TWstat_Document_OwnerID_PatientID_DocumentID(5)OwnerID[dbo].[uniqueid]9NULL allowedPoints to the provider who is assigned as the owner.
Indexes TWstat_Document_DictationSystemJobNo_PatientID_DocumentIDDictationSystemJobNovarchar(255)255NULL allowedDictation system job number
Indexes TWstat_Document_Priority_PatientID_DocumentIDPriority[dbo].[uniqueid]9NULL allowedThe priority of this document
Indexes TWstat_Document_TransactionDTTM_PatientID_DocumentIDTransactionDTTMdatetime8NULL allowedTime of the transaction
Indexes TWstat_Document_ServiceDTTM_PatientID_DocumentIDServiceDTTMdatetime8NULL allowedDate-of-service date/time
Indexes TWstat_Document_AuthoredDTTM_PatientID_DocumentIDAuthoredDTTMdatetime8NULL allowedWhen the document was authored, in contrast to RecordedDTTM.
Indexes TWstat_Document_InterfaceID_PatientID_DocumentIDInterfaceIDint4NULL allowedInterface source ID
Indexes NIX_Document_NextVersionID_RecordedDTTM_WithIncludeColumns, NIX_Document_PhysicalManifestationDE_RecordedDTTM_WithIncludeColumns, NIX_Document_RecordedDTTM_WithIncludeColumns_IsArchived, TWstat_Document_SiteDE_PatientID_DocumentID(4)Foreign Keys FK_Document_SiteDE_Site_DE_ID: [dbo].[Site_DE].SiteDESiteDE[dbo].[dict_id]5NULL allowedKey to the Site_DE table.
Indexes NIX_Document_AccessionNumber_INC_OriginatingDocumentID, NIX_Document_EncounterID_WithIncludeColumns, NIX_Document_NextVersionID_RecordedDTTM_WithIncludeColumns, NIX_Document_OriginatingDocumentID_NextVersionID_WithIncludeColumns, NIX_Document_PatientID_WithIncludeColumns, NIX_Document_PhysicalManifestationDE_RecordedDTTM_WithIncludeColumns, NIX_Document_RecordedDTTM_WithIncludeColumns_IsArchived(7)OriginatingDocumentID[dbo].[uniqueid]9NOT NULL((0))Points to the start of the version chain.
EditableChunkCompressedvarbinary(max)maxNULL allowedCompressed content (body) of the document (varies by Manifestation)
UnEditableChunkCompressedvarbinary(max)maxNULL allowedCompressed content (body) of the document (varies by Manifestation)
Indexes NIX_Document_RecordedDTTM_WithIncludeColumns_IsArchivedIsArchivedbit1NULL allowedIs BLOB data moved to Archive Database(0/1)?
TextTemplateID[dbo].[uniqueid]9NULL allowedText Template used to create the document
IsMUNonClinicalSetting[dbo].[BOOL]1NOT NULL('N')Y =  Non-Clinical Document
N= Clinical Document
ClientTimeZonevarchar(5)5NULL allowedWindows TimeZone Abbreviation of the client machine where document creation was initiated