ADL General Collection Information: Difference between revisions

m In TMSX: clean-up
Line 70: Line 70:
=== in CCMDB.mdb ===
=== in CCMDB.mdb ===
In CCMDB the ADLs are stored as their full words rather than scores, e.g. "ADL_Bathing" might have a value of "unassisted". The values are entered via dropdown list, which is driven by table [[s_ADLOptions]]. In that table there is a column "sorter" with numbers used to change the order the values appear in the dropdown list. The column is '''not''' a score and not used for anything beyond sorting.  
In CCMDB the ADLs are stored as their full words rather than scores, e.g. "ADL_Bathing" might have a value of "unassisted". The values are entered via dropdown list, which is driven by table [[s_ADLOptions]]. In that table there is a column "sorter" with numbers used to change the order the values appear in the dropdown list. The column is '''not''' a score and not used for anything beyond sorting.  
=== on sending from CCMDB.mdb to TMSX ===
When exporting to TMSX ADLs are encoded by setting one of three columns per value to "TRUE" and the rest to "FALSE"; no score is included.


=== In TMSX ===
=== In TMSX ===