Master (enterprise) dictionary surrogate key. Points to Dictionary_Entry.EnterpriseEntryID
DefinitionSetID
[dbo].[dict_id]
5
NOT NULL
Points to Dict_Definition_Set.DefinitionSetID but is typically zero.
Entry
[dbo].[dict_id]
5
NOT NULL
Calculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
EntryCode
[dbo].[code]
10
NOT NULL
Unique alphanumeric code. Brief but cryptic.
EntryName
[dbo].[name]
255
NOT NULL
Unique alphanumeric "friendly" display name
EntryMnemonic
[dbo].[code]
10
NOT NULL
Typically the same as the Code value, but can be blank. If present, it must be unique.
IsInactiveFLAG
[dbo].[BOOL]
1
NOT NULL
Y=row is not active; N=row is active. (Rows are inactivated rather than deleted for history)
IsEnforcedFLAG
[dbo].[BOOL]
1
NOT NULL
Y=row is readonly; N=row is modifiable
IsCurrentFLAG
[dbo].[BOOL]
1
NOT NULL
Usually 'Y' but occasionally used to subordinate rows. Not exposed to the end user.
EffectiveDT
datetime
8
NULL allowed
Time of last modification (not "when this row goes into effect")
StandardCode
varchar(20)
20
NOT 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.