Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Patient_Family_Unit_Member
Touchworks 25.2
[dbo].[Patient_Family_Unit_Member]
MS_Description
Family unit member information
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Surrogate auto-generated unique primary key value
FamilyUnitID
[dbo].[uniqueid]
9
NOT NULL
Reference to the family unit
LinkPatientID
[dbo].[uniqueid]
9
NOT NULL
PatientID identifier of the family unit member. Link to Patient_Member.ID
RelationshipDE
[dbo].[dict_id]
5
NOT NULL
Relationship detail of the family member to the patient. Link to Relationship_DE.ID
CreatedBy
[dbo].[uniqueid]
9
NOT NULL
UserID of the user who associated the patient to the family unit. Link to IDX_User.ID
CreatedDTTM
datetime
8
NOT NULL
Family unit member created date and time