Centralized data front end.accdb Change Request: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 4: | Line 4: | ||
== Requested Changes == | == Requested Changes == | ||
=== automate re-linking of tables === | === automate re-linking of tables === | ||
Ask for the phi and centralized directories and reconnect. | Ask for the phi and centralized directories and reconnect. | ||
| Line 14: | Line 10: | ||
we should probably revisit [[:Category:Cleaner.mdb Data Integrity Checks]] in this context. | we should probably revisit [[:Category:Cleaner.mdb Data Integrity Checks]] in this context. | ||
=== SAS Views === | === SAS Views === | ||
* make SAS query show ADLs with score. or some other query. cross-reference with [[s_ADLOptions]], anyway. | |||
* make SAS query show GCS scores using [[s_GCS]] | |||
* implement [[Created Variables in TMSX or Med TMS]] | |||
==== column headers ==== | ==== column headers ==== | ||
Variables headers for Registry, APACHE,SAPS, ADL elements – you may not necessarily make them in separate tables to be consistent with Ed’s output tables. Putting them together as in the L_Log but using the same headers as ED’s ( can be called as L_log of front end) are just fine. This will be less work in my end because I don’t need to merge these individual tables together. | Variables headers for Registry, APACHE,SAPS, ADL elements – you may not necessarily make them in separate tables to be consistent with Ed’s output tables. Putting them together as in the L_Log but using the same headers as ED’s ( can be called as L_log of front end) are just fine. This will be less work in my end because I don’t need to merge these individual tables together. | ||
| Line 26: | Line 23: | ||
==== exclude tasks from Dx listing ==== | ==== exclude tasks from Dx listing ==== | ||
Diagnosis – can be in separate tables as you have now but exclude the TASKS data, must exclusively contain admit and acquired diagnosis only. In this way, I don’t need to filter and remove the TASKS. Also can I request another column of data which contain only the main diagnosis (first 3 number). | |||
* need to figure out what to do here... I need to keep tasks in dxs table until we also change it for the laptops, but what do we want it to be in the end? Ttenbergen 10:10, 2013 December 2 (CST) | |||
[[Category: Development Documentation]] | [[Category: Development Documentation]] | ||
[[category:2013 data upgrades]] | [[category:2013 data upgrades]] | ||