L Dxs table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
m link
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,597 edits
No edit summary
 
(17 intermediate revisions by 2 users not shown)
Line 1: Line 1:
'''L_Dxs''' is the table where patients' diagnoses are stored. It is linked to [[L_Log table]] by [[D_ID]].
{{DISPLAYTITLE:L_Dxs table}}
{{LegacyContent
|explanation=We now collect this data in [[L ICD10 table]]. In [[Legacy TMS Data.mdb]] this table contains legacy data from before [[Conversion from our old diagnosis schema to ICD10/CCI]]
|successor=[[L ICD10 table]]
|content=
'''L_Dxs table''' is the table where patients' diagnoses are stored. It is linked to [[L_Log table]] by [[D_ID]].


==Contents of L_Dxs==
==Contents of L_Dxs table==
L_Dxs is populated with diagnoses from the [[S AllDiagnoses ]] table. The diagnoses are structured in a system of main- and sub-diagnoses. Which diagnoses end up on the list is determined by the [[:Category:Steering Committee|steering committee]].
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]].
L_DXs contains a field "priority" which is used for determining the [[Primary Admit Diagnosis]].
Line 10: Line 15:
To see the most up-to-date data structure of this table, see the master files.
To see the most up-to-date data structure of this table, see the master files.


L_Dxs in the CCMDB.mdb Access program contains the fields
L_Dxs table in the CCMDB.accdb Access program contains the fields
{| border="1"
|Dx_ID  || unique id for relationships and indexes
|-
|Pat_ID  || unique patient identifier
|-
|Adm_Acqu || to designate whether this is a diagnosis, complication or task |-
|-
|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 sort to limit to 6 diagnoses resp. 9 complications
|-
|rank  || used to rank to limit to 6 diagnoses resp. 9 complications
}


Dx_ID        ! unique id for relationships and indexes
Pat_ID        ! unique patient identifier
Adm_Acqu      ! to designate whether this is a diagnosis, complication or task
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)


[[Category: Data structure]]
== Log ==
[[Category:L Dxs|* ]]
* 2022-08-31 - data was removed from [[Centralized data.mdb]]
* 2022-08-31 - data was moved to [[Legacy TMS Data.mdb]]
 
== Related articles ==
{{Related Articles}}
 
 
[[Category:Data structure]]
[[Category:L_Dxs table| * ]]
[[Category:L Table]]
[[Category:Legacy Data structure]]
}}

Latest revision as of 09:50, 12 August 2024

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

Retrieved from "https://ccmdb.kuality.ca/index.php?title=L_Dxs_table&oldid=161669"