Change Priorities: Difference between revisions

TOstryzniuk (talk | contribs)
m Post code: minor
TOstryzniuk (talk | contribs)
For Tina
Line 9: Line 9:
*tblTISSpatient, D_ID:  make a query that Pagasa can run each time she uploading to TISS.mdb, to make it lowercase
*tblTISSpatient, D_ID:  make a query that Pagasa can run each time she uploading to TISS.mdb, to make it lowercase


==Dispo Fields ==
===Dispo Fields ===
*add other HSC stepdown units that are at HSC.  
*add other HSC stepdown units that are at HSC.  
**A3SDU, D3SDU, and A5SDU - was requested by HSC ICU's to include admission/discharge to these special locations.
**A3SDU, D3SDU, and A5SDU - was requested by HSC ICU's to include admission/discharge to these special locations.
Line 15: Line 15:
**A4SDU - only 6 beds in this area
**A4SDU - only 6 beds in this area


==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)
**there is a request from ICU Director for admissions from other RHA's in MB
**there is a request from ICU Director for admissions from other RHA's in MB


==ACP status 2 records per status==
===ACP status - add check to CCMDB===
*define a crosscheck to put in place in CCMDB
*define a crosscheck to put in place in CCMDB
**Must have integer, must have a date, and must have a matching pair.
**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==
===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.   
*ICU pt since beginning 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
*Medicine:  Tina to make a query to shift across pharmacy complete box will be transferred to off ward checkbox. started July 1.16
*ICU: No query.  Cannot reclaim.  Will report started on Sept 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==
===Post code==
*Fix master table - removed unnessary columns of data.
*Fix master table - removed unnecessary columns of data.


===CFE - Service Location Field ===
*Service Location field in CFE should allow inactive option
*FORM VIEW LOCATION DROPDOWN HAS TO RESOLVE TO NAME BUT GO TO FORM WHEN TRYING TO EDIT


=== DSM labs exchange ===
== DSM labs exchange ===
* [[DSM_Lab_Extract]]  - need to set up Ttenbergen 14:56, 2015 April 8 (CDT)
* [[DSM_Lab_Extract]]  - need to set up Ttenbergen 14:56, 2015 April 8 (CDT)
* Test [[DSM data testing]]
* Test [[DSM data testing]]
===TISS importer===
*needs work - allow duplicates
=== change APACHE tab to ICU tab and Medicine Tab (Alert) ===
=== change APACHE tab to ICU tab and Medicine Tab (Alert) ===
*when fixing up CCMDB tabs, to reduce confusion, change APACHE tab to ICU tab and the medicine one to Medicine tab.
*when fixing up CCMDB tabs, to reduce confusion, change APACHE tab to ICU tab and the medicine one to Medicine tab.
Line 48: Line 55:
*ALERT article refers Medicine not APACHE article
*ALERT article refers Medicine not APACHE article


=== Add Venous Blood gas count ===
== Add Venous Blood gas count ==
[[:Category: ABG | ABG]]
[[:Category: ABG | ABG]]
to count separate to ABG, so need to add to lab_flow.
to count separate to ABG, so need to add to lab_flow.