Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Patient_Community
Touchworks 25.2
[dbo].[Patient_Community]
MS_Description
Patient Community Membership
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Patient_Community Table
PatientID
[dbo].[uniqueid]
9
NOT NULL
((0))
Patient Idetifier. Link to Person.ID
CommStatusDE
[dbo].[dict_id]
5
NOT NULL
((0))
Community Status. Link to Community_Status_DE.ID
OrgID
numeric(18,0)
9
NOT NULL
((0))
Organziation Identifier. link to Organization.ID
CommunityID
[dbo].[uniqueid]
9
NOT NULL
Community Identifier. Link to CED_Endpoints.ID