Tables [dbo].[Document_Type_de]
Classifications for grouping documents by similar content and workflows
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Document_Type_de_ID: IDIndexes NIX_Document_Type_DE_ID, TWstat_Document_Type_de_AutoCCFLAG_ID, TWstat_Document_Type_de_DefinitionSetID_ID, TWstat_Document_Type_de_DisplayNoteIconOnSchedFLAG_ID, TWstat_Document_Type_de_Entry_ID, TWstat_Document_Type_de_EntryName_ID, TWstat_Document_Type_de_IncludeInUnsigned_ID, TWstat_Document_Type_de_IsEnforcedFLAG_ID, TWstat_Document_Type_de_IsInactiveFLAG_ID, TWstat_Document_Type_de_IsLetterFLAG_ID, TWstat_Document_Type_de_IsScanResultFLAG_ID(11)IDnumeric(8,0)5NOT NULL1 - 1Key to the document_type_de table
Foreign Keys FK_Document_Type_de_EnterpriseEntryID_Dictionary_Entry_EnterpriseEntryID: [dbo].[Dictionary_Entry].EnterpriseEntryIDEnterpriseEntryIDnumeric(16,0)9NULL allowedMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes TWstat_Document_Type_de_DefinitionSetID_IDForeign Keys FK_Document_Type_de_DefinitionSetID_Definition_Set_DefinitionSetID: [dbo].[Definition_Set].DefinitionSetIDDefinitionSetIDnumeric(8,0)5NULL allowedPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Indexes TWstat_Document_Type_de_Entry_IDEntrynumeric(8,0)5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes NIX_Document_Type_DE_IDEntryCodechar(10)10NOT NULLUnique alphanumeric code.  Brief but cryptic.
Indexes NIX_Document_Type_DE_ID, TWstat_Document_Type_de_EntryName_ID(2)EntryNamevarchar(255)255NOT NULLUnique alphanumeric "friendly" display name
EntryMnemonicchar(10)10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique.
Indexes TWstat_Document_Type_de_IsInactiveFLAG_IDCheck Constraints CK_Document_Type_de_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLY=row is not active; N=row is active.  (Rows are inactivated rather than deleted for history)
Indexes TWstat_Document_Type_de_IsEnforcedFLAG_IDCheck Constraints CK_Document_Type_de_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Check Constraints CK_Document_Type_de_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLUsually 'Y' but occasionally used to subordinate rows.  Not exposed to the end user.
EffectiveDTdatetime8NULL allowedTime of last modification  (not "when this row goes into effect")
Foreign Keys FK_Document_Type_de_IDXDocumentTypeDE_IDX_Document_Type_DE_id: [dbo].[IDX_Document_Type_DE].IDXDocumentTypeDEIDXDocumentTypeDE[dbo].[dict_id]5NOT NULL(0)Key to the IDX_Document_Type_DE table.
Foreign Keys FK_Document_Type_de_ReqSignatureAuthorityDE_Signature_Authority_DE_ID: [dbo].[Signature_Authority_DE].ReqSignatureAuthorityDEReqSignatureAuthorityDE[dbo].[dict_id]5NOT NULL(0)Key to the Signature_Authority_DE table.
Check Constraints CK_Document_Type_de_PromptforSigFLAG_Yes_Or_No : ([PromptforSigFLAG]='N' OR [PromptforSigFLAG]='Y')PromptforSigFLAG[dbo].[BOOL]1NOT NULL('N')Specifies if a dialog box prompting the signing user to identify a second user to sign the note is presented immediately after the first user signs the document.
Check Constraints CK_Document_Type_de_PrintTaskonSignFLAG_Yes_Or_No : ([PrintTaskonSignFLAG]='N' OR [PrintTaskonSignFLAG]='Y')PrintTaskonSignFLAG[dbo].[BOOL]1NOT NULL('N')If 'Y' then do not create a sign task.
Check Constraints CK_Document_Type_de_PrintOnSignFLAG_Yes_Or_No : ([PrintOnSignFLAG]='N' OR [PrintOnSignFLAG]='Y')PrintOnSignFLAG[dbo].[BOOL]1NOT NULL('N')obsolete (now done in Queue Admin)
Check Constraints CK_Document_Type_de_NoSigRequiredFLAG_Yes_Or_No : ([NoSigRequiredFLAG]='N' OR [NoSigRequiredFLAG]='Y')NoSigRequiredFLAG[dbo].[BOOL]1NOT NULL('N')obsolete (now done in Queue Admin)
Check Constraints CK_Document_Type_de_PrintTaskOnFinalizationFLAG_Yes_Or_No : ([PrintTaskOnFinalizationFLAG]='N' OR [PrintTaskOnFinalizationFLAG]='Y')PrintTaskOnFinalizationFLAG[dbo].[BOOL]1NOT NULL('N')obsolete (now done in Queue Admin)
DefaultPhysicalManifestationDE[dbo].[dict_id]5NOT NULL(20)The format of the document (PDF, TIF, CCDA, v11 note, etc).   Points to PhysicalManifestation_DE
Indexes TWstat_Document_Type_de_IncludeInUnsigned_IDIncludeInUnsignedchar(1)1NOT NULL('N')Specifies if this document type is included in the Unsigned Notes report.
Foreign Keys FK_Document_Type_de_WorkFlowTypeDE_Workflow_Type_DE_ID: [dbo].[Workflow_Type_DE].WorkFlowTypeDEWorkFlowTypeDE[dbo].[dict_id]5NULL allowed(0)Key to the Workflow_Type_DE table.
DifficultyFactornumeric(2,1)5NULL allowed(1.0)Dictating provider's level of dictation difficulty (due to accent, subject matter, etc.) for transcribing this document type.
Check Constraints CK_Document_Type_de_CreateTaskOnAmendFLAG_Yes_Or_No : ([CreateTaskOnAmendFLAG]='N' OR [CreateTaskOnAmendFLAG]='Y')CreateTaskOnAmendFLAG[dbo].[BOOL]1NULL allowedIf 'Y' creates a sign note task when previously signed document has been Amended.  (not v11)
Check Constraints CK_Document_Type_de_PromptforSigOverrideFLAG_Yes_Or_No : ([PromptforSigOverrideFLAG]='N' OR [PromptforSigOverrideFLAG]='Y')PromptforSigOverrideFLAG[dbo].[BOOL]1NOT NULL('N')Specifies whether users can override the necessary signature authority specified for this document type.  (not v11)
Indexes TWstat_Document_Type_de_DisplayNoteIconOnSchedFLAG_IDCheck Constraints CK_Document_Type_de_DisplayNoteIconOnSchedFLAG_Yes_Or_No : ([DisplayNoteIconOnSchedFLAG]='N' OR [DisplayNoteIconOnSchedFLAG]='Y')DisplayNoteIconOnSchedFLAG[dbo].[BOOL]1NOT NULL('Y')Specifies whether a note icon appears on the schedule for this doc type.
Indexes TWstat_Document_Type_de_IsScanResultFLAG_IDCheck Constraints CK_Document_Type_de_IsScanResultFLAG_Yes_Or_No : ([IsScanResultFLAG]='N' OR [IsScanResultFLAG]='Y')IsScanResultFLAG[dbo].[BOOL]1NOT NULL('N')Specifies whether to flag scanned document types as a result within ChartViewer.
Indexes TWstat_Document_Type_de_IsLetterFLAG_IDCheck Constraints CK_Document_Type_de_IsLetterFLAG_Yes_Or_No : ([IsLetterFLAG]='N' OR [IsLetterFLAG]='Y')IsLetterFLAGchar(1)1NOT NULL('N')Specifies whether to allow users to create letters derived from notes with a suitable salutation and closing.  (not v11)
Indexes TWstat_Document_Type_de_AutoCCFLAG_IDCheck Constraints CK_Document_Type_de_AutoCCFLAG_Yes_Or_No : ([AutoCCFLAG]='N' OR [AutoCCFLAG]='Y')AutoCCFLAG[dbo].[BOOL]1NOT NULL('N')Specifies if this document type can automatically be carbon copied. (not v11)
Check Constraints CK_Document_Type_de_eReplyFlag_Yes_Or_No : ([eReplyFlag]='N' OR [eReplyFlag]='Y')eReplyFlag[dbo].[BOOL]1NOT NULL('N')Specifies whether a document can be used to reply to Patient online (eReply).
Check Constraints CK_Document_Type_de_CreateReferringProviderNotificationTaskFLAG_Yes_Or_No : ([CreateReferringProviderNotificationTaskFLAG]='N' OR [CreateReferringProviderNotificationTaskFLAG]='Y')CreateReferringProviderNotificationTaskFLAG[dbo].[BOOL]1NOT NULL('N')If 'Y' creates a delegated task linked to the note owner indicating that a referring provider should be notified.
Check Constraints CK_Document_Type_de_CreatePatientNotificationTaskFLAG_Yes_Or_No : ([CreatePatientNotificationTaskFLAG]='N' OR [CreatePatientNotificationTaskFLAG]='Y')CreatePatientNotificationTaskFLAG[dbo].[BOOL]1NOT NULL('N')If 'Y' creates a delegated task of the note owner indicating the patient should be notified.
Check Constraints CK_Document_Type_de_CreateReviewCoveredNoteTaskonFinalizationFLAG_Yes_Or_No : ([CreateReviewCoveredNoteTaskonFinalizationFLAG]='N' OR [CreateReviewCoveredNoteTaskonFinalizationFLAG]='Y')CreateReviewCoveredNoteTaskonFinalizationFLAG[dbo].[BOOL]1NOT NULL('N')If 'Y' creates a task for the appointment encounter provider to review the note that was finalized by the covering physician.
Check Constraints CK_Document_Type_de_AmendOnAnnotationFLAG_Yes_Or_No : ([AmendOnAnnotationFLAG]='N' OR [AmendOnAnnotationFLAG]='Y')AmendOnAnnotationFLAG[dbo].[BOOL]1NOT NULL('N')Determines whether to change the note status to Amended when an annotation is added on the note.
Check Constraints CK_Document_Type_de_AmendOnEncounterChangeFLAG_Yes_Or_No : ([AmendOnEncounterChangeFLAG]='N' OR [AmendOnEncounterChangeFLAG]='Y')AmendOnEncounterChangeFLAG[dbo].[BOOL]1NOT NULL('N')Determines whether to change the note status to Amended when the encounter tied to the note has been changed.
Check Constraints CK_Document_Type_de_AmendOnCCAddedFLAG_Yes_Or_No : ([AmendOnCCAddedFLAG]='N' OR [AmendOnCCAddedFLAG]='Y')AmendOnCCAddedFLAG[dbo].[BOOL]1NOT NULL('N')Determines whether to change the note status to Amended when a Carbon Copy recipient has been edited or added to the note.
Check Constraints CK_Document_Type_de_AmendOnNoteOwnerChangeFLAG_Yes_Or_No : ([AmendOnNoteOwnerChangeFLAG]='N' OR [AmendOnNoteOwnerChangeFLAG]='Y')AmendOnNoteOwnerChangeFLAG[dbo].[BOOL]1NOT NULL('N')Determines whether to change the note status to Amended when the note owner has been changed.
Foreign Keys FK_Document_Type_de_OwnerAuthorityDE_Signature_Authority_DE_ID: [dbo].[Signature_Authority_DE].OwnerAuthorityDEOwnerAuthorityDE[dbo].[dict_id]5NOT NULL(0)The level of authority that is required for ownership of this document type.  Points to Signature_Authority_DE
Foreign Keys FK_Document_NoteVisibilityDE: [dbo].[Note_Visibility_DE].NoteVisibilityDENoteVisibilityDE[dbo].[dict_id]5NOT NULL(0)Indicates when a note becomes visible within the Chart Viewer. (v11 only)  Points to Note_Visibility_DE
Foreign Keys FK_Document_Type_de_DocumentTypeParentID_Document_Type_de_ID: [dbo].[Document_Type_de].DocumentTypeParentIDDocumentTypeParentID[dbo].[dict_id]5NOT NULL(0)A non-zero value specifies this is a sub type of a parent type.  (Self-referencing lookup)
DisplayNamevarchar(255)255NOT NULL('')Specified in UI as Note Properties -> General Description
Check Constraints CK_Document_Type_de_FinalizeOnSaveFLAG_Yes_Or_No : ([FinalizeOnSaveFLAG]='N' OR [FinalizeOnSaveFLAG]='Y')FinalizeOnSaveFLAG[dbo].[BOOL]1NOT NULL('N')Specifies that the note status will be set to "Finalized" when it is saved.
ReqCorrAllowInvalidateOnlychar(1)1NOT NULL('N')If 'Y' when you click Req Corr from the Document Completion Tasks page, the only option available is Invalidate - Do Not Correct.
Check Constraints CK_Document_Type_de_IsClinicalSummaryFLAG_Yes_Or_No : ([IsClinicalSummaryFLAG]='N' OR [IsClinicalSummaryFLAG]='Y')IsClinicalSummaryFLAG[dbo].[BOOL]1NOT NULL('N')Specifies whether users can utilize this document type as a clinical summary report to provide to patients.
PortalFormNamevarchar(255)255NULL allowed('')Name of portal form; only applicable when Manifestation is PDF
Check Constraints CK_Document_Type_de_IsMUProgressNoteFLAG_Yes_Or_No : ([IsMUProgressNoteFLAG]='N' OR [IsMUProgressNoteFLAG]='Y')IsMUProgressNoteFLAG[dbo].[BOOL]1NOT NULL('N')Identifies documents as progress notes that count toward MU2 reporting requirements.
Check Constraints CK_Document_Type_de_InboundPDFPortalFormFlag_Yes_Or_No : ([InboundPDFPortalFormFlag]='N' OR [InboundPDFPortalFormFlag]='Y')InboundPDFPortalFormFlag[dbo].[BOOL]1NULL allowed('N')Indicates that this doc type represents a portal form and therefore requires a value for PortalFormName  (only for PDF)
Check Constraints CK_Document_Type_de_HasImageFLAG_Yes_Or_No : ([HasImageFLAG]='N' OR [HasImageFLAG]='Y')HasImageFLAG[dbo].[BOOL]1NOT NULL('N')Indicates that the document type has an associated image.  Typically only scanned, V11, and unstructured Notes have images.
SignNoteTask[dbo].[BOOL]1NOT NULL('N')Generate Sign Note Task for the unstructured document type (Y/N)
IsMUNonClinicalSetting[dbo].[BOOL]1NOT NULL('N')Y =  Non-Clinical Document  Type
N= Clinical Document  Type
Foreign Keys FK_Document_Type_DE_PatientConsentDE: [dbo].[Patient_Consent_DE].PatientConsentDEPatientConsentDE[dbo].[dict_id]5NOT NULL((0))Patient Consent Type. Link to Patient_Consent_DE.ID
DBMotionLOINCCodevarchar(10)10NULL allowedDBMotion LOINC Code values
LOINCCodevarchar(10)10NOT NULL('')LOINC Code values
SNOMEDCodevarchar(18)18NOT NULL('')SNOMED Code