PATIENTDECEASED
Description: Information relating a deceased patient

Primary Key
Column Name Ordinal Position

Foreign Key
Column Name Ordinal Position Referenced Table

Column Information
Name Type
1 PATIENTDECEASEDID INT
Description: The unique Id for the PatientDeceased table
Name Type
2 PRELIMINARYCODREASON NVARCHAR
Description: Preliminary cause of death reason
Name Type
3 EXPIRATIONDATETIME DATETIMEOFFSET
Description: Date Patient Expired
Name Type
4 EXPIRATIONDATETIMEOFFSET INT
Description: Time Patient Expired
Name Type
5 LKSYSTIMEZONEID INT
Description: LkSysTimeZoneId is a foreign key to the LkSysTimeZone table