L Como table: Difference between revisions
Ttenbergen (talk | contribs) m New page: '''L_Como''' is the data structure where patients' comorbids are stored. ==Instances of L_Como== There are several instances of L_Como * a HanDBase file on each PDA ** containing a ... |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 25: | Line 25: | ||
|Linked ||used by HanDBase to relate tables | |Linked ||used by HanDBase to relate tables | ||
|- | |- | ||
|Priority || legacy field, used to be used to | |Priority || legacy field, used to be used to sort comorbids to limit to 6 | ||
|} | |} | ||
===L_Como Table in the [[CCMDB.mdb]]=== | ===L_Como Table in the [[CCMDB.mdb]]=== | ||
L_Como in the CCMDB.mdb Access program contains the fields | L_Como in the CCMDB.mdb Access program contains the fields | ||
{| border="1" | {| border="1" | ||
| Pat_ID || | |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 | ||
|- | |- | ||
| | |rhdrinfo_ || required for HanDBase sync | ||
|- | |- | ||
| | |rhdrid_ || required for HanDBase sync | ||
|} | |} | ||
Revision as of 12:10, 2008 April 14
L_Como is the data structure where patients' comorbids are stored.
Instances of L_Como
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
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.
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 HanDBase File and Table
L_Como on HanDBase contains the fields
| Pat_ID | Unique patient identifier |
| ComorbidMain | as chosen from s_charlsoncomorbids |
| 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 |
L_Como Table in the CCMDB.mdb
L_Como in the CCMDB.mdb 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 |
| rhdrinfo_ | required for HanDBase sync |
| rhdrid_ | required for HanDBase sync |