L Dxs table: Difference between revisions

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

|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 15:

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

|-

== Related articles ==

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

|-

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

|}

[[Category: Data structure]]

[[Category:Data structure]]

[[Category: L_Dxs table| * ]]

[[Category:L_Dxs table| * ]]

[[Category: L Table]]

[[Category:L Table]]

}}

@@ 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]]
+|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 15: @@
 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
-|-
+== Related articles ==
-|Pathogen || to store data related to [[Universal Pathogen List]]
+{{Related Articles}}
-|-
-|Priority || used to establish [[Primary Admit Diagnosis]] (lowest priority Admit Diagnosis)
-|}
-[[Category: Data structure]]
+[[Category:Data structure]]
-[[Category: L_Dxs table| * ]]
+[[Category:L_Dxs table| * ]]
-[[Category: L Table]]
+[[Category:L Table]]
+}}