User:Ttenbergen/questions for tina

76

	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.
Colonized with organism (not infected)	Are all of these actually things that can colonize without infection? We should only list those here that can. I started adding in links but then decided to hold off in case a lot of them drop off this list. Ttenbergen 15:34, 2018 November 28 (CST) make sure this is consistent with Lab and culture reports	13 February 2019 18:56:15	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
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
Deceased patients	Is that really what you want? It will give fact that patient died, but miss new location. Is that really what you want? It will give occupancy but miss actual time of death. to be done likely after DSM: add destinations to organ donor deaths. 1 Julie asks: how to add a code for palliative care/ comfort care at discharge and/or change dx palliative service. Can we change the dispo field so it implies where organ donors went? (See #discussion about organ donor collection) Allan confirmed that we can change the dispo field so it implies where organ donors went? (See #discussion about organ donor collection) Once that is implemented, I can set up Check dx implying death across encounters. Correcting suspect links also needs to be dealt with when this is done. And needs to be documented.	7 February 2019 17:31:06	Pagasa Torres
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
APACHE Comorbidities in ICD10 codes	Need to update from Allan's email 2018-11-26, but he said he would need to review this in light of the changes that had been made to ICD10 and CCI since he and Julie discussed. Ttenbergen 00:36, 2018 November 27 (CST) There was a comment on Chronic Health APACHE about extracting the APACHE Comos from comorbid diagnoses instead using the ranges Allan provided. Provided this list is updated to the newest ranges Allan has provided, do you see a problem with using this approach instead and stopping collection of the Chronic Health APACHE field going forward?	23 December 2018 04:06:53	Ttenbergen
S ICD10 table	There is a field "ICD10_ID" which is legacy and won't be used. Planned to remove in next version, leaving for now to have one less moving part during a data update. Ttenbergen 17:06, 2018 April 3 (CDT)	29 November 2018 21:42:24	Ttenbergen
Instructions for importing a batch of DSM Data	Something is still not right with the code for reconnecting, Tina needs to look into. Ttenbergen 17:04, 2018 May 17 (CDT) This could also be true where no labs were sent for, eg a patient who dies shortly after arrival. In the past we would have entered a "no labs" for these. Do we want to do something similar? It would have to be Pagasa that does it. Might be a lot of extra work. Need to review. (ex. wrong D_ID when exported but found it error and so fixed it before the data for import comes back). For now we do not have an entry like that. And it might not be worth it - what would Pagasa do to check that the no-labs are legit?	14 February 2019 22:09:22	Ttenbergen
Awaiting/delayed transfer to other care facility NOS	We probably don't need this code from a data use perspective (as confirmed by AG 2018-11-30) but we might need it for cross checks like Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days or similar; will keep this code until we have worked out if those checks will be possible.	7 February 2019 16:57:53	Joanna Velasco
Data dictionary	something went wrong with this query and it has no data Attempt at a easier to follow data dictionary. Is this what you had in mind? Yes, this is what I have in mind. Thanks. Some suggestions: I just notice some start dates are not the actual start dates - It is important for the users to know how far back the data are available so they can decide the covered period of their study. is it possible to change the date to actual earliest collection start date (not 1 Jan 1900). --JMojica 10:05, 2019 January 3 (CST) The start and end dates are stored on the individual pages. If the list shows 1900 then they were not filled in. If you know what they are and fill them in then this page will list them. I can also change the default if-not-filled value in templates to something other than 1900-01-01. I just needed a value for ranges and filters to work. Ttenbergen 14:49, 2019 January 3 (CST) add a column for program (Critical care only or Medicine only or both). I can do that, but the table is already getting quite wide for a web page. Can we lose any of the columns we currently have? The info you mean is always visible in the pages themselves as well, in case that's sufficient. But, yes, we can tweak what the tables should show. It is done in Template:DataDictionaryQuery (details visible once you edit it...) and removing fields would be easy enough. I can show you how to add fields. Or I can add them once we confirm what we want. Tina has changed the ICD10 and CCI templates to use a startdate of 2019-01-01 and will change other default dates as I receive dates Julie wants me to use.	14 January 2019 11:34:54	Ttenbergen
Bronchitis, acute or chronic not specified, infectious or noninfectious	bringing you in on existing discussion APACHE CHRONIC stuff related coding schemas This does not trigger APACHE Acute Dxs in ICD10 codes while some other dxs that seem no more "intense" do. Is that right? AG REPLY --- Leave it OUT, it's a wastebasket code and could be acute disorders. ALSO, in Feb we'll shift from tick boxes for the AP2 comorbs to identification via ICD10, for which I've made the coding already. Julie has investigated the APACHE conversion further since this was brought up, so she should be included in any further conversation about this. Ttenbergen 14:45, 2018 August 6 (CDT)	20 December 2018 22:33:51	Ttenbergen
Centralized data front end.accdb Change Log 2019	clean up the form add button for link suspects to patient list update Correcting suspect links	7 February 2019 18:39:53	Pagasa Torres
Requested TISS changes for the next version	emailed Julie to find out if any of these are still relevant. Ttenbergen 09:22, 2018 May 9 (CDT) Julie confirmed that these are still relevant. Ttenbergen 11:15, 2018 May 9 (CDT)	11 February 2019 23:03:03	Ttenbergen
CFE Data Integrity Checks	information that still needs to be integrated Pre-linking checks Quality Assurance queries in CFE	11 February 2019 16:44:07	Ttenbergen
Foo	querying for data in templates I need to clean up Template:CCI collect count days when this is resolved	12 January 2019 03:05:25	Ttenbergen
Charlson Comorbid Score query	the query needs to be cleared out of CFE once we are done. Possibly sooner, I sort of doubt it is used.	28 November 2018 01:55:31	Ttenbergen
Check TISS Intubation consistent	this cross check would not know the difference between (on one day, intubated, extubated, and reintubated) vs (intubated and then extubated); while this hopefully not too common of a thing, would it cause false positives for Pagasa to run after? Ttenbergen 11:33, 2018 October 29 (CDT) yes that is correct because both have a difference of zero. Using the cut off GTE Abs(2) will get true negatives and not false positives. This query considers only the counts and not the dates which will have numerous scenarios and too complicated to define. For those having a difference of -1,0,1 , there are also the possibility for incorrect sequence of dates of intubation or extubation - this is not captured in the query. If you have other suggestions, let us know.--JMojica 12:19, 2018 October 29 (CDT) What I was trying to say is that I am worried this would be a false positive, which will then create work load for Pagasa and/or Collectors to confirm. Do we really want cross checks that bring up potential errors? We have talked about this before, but never really come up with a general answer. Should we take it to task meeting? Ttenbergen 23:45, 2018 October 29 (CDT) Are you saying I should use "difference between A and B can be -2, -1, 0, 1, 2. Other values will be questionable? The basic scenarios are 1. no new insert and no extubation (0-0=0) , 2. no new insert and then extubated - this assumes currently with tube and then extubated (0-1=-1), 3. insert new tube and no extubation(1-0=1), 4) insert new tube and then extubated (1-1=0). When there are 2 insertions, the valid number of extubations =1,2,3 even if occurring at same or different days as insertion day, the difference will either be -1,0,1. Same holds true with 3 insertions or 4 insertions. there will be definite errors if the difference is >= 2 or <= -2. Having 1 insertion and 3 extubations or 3 insertions and 1 extubation are not possible and are errors. Scenario: Pt arrives intubated. On day 1, they are extubated. On day 2 they are intubated, extubated and then intubated again on the same day, which will look on TISS as one insertion on that day and one removal. If you then had a removal the next day you will have an error because you have a count of 3 extubations with only 1 intubation. yes, this scenario if indeed correct has to be checked with the dates and also not that frequent. I found a case of 3 days extubations and 1 day insertion which is questionable because the 2nd day extubation (4/18/2018) is not the same day as the insertion day (4/16/2018) and the 3rd extubation day is 4/23/2018 - is there a missing insertion before 4/23 or an extra extubation 4/18 or 4/23? Actually, the most common cases are either extubations >= 2 and zero intubations or zero extubation and intubations >= 2 which we assume as missed bubble that is why -2 and 2 are not included in the acceptable values. When I discussed with Trish the scenario you have cited, she said we still need an audit so we are aware and clear about the cases of two insertions done in a day.--JMojica 10:19, 2018 November 21 (CST) I will have to sit down with this and work through it.	7 January 2019 03:27:48	Ttenbergen
Changing settings in MS Access after first open	Dec 31.18 - noticed that digital images of scanned TISS forms in Teleform are no longer being stored anywhere. (screen shot as per email sent on this date) ----Trish Jan 4.18 - Tina just had a look at this with Trish, and I think that error is one of those misleading ones. It turns out the image files are not actually being stored after processing. They used to be, and we need them to be, because we regularly refer back to them. Having an electronic version is why we are able to destroy the paper forms, so we need these. I assume there is a setting in Teleform where you set whether to keep data after processing, and where to keep it. Could you have a look?---Tina Trish to remind Herman/Tina in few weeks to look at this. For now, paper forms from scan batch one onward, will be kept on file until in office.Trish Ostryzniuk 13:55, 2019 January 3 (CST)	3 January 2019 19:57:10	Trish Ostryzniuk
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
Lab Collection Process	After all remaining patients are sent, remove labs from CCMDB: remove tab remove checks remove labs from sending	24 December 2018 05:03:56	Ttenbergen
Controlling Dx Type for ICD10 codes	not needed at go-live; Need to export the list and plan process that includes the extra items below. To export, see S_ICD10_table#Query_to_populate_s_ICD10_table_from_wiki. Charlson Admit Como - this is part of that discussion I have emailed Allan the table with all Dxs to set them as Como_allowed, Admit_allowed, Acquired_allowed. Will set up infrastructure to contain this once I have data. Ttenbergen 12:31, 2019 February 13 (CST)	13 February 2019 18:31:37	Ttenbergen
APACHE Acute Diagnoses	Diabetes_mellitus_chronic_complication:_Musculoskeletal is selected by the line ns_Z1 Renal/Metabolic NOS NOT admitted to ICU postoperatively AND Any admit diagnosis is N00.^-N39.^, E00.^-E90.^ In your excel sheet. It is a chronic code sort of by definition, so hopefully no one would code it as an admit, but for now they could. And if they did, it would give them APACHE Dx (not como) points. Is that really as intended? I suppose even as a chronic code it is a marker for the presence of diabetes, so it wouldn’t necessarily be wrong, but it seems odd, so flagging it. need here some general info what these are, links to wiki articles they are actually related to under old coding scheme, etc. I need help with this because I don't know if any of this is on the wiki, or else what it is about. Ttenbergen 17:20, 2018 February 23 (CST) Dx grouping There would be no way to exclude post-first-48hr Acquireds from the calculation. Do we care? Or should this only be Admits?	3 January 2019 23:31:35	Ttenbergen
APACHE Comorbid Diagnoses	Dx grouping either need details or need to revise this when we re-group dxs; meeting booked with Julie and Allan 2019-01-20 Ttenbergen 15:42, 2019 January 3 (CST)	3 January 2019 21:42:31	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
Check drugs vs TISS	Have all info now, Allan confirmed drug list. Once implemented let Julie know so she can not do this in SAS any longer	7 February 2019 14:18:33	Ttenbergen
Automatic updating of MS Access Databases using scheduled tasks	I think PHI copy automation uses this. It might accomplish this in a different way...	3 January 2019 21:50:56	Ttenbergen
Query NDC VAP AcqDX but NoVAP DateinTMPV2	ICD/CCI remove once old pt gone	7 February 2019 06:30:13	Ttenbergen
R Filter Field	move into dx and eliminate this field ICD/CCI remove once old pt gone	7 January 2019 05:05:12	Ttenbergen
Query NDC CLI No AcqDX but CLI DateinTMPV2	ICD/CCI remove once old pt gone	7 February 2019 14:06:07	Ttenbergen
Como Complete	ICD/CCI remove once old pt gone	7 January 2019 05:00:31	Ttenbergen
Query NDC VAP No AcqDX but VAP DateinTMPV2	ICD/CCI remove once old pt gone	7 February 2019 06:30:13	Ttenbergen
Query NDC CLI unacceptable date	ICD/CCI remove once old pt gone	7 February 2019 14:06:19	Ttenbergen
Query NDC zCRRT CCI Px but no TISS	ICD/CCI remove once old pt gone	7 January 2019 00:51:50	Ttenbergen
Query NDC zCRRT TISS but no CCI Px	ICD/CCI remove once old pt gone	7 January 2019 00:51:52	Ttenbergen
Query NDC CLI vs DX but no TISS17 CentralLine	ICD/CCI remove once old pt gone	7 February 2019 14:05:52	Ttenbergen
Query NDC VAP unacceptable date	ICD/CCI remove once old pt gone	7 February 2019 06:23:38	Ttenbergen
ApLab Complete	ICD/CCI remove once old pt gone This is a legacy field we could probably get rid of. Not sure when we stopped using it.	7 January 2019 05:01:49	Ttenbergen
Query NDC CLI AcqDX but NoCLI DateinTMPV2	ICD/CCI remove once old pt gone	7 February 2019 14:05:59	Ttenbergen
S dispo.loc type	This value is not yet encoded on the wiki as Property:Collection Location Location Type for locations that have their own article, but maybe it should be. Should it be? Ttenbergen 09:46, 2017 November 9 (CST) Indeed, what is the description? Especially in contrast to S dispo.service type; when you give the answer, please put it behind "element_description" above and delete this question.	25 October 2018 03:37:29	Ttenbergen
Bed holds	Julie seems to set the limit at 1 day - emailed Julie Ttenbergen 10:07, 2016 November 10 (CST) duplication on wiki needs to be cleaned up once we are on same page Laura and Tina discussed this and there clearly are different understandings about this. Need to review. LKolesar 14:43, 2017 March 1 (CST)	3 January 2019 22:22:52	Ttenbergen
Centralized data front end.accdb Change Request	Postal Code vs Pre-acute Linked pairs, better storage	7 February 2019 06:40:34	Ttenbergen
S ICD10 Chapter block pattern table	Need to get the list like S ICD10 Block Dxs table here from wiki, but use something like the Charlson template so the data can be shown on the actual pages.	11 January 2019 05:17:45	Ttenbergen
Check dx implying death across encounters	Need to update the definition for this and implement once we have Deceased patients figured out. I have left a link there to remember.	7 January 2019 03:04:08	Ttenbergen
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)	7 February 2019 15:42:57	Pagasa Torres
Biographic changes over time	Right now we do not track anywhere that Betty became John. Our data would make it look like the person had always been John and female. So, when we cross-check data, these people get flagged. Should we change how we collect them? Should we change how we alias them? Or should this info only live in the L_Problem table?	3 January 2019 22:24:05	Ttenbergen
Check dx implying death must be dispo deceased	Started to build query but not applied yet; see discussion in Deceased patients.	26 December 2018 22:13:48	Ttenbergen
Centralized data front end.accdb	Still has old name, need to update. Also, isn't really documented here yet	30 January 2019 16:18:10	Ttenbergen
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
Searching the wiki	There are ongoing problems searching the wiki. Better search functionality would be nice planning to try ElasticSearch when I next update the wiki software via elastica or CirrusSearch - timeframe: next 2 months Ttenbergen 13:53, 2019 February 13 (CST)	13 February 2019 19:59:19	Ttenbergen
Cat button	Tina to add detail to this page	11 February 2019 22:03:57	Pagasa Torres
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
ICD10 Guideline for drugs and substances	fix SMW to include templates You asked me at Task Team Meeting - Rolling Agenda and Minutes 2019#ICU Database Task Group Meeting – February 6, 2019 to add a page to wiki to explain how Intravenous Drug Abuse (IVDA) would be coded. Instead of adding a page, I think this might be a good fit, and it's already linked from substance pages.	7 February 2019 14:46:12	Ttenbergen
Query check ICD10 duplicates	add mechanism to the exceptions	1 February 2019 22:20:47	Ttenbergen
Can't check ICD10 ARF vs APACHE ARF	definition is changing so it might become possible soon to cross-check this.	28 December 2018 21:38:35	Ttenbergen
Apache Value Reconciliation	got lost	22 December 2018 14:51:50	Ttenbergen
Potential Change	got lost	22 December 2018 14:55:41	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
Standard error messages	more informative error messages requested	10 January 2019 18:43:14	Ttenbergen
ALERT Scale	need tie-it-together page.	22 December 2018 22:03:30	Ttenbergen
Continuous Stay	need to integrate Julie's definition pasted here into this page	3 January 2019 22:38:01	Ttenbergen
Allan's links	need to update this to list templates	6 February 2019 05:36:19	Ttenbergen
CXR count cross check	needs to be implemented but not strictly needed for go-live	24 December 2018 18:58:21	Ttenbergen
Query check ICD10 only 1 stage of renal failure	pt could have several stages during acquired, right? Is that how we would want to code deterioration? AG REPLY -- not really. While one could have a lower level as a comorbid, and be admitted with what is finally decided to be an advancement of CRF (so that an admit dx is a higher level), in many cases what you'll have is some degree of CRF + an AKI on top of it. It's important to distinguish between these. Emailed Michelle to find out if that is how she would have understood it as a renal-focused collector. Ttenbergen 08:25, 2019 January 24 (CST) M said it made sense.	24 January 2019 20:08:51	Ttenbergen
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
Chronic kidney disease (chronic renal insufficiency, uremia) Stage 1	q Tina, Could you please add the GFR ranges to each stage in the ICD10 diagnosis? This would make it simpler, rather than trying to memorize each stage or having to look it up every time. thanks in advance! Lisa Kaita 14:00, 2019 February 4 (CST) Will do, I have put it into the pipe.	6 February 2019 17:26:36	Ttenbergen
Chronic kidney disease, NOS (stage unspecified)	q Tina, could we please have the words kidney and renal in all of the kidney codes (ie.renal/kidney)? This code will not come up when you search the word "renal". Allan, any concerns if I rename this to "Chronic renal disease, NOS (stage unspecified)", or if I rename all of them to renal/kidney? Ttenbergen 16:34, 2019 January 21 (CST) Allan had no concerns, need to implement. Ttenbergen 22:17, 2019 February 5 (CST)	6 February 2019 04:17:20	Ttenbergen
Query s tmp IICU consult not paired	see question in IICU_consult#Multiple_Consults	22 January 2019 18:50:32	Ttenbergen
Query check ICD10 ESRD vs ARF	some of these give false positives for transplants, review what's up.	6 February 2019 18:15:04	Ttenbergen
Query check ICD10 ESRD vs AP ARF	some of these give false positives for transplants, review what's up.	6 February 2019 18:15:07	Ttenbergen
Collector dictionary	something went wrong with this query and it has no data	7 January 2019 05:08:11	Ttenbergen
Conversion from our old diagnosis schema to ICD10/CCI	transition plan to CCI/ICD10 details...	6 February 2019 05:24:07	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
Lab and culture reports	you wanted to remove stuff from here that's already in the infection guidelines instead.	16 October 2018 02:43:39	Ttenbergen