Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Person_TribalAffiliation
Touchworks 25.2
[dbo].[Person_TribalAffiliation]
MS_Description
Tribal Affiliations for a patient
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
PersonID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Person.ID
TribalAffiliationDE
[dbo].[dict_id]
5
NOT NULL
Tribal Affiliation. Link to Tribal_Affiliation_DE.ID
IsDeleted
bit
1
NOT NULL
((0))
Has this affiliation been deleted?
EffectiveDTTM
datetime
8
NULL allowed
Effective date for the affiliation
LastUpdatedDTTM
datetime
8
NULL allowed
Last updated date and time
ModifiedByID
[dbo].[uniqueid]
9
NOT NULL
User who modified the affiliation. Link to IDX_User.ID