Tables [dbo].[Answer_DE]
Answers for the clinical questions. The answers could be put into a picklist which then could be used as the possible answers for a clinical question.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Answer_DE_ID: IDIndexes TWstat_Answer_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Answer_DE_SecurityCodeDE_EntryName_IsCurrentFLAG_ID(2)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the Answer_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 NIX_Answer_DE_EntryCode_WithIncludeColumns, NIX_Answer_DE_EntryMnemonic_WithIncludeColumns, NIX_Answer_DE_EntryName_WithIncludeColumns(3)EntryCode[dbo].[code]10NOT NULLUnique alphanumeric code. Brief but cryptic.
Indexes NIX_Answer_DE_EntryCode_WithIncludeColumns, NIX_Answer_DE_EntryMnemonic_WithIncludeColumns, NIX_Answer_DE_EntryName_WithIncludeColumns, TWstat_Answer_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Answer_DE_SecurityCodeDE_EntryName_IsCurrentFLAG_ID(5)EntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes NIX_Answer_DE_EntryCode_WithIncludeColumns, NIX_Answer_DE_EntryMnemonic_WithIncludeColumns, NIX_Answer_DE_EntryName_WithIncludeColumns(3)EntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique.
Indexes NIX_Answer_DE_EntryCode_WithIncludeColumns, NIX_Answer_DE_EntryMnemonic_WithIncludeColumns, NIX_Answer_DE_EntryName_WithIncludeColumns, TWstat_Answer_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(4)Check Constraints CK_Answer_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_Answer_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Indexes NIX_Answer_DE_EntryCode_WithIncludeColumns, NIX_Answer_DE_EntryMnemonic_WithIncludeColumns, NIX_Answer_DE_EntryName_WithIncludeColumns, TWstat_Answer_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Answer_DE_SecurityCodeDE_EntryName_IsCurrentFLAG_ID(5)Check Constraints CK_Answer_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")
SnoTermCODEvarchar(18)18NULL allowedSNOMED code
ICD9DiagnosisCODE[dbo].[code]10NOT NULL(' ')ICD9 Diagnosis Code.
Indexes TWstat_Answer_DE_SecurityCodeDE_EntryName_IsCurrentFLAG_IDForeign Keys FK_Answer_DE_SecurityCodeDE_Security_Code_DE_ID: [dbo].[Security_Code_DE].SecurityCodeDESecurityCodeDE[dbo].[dict_id]5NOT NULLSecurity Code. Link to Security_Code_DE.ID
ICD9ProcedureCODEchar(10)10NOT NULL(' ')ICD9 Procedure Code
LOINCCodevarchar(10)10NOT NULL('')LOINC Code