L Como table: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
{{LegacyContent | {{LegacyContent | ||
|explanation=We now collect this data in [[L ICD10 table]]. In [[ | |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]] | |successor=[[L ICD10 table]] | ||
|content= | |content= | ||
| Line 33: | Line 33: | ||
== Data Structure == | == 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]]. | 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-?? - data was moved to [[Legacy TMS Data.mdb]] | |||
== Related articles == | == Related articles == | ||
Revision as of 10:52, 31 August 2022
Legacy Content
This page contains Legacy Content.- 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
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.
Instances of L_Como
There are several instances of L_Como
- a table in each copy of the CCMDB.accdb
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 {