Tables [dbo].[Person_TribalAffiliation]
Tribal Affiliations for a patient
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Person_TribalAffiliation: PersonID\TribalAffiliationDEForeign Keys FK_Person_TribalAffiliation_Person: [dbo].[Person].PersonIDPersonID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
Cluster Primary Key PK_Person_TribalAffiliation: PersonID\TribalAffiliationDEForeign Keys FK_Person_TribalAffiliation_TribalAffiliationDE: [dbo].[Tribal_Affiliation_DE].TribalAffiliationDETribalAffiliationDE[dbo].[dict_id]5NOT NULLTribal Affiliation. Link to Tribal_Affiliation_DE.ID
IsDeletedbit1NOT NULL((0))Has this affiliation been deleted?
EffectiveDTTMdatetime8NULL allowedEffective date for the affiliation
LastUpdatedDTTMdatetime8NULL allowedLast updated date and time
ModifiedByID[dbo].[uniqueid]9NOT NULLUser who modified the affiliation. Link to IDX_User.ID