diag_events_dic - theonesp/p_zero-code GitHub Wiki
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_eventsoncie.
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. |