Change Priorities: Difference between revisions
TOstryzniuk (talk | contribs) For Tina |
TOstryzniuk (talk | contribs) m For Tina |
||
| Line 7: | Line 7: | ||
==TISS Uppercase== | ==TISS Uppercase== | ||
*make a query to make it lowercase | *make a query that Pagasa can run each time she uploading to TISS.mdb, to make it lowercase | ||
==Dispo Fields == | ==Dispo Fields == | ||
| Line 15: | Line 15: | ||
==Post code== | ==Post code== | ||
*Fix query - include date filter for 2015 onward (allow Pagasa to change date filter) | *Fix query - include date filter for 2015 onward (allow Pagasa to change date filter) | ||
* | |||
==ACP status 2 records per status== | |||
*define a crosscheck to put in place in CCMDB | |||
**Must have integer, must have a date, and must have a matching pair. | |||
==Dispo Fields == | ==Dispo Fields == | ||
*Finish conversion of old dispo field data | *Finish conversion of old dispo field data | ||
*preacute, previous location and dispo (Julie has sent Tina emails) | *preacute, previous location and dispo (Julie has sent Tina emails) | ||
[[2016_Time_and_Place_changes]] | [[2016_Time_and_Place_changes]] | ||
==off ward checked off box hooked up to pharmacy field== | |||
*ICU pt since begining of July we don't have offward data, because the check off box was hooked up to Pharm complete box. | |||
*Medicine: Tina to make a query to shift across phamracy complete box will be transfered to off ward checkbox. started July 1.16 | |||
*ICU: No query. Cannot reclaim. Will report started on Sept 1.16 | |||
==TISS Uppercase== | ==TISS Uppercase== | ||
*Tina: Later: change importer so it does lowercase | *Tina: Later: change importer so it does lowercase | ||
== | ==Post code== | ||
* | *Fix master table - removed unnessary columns of data. | ||
=== DSM labs exchange === | === DSM labs exchange === | ||