Centralized data front end.accdb Change Request: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 19: | Line 19: | ||
* '''problem importing csv files is with the date field... need to give it the right import specs'''Ttenbergen 17:34, 2013 November 4 (CST) | * '''problem importing csv files is with the date field... need to give it the right import specs'''Ttenbergen 17:34, 2013 November 4 (CST) | ||
** Brad will look into that one, in a different file. | ** Brad will look into that one, in a different file. | ||
=== Diagnosis vs Tasks === | |||
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) | |||
=== SAS Views === | |||
==== 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 ==== | |||
[[Category: Development Documentation]] | [[Category: Development Documentation]] | ||
[[category:2013 data upgrades]] | [[category:2013 data upgrades]] | ||