Tables [dbo].[Sex_DE]
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Sex_DE_ID: IDCluster Key XAK1Sex_DE: EntryName\IsCurrentFLAG\IDIndexes XAK2Sex_DE, XAK3Sex_DE, TWstat_Sex_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Sex_DE_IsCurrentFLAG_EntryName_ID, TWstat_Sex_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(5)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the Sex_DE table.
Indexes TWstat_Sex_DE_EnterpriseEntryIDEnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes TWstat_Sex_DE_DefinitionSetID_EntryName_IsCurrentFLAG_IDDefinitionSetID[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 XAK2Sex_DEEntryCode[dbo].[code]10NOT NULLUnique alphanumeric code.  Brief but cryptic.
Cluster Key XAK1Sex_DE: EntryName\IsCurrentFLAG\IDIndexes TWstat_Sex_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Sex_DE_IsCurrentFLAG_EntryName_ID, TWstat_Sex_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(3)EntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes XAK3Sex_DEEntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique.
Indexes TWstat_Sex_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_IDCheck Constraints CK_Sex_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_Sex_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Cluster Key XAK1Sex_DE: EntryName\IsCurrentFLAG\IDIndexes XAK2Sex_DE, XAK3Sex_DE, TWstat_Sex_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Sex_DE_IsCurrentFLAG_EntryName_ID, TWstat_Sex_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(5)Check Constraints CK_Sex_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")
StandardCodevarchar(15)15NULL allowedStandard Code for the gender
SNOMEDcodevarchar(18)18NOT NULL('')SNOMED Code for the gender