Tables [dbo].[Clinical_Relation_DE]
Types of family members. Used for family problem history dropdowns and checkbox in the ACI.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Clinical_Relation_DE_ID: IDCluster Key XAK1ClinicalRelation_DE: EntryName\IsCurrentFLAG\IDIndexes XAK2ClinicalRelation_DE, XAK3ClinicalRelation_DE, TWstat_Clinical_Relation_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID(3)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the Clinical_Relation_DE table.
EnterpriseEntryID[dbo].[uniqueid]9NULL allowedKey to the dictionary_Entry table. This is a unique identifier across all dictionaries.
Indexes TWstat_Clinical_Relation_DE_DefinitionSetID_EntryName_IsCurrentFLAG_IDDefinitionSetID[dbo].[dict_id]5NULL allowedDictionary Subset as defined in the Dict_Definition_Set table.
Entry[dbo].[dict_id]5NOT NULLEntry number within the Definition Set
Indexes XAK2ClinicalRelation_DEEntryCode[dbo].[code]10NOT NULLEntry Code
Cluster Key XAK1ClinicalRelation_DE: EntryName\IsCurrentFLAG\IDIndexes TWstat_Clinical_Relation_DE_DefinitionSetID_EntryName_IsCurrentFLAG_IDEntryName[dbo].[name]255NOT NULLEntry Name
Indexes XAK3ClinicalRelation_DEEntryMnemonicchar(10)10NOT NULL(' ')Entry Mnemonic
Check Constraints CK_Clinical_Relation_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLIs the entry inactive (Y/N)?
Check Constraints CK_Clinical_Relation_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLIs the entry Enforced (Y/N)? Enforced entries can not be modified by the application.
Cluster Key XAK1ClinicalRelation_DE: EntryName\IsCurrentFLAG\IDIndexes XAK2ClinicalRelation_DE, XAK3ClinicalRelation_DE, TWstat_Clinical_Relation_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID(3)Check Constraints CK_Clinical_Relation_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLIs the entry Current (Y/N)?
EffectiveDTdatetime8NULL allowedEffective Date. This is the last edited date.
ClinicalOrdersmallint2NOT NULL((0))Order of the relationship
Check Constraints CK_Clinical_Relation_DE_FirstDegreeRelativeFLAG_Yes_Or_No : ([FirstDegreeRelativeFLAG]='N' OR [FirstDegreeRelativeFLAG]='Y')FirstDegreeRelativeFLAG[dbo].[BOOL]1NOT NULL('N')Is this a first degree relation (Y/N)?