L Dxs table

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

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.

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.

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.

To see the most up-to-date data structure of this table, see most up-to-date ccmdb_data.mdb in Regional Server\data\Master CCMDB.mdb.

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