Tables [dbo].[Gender_Identity_Standard_DE]
Gender Identity standard codes
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Gender_Identity_Standard_DE: IDID[dbo].[dict_id]5NOT NULL1 - 1Link to the Gender_Identity_Standard_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_Gender_Identity_Standard_DE_EntryCodeEntryCode[dbo].[code]10NOT NULLUnique alphanumeric code.  Brief but cryptic.
Indexes NIX_Gender_Identity_Standard_DE_EntryNameEntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes NIX_Gender_Identity_Standard_DE_EntryMnemonicEntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique.
Check Constraints CK_Gender_Identity_Standard_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_Gender_Identity_Standard_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Check Constraints CK_Gender_Identity_Standard_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(20)20NOT NULL('')StandardCode is field to store the actual code for the Gender Identity standard code. Since the length exceeds more than 10 characters, we couldn’t use the entrycode and entryMnemonic columns for this.