To do list

From CCMDB Wiki
Jump to navigation Jump to search

This page contains pages that have to-do items, tagged using Template:Todo. It was set up to help us get those off the Questions list.

To do list

There are currently 59 pages with to do list items.

wiki page question who todo added todo action
Accept DtTm field _after
  • Field is legacy; once no longer used, remove it from sending and then from ccmdb_data. Query to check:
SELECT L_Log.D_ID, L_Log.RecordStatus, L_Log.Accept_DtTm, L_Log.Arrive_DtTm
FROM L_Log
WHERE (((L_Log.RecordStatus)="incomplete") AND ((L_Log.Accept_DtTm) Is Not Null) AND ((L_Log.Arrive_DtTm) Is Not Null));
  • 98 left as of 2022-08-04
Tina 2022-06-30 2022-10-30
Adding a CCI or ICD10 entry in CFE wiki housekeeping
  • this may have been automated; if so it's out of date. either way, it should be linked in better.
Tina 2022-06-16 2022-06-16
APACHE Acute Diagnoses
  • I will need to re-think how these are documented on the wiki as well, as the current schema was based on individual dxs meeting criteria and this is quite different. Ttenbergen 10:39, 2022 November 15 (CST)
Tina
APACHE Acute Diagnoses just Tina's working notes:

Scenarios:

  • one of a * of ICD10s
  • one of a * of ICD10s AND one of a * of ICD10s
  • one of a * of ICD10s AND an ICD10 with a word in it
  • one of a * of ICD10s AND one of a * of CCIs
  • one of a * of CCIs
  • two or more of a * of ICD10s

AND any admit procedure is EITHER: (a) of the form 1.AA.xx, 1.AB.xx, 1.AC.xx, 1.AE.xx, 1.AD.xx, 1.AG.xx, 1.AJ.xx, 1.AK.xx, 1.AN.xx, 1.AP.xx

where “xx” = any of 13, 51, 52, 53, 56, 57, 59, 72, 76, 80, 87, 89, 90, 91

or (b) 2.AA.71.yy, 2.AB.71.yy, 2.AC.71.yy, 2.AE.71.yy, 2.AD.71.yy, 2.AG.71.yy, 2.AJ.71.yy, 2.AK.71.yy, 2.AN.71.yy, 2.AP.71.yy

where “yy” = any of 70.^, 71.^
  • one of a * of ICD10s AND (one of * of CCI1 and a * of CCI2)
    • might be able to do a pattern recognition on that? Or a regular expression?
Tina
ApLab Complete _wiki_housekeeping
  • removed field from sending
  • removed field from ccmdb_data
  • removed field from CFE data
  • delete wiki page when done
Tina 2022-03-09 2022-08-09
Arrive DtTm field _after
  • Field is legacy; once no longer used, remove it from sending and then from ccmdb_data. Query to check:
SELECT L_Log.D_ID, L_Log.RecordStatus, L_Log.Accept_DtTm, L_Log.Arrive_DtTm
FROM L_Log
WHERE (((L_Log.RecordStatus)="incomplete") AND ((L_Log.Accept_DtTm) Is Not Null) AND ((L_Log.Arrive_DtTm) Is Not Null));
  • 98 left as of 2022-08-04
Tina 2022-06-30 2022-10-30
Blood Product Data _after
  • Identified as something we should do to streamline data collection. I have made this page to document progress toward this import.
    • This will not happen until we have a PHIA approved repository. Ttenbergen 11:32, 2022 February 9 (CST)
      • Nothing will come of this until our data is stored elsewhere, so pulling it onto my list so we have some record that this is an outstanding want. Ttenbergen 13:04, 2022 June 22 (CDT)
Tina 2022-06-22 2022-06-22
Centralized data front end.accdb Change Request _dev_CFE
  • CCI and ICD10 make button for Pagasa
Tina 2021-07-15
Centralized data front end.accdb Change Request _dev_CFE
  • Linked pairs, better storage
Tina 2021-07-15
CFE Inline Integrity Checks _dev_CFE
  • ready to implement inline cross check for CFE edits. Ttenbergen 10:03, 2022 September 6 (CDT)
Tina 2022-09-06 2022-09-06
Change of remaining location names from "our" names to EPR/Cognos names wiki housekeeping

Need to clean this up

  • * What happens to the ICU Previous Location, Pre-admit Inpatient Institution, Dispo or even Service Location - should they be changed too by the new COGNOS ICU locations? Example current STB_ACCU is SBGH-CCUO in COGNOS, STB_CICU is SBGH_ICCS, STB_MICU is SBGH_ICMS. Should the old labels remain? We need to think hard for its implications to queries of linking and/or matching tables before implementing any change. --JMojica 16:33, 2022 February 2 (CST)
    • It would be nice to have this consistent, and yet you are correct that this would tie into a lot of things. I think the benefits of making it consistent win out, though especially when it comes to also thinking about this in terms of that metadata we discussed the other day. Even if we keep the (possibly identical) data in both s_tmp and s_dispo for now, we would then be able to use that metadata table for both. This would require thinking through the details. Julie, I think it only involves you and me, so maybe we should discuss at our wiki meetings? Ttenbergen 13:44, 2022 February 8 (CST)
      • Julie and Tina discussed:
  • We use the 4 fields Previous Location, Pre-admit Inpatient Institution, Dispo and Service/Location also to map patient flow between laptops, and we very much don't use Cognos values for this (e.g. HSC_Med). We need to retain this ability to use the entries for linking but would also make them the same as Cognos where possible. So we need to keep our "own" values for this for locations where we collect.
  • We decided to use manually split CC entries e.g. HSC_MICU vs HSC_SICU since Julie reports in those increments, ie it is hard to pull apart a stay in two ICU types if it is collected as one record. We don't want to lose that.
  • We would still like to change these own values to the "modern" values where we use legacy terms, eg. STB ICMS vs STB MICU. As long as we make a clean transition between old and new, or change all old, that should not be a problem, but we need to account for it.
  • We could use the Cognos values for all places where we don't collect, e.g. if a pt comes from Ward HSC_A1 and Cognos lists that as HSC-GA1, we could just enter that. However, for locations we don't collect we currently aggregate this to HSC_ward. Do we want the extra detail? It would be easier to enter but might be harder to interpret and possibly even harder to work with for collectors.
  • If we want to keep our proprietary value for locations where we collect, and keep aggregate ones for locations where we don't collect, I am not sure which locations that then leaves where we would use the Cognos values?
      • Julie, do you agree to that summary? If so, there may be nothing to discuss with Lisa, since we will need to leave this as is. If I am missing something pls update and then pass on to Lisa for her take. Ttenbergen 16:56, 2022 March 23 (CDT)
        • agree. pass to lisa. --JMojica 15:27, 2022 June 8 (CDT)
  • I think this is no longer an issue, unless we are looking to change how we collect this, which I am not in favor of Lisa Kaita 12:23, 2022 August 24 (CDT)
Tina 2022-08-24 2022-08-24
Change of remaining location names from "our" names to EPR/Cognos names wiki housekeeping

need to make sure it is documented somewhere that Julie will group the old and new versions of htese via the Centre column in s_dispo table... where would I document that? Ttenbergen 16:56, 2022 March 23 (CDT)

  • Tina, in the s_dispo, I also use the column ward to group the different labels referring to the same ward/unit and column centre for the order sequence of these ward/unit in the report. --JMojica 15:23, 2022 March 25 (CDT)
Tina 2022-08-24 2022-08-24
ClientGUID field _dev_ccmdb
  • review linking and related processes to see what could change to make best use of this
  • remove the L_Person table - we don't use it and this further means we don't need/use it. as confirmed with Julie here.
Tina 2022-03-24 2022-09-25
ClientGUID field
  • Chastity confirmed there is a merge process for J Does who get identified. Confirming how this works, emailed Chastity 2022-06-16.
  • Asked Chastity if 3 month updates will be possible.
Tina 2022-04-13 2022-06-30
Cognos2 Service Starter _after
  • The above info is really more related to the overarching way to use this process than to this form. This form should just instruct to enter things as is, and refer to Using Cognos2 to keep track of patients for the overall process, and to Service tmp entry for instructions to enter that as Cognos initially and as first boarding loc later. Having the info in the page for the form in the software removes it from both the process and from our ability to understand incomplete data. I will leave it here for now since there is a going conversation, but will break it out and move it once it's resolved, unless someone presents a compelling case why not to. Ttenbergen 09:51, 2022 May 19 (CDT)
    • When the JALT discussion is resolved I'd like to discuss with Lisa where this would best live. Ttenbergen 14:55, 2022 June 14 (CDT)
Tina 2022-05-19 2022-06-25
Collection location documentation _locationData
  • How should we now keep track of the ward/unit info on the wiki? More questions on page.Ttenbergen 16:07, 2021 July 14 (CDT)
    • Perhaps this can also be included in the Location metadata storage you will set up showing the start and end dates and the bed size. --JMojica 14:32, 2022 February 7 (CST)
      • Agreed! This is also why I think where possible we should shift the s_dispo contents to the same name so the Location metadata storage can supply both. I want to discuss how to best encode this with you, hopefully tomorrow at out wiki meeting. Ttenbergen 15:14, 2022 February 8 (CST)
        • I need the s_dispo because I am using the other columns as various categories of the detailed numeric locations name and I do not want to drop it for now. I have yet to see the Location metadata storage you are talking about to decide.
          • Sorry didn't say that clearly. Don't mean to eliminate s_dispo table at this time, just want to make sure we use same location name as in Boarding Loc where applicable, so we can store the metadata all in one table. Ttenbergen 13:36, 2022 February 9 (CST)
            • Decided at Task today that this likely needs to be done on wiki with dates. Taking off Julie's list until I figure out details Ttenbergen 16:01, 2022 June 22 (CDT)
Tina
Collection location documentation _wiki_housekeeping
  • How should we now keep track of the ward info on the wiki? Do we actually need to? Or is it sufficient to tell the number of beds at e.g. Grace Medicine? what links to site/locations page is likely an indicator of the audience for this info, but Julie may well link from reports as well. Depending how we want to use this going forward, a static page might be an option, but then we can no longer link to individual locations. If we keep separate locations, we need to make sure we keep them updated.
  • I have put this on Julie's question list as well, and emailed Julie and Lisa about it. Ttenbergen 16:07, 2021 July 14 (CDT)
Tina 2020-10-15 2021-09-01
Controlling Dx Type for ICD10 codes _after
  • Built query "z_ComoAdmAcqu_Primary_List", exported to excel, sent to Barret; Allan said this is low priority, so putting a review data of 3 months from now
  • added this back to the task list, been almost 6 months
Tina 2022-02-17 2022-08-10
Controlling Dx Type for ICD10 codes _after

Make sure that these examples that were mentioned over time are adressed:

Tina 2022-02-17
Created Variables Common 2021 table _after Tina 2022-08-04 2022-08-04
Cross Check Engine _dev_CCMDB
  • implement better cross-check triggering
Tina 2022-04-27 2022-04-27
Direct Data Access for RIS/PACS _after
  • Identified as something we should do; the notes below are quite old but might still be a starting point.
    • This will not happen until we have a PHIA approved repository. Ttenbergen 11:32, 2022 February 9 (CST)
      • Nothing will come of this until our data is stored elsewhere, so pulling it onto my list so we have some record that this is an outstanding want. Ttenbergen 13:04, 2022 June 22 (CDT)
Tina 2022-06-22 2022-06-22
Drug-induced immunosuppression wiki_housekeeping Tina 2022-07-06 2022-07-13
ECIP wiki housekeeping Tina 2021-07-15 2021-08-10
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 field 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.
Tina
EPR Admit DtTm field _wiki_housekeeping
  • confirmed this is really unused
  • removed field from sending
  • removed field from ccmdb_data
  • confirmed field is not in CFE data
  • delete wiki page when done
Tina 2022-04-19 2022-08-09
EPR Analytics z
  • decide if it is time to ask the powers-that-be about this again
Tina 2022-01-01
FinalCheck field _wiki_housekeeping
  • removed field from sending
  • removed field from ccmdb_data
  • removed field from CFE data
  • delete wiki page when done
Tina 2021-07-15 2022-08-09
High-Obs Wards
  • Discussed with Julie 15:49, 2022 October 19 (CDT): so much easier to do this with a simple explicit match than to do it through data that we will do it htis way. I will need to link the pages somehow to tag that they are HOBS at some point, and we can have our actual match statements in here.
Tina 2022-10-19 2022-10-19
Hospitalization ID _CFE_Data_reconsolidate Tina 2022-08-25 2022-09-25
Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI) _wiki housekeeping
  • we have a page about attribution somewhere, make sure that this is consistent.
Tina 2022-08-04 2022-08-04
Location metadata storage _locationData
  • _Dev_CFE linking of s_LocationData table
  • _Dev_CCMDB - process to import data from wiki (similar to Converting ICD10 between wiki and ccmdb.accdb)
  • set up wiki template for locations
  • consider data import for locations so no manual pre-populating of pages
  • S_level_of_care needs to be integrated with whatever metadata we set up
  • discussed at Task whether we should wait for Shared Health info, will make our own; Shared Health's data is no better than ours, so won't do that.
  • STB-L2HA is another page we will need to include when we deal with this.
Tina 2022-02-09 2022-02-09
Location metadata storage _locationData
  • Discussed at JALT; we need to store this on a per page on wiki level, with multiple start and end dates being possible. Tina needs to create the structure for this and pre-populate. Probably discuss with Julie at the planning stage. Ttenbergen 12:04, 2022 June 22 (CDT)
    • It needs to be possible to access this as data. Ttenbergen 09:58, 2022 June 28 (CDT)
Tina 2022-06-22 2022-06-22
LOS _wiki_housekeeping
  • need to integrate this better and clean things out; also should make sure that queries that deal with LOS use Function LOS()
Tina 2022-02-10 2022-03-01
Pharm Flow Complete _wiki_housekeeping
  • confirmed this is really unused
  • removed field from sending
  • removed field from ccmdb_data
  • removed field from CFE data
  • delete wiki page when done
Tina 2021-07-15 2022-08-09
Problems related to event timing of data consistency checks _dev_ccmdb Tina 2022-04-13 2022-04-13
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.
Tina
Query check CCI CXR vs LOS _dev_CCMDB
  • Not currently implemented; starting point for the query exists but doesn't yet include Julie's values. Also, isn't being called from anywhere.
Tina 2022-04-14 2022-04-21
Query check CCI TISS time means must be two _dev_CCMDB
  • summarized discussion, waiting for confirmation from Julie
Tina
Query check ICD10 CLI vs CCI CentralLine _dev_CCMDB * needs to be added to CCMDB Tina 2021-10-07
Query check long transfer delay _after
  • This will need to be implemented when the 3SD is available.
Tina 2022-08-04 2022-08-04
Query maintenance s tmp deletables _regular * this should be done regularly, maybe every 6 months Tina 2022-01-26 2023-02-10
Query Mgmt Collector Admission Count _Dev_CFE mgmt queries Tina 2022-04-27
Query NDC Bad Postal Code
  • emailed Chastity to see if we could get Postal Code data from them rather than maintaining our own.
    • Never got a response. Emailed Chastity again. Ttenbergen 14:41, 2022 June 30 (CDT)
Tina 2022-03-24 2022-07-15
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)
Tina
R Filter Field _after
  • removed field from sending
  • removed field from sending
  • removed field from ccmdb_data
  • remove field from CFE data
  • delete wiki page when done
Tina 2022-08-09
R Filter Field _CFE_Data_reconsolidate
  • move into ICD10 and tmp - emailed Pagasa Ttenbergen 09:53, 2022 August 4 (CDT)
    • emailed again because the first email didn't explain that the relevant info is under "expand" Ttenbergen 11:42, 2022 August 23 (CDT)
      • Pagasa emailed "done" Aug 23 Ttenbergen 17:19, 2022 September 1 (CDT)
  • figure out last two sets of values - emailed Julie Ttenbergen 09:53, 2022 August 4 (CDT)
    • emailed again because the first email didn't explain that the relevant info is under "expand" Ttenbergen 11:42, 2022 August 23 (CDT)
  • and eliminate this field
Tina 2022-08-25
Room nr _wiki_housekeeping
  • removed field from sending
  • removed field from ccmdb_data
  • removed field from CFE data
  • delete wiki page when done
Tina 2021-07-15 2022-08-09
S dispo Collector Location table _Dev_CFE mgmt queries Tina 2022-04-27
S dispo table _wiki housekeeping
  • break this out because it needs to apply to locations in general, wiki side, s_dispo, boarding loc etc.
Tina 2022-02-10 2022-02-10
S ICD10 Chapter block pattern table _wiki housekeeping
  • 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.
Tina
S LocationData table locationData
  • No longer applicable, we discussed today that we will need multiple start and end dates and that it maybe should be stored on wiki.

---

  • _dev_CCMDB - the process to import from wiki should run a consistency check on the start and end dates to ensure there is no overlap of same attribute
  • _dev_CFE - include this in the import of s_ tables at startup; there was a second s_ table to pull into CFE, emailed Julie for which one
Tina 2022-02-10 2022-02-10
Scheduled Tasks wiki housekeeping
  • Do we still schedule Backup Checker?
    • No, I remembered it was run through my desk top computer, not now anymore. PTorres 14:08, 2022 March 17 (CDT)
      • no longer doing either of these as scheduled tasks, Tina needs to clean up the documentation. PTorres 15:05, 2022 March 17 (CDT)
Tina 2022-03-17 2022-03-17
STB-L2HA locationData
  • make sure this will be integrated
Tina 2022-06-28 2022-06-28
Template:Drugs included wiki housekeeping
  • need to confirm these are applied to all relevant articles
Tina 2021-11-25 2021-11-25
Template:ICD10 Guideline Signs Symptoms Test Results not needed when cause known wiki housekeeping
  • Apply template to symptoms, physical exam findings, and radiologic findings, but NOT to laboratory findings.
    • I don't know which those would be. If we go through with this definition we should just stick them into a :Category:Lab Result or similar. Category:Testing also contains non-lab findings. Where would this leave things like Fecal occult blood test, positive? The "What links here" link on the left would show all that currently links to this page.
    • R71-R89 inclusive
Tina 2022-02-09 2022-02-09
Template:Location dropdown cleanup
  • Since no one person knows when an s_dispo item is no longer used on any laptop. Made CFE query z_s_dispo_inactivatable to check. Should check that query occasionally to review if other things can be cleaned up.
Tina 2020-10-20 2022-03-05
Transfer Delay (Critical Care)
  • Discussed with Julie that we will actually update these in the data rather than do these updates at reporting time. The query below should do it. Pagasa, could you apply it when you get a chance and update here when done? Thanks! Ttenbergen 09:46, 2022 June 29 (CDT)
    • when I started to make the query to update this I came across TRs that were not on the same date as the dispo_dttm. I can understand why we would change times if the TR is on the Dispo Dt, but it doesn't seem to make sense to change them if they are earlier. So, I just want to make sure that you really would have reported e.g. the following with a changed time.
D_ID Transfer_Ready_DtTm Dispo_DtTm HrsMins new_tr_dttm
GRA_N3-3089 2007-07-31 2007-08-23 15:30:00 00:00:00 2007-07-31 10:00:00
  • I only make a substitution if same date with Dispo date. Added that part now. however when I have looked at my current code, I no longer have this substitution. Is it because you have combined the dttm together when we moved to access from Ed's and thus the time became 00:00. how did you handle it when transitioning to ACCESS, those without time - did you make the transfer ready dttm blanks or made time to 00:00 ? --JMojica 11:37, 2022 September 21 (CDT)
        • This is one field in Access now, so leaving them blank isn't an option. So you treated blank and midnight differently? Would anyone reasonably become transfer ready at midnight? No rounds happening then. I guess it's possible. So, really you haven't done this for some time, possibly since we moved form Ed's version? I am also prepared to take this whole thing out of the documentation and not do it at all... Ttenbergen 16:20, 2022 September 22 (CDT)
          • I agree, let us drop this whole thing out about transfer time missing and do not do any substitution at all when time is missing. --JMojica 11:08, 2022 October 12 (CDT)
            • Will you stop doing them in SAS as well, then? Otherwise we are back to inconsistent definitions. Ttenbergen 11:55, 2022 October 12 (CDT) ****** OK. --JMojica 08:53, 2022 October 19 (CDT)
Tina
User:Ttenbergen/Relationship Diagram wiki housekeeping Tina