Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.PatientTranscript
Touchworks 26.1
[dbo].[PatientTranscript]
MS_Description
Transcripts (speech to text data) received from Mobile via Unity.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
bigint
8
NOT NULL
1 - 1
Key to the PatientTranscript table
UserID
[dbo].[uniqueid]
9
NOT NULL
User who records the speech in the Mobile application. Link to IDX_User.ID
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Patient_Member.ID
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID
IsEnteredInError
bit
1
NULL allowed
((0))
1 - Entered in Error, 0 - Not Entered in Error
Transcript
varbinary(max)
max
NOT NULL
Compresed text of the transcript
CreatedDTTM
datetime
8
NOT NULL
(getdate())
Date/time when transcript is received and saved