L Como table: Difference between revisions

(7 intermediate revisions by 2 users not shown)

Line 1:

{{LegacyContent

|explanation=We now collect this data in [[L ICD10 table]]. In [[~~Centralized data~~.mdb]] this table contains legacy data from before [[Conversion from our old diagnosis schema to ICD10/CCI]]

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

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

Line 17:

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

|-

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

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

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

== Related articles ==

Line 40:

Line 32:

[[Category:Data structure]]

[[Category:L Table]]

[[Category:Legacy Data structure]]

}}

@@ Line 1: / Line 1: @@
 {{LegacyContent
-|explanation=We now collect this data in [[L ICD10 table]]. In [[Centralized data.mdb]] this table contains legacy data from before [[Conversion from our old diagnosis schema to ICD10/CCI]]
+|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=
 '''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 ==
@@ Line 17: / 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
-|-
-|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 ==
 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.accdb]]
+* 2022-08-31 - data was moved to [[Legacy TMS Data.mdb]]
 == Related articles ==
@@ Line 40: / Line 32: @@
 [[Category:Data structure]]
 [[Category:L Table]]
+[[Category:Legacy Data structure]]
 }}