Data Processor

From CCMDB Wiki
(Redirected from Data processor)
Jump to navigation Jump to search

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

Questions for Pagasa

4

edit page question ModDate
edit page question ModDate
edit "cannot open any more tables" in Access
  • After which action or button-press do you get the error "cannot open any more tables" in Access?
  • When I am assigning Pseudo Phin I clicked ok then the error message shows up run time error 3014 cannot open any more tables.
  • Clicked end and close the CFE and log back in again. PTorres 14:54, 2022 November 30 (CST)
2022-11-30 9:23:53 PM
edit R Filter Field
  • Emailed Pagasa to please run the following queries to clear out this field. Ttenbergen 09:52, 2022 August 4 (CDT)
  • 2022-09-01 10:19:07 PM
    edit Run-time error when closing CFE
  • Pagasa, do you have more details about this? Ttenbergen 20:54, 2022 June 1 (CDT)
  • Right now I don't get this error message.PTorres 16:11, 2022 June 22 (CDT)
  • 2022-06-22 9:11:06 PM
    edit Gaps and overlaps
  • Pagasa, we discussed this today, and you said you would put this into L_Problems and then delete the info from the excel sheet (or the whole excel sheet if all has been transitioned). Putting this here so it is on your list. Ttenbergen 15:34, 2022 March 31 (CDT)
  • when all has been moved to l_problem, the "current state" above can be deleted and we can just leave the "future state" portion as documentation. Ttenbergen 15:45, 2022 March 31 (CDT)
  • 2022-03-31 8:45:14 PM
    edit "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)
    2022-11-30 9:23:53 PM
    edit "cannot open any more tables" in Access
  • 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)
    2022-11-30 9:23:53 PM
    edit Gaps and overlaps
    The Data processor keeps an Excel workbook that includes: reason some profiles are missing data elements (APACHE - 8 ICU profiles), gaps in database because of deletions including reasons for deletions, overlaps, overs. Example missing all APACHE elements ... and reason why could never be obtained.
    • It sounds like there might be other known error types in addition to lost, gap and overlap. Feel free to add them to L_Problems as well, just put here what any additional options mean. If needed I will pull the wiki pages apart. Ttenbergen 15:41, 2022 March 31 (CDT)
    2022-03-31 8:45:14 PM

    IT Access used

    Related Articles

    Related articles: