L Como table: Difference between revisions

mNo edit summary
m Text replacement - "Centralized data.accdb" to "Centralized_data.accdb"
 
(4 intermediate revisions by 2 users not shown)
Line 13: Line 13:
===L_Como Table in the [[CCMDB.accdb]]===
===L_Como Table in the [[CCMDB.accdb]]===
L_Como in the CCMDB.accdb Access program contains the fields
L_Como in the CCMDB.accdb Access program contains the fields
{| border="1"
* Como_ID  - unique id for relationships and indexes
|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
|Pat_ID  || unique patient identifier
* 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
|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 ==
== Data Structure ==
Line 31: Line 23:


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


== Related articles ==  
== Related articles ==