Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Patient_Family_Unit
Touchworks 25.2
[dbo].[Patient_Family_Unit]
MS_Description
Family unit information for the patient (employee)
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
FamilyUnitName
varchar(70)
70
NOT NULL
Name of the family unit, current requirement is to hold the patient last name concatenated with PatientID
PatientID
[dbo].[uniqueid]
9
NOT NULL
PatientID of the family unit owner. Link to Patient_Member.ID
CreatedBy
[dbo].[uniqueid]
9
NOT NULL
UserID of the user who created the family unit. Link to IDX_User.ID
CreatedDTTM
datetime
8
NOT NULL
Family unit created date and time