L Como table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
mNo edit summary
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,553 edits
No edit summary
 
(31 intermediate revisions by 3 users not shown)
Line 1: Line 1:
'''L_Como''' is the data structure where patients' comorbids are stored.  
{{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=


==Instances of L_Como==
'''L_Como''' was the data structure where patients' comorbids are stored. It is linked to [[L_Log table]] by [[D_ID]].
There are several instances of L_Como
* a [[HanDBase]] file on each PDA
** containing a HanDBase table
* a table in each copy of the ccmdb.mdb


==Contents of L_Como==
== Contents of L_Como ==
The L_Como is populated with comorbids from the [[s_CharlsonComorbids]] tables. These comorbids contain all comorbids in the [[Charlston Comorbidity Index]] and more. Like the diagnoses in [[L_Dxs]] and [[S_AllDiagnoses]] they are divided into main- and sub-diagnoses.  
The L_Como is populated with comorbids from the sub-section of the [[s_AllDiagnoses table]] table that is allowed as a comorbid. These comorbids contain all comorbids in the [[Charlson Comorbidity Index]] and more. Like the diagnoses in [[L_Dxs table]] and [[s_AllDiagnoses table]] they are divided into main- and sub-diagnoses.  


Because our main repository [[TMSX]] is not relational, it is limited to 6 comorbids per patient. L_Como contains a field "priority" which used to be used for ranking of the comorbids to decide which will be sent. The ranking is now done automatically based on the highest Charlson score, so the priority field is no longer used.  
L_Como contains a field "priority" which used to be used for ranking of the comorbids to decide which will be sent. The ranking is now done automatically based on the highest Charlson score, so the priority field is no longer used.  


===L_Como HanDBase File and Table===
===L_Como Table in the [[CCMDB.accdb]]===
L_Como on HanDBase contains the fields
L_Como in the CCMDB.accdb Access program contains the fields
{| border="1"
* Como_ID  - unique id for relationships and indexes
| Pat_ID  || Unique patient identifier
* Pat_ID  - unique patient identifier
|-
* ComorbidCode  - as chosen from s_charlsoncomorbids main- and sub-comorbids get pulled for display from s_charsloncomorbids
|ComorbidMain  || as chosen from s_charlsoncomorbids
* Priority - legacy field, used to be used to sort comorbids to limit to 6
|-
* rank - legacy field, used to be used to rank comorbids to limit to 6
|ComorbidSub  || as chosen from s_charlsoncomorbids
|-
|ComorbidCode  || as chosen from s_charlsoncomorbids
|-
|Linked  ||used by HanDBase to relate tables
|-
|Priority || legacy field, used to be used to sort comorbids to limit to 6
|}


== Data Structure ==
To see the data structure of this table, see most up-to-date ccmdb_data.mdb in [[Regional Server]]\data\Master [[CCMDB.accdb]].


== Log ==
* 2022-08-31 - data was removed from [[Centralized data.mdb]]
* 2022-08-31 - data was moved to [[Legacy TMS Data.mdb]]


===L_Como Table in the [[CCMDB.mdb]]===
== Related articles ==  
L_Como in the CCMDB.mdb Access program contains the fields
{{Related Articles}}
{| border="1"
|Como_ID  || unique id for relationships and indexes
|-
|Pat_ID  || unique patient identifier
|-
|ComorbidCode  || as chosen from s_charlsoncomorbids


main- and sub-comorbids get pulled for display from s_charsloncomorbids
[[Category:Comorbid]]
|-
[[Category:Data structure]]
|Priority || legacy field, used to be used to sort comorbids to limit to 6
[[Category:L Table]]
|-
[[Category:Legacy Data structure]]
|rank  || legacy field, used to be used to rank comorbids to limit to 6
}}
|-
|rhdrinfo_  || required for HanDBase sync
|-
|rhdrid_  ||  required for HanDBase sync
|}

Latest revision as of 08:49, 2024 August 12

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

L_Como was the data structure where patients' comorbids are stored. It is linked to L_Log table by D_ID.

Contents of L_Como

The L_Como is populated with comorbids from the sub-section of the s_AllDiagnoses table table that is allowed as a comorbid. These comorbids contain all comorbids in the Charlson Comorbidity Index and more. Like the diagnoses in L_Dxs table and s_AllDiagnoses table they are divided into main- and sub-diagnoses.

L_Como contains a field "priority" which used to be used for ranking of the comorbids to decide which will be sent. The ranking is now done automatically based on the highest Charlson score, so the priority field is no longer used.

L_Como Table in the CCMDB.accdb

L_Como in the CCMDB.accdb Access program contains the fields

  • Como_ID - unique id for relationships and indexes
  • Pat_ID - unique patient identifier
  • ComorbidCode - as chosen from s_charlsoncomorbids main- and sub-comorbids get pulled for display from s_charsloncomorbids
  • Priority - legacy field, used to be used to sort comorbids to limit to 6
  • rank - legacy field, used to be used to rank comorbids to limit to 6

Data Structure

To see the data structure of this table, see most up-to-date ccmdb_data.mdb in Regional Server\data\Master CCMDB.accdb.

Log

Related articles

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