L Dxs table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m m |
||
| Line 1: | Line 1: | ||
'''L_Dxs''' is the | '''L_Dxs''' is the table where patients' diagnoses are stored. | ||
==Contents of L_Dxs== | ==Contents of L_Dxs== | ||
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 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 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 [[:Category:Task Elements | 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 | To see the most up-to-date data structure of this table, see the master files. | ||
L_Dxs in the CCMDB.mdb Access program contains the fields | L_Dxs in the CCMDB.mdb Access program contains the fields | ||
Revision as of 11:29, 2015 June 24
L_Dxs is the table where patients' diagnoses are stored.
Contents of L_Dxs
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 steering committee.
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 in the CCMDB.mdb Access program contains the fields
| Dx_ID | unique id for relationships and indexes |
| Pat_ID | unique patient identifier |
| Adm_Acqu | - |
| 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 |