Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Patient_Correspondence
Touchworks 25.2
[dbo].[Patient_Correspondence]
MS_Description
Patient correspondence data
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
(11)
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to Patient_Correspondence table
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Patient_Member.ID
PatientRequestXID
[dbo].[uniqueid]
9
NOT NULL
Remote system's request ID
(2)
PatientRequestURLhash
int
4
NULL allowed
Long URL, hashed into an INT
(2)
PatientRequestAppGroup
varchar(32)
32
NULL allowed
An ODBC name for a server+database
CreateDTTM
datetime
8
NULL allowed
Date & time of the entry
LastUpdateDTTM
datetime
8
NULL allowed
Date & time when the entry was updated
UpdatedByUserID
[dbo].[uniqueid]
9
NULL allowed
User who created/updated the entry. Link to IDX_User.ID.
RequestType
[dbo].[dict_id]
5
NULL allowed
Request type. Link to IDX_Task_Action_DE.ID
Status
char(1)
1
NULL allowed
P = Pending, C = Complete
Subject
varchar(200)
200
NULL allowed
Subject of Patient correspondence
XMLstring
varchar(max)
max
NULL allowed
The original request's XML
BackwardLinkID
[dbo].[uniqueid]
9
NOT NULL
((-1))
backward link to linked request
ForwardLinkID
[dbo].[uniqueid]
9
NOT NULL
((-1))
ForwardLinkID = -1 for a new request
ForwardLinkID = ID when a request is updated
OriginatingLinkID
[dbo].[uniqueid]
9
NOT NULL
((-1))
OriginatingLinkID = -1 for a new request
OriginatingLinkID = ID when a request is updated
PracticeInitiatedFLAG
[dbo].[BOOL]
1
NULL allowed
Did the practice initiate this Y/N?