Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HDictation Used to populate the Digital-Dictation Worklist with dictations to be completed and transcribed.
Column Name Column Datatype Column Null Option Column Comment
DictOIDintNOT NULL Primary Key - Unique per dictation system. Same value as DictationID.
CreationTimesmalldatetimeNOT NULL The date and time when this row was created(local date & time)
PatientOIDintNOT NULL References ObjectID from table HPatient
PatientVisitOIDintNOT NULL References ObjectID from table HPatientVisit
DictationIDvarchar(64)NOT NULL References the dictation in the dictation system. Used e.g. to access the dictations' audio file
DictationStatuschar(1)NOT NULL The status of the dictation. Values: A = Unfinished, T = Sent to transcription/Finished, D = Cancelled/Deleted
EnteredByIDintNOT NULL References the ObjectID from the table HSUser indicating the user who created the dictation
LastCngDtimesmalldatetimeNULL The date and time of the last update of this row(local date & time)
DictationPriorityCodesmallintNOT NULL The priority of the dictation. Values: 0 = Normal, 1 = Routine, 2 = High
ResultOIDbigintNULL References ObjectID from table HInvestigationResult_Active(once dictation is placed for transcription)
ServiceOIdIntNULL References ObjectID from table HService
ServiceProviderAbbrVarchar(10)NULL Holds Abbreviation from table HHealthCareUnit for the service provider associated with the dictation

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates