L Dxs table: Difference between revisions

(30 intermediate revisions by 3 users not shown)

Line 1:

'''L_Dxs''' is the ~~data structure~~ where patients' diagnoses are stored~~; it~~ is ~~stored in~~ [[~~Ccmdb data\ccmdb data.mdb~~]]

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

==Contents of L_Dxs==

==Contents of L_Dxs table==

L_Dxs is populated with diagnoses from the [[~~S AllDiagnoses~~ ]] ~~table~~. The diagnoses are structured in a system of main- and sub-diagnoses~~. Which diagnoses end up on the list is determined by the [[:Category:Steering Committee|steering committee]]~~.

L_Dxs table is populated with diagnoses from the [[s_AllDiagnoses table]]. The diagnoses are structured in a system of main- and sub-diagnoses.

~~Because our main repository [[TMSX]] is not relational, it is limited to 6 admit diagnoses and 9 complications per patient.~~ L_DXs contains a field "priority" which is for ~~ranking of~~ the ~~comorbids to decide which will be sent~~.

L_DXs contains a field "priority" which is used for determining the [[Primary Admit Diagnosis]].

Due to limitations to our technology, we also store the data for [[Patient Task Tracking]] among our diagnoses because the data structure was set up to accept them.

Due to limitations to our technology at implementation time, we also store the data for [[:Category:Task Elements | Patient Task Tracking]] among our diagnoses because the data structure was set up to accept them.

To see the most up-to-date data structure of this table, see the master files.

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

~~===L_Dxs Table in the [[CCMDB.mdb]]===~~

Dx_ID ! unique id for relationships and indexes

~~L_Dxs in the CCMDB.mdb Access program contains the fields~~

Pat_ID ! unique patient identifier

~~{| border="1"~~

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

|Dx_ID || unique id for relationships and indexes

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

|-

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

|Pat_ID || unique patient identifier

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

|-

|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

|-

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

|-

|Priority || used to ~~sort to limit to 6 diagnoses resp. 9 complications~~

|-

~~|rank || used to rank to limit to 6 diagnoses resp. 9 complications~~

[[Category: Data structure]]

== Log ==

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

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

== Related articles ==

[[Category:Data structure]]

[[Category:L_Dxs table| * ]]

[[Category:L Table]]

[[Category:Legacy Data structure]]

}}

@@ Line 1: / Line 1: @@
-'''L_Dxs''' is the data structure where patients' diagnoses are stored; it is stored in [[Ccmdb data\ccmdb data.mdb]]
+{{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]].
-==Contents of L_Dxs==
+==Contents of L_Dxs table==
-L_Dxs is populated with diagnoses from the [[S AllDiagnoses ]] table. The diagnoses are structured in a system of main- and sub-diagnoses. Which diagnoses end up on the list is determined by the [[:Category:Steering Committee|steering committee]].
+L_Dxs table is populated with diagnoses from the [[s_AllDiagnoses table]]. The diagnoses are structured in a system of main- and sub-diagnoses.
-Because our main repository [[TMSX]] is not relational, it is limited to 6 admit diagnoses and 9 complications per patient. L_DXs contains a field "priority" which is for ranking of the comorbids to decide which will be sent.
+L_DXs contains a field "priority" which is used for determining the [[Primary Admit Diagnosis]].
-Due to limitations to our technology, we also store the data for [[Patient Task Tracking]] among our diagnoses because the data structure was set up to accept them.
+Due to limitations to our technology at implementation time, we also store the data for [[:Category:Task Elements | Patient Task Tracking]] among our diagnoses because the data structure was set up to accept them.
+To see the most up-to-date data structure of this table, see the master files.
+L_Dxs table in the CCMDB.accdb Access program contains the fields
-===L_Dxs Table in the [[CCMDB.mdb]]===
+ Dx_ID         ! unique id for relationships and indexes
-L_Dxs in the CCMDB.mdb Access program contains the fields
+ Pat_ID        ! unique patient identifier
-{| border="1"
+ Adm_Acqu      ! to designate whether this is a diagnosis, complication or task
-|Dx_ID  || unique id for relationships and indexes
+ DiagnosisCode ! as chosen from s_AllDiagnoses main- and sub diagnoses get pulled for display from s_Alldiagnoses
-|-
+ Pathogen      ! to store data related to [[Universal Pathogen List]]
-|Pat_ID  || unique patient identifier
+ Priority      ! used to establish [[Primary Admit Diagnosis]] (lowest priority Admit Diagnosis)
-|-
-|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
-|-
-|Pathogen || to store data related to [[Universal Pathogen List]]
-|-
-|Priority || used to sort to limit to 6 diagnoses resp. 9 complications
-|-
-|rank   || used to rank to limit to 6 diagnoses resp. 9 complications
-[[Category: Data structure]]
+== Log ==
+* 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:Data structure]]
+[[Category:L_Dxs table| * ]]
+[[Category:L Table]]
+[[Category:Legacy Data structure]]
+}}