Tables [dbo].[PatientTranscript]
Transcripts (speech to text data) received from Mobile via Unity.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_PatientTranscript_ID: IDIDbigint8NOT NULL1 - 1Key to the PatientTranscript table
Foreign Keys FK_PatientTranscripts_User: [dbo].[IDX_User].UserIDUserID[dbo].[uniqueid]9NOT NULLUser who records the speech in the Mobile application. Link to IDX_User.ID
Indexes IX_PatientTranscripts_PatientID_IsEnteredInErrorForeign Keys FK_PatientTranscripts_Patient: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID
Foreign Keys FK_PatientTranscripts_Encounter: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
Indexes IX_PatientTranscripts_PatientID_IsEnteredInErrorIsEnteredInErrorbit1NULL allowed((0))1 - Entered in Error, 0 - Not Entered in Error
Transcriptvarbinary(max)maxNOT NULLCompresed text of the transcript
CreatedDTTMdatetime8NOT NULL(getdate())Date/time when transcript is received and saved