L Dxs table: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m →L_Como Table in the [[CCMDB.mdb]]: L_Como has its own article |
||
Line 37: | Line 37: | ||
==Still needs to be done...== | ==Still needs to be done...== |
Revision as of 09:26, 2009 August 20
L_Dxs is the data structure where patients' diagnoses are stored.
Instances of L_Dxs
There are several instances 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 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.
L_Dxs HanDBase File and Table
L_Dxs on HanDBase contains the fields
Pat_ID | Unique patient identifier |
??? | to designate whether this is a
diagnosis, complication or task |
???Main | as chosen from s_AllDiagnoses |
???Sub | as chosen from s_AllDiagnoses |
???Code | as chosen from s_AllDiagnoses |
Linked | used by HanDBase to relate tables |
Priority | to sort to limit to 6 diagnoses, resp 9 complications |
Still needs to be done...
- confirm field names