L Dxs table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (30 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
'''L_Dxs''' is the | {{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 [[ | L_Dxs table is populated with diagnoses from the [[s_AllDiagnoses table]]. The diagnoses are structured in a system of main- and sub-diagnoses. | ||
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 | |||
diagnosis, complication or task | Dx_ID ! unique id for relationships and indexes | ||
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 | |||
Pathogen ! to store data related to [[Universal Pathogen List]] | |||
Priority ! used to establish [[Primary Admit Diagnosis]] (lowest priority Admit Diagnosis) | |||
=== | == Log == | ||
* 2022-08-31 - data was removed from [[Centralized data.mdb]] | |||
* 2022-08-?? - data was moved to [[Legacy TMS Data.mdb]] | |||
== Related articles == | |||
{{Related Articles}} | |||
[[Category: Data structure]] | [[Category:Data structure]] | ||
[[Category:L_Dxs table| * ]] | |||
[[Category:L Table]] | |||
[[Category:Legacy Data structure]] | |||
}} | |||
Latest revision as of 09:35, 2023 June 6
Legacy Content
This page contains Legacy Content.- 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
Click Expand to show legacy 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 table
L_Dxs table is populated with diagnoses from the s_AllDiagnoses table. The diagnoses are structured in a system of main- and sub-diagnoses.
L_DXs contains a field "priority" which is used for determining the Primary Admit Diagnosis.
Due to limitations to our technology at implementation time, we also store the data for 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
Dx_ID ! unique id for relationships and indexes 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 Pathogen ! to store data related to Universal Pathogen List Priority ! used to establish Primary Admit Diagnosis (lowest priority Admit Diagnosis)
Log
- 2022-08-31 - data was removed from Centralized data.mdb
- 2022-08-?? - data was moved to Legacy TMS Data.mdb