L Dxs table: Difference between revisions

(6 intermediate revisions by one other user not shown)

Line 1:

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

'''L_Dxs table''' is the table where patients' diagnoses are stored. It is linked to [[L_Log table]] by [[D_ID]].

~~{{Todo~~

~~| who = Tina~~

~~| todo_added = 2021-07-21~~

~~| todo_action =~~

~~| question = Dev_CCMDB_Data~~

~~This should be removed in the next update of [[CCMDB_data.mdb]].~~

}}

==Contents of L_Dxs table==

Line 19:

Line 16:

L_Dxs table in the CCMDB.accdb Access program contains the fields

~~{| border="1"~~

|Dx_ID || unique id for relationships and indexes

Dx_ID ! unique id for relationships and indexes

|-

Pat_ID ! unique patient identifier

|Pat_ID || unique patient identifier

Adm_Acqu ! to designate whether this is a diagnosis, complication or task

|-

DiagnosisCode ! as chosen from s_AllDiagnoses main- and sub diagnoses get pulled for display from s_Alldiagnoses

|Adm_Acqu || to designate whether this is a diagnosis, complication or task |-

Pathogen ! to store data related to [[Universal Pathogen List]]

|-

Priority ! used to establish [[Primary Admit Diagnosis]] (lowest priority Admit Diagnosis)

|DiagnosisCode || as chosen from s_AllDiagnoses main- and sub diagnoses get pulled for display from s_Alldiagnoses

|-

== Log ==

|Pathogen || to store data related to [[Universal Pathogen List]]

* 2022-08-31 - data was removed from [[Centralized data.mdb]]

|-

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

|Priority || used to establish [[Primary Admit Diagnosis]] (lowest priority Admit Diagnosis)

|}

== Related articles ==

[[Category: Data structure]]

[[Category:Data structure]]

[[Category: L_Dxs table| * ]]

[[Category:L_Dxs table| * ]]

[[Category: L Table]]

[[Category:L Table]]

[[Category:Legacy Data structure]]

}}

@@ Line 1: / Line 1: @@
+{{DISPLAYTITLE:L_Dxs table}}
+{{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=
 '''L_Dxs table''' is the table where patients' diagnoses are stored. It is linked to [[L_Log table]] by [[D_ID]].
-{{Todo
- | who = Tina
- | todo_added = 2021-07-21
- | todo_action =
- | question = Dev_CCMDB_Data
-This should be removed in the next update of [[CCMDB_data.mdb]].
- }}
 ==Contents of L_Dxs table==
@@ Line 19: / Line 16: @@
 L_Dxs table in the CCMDB.accdb Access program contains the fields
-{| border="1"
-|Dx_ID  || unique id for relationships and indexes
+ Dx_ID         ! unique id for relationships and indexes
-|-
+ Pat_ID        ! unique patient identifier
-|Pat_ID  || unique patient identifier
+ Adm_Acqu      ! to designate whether this is a diagnosis, complication or task
-|-
+ DiagnosisCode ! as chosen from s_AllDiagnoses main- and sub diagnoses get pulled for display from s_Alldiagnoses
-|Adm_Acqu || to designate whether this is a diagnosis, complication or task |-
+ Pathogen      ! to store data related to [[Universal Pathogen List]]
-|-
+ Priority      ! used to establish [[Primary Admit Diagnosis]] (lowest priority Admit Diagnosis)
-|DiagnosisCode  || as chosen from s_AllDiagnoses main- and sub diagnoses get pulled for display from s_Alldiagnoses
-|-
+== Log ==
-|Pathogen || to store data related to [[Universal Pathogen List]]
+* 2022-08-31 - data was removed from [[Centralized data.mdb]]
-|-
+* 2022-08-31 - data was moved to [[Legacy TMS Data.mdb]]
-|Priority || used to establish [[Primary Admit Diagnosis]] (lowest priority Admit Diagnosis)
-|}
+== Related articles ==
+{{Related Articles}}
-[[Category: Data structure]]
+[[Category:Data structure]]
-[[Category: L_Dxs table| * ]]
+[[Category:L_Dxs table| * ]]
-[[Category: L Table]]
+[[Category:L Table]]
+[[Category:Legacy Data structure]]
+}}