Data Processor

p:Pagasa Torres is the data processor for the Critical Care and Medicine Database.

The data processor is the main user of the Data Processor PC.

Her tasks include

• Data Processing
• assisting with Reporting
• Timekeeping for data collectors
• collector scheduling (with Manager)
• assisting with upkeep of Vacation Planner
• various other secretarial tasks as needed

Questions for Pagasa

1

	Question	Modification date"Modification date" is a predefined property that corresponds to the date of the last modification of a subject and is provided by Semantic MediaWiki.
"cannot open any more tables" in Access	After 24 rows, open and closed assigning Pseudo Phin an error message pop up then I cannot assign Phin anymore. I closed CFE then open then I am good to go again. The second time the error message pop up not 24 rows it less than 24 like 15 rows then it will show again the error message. PTorres 16:09, 2022 June 14 (CDT) Is it the "cannot open..." error or the "enter parameter..." error you get at this point? Emailed Pagasa... Ttenbergen 10:49, 2022 November 16 (CST) Still shows "cannot open "so I clicked ok then it says run time error 3014 cannot open any more tables. Closed the CFE then log back in. After I continue assigning Pseudo Phin after 25 rows "cannot open" showed up again I clicked ok then error message shows again. Closed CFE then log back in.PTorres 14:42, 2022 November 30 (CST) Are you following the steps in Generating PseudoPHINs when this goes wrong? Which step in those instructions are you at when it stops responding and you need to restart the program? Ttenbergen 13:48, 2022 November 29 (CST) Yes, I am. I am clicking and assigning the new Pseudo Phin and not moving. PTorres 14:47, 2022 November 30 (CST) Assigning Pseudo Phin or working on the queries if I worked long enough opened closed it then the error message pop up "Enter Parameter Value". PTorres 17:01, 2022 April 14 (CDT) What is the specific action or button press after which this happens? I.e. which step in Generating PseudoPHINs? Ttenbergen 10:49, 2022 November 16 (CST) When I click the pseudo button to the left of the PHIN field label, nothing is moving.PTorres 15:23, 2022 November 30 (CST) I don't understand what you mean by that. What is the last thing you do before the "Enter Parameter Value" error happens? As in, what is the last button you click or last field you enter? Ttenbergen 12:15, 2022 December 7 (CST)	7 December 2022 18:15:25

Questions in category:Data processing

leave these data processing questions for now, Tina will go over these and take those that are not really data processing out of the category before we try to address the rest.

added: no added date action: no action date

• Cargo

• Categories

	Question	Modification date"Modification date" is a predefined property that corresponds to the date of the last modification of a subject and is provided by Semantic MediaWiki.
DSM Lab Extract	A possibility to change the current Chart entry to be the same with SH format (see #DSM Inclusion Criteria/ Process for reason why in details).	30 July 2025 16:32:23
ABG Data	Identified as something we should do to streamline data collection. I have made this page to document progress toward this import. Blood gas data is in DSM listing; need to compare to see if we can use it Allan will revisit with Lab people whether this is obtainable now Ttenbergen 11:34, 2022 February 9 (CST) Allan is negotiating inclusion of Labs data with Grace hospital as per Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2023#ICU Database Task Group Meeting – April 19, 2023, leaving this flagged to ensure update. Ttenbergen 14:00, 2023 May 17 (CDT)	30 July 2025 16:32:10
Standard data cleaning process	While discussing Visit Admit DtTm differences within same admission at JALT Meeting - Rolling Agenda and Minutes 2025#JALT 2025-03-11 I realized we don't have any part of your "cleaning" process documented. We should, even if it is a rudimentary notice of the SAS files you use and what you check for. Ttenbergen 21:51, 11 March 2025 (CDT) If there is linking beyond Populate linking pairs, or if you use a different linkage, we need to document that as well; do you? Ttenbergen 21:51, 11 March 2025 (CDT)	12 March 2025 02:51:43
DSM Labs data.accdb	Emailed Julie: found overlap in old file, what does it mean proposed using labDtTm for split threshold Ttenbergen 16:51, 2024 May 2 (CDT)	30 June 2025 06:12:40
Patients residing in Manitoba with ambiguous MH Health coverage	JALT The page name isn't quite right, this concept is still evolving in documentation. Some of these may be better off broken out as their own pages or templates and only indexed from here.	14 August 2025 17:06:29
Orphans in Centralized data.accdb	Pagasa, that would be "Laptop identifier instead of "location" now, right? Ttenbergen 10:12, 7 January 2026 (CST)	7 January 2026 16:12:00
Scanning to network	That scanner is gone, right?	18 March 2025 23:06:02

IT Access used

• File share HSC Critical Care
• Critical Care Sharepoint ExtraNet