Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Patient_Community_Audit
Touchworks 25.2
[dbo].[Patient_Community_Audit]
MS_Description
Audit record of changes ot the Patient_Community table
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Pateint_Community_Audit 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
WhoDidItID
[dbo].[uniqueid]
9
NOT NULL
((0))
UserID of editting user - Link to IDX_User.ID
LastUpdateDTTM
datetime
8
NULL allowed
Datetime of the change event
CommStatusFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Comm Status Change FLAG (Y/N)?
CommunityID
[dbo].[uniqueid]
9
NOT NULL
Community Identifier - Link to CED_Endpoints.ID