diag_events_dic

Table source: Hospital Clinic HIS (based on SAP), Specific tables: data_scope.diag_dic.

Table purpose: The data_scope.diag_dic table provides information about the International Classification of Diseases (ICD-10) codes present on diag_events table.

Links to:

• diag_events on cie.

Brief summary

This table presents diagnostic details sourced from the data_scope.diag_dic table, specifically focusing on the CIE-10 (International Classification of Diseases, 10th Edition) codes. It includes information such as the diagnostic reference (diag_ref), the CIE-10 code (cie), the catalog information (catalog), the ICD code without dots (icd), a description of the diagnosis (descr), and the diagnostic reference in the SAP system (diag_sap_ref).

Table columns

Column Name	Data Type	Description
diag_ref	BIGINT	Unique identifier for each diagnostic entry.
cie	VARCHAR(20)	CIE code for diagnosis.
catalog	INTEGER	Catalog information for diagnosis.
icd	TEXT	ICD code for diagnosis.
descr	VARCHAR(256)	Description of the diagnosis.
diag_sap_ref	BIGINT	Diagnostic reference in SAP system.