Tables [dbo].[Unit_Code_DE]
Units dictionary (Once, Pound, Millimeter, etc.)
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Unit_Code_DE_ID: IDIndexes nix_Unit_Code_DE_ID, TWstat_Unit_Code_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Unit_Code_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_Unit_Code_DE_Entry_EntryName_IsCurrentFLAG_ID, TWstat_Unit_Code_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(5)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the Unit_Code_DE table
Indexes TWstat_Unit_Code_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_IDEnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes TWstat_Unit_Code_DE_DefinitionSetID_EntryName_IsCurrentFLAG_IDDefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Indexes TWstat_Unit_Code_DE_Entry_EntryName_IsCurrentFLAG_IDEntry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes NIX_Unit_Code_DE_EntryCode_WithIncludeColumns, NIX_Unit_Code_DE_EntryMnemonic_WithIncludeColumns, NIX_Unit_Code_DE_EntryName_WithIncludeColumns, nix_Unit_Code_DE_ID(4)EntryCode[dbo].[code]10NOT NULLUnique alphanumeric code. Brief but cryptic.
Indexes NIX_Unit_Code_DE_EntryCode_WithIncludeColumns, NIX_Unit_Code_DE_EntryMnemonic_WithIncludeColumns, NIX_Unit_Code_DE_EntryName_WithIncludeColumns, nix_Unit_Code_DE_ID, TWstat_Unit_Code_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Unit_Code_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_Unit_Code_DE_Entry_EntryName_IsCurrentFLAG_ID, TWstat_Unit_Code_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(8)EntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes NIX_Unit_Code_DE_EntryCode_WithIncludeColumns, NIX_Unit_Code_DE_EntryMnemonic_WithIncludeColumns, NIX_Unit_Code_DE_EntryName_WithIncludeColumns, nix_Unit_Code_DE_ID(4)EntryMnemonic[dbo].[code]10NOT NULLUnits Abreviation
Indexes NIX_Unit_Code_DE_EntryCode_WithIncludeColumns, NIX_Unit_Code_DE_EntryMnemonic_WithIncludeColumns, NIX_Unit_Code_DE_EntryName_WithIncludeColumns, TWstat_Unit_Code_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(4)Check Constraints CK_Unit_Code_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_Unit_Code_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Indexes NIX_Unit_Code_DE_EntryCode_WithIncludeColumns, NIX_Unit_Code_DE_EntryMnemonic_WithIncludeColumns, NIX_Unit_Code_DE_EntryName_WithIncludeColumns, TWstat_Unit_Code_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Unit_Code_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_Unit_Code_DE_Entry_EntryName_IsCurrentFLAG_ID, TWstat_Unit_Code_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(7)Check Constraints CK_Unit_Code_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")
NormalizedUnitsvarchar(10)10NOT NULL(' ')Normalized Units, for example kg., cm, ml etc
NormalizedFormulavarchar(50)50NOT NULL(' ')Normalized Formula for the Units