L Dxs table: Difference between revisions
Ttenbergen (talk | contribs) m →L_Como Table in the [[CCMDB.mdb]]: L_Como has its own article |
Ttenbergen (talk | contribs) |
||
| Line 35: | Line 35: | ||
|} | |} | ||
===L_Dxs Table in the [[CCMDB.mdb]]=== | |||
L_Dxs in the CCMDB.mdb Access program contains the fields | |||
{| border="1" | |||
|Dx_ID || unique id for relationships and indexes | |||
|- | |||
|Pat_ID || unique patient identifier | |||
|- | |||
| ??? || to designate whether this is a | |||
diagnosis, complication or task |- | |||
|- | |||
| ??? DxCode || as chosen from s_AllDiagnoses | |||
main- and sub diagnoses get pulled for display from s_Alldiagnoses | |||
|- | |||
| ???Priority || used to sort to limit to 6 diagnoses resp. 9 complications | |||
|- | |||
|rank || used to rank to limit to 6 diagnoses resp. 9 complications | |||
|- | |||
|rhdrinfo_ || required for HanDBase sync | |||
|- | |||
|rhdrid_ || required for HanDBase sync | |||
|} | |||
==Still needs to be done...== | ==Still needs to be done...== | ||