Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (11) | ID | numeric(8,0) | 5 | NOT NULL | 1 - 1 | | Key to the document_type_de table |
![Foreign Keys FK_Document_Type_de_EnterpriseEntryID_Dictionary_Entry_EnterpriseEntryID: [dbo].[Dictionary_Entry].EnterpriseEntryID Foreign Keys FK_Document_Type_de_EnterpriseEntryID_Dictionary_Entry_EnterpriseEntryID: [dbo].[Dictionary_Entry].EnterpriseEntryID](../../../../Images/fk.png) | EnterpriseEntryID | numeric(16,0) | 9 | NULL allowed | | | Master (enterprise) dictionary surrogate key. Points to Dictionary_Entry.EnterpriseEntryID |
 ![Foreign Keys FK_Document_Type_de_DefinitionSetID_Definition_Set_DefinitionSetID: [dbo].[Definition_Set].DefinitionSetID Foreign Keys FK_Document_Type_de_DefinitionSetID_Definition_Set_DefinitionSetID: [dbo].[Definition_Set].DefinitionSetID](../../../../Images/fk.png) | DefinitionSetID | numeric(8,0) | 5 | NULL allowed | | | Points to Dict_Definition_Set.DefinitionSetID but is typically zero. |
 | Entry | numeric(8,0) | 5 | NOT NULL | | | Calculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set |
 | EntryCode | char(10) | 10 | NOT NULL | | | Unique alphanumeric code. Brief but cryptic. |
(2) | EntryName | varchar(255) | 255 | NOT NULL | | | Unique alphanumeric "friendly" display name |
| EntryMnemonic | char(10) | 10 | NOT NULL | | | Typically the same as the Code value, but can be blank. If present, it must be unique. |
 ![Check Constraints CK_Document_Type_de_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_Document_Type_de_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is not active; N=row is active. (Rows are inactivated rather than deleted for history) |
 ![Check Constraints CK_Document_Type_de_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_Document_Type_de_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is readonly; N=row is modifiable |
![Check Constraints CK_Document_Type_de_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_Document_Type_de_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')](../../../../Images/c-constraint.png) | IsCurrentFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Usually 'Y' but occasionally used to subordinate rows. Not exposed to the end user. |
| EffectiveDT | datetime | 8 | NULL allowed | | | Time 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].IDXDocumentTypeDE Foreign Keys FK_Document_Type_de_IDXDocumentTypeDE_IDX_Document_Type_DE_id: [dbo].[IDX_Document_Type_DE].IDXDocumentTypeDE](../../../../Images/fk.png) | IDXDocumentTypeDE | [dbo].[dict_id] | 5 | NOT 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].ReqSignatureAuthorityDE Foreign Keys FK_Document_Type_de_ReqSignatureAuthorityDE_Signature_Authority_DE_ID: [dbo].[Signature_Authority_DE].ReqSignatureAuthorityDE](../../../../Images/fk.png) | ReqSignatureAuthorityDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Key to the Signature_Authority_DE table. |
![Check Constraints CK_Document_Type_de_PromptforSigFLAG_Yes_Or_No : ([PromptforSigFLAG]='N' OR [PromptforSigFLAG]='Y') Check Constraints CK_Document_Type_de_PromptforSigFLAG_Yes_Or_No : ([PromptforSigFLAG]='N' OR [PromptforSigFLAG]='Y')](../../../../Images/c-constraint.png) | PromptforSigFLAG | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_Document_Type_de_PrintTaskonSignFLAG_Yes_Or_No : ([PrintTaskonSignFLAG]='N' OR [PrintTaskonSignFLAG]='Y')](../../../../Images/c-constraint.png) | PrintTaskonSignFLAG | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_Document_Type_de_PrintOnSignFLAG_Yes_Or_No : ([PrintOnSignFLAG]='N' OR [PrintOnSignFLAG]='Y')](../../../../Images/c-constraint.png) | PrintOnSignFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | obsolete (now done in Queue Admin) |
![Check Constraints CK_Document_Type_de_NoSigRequiredFLAG_Yes_Or_No : ([NoSigRequiredFLAG]='N' OR [NoSigRequiredFLAG]='Y') Check Constraints CK_Document_Type_de_NoSigRequiredFLAG_Yes_Or_No : ([NoSigRequiredFLAG]='N' OR [NoSigRequiredFLAG]='Y')](../../../../Images/c-constraint.png) | NoSigRequiredFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | obsolete (now done in Queue Admin) |
![Check Constraints CK_Document_Type_de_PrintTaskOnFinalizationFLAG_Yes_Or_No : ([PrintTaskOnFinalizationFLAG]='N' OR [PrintTaskOnFinalizationFLAG]='Y') Check Constraints CK_Document_Type_de_PrintTaskOnFinalizationFLAG_Yes_Or_No : ([PrintTaskOnFinalizationFLAG]='N' OR [PrintTaskOnFinalizationFLAG]='Y')](../../../../Images/c-constraint.png) | PrintTaskOnFinalizationFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | obsolete (now done in Queue Admin) |
| DefaultPhysicalManifestationDE | [dbo].[dict_id] | 5 | NOT NULL | | (20) | The format of the document (PDF, TIF, CCDA, v11 note, etc). Points to PhysicalManifestation_DE |
 | IncludeInUnsigned | char(1) | 1 | NOT 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].WorkFlowTypeDE Foreign Keys FK_Document_Type_de_WorkFlowTypeDE_Workflow_Type_DE_ID: [dbo].[Workflow_Type_DE].WorkFlowTypeDE](../../../../Images/fk.png) | WorkFlowTypeDE | [dbo].[dict_id] | 5 | NULL allowed | | (0) | Key to the Workflow_Type_DE table. |
| DifficultyFactor | numeric(2,1) | 5 | NULL 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') Check Constraints CK_Document_Type_de_CreateTaskOnAmendFLAG_Yes_Or_No : ([CreateTaskOnAmendFLAG]='N' OR [CreateTaskOnAmendFLAG]='Y')](../../../../Images/c-constraint.png) | CreateTaskOnAmendFLAG | [dbo].[BOOL] | 1 | NULL allowed | | | If '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') Check Constraints CK_Document_Type_de_PromptforSigOverrideFLAG_Yes_Or_No : ([PromptforSigOverrideFLAG]='N' OR [PromptforSigOverrideFLAG]='Y')](../../../../Images/c-constraint.png) | PromptforSigOverrideFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Specifies whether users can override the necessary signature authority specified for this document type. (not v11) |
 ![Check Constraints CK_Document_Type_de_DisplayNoteIconOnSchedFLAG_Yes_Or_No : ([DisplayNoteIconOnSchedFLAG]='N' OR [DisplayNoteIconOnSchedFLAG]='Y') Check Constraints CK_Document_Type_de_DisplayNoteIconOnSchedFLAG_Yes_Or_No : ([DisplayNoteIconOnSchedFLAG]='N' OR [DisplayNoteIconOnSchedFLAG]='Y')](../../../../Images/c-constraint.png) | DisplayNoteIconOnSchedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('Y') | Specifies whether a note icon appears on the schedule for this doc type. |
 ![Check Constraints CK_Document_Type_de_IsScanResultFLAG_Yes_Or_No : ([IsScanResultFLAG]='N' OR [IsScanResultFLAG]='Y') Check Constraints CK_Document_Type_de_IsScanResultFLAG_Yes_Or_No : ([IsScanResultFLAG]='N' OR [IsScanResultFLAG]='Y')](../../../../Images/c-constraint.png) | IsScanResultFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Specifies whether to flag scanned document types as a result within ChartViewer. |
 ![Check Constraints CK_Document_Type_de_IsLetterFLAG_Yes_Or_No : ([IsLetterFLAG]='N' OR [IsLetterFLAG]='Y') Check Constraints CK_Document_Type_de_IsLetterFLAG_Yes_Or_No : ([IsLetterFLAG]='N' OR [IsLetterFLAG]='Y')](../../../../Images/c-constraint.png) | IsLetterFLAG | char(1) | 1 | NOT NULL | | ('N') | Specifies whether to allow users to create letters derived from notes with a suitable salutation and closing. (not v11) |
 ![Check Constraints CK_Document_Type_de_AutoCCFLAG_Yes_Or_No : ([AutoCCFLAG]='N' OR [AutoCCFLAG]='Y') Check Constraints CK_Document_Type_de_AutoCCFLAG_Yes_Or_No : ([AutoCCFLAG]='N' OR [AutoCCFLAG]='Y')](../../../../Images/c-constraint.png) | AutoCCFLAG | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_Document_Type_de_eReplyFlag_Yes_Or_No : ([eReplyFlag]='N' OR [eReplyFlag]='Y')](../../../../Images/c-constraint.png) | eReplyFlag | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_Document_Type_de_CreateReferringProviderNotificationTaskFLAG_Yes_Or_No : ([CreateReferringProviderNotificationTaskFLAG]='N' OR [CreateReferringProviderNotificationTaskFLAG]='Y')](../../../../Images/c-constraint.png) | CreateReferringProviderNotificationTaskFLAG | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_Document_Type_de_CreatePatientNotificationTaskFLAG_Yes_Or_No : ([CreatePatientNotificationTaskFLAG]='N' OR [CreatePatientNotificationTaskFLAG]='Y')](../../../../Images/c-constraint.png) | CreatePatientNotificationTaskFLAG | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_Document_Type_de_CreateReviewCoveredNoteTaskonFinalizationFLAG_Yes_Or_No : ([CreateReviewCoveredNoteTaskonFinalizationFLAG]='N' OR [CreateReviewCoveredNoteTaskonFinalizationFLAG]='Y')](../../../../Images/c-constraint.png) | CreateReviewCoveredNoteTaskonFinalizationFLAG | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_Document_Type_de_AmendOnAnnotationFLAG_Yes_Or_No : ([AmendOnAnnotationFLAG]='N' OR [AmendOnAnnotationFLAG]='Y')](../../../../Images/c-constraint.png) | AmendOnAnnotationFLAG | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_Document_Type_de_AmendOnEncounterChangeFLAG_Yes_Or_No : ([AmendOnEncounterChangeFLAG]='N' OR [AmendOnEncounterChangeFLAG]='Y')](../../../../Images/c-constraint.png) | AmendOnEncounterChangeFLAG | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_Document_Type_de_AmendOnCCAddedFLAG_Yes_Or_No : ([AmendOnCCAddedFLAG]='N' OR [AmendOnCCAddedFLAG]='Y')](../../../../Images/c-constraint.png) | AmendOnCCAddedFLAG | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_Document_Type_de_AmendOnNoteOwnerChangeFLAG_Yes_Or_No : ([AmendOnNoteOwnerChangeFLAG]='N' OR [AmendOnNoteOwnerChangeFLAG]='Y')](../../../../Images/c-constraint.png) | AmendOnNoteOwnerChangeFLAG | [dbo].[BOOL] | 1 | NOT 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].OwnerAuthorityDE Foreign Keys FK_Document_Type_de_OwnerAuthorityDE_Signature_Authority_DE_ID: [dbo].[Signature_Authority_DE].OwnerAuthorityDE](../../../../Images/fk.png) | OwnerAuthorityDE | [dbo].[dict_id] | 5 | NOT 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].NoteVisibilityDE Foreign Keys FK_Document_NoteVisibilityDE: [dbo].[Note_Visibility_DE].NoteVisibilityDE](../../../../Images/fk.png) | NoteVisibilityDE | [dbo].[dict_id] | 5 | NOT 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].DocumentTypeParentID Foreign Keys FK_Document_Type_de_DocumentTypeParentID_Document_Type_de_ID: [dbo].[Document_Type_de].DocumentTypeParentID](../../../../Images/fk.png) | DocumentTypeParentID | [dbo].[dict_id] | 5 | NOT NULL | | (0) | A non-zero value specifies this is a sub type of a parent type. (Self-referencing lookup) |
| DisplayName | varchar(255) | 255 | NOT NULL | | ('') | Specified in UI as Note Properties -> General Description |
![Check Constraints CK_Document_Type_de_FinalizeOnSaveFLAG_Yes_Or_No : ([FinalizeOnSaveFLAG]='N' OR [FinalizeOnSaveFLAG]='Y') Check Constraints CK_Document_Type_de_FinalizeOnSaveFLAG_Yes_Or_No : ([FinalizeOnSaveFLAG]='N' OR [FinalizeOnSaveFLAG]='Y')](../../../../Images/c-constraint.png) | FinalizeOnSaveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Specifies that the note status will be set to "Finalized" when it is saved. |
| ReqCorrAllowInvalidateOnly | char(1) | 1 | NOT 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') Check Constraints CK_Document_Type_de_IsClinicalSummaryFLAG_Yes_Or_No : ([IsClinicalSummaryFLAG]='N' OR [IsClinicalSummaryFLAG]='Y')](../../../../Images/c-constraint.png) | IsClinicalSummaryFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Specifies whether users can utilize this document type as a clinical summary report to provide to patients. |
| PortalFormName | varchar(255) | 255 | NULL 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') Check Constraints CK_Document_Type_de_IsMUProgressNoteFLAG_Yes_Or_No : ([IsMUProgressNoteFLAG]='N' OR [IsMUProgressNoteFLAG]='Y')](../../../../Images/c-constraint.png) | IsMUProgressNoteFLAG | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_Document_Type_de_InboundPDFPortalFormFlag_Yes_Or_No : ([InboundPDFPortalFormFlag]='N' OR [InboundPDFPortalFormFlag]='Y')](../../../../Images/c-constraint.png) | InboundPDFPortalFormFlag | [dbo].[BOOL] | 1 | NULL 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') Check Constraints CK_Document_Type_de_HasImageFLAG_Yes_Or_No : ([HasImageFLAG]='N' OR [HasImageFLAG]='Y')](../../../../Images/c-constraint.png) | HasImageFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Indicates that the document type has an associated image. Typically only scanned, V11, and unstructured Notes have images. |
| SignNoteTask | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Generate Sign Note Task for the unstructured document type (Y/N) |
| IsMUNonClinicalSetting | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Y = Non-Clinical Document Type N= Clinical Document Type |
![Foreign Keys FK_Document_Type_DE_PatientConsentDE: [dbo].[Patient_Consent_DE].PatientConsentDE Foreign Keys FK_Document_Type_DE_PatientConsentDE: [dbo].[Patient_Consent_DE].PatientConsentDE](../../../../Images/fk.png) | PatientConsentDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Patient Consent Type. Link to Patient_Consent_DE.ID |
| DBMotionLOINCCode | varchar(10) | 10 | NULL allowed | | | DBMotion LOINC Code values |
| LOINCCode | varchar(10) | 10 | NOT NULL | | ('') | LOINC Code values |
| SNOMEDCode | varchar(18) | 18 | NOT NULL | | ('') | SNOMED Code |