Data Processor

From CCMDB Wiki
Jump to navigationJump 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

20

 QuestionModification 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.
Cleaning up a failed send 10 April 2019 15:04:37
TISS28 Form Scanning
  • If a frozen version is kept available during TISS scanning anyways then there is no reason to not do these checks in CFE, is there? Or rather, collectors sending would not be the reason. Pagasa, let's talk about this. Maybe we can make this more convenient for you. Or write down the actual reason why it can't be done. Ttenbergen 00:34, 2017 November 12 (CST)
    • Discussed this with Pagasa. It would mean doing scanning during send time, and likely doing all fixes during pull time, so all checks could actually be done form CFE. Discussed also w Pagasaa that we would delete the error checks from TISS so there is no duplicates getting out of sync.
      • Do we want to make this change then, Pagasa? You would be the only one who would be affected, so mostly up to you. Maybe confirm with Trish.


_dev_TISS

  • Put the queries in a drop down list or accessible through a button in TISS.mdb, similar to way queries are set up in CFE. Trish Ostryzniuk 11:21, 2019 February 7 (CST)
12 March 2020 16:13:29
Processing errors in patient data
  • It is not really clear what the steps are for Link suspect negative transit time query in regards to checking and correcting between EPR and Centralized Data. --Srusnak 17:32, 2017 January 5 (CST)

  • _dev_CFE

    Automate the populating of notes so button just does it. 
    
    • raise an input box for a summary, if gets content put data and content into Notes, else put nothing.
    4 July 2019 21:38:21
    Query NDC CLI vs DX but no TISS17 CentralLine
  • It said here that this should be retired, but this is still relevant, no? We stopped tmp, but the dc and the TISS entry still exist... Do you still run this tests?
  • 4 October 2019 19:26:00
    PL missing L Tables contentHave there been more since?
    • Pagasa, could you please log here when this query lists errors, and what was found to be the problem (ie whether there was data in CCMDB.accdb that didn't make it, or no data in first place.


    dev_CFE

    • Confirm this only deals with complete records
    • Needs to check not listing missing Dispo, Previous Location - email Pagasa when fixed.
    11 December 2019 22:21:47
    Query check CCI must have entry
  • Patients without CCI entries are slipping through and found by PL missing L Tables content , must fix PTorres 09:42, 2019 February 7 (CST)
    • I seem to remember discussing this with Pagasa. There was a misconception that a "no CCIs" had to be present in both component and picklist, but that is not true: it only needs to be in the Picklist. Is this still a problem? If so, please tell me an example when one comes up.
    • Michelle sent email 2019-10-31 that she was able to click "D" with no CCIs entered. I tested on my copy and got an error when I tried. Will need more info about the scenarios where this can slip through.
  • 18 November 2019 04:37:14
    Link suspect transfer ready before arrive date
    • Someone could be transfer ready before theArrive_DtTm , if they become transfer ready after the Accept_DtTm. Is this really a good check to do? It sounds like it would have plenty of false positives. Should it be Accept_DtTm instead?
    23 February 2020 22:49:36
    Link suspect mismatch to ours incomplete query
    • There is a query Link suspect mismatch to ours incomplete2 (with a 2 at the end) in CFE. What is the story, and which one do you actually use?
    31 October 2018 23:36:26
    Changing D IDs
    • Which program do you do this in? This may actually need to be different instructions for different scenarios.


    • what queries would get you to change a D_ID? We would want to cross-link them so they point to these instructions, and so these instructions can list them as cause.


    • what queries would get you to change a D_ID for medicine? We would want to cross-link them so they point to these instructions, and so these instructions can list them as cause.

    How about L TISS Form table, L TISS Item table and L Labs DSM table? Are there others I am not thinking about ? Ttenbergen 22:20, 2019 February 6 (CST)
    7 February 2019 05:35:20
    Crash TISS MDB 24 September 2019 20:33:20
    Bed Census Data Processing Instructions
    • is this the current process, or is Bed_census.mdb? I think the process is better off here than in the .mdb article.


    • probably incomplete... Ttenbergen 18:17, 2016 April 14 (CDT) emailed Trish/PAgasa Ttenbergen 16:46, 2018 October 30 (CDT)


    what is the purpose of having clerk processing this data?

    • quality control?
    • preparing for reports?
    • ?
    • copy the database back up to the server
      • which server?
    13 November 2019 23:59:22
    StatusReport.bat
    • have we got rid of all these old files? IF so we can delete these articles, but if they are still around we might want to keep them... I think we should just get rid of the files, though. Ttenbergen 22:42, 2017 June 7 (CDT)
      • confirmed that X:\PAGASA\STATUS_REPORT still exists; can we clean that up?
    7 November 2019 21:36:21
    Encounter processing
    • says inactive, but do you actually do this? Is there anything else to it? Do we have, and do you run any multi-encounter checks yet? I guess a lot of the PLs kind of are those...
    7 February 2019 05:38:55
    Scheduled TasksDo we still schedule Backup Checker?10 March 2019 04:43:46
    TISS28 backup and start.vbsDo you still use this? It is not linked, so as part of what process?24 September 2019 20:33:32
    Fixing a D ID in TISS28.accdbPagasa will test the quicker way, and if satisfied, will clean out the two old methods.24 September 2019 20:33:25
    Data Integrity Checks/review listPagasa, regarding the meeting with Trish, Julie and Allan to decide which checks to continue to do when, please
    • expand this list to 50
    • click the “edit w f” link at the start of the line to open any that need change right in a form to use dropdowns to update them
    • confirm that all queries correctly list
      • whether you check them always or only complete (timing field)
      • whether they use L_Problem
      • whether there is a backlog (I just added that field, it defaults to "yes" so change to no if caught up)
    20 June 2019 22:37:55
    Pre-linking checksnot working right now due to PL_SamePHIN_Site_Diff_chart size limit
    This automatic list includes an PL missing L Tables content - where does it fit in into the order in which you run these above? It is likely a very first thing, right?
    20 March 2019 21:48:48
    Procedure when there are differences between L Log and L PHIWhy, what does that tell you? The only way I can imagine this would happen is if the record was deleted in centralized L_Log. In that case, if you are lucky and there is still a ccmdb_data with the completed/sent record, you can follow the Re-sending data process. If not, find it in a previous version of Centralized data.mdb, print or write down all data for the record, and manually re-enter it in a CCMDB.accdb and follow the Re-sending data process. Or what do you do? Ttenbergen 21:38, 2019 February 6 (CST)22 September 2019 16:45:24
    Query NDC Bad Postal CodeYou mentioned that you occasionally got patients with letters rather than numbers; if that happens again, pls let me know.15 January 2020 19:14:42

    Questions in category:Data processing

    Swiss Army Knife.svg

    leave these 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.

    • SMW


    • Cargo


    • Categories
     QuestionModification 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.
    Staphylococcus aureus"It was decided that Allan with contact Dr. Embil and see if we can obtain this data from Infection Control. If so, we could import it into the database, and have our data collectors cease obtaining it." - did anything come of that?20 July 2018 19:31:56
    Panelling or Discharge PlanningThat link no longer goes anywhere, the heading is not on that page. Can the reference be deleted from here, or do we need to review? And, how will this affect the use of the Category:Awaiting/delayed transfer codes? Ttenbergen 14:51, 2018 September 6 (CDT)
    28 November 2018 04:53:25
    Check pre acute consistentwhat exactly do we want to check for? Please also have a look at the stuff below that doesn't specifically have your name. This requested check ties into a bunch of things and if we want the check we need to be sure that instructions stay consistent and lose ends are tied up.
    There was a previous attempt to address some of this in Care levels in the community; this page and it need to be consistent, and consistently linked from the relevant field definitions. If we can get it short enough we might make a template to apply the instructions to each of the field pages.
    There was talk about comparing Postal Codes to known PCH Postal Codes. Since these might Include other buildings at the same site that are not PCHs, this check can at best be a soft check. Please add the list of these postal codes here.
    • from a data perspective, what do you mean by "admitted directly"? If I were to build a check, where would I find that? OR maybe I don't need to know, but then I need to have a definition of what combination of data would be an error.

    Integrity check


    • ... unless they are discharged somewhere else entirely, like another ward. So what do we really mean with this? That they can't come from one PCH and go to another or maybe "home" after all?
      • I realize this maybe hard to do. what I mean here is that if one is already a PCH resident, when leaving the hospital, the dispo location must be a PCH location too. or is a patient is already in CHF, the destination when leaving the hospital must either be a CHF or another PCH.


    • The listed postal codes are correlated to the items ‘PCH’ and ‘Chronic Health facility’ of the Pre-Acute Living Situation. Since the data collectors are collecting the postal code from the patient’s address, will it be possible to automatically fill up the Pre-Acute Living Situation as PCH or Chronic Health facility if the PCH postal codes are entered or ‘other ways’ to link the two fields and make them consistent. Info about PCH is now getting more attention/request. Tina, Will this be hard to do? Any suggestions?
      • I have changed my mind to add the PCH postal code to the Postal_Code_Master due to the possible effect on its size (when adding a new column containing text where most of the records will only be blanks). It is better to have it in separate table since this pertains to Winnipeg area only. I have added the exact address of these PCH facilities - link to table in email sent on Jan 12.18 at 1224 hrs from p:Julie Mojica
        • Is any change to CFE still required then? If not, please remove this discussion and heading. Ttenbergen 15:47, 2019 July 4 (CDT)

    How does Chronic Health Facility fit into this? Or Imprisonment/incarceration and other info in Prison / Jail / Correctional Institution?
    22 September 2019 16:44:32
    Query TISS Errors ETT consistent
    • A patient might arrive intubated, so there would be no intubation. Does this check really make sense? Ttenbergen 23:23, 2019 March 25 (CDT)
      • I have revised the conditions, pls check if they now make sense.--JMojica 16:38, 2019 July 9 (CDT)
    18 July 2019 18:00:55
    Cleaning up a failed send 10 April 2019 15:04:37
    TISS28 Form Scanning
    • If a frozen version is kept available during TISS scanning anyways then there is no reason to not do these checks in CFE, is there? Or rather, collectors sending would not be the reason. Pagasa, let's talk about this. Maybe we can make this more convenient for you. Or write down the actual reason why it can't be done. Ttenbergen 00:34, 2017 November 12 (CST)
      • Discussed this with Pagasa. It would mean doing scanning during send time, and likely doing all fixes during pull time, so all checks could actually be done form CFE. Discussed also w Pagasaa that we would delete the error checks from TISS so there is no duplicates getting out of sync.
        • Do we want to make this change then, Pagasa? You would be the only one who would be affected, so mostly up to you. Maybe confirm with Trish.


    _dev_TISS

    • Put the queries in a drop down list or accessible through a button in TISS.mdb, similar to way queries are set up in CFE. Trish Ostryzniuk 11:21, 2019 February 7 (CST)
    12 March 2020 16:13:29
    Processing errors in patient data
  • It is not really clear what the steps are for Link suspect negative transit time query in regards to checking and correcting between EPR and Centralized Data. --Srusnak 17:32, 2017 January 5 (CST)

  • _dev_CFE

    Automate the populating of notes so button just does it. 
    
    • raise an input box for a summary, if gets content put data and content into Notes, else put nothing.
    4 July 2019 21:38:21
    Manitoba Health Crosschecking Background
  • Need to know how this arrives to set up processing. Where will this data live? Ttenbergen 16:11, 2014 August 25 (CDT)
    • Actually, I think you have not been getting those for ages, right? We would just need to update that. We may or may not blow away this page, depending on whether we think we will ever get this again.
  • 7 November 2019 22:55:54
    Link suspect mismatch to ours incomplete query
    • There is a query Link suspect mismatch to ours incomplete2 (with a 2 at the end) in CFE. What is the story, and which one do you actually use?
    31 October 2018 23:36:26
    Care levels in the community
    • There usually isn't much info in the charts about the "type" of group home or level of care provided there, so in those cases we have been coding "other - known but not listed". Please clarify --Jvelasco 13:47, 2019 September 4 (CDT)
      • Julie, how do we use this, and how should this be coded in unclear cases? If you are not sure about the answer either, could you bring it to Task?
    3 October 2019 03:38:51
    Query s tmp Borrow sensible DtTm vs no borrow
    • This cross check does not seem to require a check box to send completed chart ** confirmed, check is disabled in VBA with comment "2019-01-24 disabled for now because too many errors". I think we were concerned at the time because of high workload and fresh ICD10/CCI and didn't want to analyze and fix then. We will need to review what this should be to get an acceptable number of errors only.
    24 September 2019 19:11:39
    Query s tmp Bording Loc sensible DtTm vs no borrow
    • This cross check had been disabled for Borrow Arrive because there were many errors: check was disabled in VBA with comment "2019-01-24 disabled for now because too many errors". I think we were concerned at the time because of high workload and fresh ICD10/CCI and didn't want to analyze and fix then. We will need to review what this should be to get an acceptable number of errors only.
      • Are we ready to have a cross check for this that requires either
        • no borrow and a checkbox and no time
        • at least one borrow location and a time
    25 September 2019 22:25:25
    Changing D IDs
    • Which program do you do this in? This may actually need to be different instructions for different scenarios.


    • what queries would get you to change a D_ID? We would want to cross-link them so they point to these instructions, and so these instructions can list them as cause.


    • what queries would get you to change a D_ID for medicine? We would want to cross-link them so they point to these instructions, and so these instructions can list them as cause.

    How about L TISS Form table, L TISS Item table and L Labs DSM table? Are there others I am not thinking about ? Ttenbergen 22:20, 2019 February 6 (CST)
    7 February 2019 05:35:20
    Boarding LocWhich if any of Project_Borrow_arrive#Data_Integrity_Checks_.28SMW.29 will need to be moved over to this instead?
    • ECIP - these are now happening, so how would we enter them?
    • EMIP - this structure could accommodate EMIPs, but the problem is
      • how do we identify then (right now people take turns at some sites...
      • which collector would collect them what service/location do we collect them as? Right now we have a special service location for these...
      • how about that "service x" at HSC?
    2 March 2020 21:53:00
    Bed Census Data Processing Instructions
    • is this the current process, or is Bed_census.mdb? I think the process is better off here than in the .mdb article.


    • probably incomplete... Ttenbergen 18:17, 2016 April 14 (CDT) emailed Trish/PAgasa Ttenbergen 16:46, 2018 October 30 (CDT)


    what is the purpose of having clerk processing this data?

    • quality control?
    • preparing for reports?
    • ?
    • copy the database back up to the server
      • which server?
    13 November 2019 23:59:22
    StatusReport.bat
    • have we got rid of all these old files? IF so we can delete these articles, but if they are still around we might want to keep them... I think we should just get rid of the files, though. Ttenbergen 22:42, 2017 June 7 (CDT)
      • confirmed that X:\PAGASA\STATUS_REPORT still exists; can we clean that up?
    7 November 2019 21:36:21
    Encounter processing
    • says inactive, but do you actually do this? Is there anything else to it? Do we have, and do you run any multi-encounter checks yet? I guess a lot of the PLs kind of are those...
    7 February 2019 05:38:55
    Completeness of TISS records
    • we will track the TISS outstanding status in the L_PHI.notes field
    • that field will be made available in CFE underneath notes field
    • email button will be changed to store in L_PHI.notes
    • Pagasa will clear notes field when done
    • update definition for "vetted" to reflect it does not include TISS
    • move all TISS queries into CFE
    4 June 2019 17:36:28
    EPR Reports
    • Is it only your sites, or all sites in Regional.
    • Do you use them to obtain transfers admits and discharges?
    11 February 2020 18:13:48
    List of diagnoses affecting Overstay Project (pre-ICD10)
    • in reconciling these, a lot are based on Charlson Comorbidities in ICD10 codes, so whatever we use there should be consistent with here.
      • Allan was OK with these at list meet today Ttenbergen 14:58, 2019 February 25 (CST)
    25 February 2019 20:58:13
    ICUotherService
    • t looks like there are now more options below... does the rest of this page need to be updated to reflect that? Ttenbergen 19:06, 2020 January 28 (CST)
    29 January 2020 01:06:11
    ABG Data1
    • 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
    9 December 2019 22:35:52
    Blood Product Data1
  • Identified as something we should do to streamline data collection. I have made this page to document progress toward this import.
  • 4 December 2019 16:24:32
    Direct Data Access for RIS/PACS1
  • Identified as something we should do; the notes below are quite old but might still be a starting point.
  • 4 December 2019 16:27:41
    Transfer Delay1q
  • This says it's only for survivors. Is that actually right, to exclude deceased pt? They were still delayed while alive so still "wasted" bed time. Excluding them may be inconsistent with our definition of Transfer Ready as the first time they are ready.
  • 3 October 2019 15:22:15
    Clinical Practice Management (CPM)Check up with Alan Madick about this in 6 months if we still need it.4 December 2019 16:22:42
    TISS28 backup and start.vbsDo you still use this? It is not linked, so as part of what process?24 September 2019 20:33:32
    Query NDC VAP no TISSFYI Maybe
  • Pneumonia,_ventilator-associated_(VAP)#VAPs_on_medicine_wards mentions to use the same rules as for other Acquired Diagnoses, ie the dx is acquired where it first manifests, so this check or rule no longer makes sense. If you are OK with this, please take this note out, else pls comment here.
  • 19 June 2019 18:31:08
    Reconnect CFE and initial error checksre-name these so not PL any more
    Fix why it gives this error as part of fixing DSM process.
    Tina will fix Query check CCI must have entry so those are caught going forward.
    7 February 2019 16:00:02
    Project Discharge DocumentationI could set up a query in CFE to dump this to keep it off Julie's desk. This user might find speed more important than quality? If needed, let me know.
    pls fill in once you set it up
    Will these documents be retained on charts once they hit med records?
    21 January 2020 18:50:07
    Query NDC CLI AcqDX but NoCLI DateinTMPV2ICD/CCI Please removePTorres 11:48, 2019 July 24 (CDT)18 September 2019 20:58:14
    Query NDC CLI No AcqDX but CLI DateinTMPV2ICD/CCI Please removePTorres 11:49, 2019 July 24 (CDT)18 September 2019 20:58:21
    QA Septic ShockIf we ever pick this back up we need to answer: Is "Every entry for project QA Septic must have either a date or a time." a request for a cross check? or does that check exist already?16 September 2019 19:43:49
    Critical Care Vital Signs MonitoringIt says that CCVSM is in Quarterly report. If CCVSM is no longer, is it still in quarterly?21 January 2019 18:46:58
    Query check overstay pt from our medNeeds to be cleaned up now that Overstay is done.2 March 2020 18:08:37
    Query check tmp generate allowedNeeds to be cleaned up now that Overstay is done.2 March 2020 18:08:27
    Fixing a D ID in TISS28.accdbPagasa will test the quicker way, and if satisfied, will clean out the two old methods.24 September 2019 20:33:25
    Overstay Predictor Project Collection InstructionsStickers dots put one charts....? thought we stopped....?Trish Ostryzniuk 16:55, 2019 November 12 (CST)
  • The STB medicine program has not been placing red dots on charts since I started working here. I did try it on a few occasions shortly after I started and it was around 30 mins. round trip. Occasionally charts were not available which would necessitate a return trip. There is not enough time allotted in medicine program EFT to physically chase charts on units to place stickers.--p:Pam Piche. 2019-Nov-12
  • At the Grace, we haven’t put red dots on the charts for months, as we were so far behind, it was irrelevant by the time the color was determined. p:Lisa Kaita. 2019-Nov-10
  • Only when we have time to go over to the wards.--p: Debbie Page Newton. 2019-Nov-8
  • We don’t do that at our site anymore. I often don’t even get around to generating a color until after they are discharged because we are so behind.--p:Michelle Lagadi 2019-Nov-7
  • 13 November 2019 23:12:59
    Pre-linking checksnot working right now due to PL_SamePHIN_Site_Diff_chart size limit
    This automatic list includes an PL missing L Tables content - where does it fit in into the order in which you run these above? It is likely a very first thing, right?
    20 March 2019 21:48:48
    Validation against Patient Registry DataThis page was started long ago to keep track of our attempt to get access to the registry. I think it would be good to re-convene on it so we have a central point where past efforts and current efforts can be tracked. That would also make it easier to take it to task or steering and have consistent info. Do you have a log of this somewhere? We can rename it if you want.3 January 2019 21:26:12
    CognosTina will update the code and process for EPR Reports Integrator to use this new data source, including a way to get it into collector laptops from this file share collectors don't have access to.19 March 2020 19:48:31
    Procedure when there are differences between L Log and L PHIWhy, what does that tell you? The only way I can imagine this would happen is if the record was deleted in centralized L_Log. In that case, if you are lucky and there is still a ccmdb_data with the completed/sent record, you can follow the Re-sending data process. If not, find it in a previous version of Centralized data.mdb, print or write down all data for the record, and manually re-enter it in a CCMDB.accdb and follow the Re-sending data process. Or what do you do? Ttenbergen 21:38, 2019 February 6 (CST)22 September 2019 16:45:24
    Query NDC Bad Postal CodeYou mentioned that you occasionally got patients with letters rather than numbers; if that happens again, pls let me know.15 January 2020 19:14:42
    Query TISS Errors missing dayswhich report/s are these actually included in?
    _Dev_TISS28 change to wait till complete
    4 October 2019 19:40:11
    PL 2Phin Fake or Blank_dev_CFE As per meeting with Allan, Julie and Pagasa: (1) only if complete AND (2) only do links in incomplete if have PHIN.4 October 2019 16:17:49
    Query NDC zCRRT TISS no tmp_dev_CFE - remove this and *old4 October 2019 19:32:37
    Query NDC zCRRT tmp no TISS_dev_CFE - remove this and *old4 October 2019 19:33:02
    PL SamePHIN Site Diff chart_dev_CFE 1 this query has reached the 2GB limit, must see if I can lean it out or otherwise reduce the size4 July 2019 21:14:10
    Project Borrow arrivedid they ever get back to us? no response from HSC SICU --JMojica 10:14, 2019 May 6 (CDT)29 January 2020 16:54:02
    Data Processorleave these 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.26 March 2019 03:16:37
    H1N1seems odd that we would have done a flu study only for 1 month in a summer...3 January 2019 05:14:23
    Adding a CCI or ICD10 entry in CFEwe need a better solution, I need to make that ID field populate automatically.10 April 2019 16:01:51
    TISS Form (TISS28)where does one get that requisition form?
    what actually needs to be specified when ordering?
    12 February 2020 13:54:47
    QA Infection VAPwill we still need to collect this in ICD10, since I think all the data now lives in the dx codes as well. I am holding off on implementing Query s tmp QAInf tmp no dx until resolved. same reply as in QA CLI. --JMojica 12:04, 2018 December 27 (CST)28 May 2019 19:32:55
    Questioning data back to collectorsz
    • Possible future scenario: The data processor puts the concern into the Notes field and sets the RecordStatus field to "questioned". Next time the collector sends, the record is returned to the laptop by a series of queries. The collector updates the record, sets it to "complete" and sends it in with the next round of sends, at which time it will be processed like any other record.

    This process is more automated and would need to be validated before we could implement. It would be the least work for all involved, though, I think.

    We keep discussing this, talked about it again today. Ttenbergen 17:44, 2016 December 1 (CST)
    10 March 2019 04:32:26

    IT Access used

    Related Articles

    Related articles: