Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HDeathInformation Contains patient's death information
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HDeathInformation Rows generated by Architecture. Relative to DeathInformation_oid in hpatient table.
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL RecordId of the patient death information, sometime can match RecordId of the Patient.
Descriptionvarchar(255)NULL Description that can be valued by client.
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserId of the user who created the HDeathInformation row
CreationTimesmalldatetimeNULL Date and Time when row was created.
PatientDeathDateTimedatetimeNULL Date and time when the patient died.
ReasonforDeathvarchar(64)NULL Reasons for the patient's death.
LocationOfDeathvarchar(64)NULL Location where the patient died. The location can be the healthcare unit or any other location.
MortuarybitNULL Indicates that there is a mortuary where the patient's body can be kept. Allowable Values: Null, 0 - False, 1 - True
MortuaryLocationvarchar(64)NULL Location of the mortuary where the patient's body is kept.
Autopsyvarchar(64)NULL Indicates if autopsy is performed on the patient's body.
SurgeryRelatedvarchar(64)NULL Details of the surgery performed on the patient prior to his death.
Remarksvarchar(255)NULL Comments on the patient's death, as entered by the user.
DeathTypetinyintNULL Type of death. Allowable Values: NULL, 1 - Deceased discharge, 2 - Coroner's discharge
DeathDeclVisitintNULL This field is not used currently.
IsDeletedtinyintNOT NULL Indicates if the row has been deleted. Allowable Values: 0 - False, 1 - True(deleted)
LastCngDtimedatetimeNULL Last system UTC date /time when row was updated.

Return to Table-Index

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