Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HDeathInformation Rows generated by Architecture. Relative to DeathInformation_oid in hpatient table. |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) ID generated by Architecture |
RecordId | int | NULL | RecordId of the patient death information, sometime can match RecordId of the Patient. |
Description | varchar(255) | NULL | Description that can be valued by client. |
IsVersioned | bit | NOT NULL | Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified |
CreatedUserId | int | NULL | UserId of the user who created the HDeathInformation row |
CreationTime | smalldatetime | NULL | Date and Time when row was created. |
PatientDeathDateTime | datetime | NULL | Date and time when the patient died. |
ReasonforDeath | varchar(64) | NULL | Reasons for the patient's death. |
LocationOfDeath | varchar(64) | NULL | Location where the patient died. The location can be the healthcare unit or any other location. |
Mortuary | bit | NULL | Indicates that there is a mortuary where the patient's body can be kept. Allowable Values: Null, 0 - False, 1 - True |
MortuaryLocation | varchar(64) | NULL | Location of the mortuary where the patient's body is kept. |
Autopsy | varchar(64) | NULL | Indicates if autopsy is performed on the patient's body. |
SurgeryRelated | varchar(64) | NULL | Details of the surgery performed on the patient prior to his death. |
Remarks | varchar(255) | NULL | Comments on the patient's death, as entered by the user. |
DeathType | tinyint | NULL | Type of death. Allowable Values: NULL, 1 - Deceased discharge, 2 - Coroner's discharge |
DeathDeclVisit | int | NULL | This field is not used currently. |
IsDeleted | tinyint | NOT NULL | Indicates if the row has been deleted. Allowable Values: 0 - False, 1 - True(deleted) |
LastCngDtime | datetime | NULL | Last system UTC date /time when row was updated. |
|
|