L Dxs table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
 
(39 intermediate revisions by 2 users not shown)
Line 1: Line 1:
'''L_Dxs''' is the data structure where patients' diagnoses are stored.  
{{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]].


==Instances of L_Dxs==
==Contents of L_Dxs table==
There are several instances of L_Dxs
L_Dxs table is populated with diagnoses from the [[s_AllDiagnoses table]]. The diagnoses are structured in a system of main- and sub-diagnoses.  
* a [[HanDBase]] file on each PDA
** containing a HanDBase table
* a table in each copy of the [[CCMDB.mdb]]


==Contents of L_Dxs==
L_DXs contains a field "priority" which is used for determining the [[Primary Admit Diagnosis]].
L_Dxs is populated with diagnoses from the [[s_Alldiagnoses]] table. The diagnoses are sttructured in a system of  main- and sub-diagnoses. Which diagnoses end up on the list is determined by the [[steering committee]].


Because our main repository [[TMSX]] is not relational, it is limited to 6 admit diagnoses and 9 complications per patient. L_DXs contains a field "priority" which is for ranking of the comorbids to decide which will be sent.
Due to limitations to our technology at implementation time, we also store the data for [[:Category:Task Elements | Patient Task Tracking]] among our diagnoses because the data structure was set up to accept them.  


Due to limitations to our technology, we also track [[Tasks]] 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


===L_Dxs HanDBase File and Table===
Dx_ID        ! unique id for relationships and indexes
L_Dxs on HanDBase contains the fields
Pat_ID       ! unique patient identifier
{| border="1"
Adm_Acqu      ! to designate whether this is a diagnosis, complication or task
| Pat_ID || Unique patient identifier
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]]
| ??? || to designate whether this is a  
Priority      ! used to establish [[Primary Admit Diagnosis]] (lowest priority Admit Diagnosis)


diagnosis, complication or task
== Log ==
|-
* 2022-08-31 - data was removed from [[Centralized data.mdb]]
| ???Main  || as chosen from s_AllDiagnoses
* 2022-08-31 - data was moved to [[Legacy TMS Data.mdb]]
|-
| ???Sub  || as chosen from s_AllDiagnoses
|-
| ???Code  || as chosen from s_AllDiagnoses
|-
| Linked  ||used by HanDBase to relate tables
|-
| Priority || to sort to limit to 6 diagnoses, resp 9 complications
|}


== Related articles ==
{{Related Articles}}




===L_Como Table in the [[CCMDB.mdb]]===
[[Category:Data structure]]
L_Como in the CCMDB.mdb Access program contains the fields
[[Category:L_Dxs table| * ]]
{| border="1"
[[Category:L Table]]
|Dx_ID  || unique id for relationships and indexes
[[Category:Legacy Data structure]]
|-
}}
|Pat_ID  || unique patient identifier
|-
| ??? || to designate whether this is a
 
diagnosis, complication or task |-
|-
| ??? DxCode  || as chosen from s_AllDiagnoses
 
main- and sub diagnoses get pulled for display from s_Alldiagnoses
|-
| ???Priority || used to sort to limit to 6 diagnoses resp. 9 complications
|-
|rank  || used to rank to limit to 6 diagnoses resp. 9 complications
|-
|rhdrinfo_  || required for HanDBase sync
|-
|rhdrid_  ||  required for HanDBase sync
|}
 
===Still needs to be done...===
*''''' confirm field names '''''
 
{{stub}}
[[Category: Data structure]]

Latest revision as of 09:50, 2024 August 12

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy 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 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      ! 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)

Log

Related articles

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