Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Description |
---|
 (2) | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | Key to the Credential_DE table. |
| EnterpriseEntryID | [dbo].[uniqueid] | 9 | NOT NULL | | Master (enterprise) dictionary surrogate key. Points to Dictionary_Entry.EnterpriseEntryID |
 ![Foreign Keys FK_Credential_DE_DefinitionSetID_Definition_Set_DefinitionSetID: [dbo].[Definition_Set].DefinitionSetID Foreign Keys FK_Credential_DE_DefinitionSetID_Definition_Set_DefinitionSetID: [dbo].[Definition_Set].DefinitionSetID](../../../../Images/fk.png) | DefinitionSetID | [dbo].[dict_id] | 5 | NOT NULL | | Points to Dict_Definition_Set.DefinitionSetID but is typically zero. |
 | Entry | numeric(8,0) | 5 | NOT NULL | | Calculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set |
(3) | EntryCode | char(10) | 10 | NOT NULL | | Unique alphanumeric code. Brief but cryptic. |
(5) | EntryName | varchar(255) | 255 | NOT NULL | | Unique alphanumeric "friendly" display name |
(3) | EntryMnemonic | char(10) | 10 | NOT NULL | | Typically the same as the Code value, but can be blank. If present, it must be unique. |
(4)![Check Constraints CK_Credential_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_Credential_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Y=row is not active; N=row is active. (Rows are inactivated rather than deleted for history) |
![Check Constraints CK_Credential_DE_IsEnforcedFlag_Yes_Or_No : ([IsEnforcedFlag]='N' OR [IsEnforcedFlag]='Y') Check Constraints CK_Credential_DE_IsEnforcedFlag_Yes_Or_No : ([IsEnforcedFlag]='N' OR [IsEnforcedFlag]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFlag | [dbo].[BOOL] | 1 | NOT NULL | | Y=row is readonly; N=row is modifiable |
(5)![Check Constraints CK_Credential_DE_IsCurrentFlag_Yes_Or_No : ([IsCurrentFlag]='N' OR [IsCurrentFlag]='Y') Check Constraints CK_Credential_DE_IsCurrentFlag_Yes_Or_No : ([IsCurrentFlag]='N' OR [IsCurrentFlag]='Y')](../../../../Images/c-constraint.png) | 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") |