diag_events

Table source: Clinic Hospital HIS (based on SAP). Specific tables: diag_events_stage.

Table purpose: This table contains information about diagnoses ICD codes (version 10) for each patient's hospital stay.

Links to:

• demog on patient_deid.
• diag_events_dic on cie.

Brief summary

This table contains data on diagnoses for patients for each of their hospital stays. Each row represents a unique diagnosis for a patient during a hospital stay, and the columns provide information about the diagnosis, including the International Classification of Diseases code (ICD) code on their version 10, the type of diagnosis (primary or secondary), and the date on which the diagnosis was registered. The table also includes identifiers for the patient and the hospital stay. The table diag_events_dic can be consulted for a description about the ICD codes. The "Type of diagnosis" column (diag_type) in the p_zero.diag_events table indicates whether the diagnosis is historical (H), representing diagnoses made before admission to the ward, or current (C), signifying diagnoses made during the specific ward stay.

Table columns

Column Name	Data Type	Description
patient_deid	INTEGER	Unique identifier for each patient.
hosp_stay_deid	INTEGER	Unique identifier for each hospital stay.
icd	VARCHAR(255)	International Classification of Diseases code.
diag_type	VARCHAR(1)	Type of diagnosis (H for History, C for Current).
reg_date_deid	TIMESTAMP	Date of registration for the diagnosis.