L Dxs table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
No edit summary |
||
| (9 intermediate revisions by one other user not shown) | |||
| 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]]. | '''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== | ==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 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]]. | L_DXs contains a field "priority" which is used for determining the [[Primary Admit Diagnosis]]. | ||
| Line 10: | Line 15: | ||
To see the most up-to-date data structure of this table, see the master files. | To see the most up-to-date data structure of this table, see the master files. | ||
L_Dxs table in the CCMDB. | 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) | |||
[[Category: Data structure]] | == Log == | ||
[[Category: L_Dxs table| * ]] | * 2022-08-31 - data was removed from [[Centralized data.mdb]] | ||
[[Category: L Table]] | * 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]] | |||
}} | |||
Latest revision as of 09:50, 12 August 2024
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.