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]] | ||
Revision as of 15:43, 30 December 2013
see the Development Documentation Category for other development logs
This article contains requested changes for Centralized data front end.mdb. See Centralized data front end.mdb Change Log for it's change log.
Requested Changes
automate re-linking of tables
Ask for the phi and centralized directories and reconnect.
Error Checking Queries required
we should probably revisit Category:Cleaner.mdb Data Integrity Checks in this context.
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
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.
Data formats
Data type/values for VERBAL, CHRONIC , ADMIT TYPE , RENAL, ADL - these need conversion as we had agreed and they are included under the L_Log of Front end.
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)