Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
DictOID | int | NOT NULL | Primary Key - Unique per dictation system. Same value as DictationID. |
CreationTime | smalldatetime | NOT NULL | The date and time when this row was created(local date & time) |
PatientOID | int | NOT NULL | References ObjectID from table HPatient |
PatientVisitOID | int | NOT NULL | References ObjectID from table HPatientVisit |
DictationID | varchar(64) | NOT NULL | References the dictation in the dictation system. Used e.g. to access the dictations' audio file |
DictationStatus | char(1) | NOT NULL | The status of the dictation. Values: A = Unfinished, T = Sent to transcription/Finished, D = Cancelled/Deleted |
EnteredByID | int | NOT NULL | References the ObjectID from the table HSUser indicating the user who created the dictation |
LastCngDtime | smalldatetime | NULL | The date and time of the last update of this row(local date & time) |
DictationPriorityCode | smallint | NOT NULL | The priority of the dictation. Values: 0 = Normal, 1 = Routine, 2 = High |
ResultOID | bigint | NULL | References ObjectID from table HInvestigationResult_Active(once dictation is placed for transcription) |
ServiceOId | Int | NULL | References ObjectID from table HService |
ServiceProviderAbbr | Varchar(10) | NULL | Holds Abbreviation from table HHealthCareUnit for the service provider associated with the dictation |