Bed Census Data Processing Instructions: Difference between revisions

Line 3:

==Program==

Critical Care in WRHA

*Persons Responsible: The [[Statistician]] and the [[~~Data Processor~~]] of the ~~Critical Care Database~~

*Persons Responsible: The [[Statistician]] of the Critical Care Database as assigned by the Critical Care Director

* Since there is only one SAS license and only at the [[Statistician]] computer, the processing is done by the [[Statistician]] .

==Start Date==

May 3, 2012

Line 12:

==Data Processing -New Instructions==

#~~Goes to the~~ HSC_MICU ~~and picks up the bed census faxed sheets minimally every Tuesday and Friday. (~~clerk ~~leaves it in a slot by fax machine).~~ ~~Due to COVID, the HSC_MICU clerk bring~~ the forms ~~to JJ387 inbox~~.

# The HSC_MICU clerk disposed the forms as confidential waste.

#'''Exports (downloads)''' all entered data once per week;

#*FROM: http:\\forms.manitoba-ehealth.ca/ccwhiteboard/secure/admin.php, (~~only the scanner computer has access this site our office.~~ Site is password protected).

#*FROM: http:\\forms.manitoba-ehealth.ca/ccwhiteboard/secure/admin.php, (Site is password protected).

#*TO: x\\med_ccmed\Pagasa\whiteboard\'''ICUBedsCensusHistory.xls'''

#'''Opens SAS 9.4''' (program written by the Statistician [[User: JMojica | Jmojica]] to sort and export. Sorted to include bed count closes to before 1500 hrs each days and also for those dates where there was no bed change (IICU) reuse the bed count from the previous day closest to before 1500 hrs.

Line 27:

#Go to: S:\MED\MED_CCMED\PAGASA\Whiteboard\'''whiteboard.xlsx'''

#'''Manually checks''' whiteboard.xlsx if the dates specified for each unit are complete.

#'''uploads (imports)''' the '''whiteboard.xlsx''' from "S:\MED\MED_CCMED\PAGASA\Whiteboard" to S:\Critical_Care\Patient_DB_Reports\Bed_Census into an access database. ~~This is also known as Randy Martens Daily bed census database.~~

#'''uploads (imports)''' the '''whiteboard.xlsx''' from "S:\MED\MED_CCMED\PAGASA\Whiteboard" to S:\Critical_Care\Patient_DB_Reports\Bed_Census into an access database.

#*Copy the '''WRHA Critical Care Daily Bed Census-Ver2020.mdb''' from folder S:\Critical_Care\Patient_DB_Reports\Bed_Census to your '''desktop'''

#*OPEN '''WRHA Critical Care Daily Bed Census-Ver2020.mdb'''

Line 43:

==Bed census.mdb Queries ==

*most of the Queries in this mdb are made by [[p:Randy Martens]], who is not longer with Program effective July 16, 2020

*most of the Queries in this mdb are made by [[p:Randy Martens]], who is not longer with Program effective July 16, 2020. Has been replaced by Corey Bacshuk and the [[Statistician]] showed the Bed Census Database to him.

== [[Legacy Processing Instructions Bed census.mdb]] ==

@@ Line 3: / Line 3: @@
 ==Program==
 Critical Care in WRHA
-*Persons Responsible: The [[Statistician]] and the [[Data Processor]] of the Critical Care Database
+*Persons Responsible: The [[Statistician]]  of the Critical Care Database as assigned by the Critical Care Director
+* Since there is only one  SAS license  and only at the [[Statistician]] computer, the processing is done by the [[Statistician]] .
 ==Start Date==
 May 3, 2012
@@ Line 12: / Line 12: @@
 ==Data Processing -New Instructions==
-#Goes to the HSC_MICU and picks up the bed census faxed sheets minimally every Tuesday and Friday. (clerk leaves it in a slot by fax machine).  Due to COVID, the HSC_MICU clerk bring the forms to JJ387 inbox.
+# The HSC_MICU clerk disposed  the forms as confidential waste.
 #'''Exports (downloads)''' all entered data once per week;
-#*FROM:  http:\\forms.manitoba-ehealth.ca/ccwhiteboard/secure/admin.php, (only the scanner computer has access this site our office. Site is password protected).
+#*FROM:  http:\\forms.manitoba-ehealth.ca/ccwhiteboard/secure/admin.php,  (Site is password protected).
 #*TO:  x\\med_ccmed\Pagasa\whiteboard\'''ICUBedsCensusHistory.xls'''
 #'''Opens SAS 9.4''' (program written by the Statistician [[User: JMojica | Jmojica]] to sort and export. Sorted to include bed count closes to before 1500 hrs each days and also for those dates where there was no bed change (IICU) reuse the bed count from the previous day closest to before 1500 hrs.
@@ Line 27: / Line 27: @@
 #Go to: S:\MED\MED_CCMED\PAGASA\Whiteboard\'''whiteboard.xlsx'''
 #'''Manually checks''' whiteboard.xlsx if the dates specified for each unit are complete.
-#'''uploads (imports)''' the '''whiteboard.xlsx'''  from "S:\MED\MED_CCMED\PAGASA\Whiteboard" to S:\Critical_Care\Patient_DB_Reports\Bed_Census into an access database.  This is also known as Randy Martens  Daily bed census  database.
+#'''uploads (imports)''' the '''whiteboard.xlsx'''  from "S:\MED\MED_CCMED\PAGASA\Whiteboard" to S:\Critical_Care\Patient_DB_Reports\Bed_Census into an access database.
 #*Copy the '''WRHA Critical Care Daily Bed Census-Ver2020.mdb''' from folder S:\Critical_Care\Patient_DB_Reports\Bed_Census to your '''desktop'''
 #*OPEN '''WRHA Critical Care Daily Bed Census-Ver2020.mdb'''
@@ Line 43: / Line 43: @@
 ==Bed census.mdb Queries ==
-*most of the Queries in this mdb are made by [[p:Randy Martens]], who is not longer with Program effective July 16, 2020
+*most of the Queries in this mdb are made by [[p:Randy Martens]], who is not longer with Program effective July 16, 2020.  Has been replaced by Corey Bacshuk  and  the [[Statistician]] showed the Bed Census Database to him.
 == [[Legacy Processing Instructions Bed census.mdb]] ==