L Dxs table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,597 edits
No edit summary
 
(35 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 [[:Category:Steering Committee|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 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


===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, 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"