L Dxs table: Difference between revisions

Line 8: Line 8:


==Contents of L_Dxs==
==Contents of L_Dxs==
L_Dxs is populated with diagnoses from the [[s_Alldiagnoses]] table. The diagnoses are sttructured 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 sttructured in a system of  main- and sub-diagnoses. Which diagnoses end up on the list is determined by the [[:Category:Steering Committee|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.
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.