Tables [dbo].[Team_DE]
Teams associated to Tasks
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_Team_DE_ID: IDIndexes XAK2TEAMID[dbo].[dict_id]5NOT NULL1 - 1Key to the Team_DE table.
Indexes NIX_Team_DE_EntryCode_WithIncludeColumns, NIX_Team_DE_EntryMnemonic_WithIncludeColumns, NIX_Team_DE_EntryName_WithIncludeColumns(3)Check Constraints CK_Team_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_Team_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Indexes XAK2TEAM, NIX_Team_DE_EntryCode_WithIncludeColumns, NIX_Team_DE_EntryMnemonic_WithIncludeColumns, NIX_Team_DE_EntryName_WithIncludeColumns(4)Check Constraints CK_Team_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.
Indexes NIX_Team_DE_EntryCode_WithIncludeColumns, NIX_Team_DE_EntryMnemonic_WithIncludeColumns, NIX_Team_DE_EntryName_WithIncludeColumns(3)EntryCode[dbo].[code]10NOT NULLUnique alphanumeric code.  Brief but cryptic.
Indexes NIX_Team_DE_EntryCode_WithIncludeColumns, NIX_Team_DE_EntryMnemonic_WithIncludeColumns, NIX_Team_DE_EntryName_WithIncludeColumns(3)EntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique.
EffectiveDTdatetime8NULL allowedTime of last modification  (not "when this row goes into effect")
Indexes XAK2TEAMDefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Indexes XAK2TEAM, TWstat_Team_DE_Entry(2)Entry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes TWstat_Team_DE_SecurityCodeDEForeign Keys FK_Team_DE_SecurityCodeDE_Security_Code_DE_ID: [dbo].[Security_Code_DE].SecurityCodeDESecurityCodeDE[dbo].[dict_id]5NOT NULLSecurity Code. Key to the Security_Code_DE table.
Indexes NIX_Team_DE_EntryCode_WithIncludeColumns, NIX_Team_DE_EntryMnemonic_WithIncludeColumns, NIX_Team_DE_EntryName_WithIncludeColumns(3)EntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes TWstat_Team_DE_EnterpriseEntryIDEnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID