User:Ttenbergen/questions for tina

From CCMDB Wiki
Jump to navigation Jump to search

Questions

edit page question ModDate
edit page question ModDate
edit Swap Locations
  • Would it make sense to talk to STB about how the swing beds are used by ER? I don't think talking to anyone about how the swing beds are used by er would be helpful. I've explained in great detail a number of times, to a number of people why this occurs. I can't think of anything different that could potentially be done to work around the issue as it occurs in the first place. DPageNewton 10:59, 2020 December 3 (CST)
2021-09-07 3:42:46 PM
edit Transfer Delay (Medicine) are you planning to add the updated calculation based on the new process in the created variables ? --JMojica 16:55, 2021 June 11 (CDT) 2021-08-04 1:21:23 AM


To dos

wiki page question todo added todo action Last modified
APACHE Comorbidities in ICD10 codes 2021-04-21 7:17:11 PM
ApLab Complete _DEV_CCMDB
  • remove field from sending, then set to _DEV_CCMDB_DATA
2021-07-15 2021-07-15 9:47:17 PM
Bed holds
      • NOTE for Julie -- if such a patient was admitted in hospital B to a location where we collect, then the hospital A and B records will be flagged in the data check as having overlapping times. In that case the end of the hospital A record should be taken as the time of the hospital B admission.
        • That's not so much a note for Julie as an instruction for a cross-check. Not sure if that's a cross check we have in CFE or something she does in SAS...
2021-07-15 2021-07-15 4:28:08 PM
Bed holds duplication on wiki needs to be cleaned up once we are on same page , e.g. LOS Medicine per hospital admission and other LOS pages would use this concept as well and other

details are duplicated at articles in "what links here", should get rid of details elsewhere and only have them here, but need to discuss with Julie.

There are likely three parts:

  • How this should be collected - almost trivial now since Using Cognos2 to keep track of patients should address it, but since collectors don't necessarily follow that, we should probably leave the instructions above and just link from there? Maybe?
  • Cross-checks - this is done by which queries?
  • Data Use - The actual way that's done may well be different for different Indicators and Reports, so it would likely be best if the details were stored in the respective pages with a link back to this page whenever the concept crops up.
2021-07-15 4:28:08 PM
Centralized data front end.accdb Change Request _dev_CFE
  • CCI and ICD10 make button for Pagasa
2021-07-15 2021-07-15 9:34:31 PM
Centralized data front end.accdb Change Request _dev_CFE
  • Linked pairs, better storage
2021-07-15 2021-07-15 9:34:31 PM
CFE Inline Integrity Checks
  • What sort of checks do we actually want here?
  • What would trigger the checks? We don't have "complete" to trigger a check, so what would trigger it? on_change has problems when used on comparison of multiple fields.
2021-07-27 2021-07-27 10:06:57 PM
Change of GRA location names from "our" names to EPR/Cognos names
  • decided at Task that we should to this for the other sites as well, need to execute.

once that's done, we will need to review if the following are still needed:

Julie email confirmed that she doesn't need the specific info listed on these pages since we now get the details in Boarding Loc. Ttenbergen 15:43, 2021 April 29 (CDT)
April 2021 2021-10-14 4:31:54 PM
Change of GRA location names from "our" names to EPR/Cognos names
  • We have not changed s_dispo table over to use the same values yet. There are at least two Cognos Units at GRA that don't map cleanly:
    • "GH-SWAP Location" - we can probably ignore that one, as per GH-SWAP Location we don't enter it so it doesn't really need a counterpart
    • "GH-Surgical Day Care" - this one can eithe rbe an ICU contingency bed or a GRA ambulatory care location; or maybe that's even changed, it was a thing during COVID. There is one line in Cognos for this in the 2020-05-06 batch, and it's for 2021-04-20 10:05:00; there was also a location "GH-IP-Surgical Day Care"... maybe that was the COVID one? Ttenbergen 16:30, 2021 May 6 (CDT)
2021-10-14 4:31:54 PM
Change of GRA location names from "our" names to EPR/Cognos names Change the names of the locations for GRA in s_dispo table to the names used in Cognos. 2021-10-14 4:31:54 PM
Change of remaining location names from "our" names to EPR/Cognos names
  • Almost complete for Med, notified collectors of stragglers
  • 2020-12-30 asked Julie and Trish if CC should be next since they are now inconsistent with Med.
2021-06-15 9:18:03 PM
Change of remaining location names from "our" names to EPR/Cognos names
  • decided at Task that we should to this for the other sites as well, need to execute.

once that's done, we will need to review if the following are still needed:

Julie email confirmed that she doesn't need the specific info listed on these pages since we now get the details in Boarding Loc. Ttenbergen 15:43, 2021 April 29 (CDT)
April 2021 2021-06-15 9:18:03 PM
Change to collect TISS data in CCI Picklist When this is settled, there need to be wiki updates to many pages: 2021-09-01 4:16:01 PM
Change to collect TISS data in CCI Picklist TISS quality checks#TISS checks run in Data Processing has a list, these need to be reviewed and some implemented in CCMDB.accdb 2021-09-01 4:16:01 PM
Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc
  • work through #Data Integrity Checks SMW), update documentation in process
  • remove ADT2 button that automatically populates this
  • confirm no more actionable links to the two pages
  • replace the summary entries at the top of Patient Viewer; in fact: Do we still need two entries there since all starts at accept now?
  • hide fields in CCMDB.accdb when all done
  • Created Variables
2021-04-15 2021-08-17 2021-09-02 7:39:10 PM
Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc 2021-04-15 2021-07-27 2021-09-02 7:39:10 PM
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.
2021-07-15 2021-07-15 5:13:47 PM
Check pre acute consistent
  • 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.
2021-02-11 6:11:08 PM
Chronic Health APACHE
  • Tina has an Outlook task to make sure this doesn't get lost, details for next steps in there.
2021-04-22 10:26:44 PM
ClientVisitGUID
  • Implementation is a work in progress.
  • This will likely replace Hospitalization ID.
  • When we start sending this to CFE, update data_element_start_date to actual
2021-06-17 7:57:54 PM
Clinical Practice Management (CPM) Check up with Alan Madick about this in 6 months if we still need it. 2020-05-05 9:53:25 PM
Cognos2 Service Starter
  • If there is more than one profile for a patient, we have not yet been able to list only the one with the applicable admission range. That is surprisingly hard to do without also losing service entries for which there is no associated record. Tina plans to look into this some more, for now eyeball the service time against the profile start dttm and the dispo dttm, which are in the small fields underneath the service time.
2021-10-13 9:26:26 PM
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)
2020-10-15 2021-09-01 2021-07-14 9:36:39 PM
Completeness of TISS records This will need to be reviewed for what we want to do about it when the pink sheets are gone.
  • 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
  • see also TISS form audit
2021-03-01 2021-10-07 7:52:02 PM
Created Variables CC table remove as discussed 2019-09-29. 2021-09-29 9:05:05 PM
Created Variables Common maker query As per email exchange ending 2021-06-10, we will base the "admit dttm" component on the first of the following that exists: (first Service tmp entry), Accept DtTm, Arrive DtTm; need to confirm that that's how I implemented it. Ttenbergen 14:30, 2021 June 10 (CDT) 2021-04-21 7:47:55 PM
Created Variables Common maker query As per email exchange ending 2021-06-10, we will base the "admit dttm" component on the first of the following that exists: (first Service tmp entry), Accept DtTm, Arrive DtTm; need to confirm that that's how I implemented it. Ttenbergen 14:30, 2021 June 10 (CDT) 2021-06-10 7:30:24 PM
Created Variables Common table remove as discussed 2019-09-29. 2021-04-21 7:37:10 PM
Created Variables Common table remove as discussed 2019-09-29. 2021-09-29 9:10:47 PM
Created Variables Common table This one can 2021-04-21 7:37:10 PM
Created Variables Common table This one can 2021-09-29 9:10:47 PM
CTE CTU vs NTU 2020-05-05 9:53:41 PM
Dispo field
  • 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.
2020-10-20 2022-01-05 2021-10-15 7:59:02 PM
Drug-induced immunosuppression
  • Not quite TISS and not quite not TISS, how do I fit this into the wiki documentation?
  • This code was added as a "TISS code" because that turns it into something only collected by ICU. Tina needs to add this into the documentation better.
  • This code was added to eventually replace Apache chronic; there is a change page for this somewhere, it's incomplete.
  • Lisa states that, when used as a TISS item, there are errors because TISS wants a date; need to reconsider how that's done.
2021-09-23 2021-09-23 2021-09-23 4:24:33 PM
Dx Date {{{1}}} 2021-10-13 5:12:34 PM
ECIP 2021-07-15 2021-08-10 2021-07-15 3:19:43 PM
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.
2021-01-22 2:12:54 AM
EMIP TT needs to integrate these better.


  • Scenario...
    • (1) Internal Med answered consult but deferred to ICMS and admitted under Critical care. Profile should be under Critical care and not Med?
      • Consult doesn't count as admission, collect in Critical care only.
    • (2) Rural Pt was accepted by Internal Med but deteriorated enroute to Winnipeg. Transport team transferred to ER resusc room and ICMS consulted and admitted pt. Is this an EMIP/Medicine profile? Or straight Critical care profile? Thank you. p:Mailah Damian ---2021_Mar_16
      • Should only be collected as critical care profile, they were already under CC before they arrived at the hospital. Consider how we would also not collect the pt under medicine if they had died in transit.
2021-08-04 2021-08-17 2021-08-05 3:48:49 PM
EPR Analytics
  • decide if it is time to ask the powers-that-be about this again
2022-01-01 2021-03-18 7:17:43 PM
FinalCheck field _DEV_CCMDB
  • remove field from sending, then set to _DEV_CCMDB_DATA
2021-07-15 2021-08-04 1:19:32 AM
Guideline for coding organ donation after death _dev_CFE

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

2021-07-13 10:40:48 PM
Iatrogenic, mechanical complication/dysfunction, internal prosthetic device or implant or graft NOS q_iatrogenic_trauma

CCMDB is giving an error message saying "has trauma mechanism but no related trauma", cannot send - Joanna Velasco May 29, 2019

  • AG REPLY -- the issue is that this is not a trauma that requires a cause. TINA our soln is to turn all the iatrogenic things like this into "Potential Mechanisms"
2020-05-05 9:53:42 PM
ICD/CCI remove once old pt gone _dev_CCMDB_data
  • remove tables from CCMDB_data: L_LabsFlowsheet, L_Dxs, L_Como
    • they have been removed from sending
2021-08-04 8:34:27 PM
John or Jane Doe patient Tina is working on this, see ClientVisitGUID. 2021-07-08 4:54:09 PM
L Como table Dev_CCMDB_Data 2021-07-21 2021-07-21 8:18:32 PM
L Dxs table Dev_CCMDB_Data 2021-07-21 2021-07-21 8:18:28 PM
L Hospitalization table still need to figure out if I need an s_table for this. 2020-05-05 9:53:40 PM
L Hospitalization table z
  • implementation was never finalized, and it wasn't tested and isn't used.
2020-05-05 9:53:40 PM
Lab identification in the DSM data
  • whatever is decided here, I also need to change this to use the new mixed definition of Admit DtTm
2021-09-02 2021-09-02 3:28:17 PM
Multiple encounter consistency checks The task is currently done by the Statistician and we'd like to get it off her plate. 2021-07-13 10:40:00 PM
Multiple encounter linking checks Considering continuous stay patients as per Continuous_Stay#Identification check for patients that almost meet the requirements
  • Negative stay duration
  • admit/discharge and location consistent, times are not
    • started as query link_suspect_tl_good_time_bad_location
  • times consistent, admit/discharge and location are not
  • EMIP or Parked in ER / direct transfer
2021-07-15 2021-07-15 10:24:29 PM
Multiple LOS errors
  • Flagged as still a problem in 2020-10, possibly for Query check_ER_Delay_not_too_big; if so, it's now fixed since that check got disabled. Ttenbergen 22:08, 2020 October 18 (CDT)
2013-08-02 2021-03-18 2021-09-08 6:31:03 PM
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.
2021-02-22 7:13:18 PM
Pharm Flow Complete _DEV_CCMDB
  • confirm this is really unused...
  • remove field from sending, then set to _DEV_CCMDB_DATA
2021-07-15 2021-07-15 10:23:20 PM
Pre-admit Inpatient Institution field
  • 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.
2020-10-20 2022-01-05 2021-08-05 3:37:27 PM
Previous Location field
  • 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.
2020-10-20 2022-01-05 2021-10-06 9:18:01 PM
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.
2021-04-30 3:06:01 AM
Proposed future changes to Location and Transfer Ready and related fields Meeting is booked for Oct 13 2021 to discuss. 2021-09-23 6:54:07 PM
Px Date 2021-09-08 2021-09-08 2021-09-08 2:45:04 PM
Query check CCI InExtubation consistent _Dev_CCMDB
  • This could be done in CCMDB instead now that we collect TISS there. Confirming with Lisa if she thinks this would be problematic.
    • Lisa couldn't think of problems with it either, so will implement like this to start and we can tweak if there are problems. Ttenbergen 09:52, 2021 July 27 (CDT)
2021-07-15 2021-07-27 2021-07-27 2:52:39 PM
Query check ICD10 awaiting has Transfer Ready DtTm 2021-07-08 2:53:15 PM
Query check ICD10 CLI vs CCI CentralLine
  • needs to be added to CCMDB
2021-10-07 2021-10-07 7:52:02 PM
Query check ICD10 duplicates _Dev_CCMDB
  • the count is wrong, there wasn't a quick fix, so disabling the query for now. Ttenbergen 15:56, 2019 March 27 (CDT)
2021-10-07 10:30:41 PM
Query check ICD10 mechanism vs trauma q_iatrogenic_trauma This is the query that is what is causing trouble with entries like fractures during CPR etc. For now the check makes no allowance for iatrogenics. 2020-05-05 9:53:29 PM
Query check ICD10 trach dxs consistent _dev_CCMDB 2021-08-04 2021-08-17 2021-09-16 9:19:16 PM
Query check tmp chrono boarding transfer
  • do we have instructions where the linking integer is supposed to have meaning? discussed with Julie, and we need to do it that way because otherwise there is no useful way to sort these, since transfer might not have a date at all.
      • decided these don't have to be sequential, will need to update the definition to make that clear
    • There would be work-arounds so this would not be needed, but Julie finds it useful
    • in any case I need to look and make sure that the definitions are same and sensible in the two pages
  • within a pair, the boarding loc has to be before or equal
  • Boarding Loc Transfer Ready DtTm tmp entry
2021-07-27 2021-08-10 2021-08-04 3:56:00 PM
Query check tmp service or location duplicate
  • we also need to check whether there is a duplicate dttm on DIFFERENT items; same query or better in a different one
2021-09-02 2021-09-02 2021-09-02 7:46:18 PM
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)
2020-05-05 9:53:32 PM
R Filter Field _CFE_Data_reconsolidate
  • move into dx and eliminate this field
2021-08-04 8:32:32 PM
R Filter Field _dev_CCMDB data remove
  • stop sending this one
2021-08-04 8:32:32 PM
Reconnect CFE and initial error checks Fix why it gives this error as part of fixing DSM process. 2020-05-05 9:53:46 PM
Reconnect CFE and initial error checks re-name these so not PL any more 2020-05-05 9:53:46 PM
Reconnect CFE and initial error checks Tina will fix Query check CCI must have entry so those are caught going forward. 2020-05-05 9:53:46 PM
Repeat clicks being needed when entering CCI PX Type _dev_CCMDB
  • investigate and fix
2019-03-09 2021-08-17 2021-08-04 8:35:43 PM
Room nr _DEV_CCMDB
  • remove field from sending, then set to _DEV_CCMDB_DATA
2021-07-15 2021-07-15 10:22:33 PM
S AP Chronic table Dx grouping 2020-07-24 2:36:33 AM
S dispo chooser _DEV_CCMDB - if no further noise, remove form Ttenbergen 14:48, 2020 March 2 (CST) 2020-05-05 9:53:42 PM
S dispo Collector Location table _Dev_CFE * This table can be removed, but need to make sure all dependencies are also cleaned up. No longer relevant after PatientFollow Project. 2021-07-14 2021-08-04 8:43:36 PM
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. 2021-02-22 7:10:55 PM
SBGH Swing Beds 2020-12-15 9:17:07 PM
Searching the wiki wiki housekeeping
  • There are ongoing problems searching the wiki. Better search functionality would be nice.
2019-02-13 2021-08-04 8:41:57 PM
Service tmp entry
  • Since that's already available in ADT2 tab, should we have a way to click to fill this date into the Service DtTm? It would likely be a button on each line that would set that line's dt and tm to the relevant parts of the single field Visit Admit DtTm. Ttenbergen 10:55, 2021 April 29 (CDT)
    • that would be great! Lisa Kaita 20:04, 2021 April 30 (CDT)
1969-12-31 2021-09-23 8:48:10 PM
Service/Location field
  • 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.
2020-10-20 2022-01-05 2021-01-22 2:19:33 AM
SL EPR Exclusions table Dev_CCMDB_Data 2021-07-08 2021-07-21 8:19:16 PM
Task Team Meeting - Rolling Agenda and Minutes 2021 make time available in the Dx Date field, update instructions. 2021-10-13 5:16:26 PM
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.
2020-10-20 2022-01-05 2021-10-06 9:19:02 PM
TISS need to make this a better re-director about all things TISS. but not right now. 2021-07-15 2021-07-15 9:47:23 PM
Transfer Delay (Medicine) _dev_CFE Make that available in CFE. 2021-08-03 2021-08-17 2021-08-04 1:21:23 AM
Transfer Ready DtTm field Once the following query comes up empty this field should be removed from view in CCMDB.accdb

SELECT L_Log.D_ID, L_Log.RecordStatus, L_Log.Accept_DtTm, L_Log.Arrive_DtTm, Nz([Accept_DtTm],Nz([arrive_dttm],#1/1/1900#))<=#10/15/2020# AS filter
FROM L_Log
WHERE (((L_Log.RecordStatus)="incomplete") AND ((Nz([Accept_DtTm],Nz([arrive_dttm],#1/1/1900#))<=#10/15/2020#)=True)); 
  • 2021-09-07 - checked query, still 4 profiles
2021-04-14 2021-10-01 2021-09-07 10:30:25 PM
What is a service admission
  • Allan discussed with someone at STB what should be entered for Service with STB mgr of admitting Chantal Plaetnik.
  • Confirmed with Allan that this is still in progress and should move forward today. Ttenbergen 09:46, 2020 November 26 (CST)
  • STB Med flagged various pts where Service in Cognos doesn't match with services in orders. There is still something going on here, and I don't know how to troubleshoot it. Ttenbergen 12:01, 2020 December 10 (CST)
  • Tina needs to integrate.
2021-09-07 2021-09-07 2021-09-07 3:42:00 PM
What is a service admission There is a different page that deals with this, and its no longer an issue, TT needs to clean up. 2021-08-04 2021-08-17 2021-09-07 3:42:00 PM