dbo.Tribal_Affiliation

[dbo].[Tribal_Affiliation_DE]

Dictionary of Tribal Affiliations

Name	Data Type	Max Length (Bytes)	Nullability	Identity	Default	Description
ID	[dbo].[dict_id]	5	NOT NULL	1 - 1		Key to the Tribal_Affiliation_DE table
EnterpriseEntryID	[dbo].[uniqueid]	9	NOT NULL			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")
TribalEntityUS	varchar(10)	10	NOT NULL		('')	Copy of EntryCode