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

19

	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.	Last editor is "Last editor is" is a predefined property that contains the page name of the user who created the last revision and is provided by Semantic MediaWiki.
Scanning to network	Discussed with Pagasa to test scanning larger volume to make this smudge problem show up, but then giving the scanner ~15 minutes to cool down without cleaning it to test if this is really an overheating issue. Waiting to hear back. PTorres 09:49, 2019 February 11 (CST)	11 February 2019 15:49:58	Pagasa Torres
Correcting Person IDs	Do you ever manually change Person_IDs (as opposed to Generate Person IDs)? What are the circumstances? What are the steps?	7 February 2019 05:47:28	Ttenbergen
Cleaning up a failed send	How do you figure out why it happened? What are likely scenarios here? Is this related to Procedure when there are differences between L Log and L PHI or Orphans in Centralized data.mdb?	7 February 2019 05:16:32	Ttenbergen
Data Processing Priority	Is this still accurate? How about other days? Why those days? This page needs to be set up so that whoever covers would know how to determine the priority.	7 February 2019 05:25:05	Ttenbergen
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) 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.	7 February 2019 16:43:11	Pagasa Torres
Changing PHINs	Pagasa, are there other things you do in this case? Probably change for other encounters if not just a typo. Anything else? Ttenbergen 11:55, 2017 September 18 (CDT)	7 February 2019 04:31:30	Ttenbergen
PL missing L Tables content	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.mdb that didn't make it, or no data in first place.	7 January 2019 03:24:29	Ttenbergen
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	Ttenbergen
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	Ttenbergen
PL Chart 9 Digit	Function Validate Chart should capture all of these in CCMDB.mdb. Emailed Pagasa to find out if she ever actually finds any in here. If she does we need to fix Function Validate Chart, if she doesn't she could stop running this check. I did end up checking Function Validate Chart 2018-11-24 to confirm that the check >8 digits is being run. If there are others problems that slip through please log them as DT at Function Validate Chart	7 February 2019 14:34:25	Ttenbergen
Crash TISS MDB	TISS28 Form Scanning doesn't have a step for run reports... is this still a thing?	11 February 2019 17:02:28	Ttenbergen
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	Ttenbergen
TISS28 backup and start.vbs	Do you still use this? It is not linked, so as part of what process?	7 February 2019 03:31:50	Ttenbergen
"Pulling" Centralized data.mdb	Is name and icon still right?	7 February 2019 03:43:45	Ttenbergen
Fixing a D ID in TISS28.mdb	Pagasa will test the quicker way, and if satisfied, will clean out the two old methods.	11 February 2019 22:30:49	Pagasa Torres
Pre-linking checks	That includes an PL missing L Tables content - where does it fit in? It is likely a very first thing, right? not working right now due to PL_SamePHIN_Site_Diff_chart size limit	7 February 2019 16:20:42	Pagasa Torres
Linking in centralized data front end.mdb	Why are these not the same as below? What are we doing now? Do these need to be done in a specific order?	30 January 2019 19:26:22	Ttenbergen
Procedure when there are differences between L Log and L PHI	Why, 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.mdb and follow the Re-sending data process. Or what do you do? Ttenbergen 21:38, 2019 February 6 (CST)	7 February 2019 03:44:39	Ttenbergen
FirstName field	under #Legacy info it said we stopped messing with names so cross checks with old data would work. If we no longer do that we should fix the reasoning there.	7 February 2019 05:32:02	Ttenbergen

Questions in category:Data processing

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.

	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.	Last editor is "Last editor is" is a predefined property that contains the page name of the user who created the last revision and is provided by Semantic MediaWiki.
Panelling or Discharge Planning	That 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) There are a lot of details. Which need to come over to one of the pages in Category: Awaiting/delayed transfer? Ttenbergen 14:51, 2018 September 6 (CDT)	28 November 2018 04:53:25	Ttenbergen
Check pre acute consistent	what 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. How does Chronic Health Facility fit into this? 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 if Previous Location field ='Home' then Pre acute living situation field is either Apartment, Assisted Living,Supportive Housing,Prison / Jail / Correctional Institution or House; otherwise Error. if Previous Location field = 'Deer Lodge' or 'Riverview' or 'St Amant' then Pre acute living situation field = Chronic Health Facility; otherwise Error. if Previous Location field = 'any PCH location' then Pre acute living situation field = Personal Care Home; otherwise Error. ... 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. Need to look at the PCH Postal code data. It may be relevant to this check that we have ICD10 Imprisonment/incarceration and other info in Prison / Jail / Correctional Institution.	21 December 2018 16:09:26	Ttenbergen
Scanning to network	Discussed with Pagasa to test scanning larger volume to make this smudge problem show up, but then giving the scanner ~15 minutes to cool down without cleaning it to test if this is really an overheating issue. Waiting to hear back. PTorres 09:49, 2019 February 11 (CST)	11 February 2019 15:49:58	Pagasa Torres
Correcting Person IDs	Do you ever manually change Person_IDs (as opposed to Generate Person IDs)? What are the circumstances? What are the steps?	7 February 2019 05:47:28	Ttenbergen
Cleaning up a failed send	How do you figure out why it happened? What are likely scenarios here? Is this related to Procedure when there are differences between L Log and L PHI or Orphans in Centralized data.mdb?	7 February 2019 05:16:32	Ttenbergen
TISS28 Form Scanning	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) 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	11 February 2019 22:23:10	Pagasa Torres
Data Processing Priority	Is this still accurate? How about other days? Why those days? This page needs to be set up so that whoever covers would know how to determine the priority.	7 February 2019 05:25:05	Ttenbergen
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) 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.	7 February 2019 16:43:11	Pagasa Torres
Comfort Care	We may be able to stop this when ICD10 comes; but continued collection wont break anything. Julie, can you add here why this can stop when ICD10 comes? Is it because we will start collecting Palliative care? Because that is not really the same definition... We will need to update a the reference to this in Palliative_care#This_code_vs_Comfort_Care once decided.	1 February 2019 17:50:15	Ttenbergen
Changing PHINs	Pagasa, are there other things you do in this case? Probably change for other encounters if not just a typo. Anything else? Ttenbergen 11:55, 2017 September 18 (CDT)	7 February 2019 04:31:30	Ttenbergen
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	Ttenbergen
IICU consult	To cross check query s_tmp_IICU_consult_not_paired I was thinking through special cases and realized that we don't have a definition for what to do if there are multiple consults, e.g. there is a consult, pt deteriorates and consult is no longer applicable, and then pt gets better and there is a second consult. How would that work on ward in real life, and how would we want to code that? Ttenbergen 12:49, 2019 January 22 (CST) would there ever be 4, 6, 8 records, or do we only enter the first consult? Or, for that matter, would there ever be a second consult before the first is acted on? how would this work for patients who leave the unit before the consult is answered? the newest instructions mention that STB might only have the first entry... if so will they need to be excluded from this check?	22 January 2019 18:50:12	Ttenbergen
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	Ttenbergen
PL Chart 9 Digit	Function Validate Chart should capture all of these in CCMDB.mdb. Emailed Pagasa to find out if she ever actually finds any in here. If she does we need to fix Function Validate Chart, if she doesn't she could stop running this check. I did end up checking Function Validate Chart 2018-11-24 to confirm that the check >8 digits is being run. If there are others problems that slip through please log them as DT at Function Validate Chart	7 February 2019 14:34:25	Ttenbergen
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)	9 November 2018 01:05:32	Trish Ostryzniuk
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	Ttenbergen
PL SamePHIN Site Diff chart	1 this query has reached the 2GB limit, must see if I can lean it out or otherwise reduce the size	7 February 2019 16:16:51	Pagasa Torres
TISS28 backup and start.vbs	Do you still use this? It is not linked, so as part of what process?	7 February 2019 03:31:50	Ttenbergen
Query NDC VAP no TISS	FYI 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.	7 February 2019 14:08:04	Ttenbergen
Reconnect CFE and initial error checks	re-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	Pagasa Torres
Query NDC CLI No AcqDX but CLI DateinTMPV2	ICD/CCI remove once old pt gone	7 February 2019 14:06:07	Ttenbergen
Query NDC CLI AcqDX but NoCLI DateinTMPV2	ICD/CCI remove once old pt gone	7 February 2019 14:05:59	Ttenbergen
QA Septic Shock	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?	3 January 2019 05:41:09	Ttenbergen
"Pulling" Centralized data.mdb	Is name and icon still right?	7 February 2019 03:43:45	Ttenbergen
Critical Care Vital Signs Monitoring	It says that CCVSM is in Quarterly report. If CCVSM is no longer, is it still in quarterly?	21 January 2019 18:46:58	Ttenbergen
Fixing a D ID in TISS28.mdb	Pagasa will test the quicker way, and if satisfied, will clean out the two old methods.	11 February 2019 22:30:49	Pagasa Torres
Pre-linking checks	That includes an PL missing L Tables content - where does it fit in? It is likely a very first thing, right? not working right now due to PL_SamePHIN_Site_Diff_chart size limit	7 February 2019 16:20:42	Pagasa Torres
Validation against Patient Registry Data	This 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	Ttenbergen
Query TISS Errors NrTISSDays NE LOS	Tina to break out this standard check information to a different page to link to... and clean up duplication	11 February 2019 22:15:54	Pagasa Torres
Generate Person IDs	We don't have process to populate L_Hospitalization worked out yet.	7 February 2019 18:31:53	Pagasa Torres
Linking in centralized data front end.mdb	Why are these not the same as below? What are we doing now? Do these need to be done in a specific order?	30 January 2019 19:26:22	Ttenbergen
Procedure when there are differences between L Log and L PHI	Why, 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.mdb and follow the Re-sending data process. Or what do you do? Ttenbergen 21:38, 2019 February 6 (CST)	7 February 2019 03:44:39	Ttenbergen
CRRT	Would it make sense (e.g. are the stickers of a size where this is possible) to give the nephrologists stickers so they can attach them as needed? Ttenbergen 15:14, 2018 September 21 (CDT)	3 January 2019 05:09:07	Ttenbergen
Project Borrow arrive	did they ever get back to us?	23 January 2019 00:15:12	Ttenbergen
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.	6 February 2019 06:53:05	Ttenbergen
Data Processor	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.	7 February 2019 18:37:39	Pagasa Torres
Query TISS Errors TISS date out of admission	pull into standard troubleshooting page: if there is an extra TISS day that is identical to previous, just delete it, if the "offending" TISS day is different from surrounding, then confirm with collector	11 February 2019 22:17:23	Pagasa Torres
Query s tmp IICU consult not paired	see question in IICU_consult#Multiple_Consults	22 January 2019 18:50:32	Ttenbergen
H1N1	seems odd that we would have done a flu study only for 1 month in a summer...	3 January 2019 05:14:23	Ttenbergen
Correcting suspect links	update when the button has been added: When done, click the ... button to confirm all link_suspects queries are clean.	7 February 2019 17:38:11	Pagasa Torres
Query TISS Errors missing days	which report/s are these actually included in?	11 February 2019 22:14:57	Pagasa Torres
QA Infection VAP	will 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)	3 January 2019 05:08:29	Ttenbergen