L Como table: Difference between revisions

(12 intermediate revisions by 2 users not shown)

Line 1:

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

{{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 table ~~in each copy of the~~ [[~~CCMDB.accdb~~]]

== Contents of L_Como ==

Line 12:

Line 13:

===L_Como Table in the [[CCMDB.accdb]]===

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~~

== 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]].

~~|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~~ ==

== Log ==

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

* 2022-08-31 - data was removed from [[Centralized_data.accdb]]

* 2022-08-31 - data was moved to [[Legacy TMS Data.mdb]]

== Related articles ==

[[Category: Comorbid]]

[[Category:Comorbid]]

[[Category: Data structure]]

[[Category:Data structure]]

[[Category:L Table]]

[[Category:Legacy Data structure]]

}}

@@ Line 1: / Line 1: @@
-'''L_Como''' is the data structure where patients' comorbids are stored. It is linked to [[L_Log table]] by [[D_ID]].
+{{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 table in each copy of the [[CCMDB.accdb]]
 == Contents of L_Como ==
@@ Line 12: / Line 13: @@
 ===L_Como Table in the [[CCMDB.accdb]]===
 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
+== 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]].
-|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 ==
+== Log ==
-To see the data structure of this table, see most up-to-date ccmdb_data.mdb in [[Regional Server]]\data\Master [[CCMDB.accdb]].
+* 2022-08-31 - data was removed from [[Centralized_data.accdb]]
+* 2022-08-31 - data was moved to [[Legacy TMS Data.mdb]]
+== Related articles ==
+{{Related Articles}}
-[[Category: Comorbid]]
+[[Category:Comorbid]]
-[[Category: Data structure]]
+[[Category:Data structure]]
 [[Category:L Table]]
+[[Category:Legacy Data structure]]
+}}