L Dxs table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
'''L_Dxs table''' is the table where patients' diagnoses are stored. It is linked to [[L_Log table]] by [[D_ID]]. | '''L_Dxs table''' is the table where patients' diagnoses are stored. It is linked to [[L_Log table]] by [[D_ID]]. | ||
{{Todo | |||
| who = Tina | |||
| todo_added = 2021-07-21 | |||
| todo_action = | |||
| question = Dev_CCMDB_Data | |||
This should be removed in the next update of [[CCMDB_data.mdb]]. | |||
}} | |||
==Contents of L_Dxs table== | ==Contents of L_Dxs table== | ||
Revision as of 14:14, 2021 July 21
L_Dxs table is the table where patients' diagnoses are stored. It is linked to L_Log table by D_ID.
|
Dev_CCMDB_Data This should be removed in the next update of CCMDB_data.mdb. |
|
Contents of L_Dxs table
L_Dxs table is populated with diagnoses from the s_AllDiagnoses table. The diagnoses are structured in a system of main- and sub-diagnoses.
L_DXs contains a field "priority" which is used for determining the Primary Admit Diagnosis.
Due to limitations to our technology at implementation time, we also store the data for Patient Task Tracking among our diagnoses because the data structure was set up to accept them.
To see the most up-to-date data structure of this table, see the master files.
L_Dxs table in the CCMDB.accdb Access program contains the fields
| Dx_ID | unique id for relationships and indexes |
| Pat_ID | unique patient identifier |
| Adm_Acqu | - |
| DiagnosisCode | as chosen from s_AllDiagnoses main- and sub diagnoses get pulled for display from s_Alldiagnoses |
| Pathogen | to store data related to Universal Pathogen List |
| Priority | used to establish Primary Admit Diagnosis (lowest priority Admit Diagnosis) |