Tables [dbo].[Clinical_Document_Target_DE]
Dictionary of desitinations for CEDs. Ex (Immunization Regsitry, ACDM, etc)
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Clinical_Document_Target_DE_ID: IDID[dbo].[dict_id]5NOT NULL1 - 1Key to the Clinical_Document_Target_DE table.
EnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
DefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Entry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes XAK2ClinicalDocumentTargetDEEntryCode[dbo].[code]10NOT NULLUnique alphanumeric code. Brief but cryptic.
Cluster Key XAK1ClinicalDocumentTargetDE: EntryName\IsCurrentFLAG\IsTrustedSourceFLAGEntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes XAK3ClinicalDocumentTargetDEEntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique.
Check Constraints CK_Clinical_Document_Target_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)
Check Constraints CK_Clinical_Document_Target_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Cluster Key XAK1ClinicalDocumentTargetDE: EntryName\IsCurrentFLAG\IsTrustedSourceFLAGIndexes XAK2ClinicalDocumentTargetDE, XAK3ClinicalDocumentTargetDE(2)Check Constraints CK_Clinical_Document_Target_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")
URLvarchar(255)255NOT NULL('')Target URL, if applicable
Check Constraints CK_Clinical_Document_Target_DE_IsRegistryFLAG_Yes_Or_No : ([IsRegistryFLAG]='N' OR [IsRegistryFLAG]='Y')IsRegistryFLAG[dbo].[BOOL]1NOT NULL('N')Target is a Registry FLAG (Y/N)
Check Constraints CK_Clinical_Document_Target_DE_UseStoredQueryFLAG_Yes_Or_No : ([UseStoredQueryFLAG]='N' OR [UseStoredQueryFLAG]='Y')UseStoredQueryFLAG[dbo].[BOOL]1NOT NULL('N')Stored Query Transactions FLAG
Check Constraints CK_Clinical_Document_Target_DE_UseMTOMFLAG_Yes_Or_No : ([UseMTOMFLAG]='N' OR [UseMTOMFLAG]='Y')UseMTOMFLAG[dbo].[BOOL]1NOT NULL('N')Message Tranmission Optimization Mechanism encoding Flag
Check Constraints CK_Clinical_Document_Target_DE_UseBPPCFLAG_Yes_Or_No : ([UseBPPCFLAG]='N' OR [UseBPPCFLAG]='Y')UseBPPCFLAG[dbo].[BOOL]1NOT NULL('N')Basic Patient Privacy Consensts Flag
Foreign Keys FK_Clinical_Document_Target_DE_CDTTypeDE_CDT_Type_DE_ID: [dbo].[CDT_Type_DE].CDTTypeDECDTTypeDE[dbo].[dict_id]5NOT NULL((0))Clinical Document Target Type. Links to CDT_Type_DE.ID
CDTObjectIDvarchar(255)255NOT NULL('')Clinical Document Type ID
Foreign Keys FK_Clinical_Document_Target_DE_CDTImportDE_CDT_Import_DE_ID: [dbo].[CDT_Import_DE].CDTImportDECDTImportDE[dbo].[dict_id]5NOT NULL((0))Clinical Document Import Type. links to CDT_Import_DE.ID
Cluster Key XAK1ClinicalDocumentTargetDE: EntryName\IsCurrentFLAG\IsTrustedSourceFLAGCheck Constraints CK_Clinical_Document_Target_DE_IsTrustedSourceFLAG_Yes_Or_No : ([IsTrustedSourceFLAG]='N' OR [IsTrustedSourceFLAG]='Y')IsTrustedSourceFLAG[dbo].[BOOL]1NOT NULL('N')Trusted source impacts verification requirements
Foreign Keys FK_ClinicalDocTargetDE_EncounterTypeDE: [dbo].[Encounter_Type_DE].EncounterTypeDEEncounterTypeDE[dbo].[dict_id]5NOT NULL((0))Encounter Type. Links to Encounter_Type_DE.ID
IsSuppressedbit1NOT NULL((0))document source (Facility level) suppression