From CCMDB Wiki
Jump to navigationJump to search

Testing to see if shows in recent changes

"need collector input"

changing mediawiki appearance

Questions for Tina

  • current # of questions: 70
edit page question
edit Previous Location field
  • In the instructions above it says to select "other - known but not listed" this is not in the dropdown as an option.
  • Turns out location missing/unknown wasn't implemented either. Is there any concern if we implement this now?
  • Implement both now
edit Awaiting/delayed transfer to other care facility NOS
edit 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
edit 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)
edit Exporting and sorting an admission list from EPR Building this now, more info to come.
edit PL missing L Tables content Confirm this only deals with complete records
edit CTE CTU vs NTU
edit Eliminating distinction between different ward types CTU vs NTU - we decided at task that we wanted to eliminate the distinction. A lot of things are part of their network of information, so we will need to work out the details above before we can move ahead.
  • I believe it was only related to transfer ready DtTm between CTU and NTU not eliminate the concept. Medicine program would have to weigh in. Trish Ostryzniuk 16:11, 2018 July 30 (CDT)
    • I seem to remember the reason to stop doing this also involved that we have more and more locations that don't fall into a clean place. For now we pretend we can give medicine this data, but is it true and meaningful? Ttenbergen 15:51, 2018 July 31 (CDT)
      • Allan will contact the medicine stakeholders about eliminating this distinction. Will email Mary-Ann Lynch, VanAmeyde, Griffin. Ttenbergen 12:18, 2019 January 24 (CST)
        • pinged again for Allan to Follow-up. Ttenbergen 13:44, 2019 February 25 (CST)
  • AG REPLY: DONE. NOBODY is using or seeking this info. So let's stop collecting it.
edit Bed holds duplication on wiki needs to be cleaned up once we are on same page
edit Non-standard ICD10 Diagnoses Dx grouping
  • With our addition of codes, collectors may use one of our codes rather than the closest standard ICD10 code. In that case, the dx would not show up in the range. How should we address this? The most likely candidates above seem Bronchiolitis obliterans organizing pneumonia (BOOP, cryptogenic organizing pneumonia (COP)) and SARS (severe acute respiratory syndrome)
    • AG REPLY -- for this nonstd BOOP code, there are no existing issues regarding any of the comorbid groups (e.g. Charlson)
      • Allan, could you confirm that that this is what we found when we looked into BOOP.
  • AG REPLY --- so far Tina the only 2 U-codes that would ever be a primary dx are U04 and U14.68 -- which belong respectively to ICD10 chapters J and E. But whenever we add a new U-code we need to remember to decide which chapter (if any) it needs to be included under. Tina to add to template.
edit 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)
edit APACHE Comorbidities in ICD10 codes Dx grouping
  • 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)
edit Reconnect CFE and initial error checks Fix why it gives this error as part of fixing DSM process.
edit Category:Potential Change got lost
edit Automatic updating of MS Access Databases using scheduled tasks I think PHI copy automation uses this. It might accomplish this in a different way...
edit Query NDC CLI AcqDX but NoCLI DateinTMPV2 ICD/CCI Please removePTorres 11:48, 2019 July 24 (CDT)
edit Query NDC CLI No AcqDX but CLI DateinTMPV2 ICD/CCI Please removePTorres 11:49, 2019 July 24 (CDT)
edit Query NDC VAP AcqDX but NoVAP DateinTMPV2 ICD/CCI remove once old pt gone
edit Query NDC CLI unacceptable date ICD/CCI remove once old pt gone
edit Query NDC VAP No AcqDX but VAP DateinTMPV2 ICD/CCI remove once old pt gone
edit Query NDC VAP unacceptable date ICD/CCI remove once old pt gone
edit R Filter Field ICD/CCI remove once old pt gone
edit ICD/CCI remove once old pt gone ICD/CCI remove once old pt gone 1
edit "almost same patient" check If we need this page at all it needs to be integrated better.
edit Repeat clicks being needed when entering CCI PX Type investigate and fix
edit REDCap Just need a place to jot down some thoughts, need to clean them out later.
edit S ICD10 Chapter block pattern table Just storing this here for now, it should really be integrated into the SMW like the Charlson and Apache ones. Generated by query CCMDB.accdb.s_ICD10_Chapter_block_pattern_wikimaker.
edit Bed holds Laura and Tina discussed this and there clearly are different understandings about this. Need to review. LKolesar 14:43, 2017 March 1 (CST)
edit 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.
edit Room nr legacy data
edit Pharm Flow Complete legacy data field
edit ApLab Complete Legacy field cleanup.
edit R Filter Field move into dx and eliminate this field
edit APACHE Acute Diagnoses 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)
edit TISS need to make this a better re-director about all things TISS. but not right now.
edit Test needs troubleshooting
edit Template:Newsflash needs troubleshooting
edit Pre-linking checks not working right now due to PL_SamePHIN_Site_Diff_chart size limit
edit 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)
edit Searching the wiki 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)
edit Query check ICD10 only 1 stage of renal failure q

According to our collection instructions for Admit Diagnosis and Comorbid Diagnosis, and the instructions for these codes (e.g. Chronic kidney disease (chronic renal insufficiency, uremia) Stage 1, GFR GT 90, the diagnoses could be coded as both an Admit Diagnosis and Comorbid Diagnosis. Right now this cross check prevents that.

  • Do we want to be able to code these as both admit and como?
  • Would both need to be the same code?
    • allow this duplication in different bins
edit Reconnect CFE and initial error checks re-name these so not PL any more
edit Centralized data front end.accdb Still has old name, need to update. Also, isn't really documented here yet
edit L Hospitalization table still need to figure out if I need an s_table for this.
edit Query check ICD10 duplicates the count is wrong, there wasn't a quick fix, so disabling the query for now. Ttenbergen 15:56, 2019 March 27 (CDT)
edit Multiple encounter consistency checks The task is currently done by the Statistician and we'd like to get it off her plate.
edit Searching the wiki There are ongoing problems searching the wiki. Better search functionality would be nice
edit LOS this article has evil twins, need to reconcile, search for LOS Ttenbergen 21:13, 2014 October 23 (CDT)
edit Query Import request matcher This part of the cross-check is now well understood and ready to program.
edit 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)
edit Reconnect CFE and initial error checks Tina will fix Query check CCI must have entry so those are caught going forward.
edit S TISS Report table TISS: not really sure where and how this is used, will need to update
edit Adding a CCI or ICD10 entry in CFE we need a better solution, I need to make that ID field populate automatically.
edit Lab and culture reports you wanted to remove stuff from here that's already in the infection guidelines instead.
edit L Hospitalization table z
  • implementation was never finalized, and it wasn't tested and isn't used.
edit Questioning data back to collectors z
  • 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)
edit Check Inf Potential Infection must have pathogen or alt combined code _dev_CCMDB
  • Discussed on Agarland 09:56, 2019 August 22 (CDT) - we should implement this. At least for a while. If too much extra work, we can take it out.
edit FinalCheck field _DEV_CCMDB_data
edit FinalCheck field _DEV_Centralized_data
edit Processing errors in patient data _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.
edit Centralized data front end.accdb Change Request _dev_CFE
  • add button for link suspect queries to patient list, then update Correcting suspect links with change in steps
  • 2019 March 01 - move priority number column for ICD10 to be after the primary type column. This would make it the same as CCMDB.
  • add TDI column to query L_CCI_Combined
  • fix dc treatment box that isn't showing up in form Ttenbergen 15:52, 2018 April 11 (CDT)
  • fix table reconnector to not look for L_Labs_DSM any longer, since it's now elsewhere. Ttenbergen 15:52, 2018 April 11 (CDT)
  • CCI and ICD10 make button for Pagasa
edit Query NDC TISS vs pharmacy _Dev_CFE
  • Have all info now, Allan confirmed drug list. Once implemented let Julie know so she can not do this in SAS any longer
edit Query NDC TISS Extubation only on TISS Intubated days _DEV_CFE
  • implement check
edit Check TISS Intubation consistent _Dev_CFE
  • 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.
edit Centralized data front end.accdb Change Request _dev_CFE Linked pairs, better storage
edit Guideline for coding organ donation after death _dev_CFE

The following in Correcting suspect links will need to be updated for this:

edit Charlson Comorbid Score query _dev_CFE
  • the query needs to be cleared out of CFE once we are done. Possibly sooner, I sort of doubt it is used.
edit Query NDC Dxs vs TISS Dialysis _DEV_CFE Discussed 10:00, 2019 August 22 (CDT) - list looks like a good start, ready to implement.
edit Query NDC Trach Dx TISS _DEV_CFE ready to implement
edit 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.
edit Query NDC Dialysis TISS CCI _dev_CFE change to wait till complete
edit Query NDC zCRRT TISS no tmp _dev_CFE - remove this and *old
edit Query NDC zCRRT tmp no TISS _dev_CFE - remove this and *old
edit 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 size
edit DSM Labs Consistency check.accdb _DEV_DSM
  • Next version:
    • lock out sending of request if any sent but not vetted records are present to make sure they are not missed; or send all <> incomplete?
    • fix auto email it says "Hi, \n \n here is a new data request file for the CCMDB export. Could you please generate the lab export and let us know when done? \n \n Thanks!"
      • why would I change it and to what?
    • Add a debug.stop after the new-lab-finding part so the import can just continue.
    • the error it gives for there already existing a file needs more helpful text.
    • automate reconnecting; I thought this was done but it's not.
edit Instructions for importing a batch of DSM Data _dev_DSM There is a newly found and new added query for each; why are there two and can I delete one set?
edit TISS28 Form Scanning _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)
edit Query TISS Errors missing days _Dev_TISS28 change to wait till complete

SMW stuff

full text search link

table side by side vs right justified

title 1
line | 1
title 2
line | 2


Special:ReplaceText Can use regExps if you check use regular expressions such as [[Category: ?TISS76 ?]] to allow spaces or not.

job queue

Magic words

e.g. {{CURRENTYEAR}} to get : 2019 see

transcluding subheadings...

Doesn't work, sucks in whole article

wiki testing, syntax and tricks

Parser Functions

lowercase works so hopefully so do the others...

  • try this
  • no
  • 1
  • yes


As from Cindy Cicalese: Graph This Page

Transclusion vs Substitution

Transclusion is calling content from a page or template, substitution is copying it.

Testing collapsing

...test content...