L Como table: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
'''L_Como''' is the data structure where patients' comorbids are stored. | '''L_Como''' is the data structure where patients' comorbids are stored. | ||
==Instances of L_Como== | == Instances of L_Como == | ||
There are several instances of L_Como | There are several instances of L_Como | ||
* a table in each copy of the [[CCMDB.mdb]] | * 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 [[ | The L_Como is populated with comorbids from the sub-section of the [[S_AllDiagnoses]] 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]] and [[S_AllDiagnoses]] 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. | 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. | ||
| Line 51: | Line 51: | ||
To see the data structure of the [[CCMDB.mdb]] refer to the master version at | To see the data structure of the [[CCMDB.mdb]] refer to the master version at | ||
*{{UNC | \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Programs\Master | \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Programs\Master}} | *{{UNC | \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Programs\Master | \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Programs\Master}} | ||
[[Category: Comorbid]] | [[Category: Comorbid]] | ||
[[Category: Data structure]] | [[Category: Data structure]] | ||