From CCMDB Wiki

Lists all pages in. For those that were added with Template:Discuss it also lists the question.


edit wiki page who question Last modified
edit wiki page who question Last modified
edit "cannot open any more tables" in Access Pagasa
  • If you figure out a pattern why this happens pls put it here. Ttenbergen 17:29, 2022 April 7 (CDT)
    • Assigning Pseudo Phin or working on the queries if I worked long enough opened closed it then the error message pop up "Enter Parameter Value". PTorres 17:01, 2022 April 14 (CDT)
      • The parameter value error usually means a query is opened from somewhere I did not expect it to be opened from, e.g. opening a form expects that it will be opened for a specific record. Can you tell me what is the last thing you did before this error? Ttenbergen 10:58, 2022 April 21 (CDT)
        • After 24 rows, open and closed assigning Pseudo Phin an error message pop up then I cannot assign Phin anymore. I closed CFE then open then I am good to go again. The second time the error message pop up not 24 rows it less than 24 like 15 rows then it will show again the error message. PTorres 16:09, 2022 June 14 (CDT)
          • Is it always at a specific action or button press or similar where this happens? Ttenbergen 13:52, 2022 June 16 (CDT)
  • Yes. Tested it. PTorres 13:55, 2022 June 16 (CDT)
2022-06-16 6:55:24 PM
edit ABG Data Allan z
  • Identified as something we should do to streamline data collection. I have made this page to document progress toward this import. Blood gas data is in DSM listing; need to compare to see if we can use it
    • Allan will revisit with Lab people whether this is obtainable now Ttenbergen 11:34, 2022 February 9 (CST)
  • 2022-04-21 10:25:05 PM
    edit APACHE Acute Diagnoses all JALT
  • The list of admit CCI procedures used in combination with the admit ICD10 codes is shown in
    • There are many questions about that list, I have emailed Julie and Allan for more info. Ttenbergen 16:38, 2022 June 15 (CDT)
      • Allan has provided newest list, but there were version control issues. Allan to sent the current master version to Tina and Julie as of today's JALT. Ttenbergen 10:11, 2022 July 27 (CDT)
  • 2022-07-27 3:11:10 PM
    edit Battery Capacity on Laptops all Are there any problems with battery life at point? 2022-06-16 2:46:22 PM
    edit Battery disposal all collectors, please document what your process is at your office location.Trish Ostryzniuk 17:38, 2019 March 5 (CST) 2020-04-30 4:26:36 PM
    edit CFE Inline Integrity Checks Julie
  • Possible checks:
    • All S, B, T have to be before D
    • any T has to be after the B it's linked to
      • how about T the same as B it's linked to? see cases like this. should we allow? or T must increment one minute from B. --JMojica 10:11, 2022 August 10 (CDT)
        • Pulling that out for Lisa... Ttenbergen 15:56, 2022 August 10 (CDT)
    • any S/B has to be before any CCI and ICD10, and D has to be after these
  • Pagasa, Julie, can you think of other things to check?
    • First S must be the same as first B. - --JMojica 10:11, 2022 August 10 (CDT)
    • Any CCI and ICD10 with datetime must have a corresponding B date. - --JMojica 10:11, 2022 August 10 (CDT)
      • Does it? They are acquireds so could be on B or at any time before D. If so, that was already on my list of possible checks above. If you mean something else, pls explain. Ttenbergen 16:18, 2022 August 10 (CDT)
        • having datetime implies the patient is in two locations on that date. the first location has no time and the second location must have time. I see cases with time but no change in location. if you have this already, then ignore this one. --JMojica 16:32, 2022 August 12 (CDT)
    • do we allow first B ER the same as second B non-ER when previous loc is ER? or simply delete the first B ER from tmp if the same as second B non-ER. - --JMojica 10:11, 2022 August 10 (CDT)
      • I don't understand this one. Do you mean same time? Query_check_tmp_service_or_location_duplicate should find such duplicates, so I think they are not allowed. Are you seeing such things? But I still don't remember what the additional information you give about ER has to do with it... can you explain? Additionally, these extra checks on this page are to catch things Pagasa accidentally gets wrong in edits - would she edit this? Ttenbergen 16:18, 2022 August 10 (CDT)
        • OK, I think Pagasa will not add dups. Pls ignore. --JMojica 16:38, 2022 August 12 (CDT)
    • only one T per B it's linked to (no multi T). each T must have an integer. found case with multi T- one without integer and another with integer. - --JMojica 10:11, 2022 August 10 (CDT)
      • How old were the problems you found? Query_s_tmp_check_Boarding_Loc_and_TransferReadyDtTm_pairs should catch these. I can't think of an error scenario where Pagasa would edit the linking integers, so I wonder how this crept in. Ttenbergen 16:18, 2022 August 10 (CDT)
        • I found some only by accident. maybe these are old but nice to catch and clean. --JMojica 16:38, 2022 August 12 (CDT)
    • T should not have missing time or should not have check mark. - --JMojica 10:11, 2022 August 10 (CDT)
      • Do you mean just time, or dttm? It's one field now, so missing time and midnight are the same. I don't think we have any rule to disallow that. Ttenbergen 16:18, 2022 August 10 (CDT)
        • drop the time and consider the check mark. --JMojica 16:38, 2022 August 12 (CDT)
  • 2022-08-12 9:38:56 PM
    edit CFE Inline Integrity Checks Lisa
  • Julie says she is seeing some Transfer Ready DtTm tmp entry with same DtTm as their corresponding Boarding Loc. The way I read Transfer_Ready_DtTm_tmp_entry#Data_entry_instructions that should be impossible, ie becoming ready at the same time as arriving, no? query check_transfer_DtTm_during_admission would allow at BL but not before. Same for query check_Transfer_DtTm_after_paired_BL_and_before_later_BL. So right now we let BL equal to TR through, but we likely should not. Agree? Ttenbergen 15:56, 2022 August 10 (CDT)
  • Yes the current rule is that you do not carry forward a previous TR dttm to a new boarding loc, however, this can legitimately happen, I have used it a couple of times recently, where the boarding loc date and time is earlier than EPR, but not greater than 30 mins difference, (so we don't change it) and the order or note written for TR then precedes our COGNOS boarding dttm so I enter the earliest possible dttm which is the same as the boarding loc dttm. This is usually for those patients deemed ACP C or palliative Lisa Kaita 08:00, 2022 August 12 (CDT)
  • 2022-08-12 9:38:56 PM
    edit CFE Inline Integrity Checks Pagasa
  • This would best be based on things Pagasa is likely to check and change. Pagasa, so you agree that would most likely changes the following? Are there other checkable things you edit a lot?
  • 2022-08-12 9:38:56 PM
    edit CFE Inline Integrity Checks Pagasa
  • Would running these queries just before vetting work for Pagasa? Ttenbergen 16:24, 2022 August 9 (CDT)
  • 2022-08-12 9:38:56 PM
    edit Change for Apache Chronic to ICD10 from separate variable Julie
  • Created_Variables_CC_maker_2021 query now uses Created_APACHE_Chronic query with cut off Dispo_DtTm 2019-01-01. Please let me know if anything further is required about this. If all done, please take out this discussion and section. Ttenbergen 10:47, 2022 June 30 (CDT)
  • 2022-06-30 3:47:34 PM
    edit Change of GRA location names from "our" names to EPR/Cognos names Tina
  • Do we need to change old ITEM values for consistencies? --JMojica 12:11, 2022 March 8 (CST)
    • It might be nice to have, and you would know better how important this is. If we want to do it, we would need to ask Pagasa to run the update queries for each item. The query would be like
  • UPDATE L_TmpV2 SET L_TmpV2.Item = "GH-Emergency"
    WHERE (((L_TmpV2.Project)="Boarding Loc") AND ((L_TmpV2.Item)="GRA_ER"));
        • Was updated for all except GRA Boarding... Tina needs to fix wiki page. Ttenbergen 16:11, 2022 March 23 (CDT)
    2022-03-23 9:11:36 PM
    edit Change of remaining location names from "our" names to EPR/Cognos names Lisa
  • 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)
    2022-06-14 6:45:20 PM
    edit Change of remaining location names from "our" names to EPR/Cognos names Lisa This was a To Do entry with Lisa's name - some decision had been made and we needed to make sure that whatever is now in here is consistent with what is in the following. This may be done already, if so this discusssion can be deleted. Ttenbergen 13:45, 2022 June 14 (CDT)
  • CUS
  • Using Cognos2 to keep track of patients
  • Boarding Loc
  • 2022-06-14 6:45:20 PM
    edit Change of remaining location names from "our" names to EPR/Cognos names Tina 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)
    2022-06-14 6:45:20 PM
    edit ClientGUID field Lisa
  • Aside from the odd correction entries, are there scenarios where records are routinely added other than via Cognos? Ttenbergen 11:41, 2022 June 16 (CDT)
  • 2022-08-10 6:52:07 PM
    edit ClientGUID field Lisa
  • Do collectors add all HSC IICU admissions via Cognos now that each IICU service admission is included on all HSC CC laptops? Or are there still exceptions. Ttenbergen 11:41, 2022 June 16 (CDT)
  • 2022-08-10 6:52:07 PM
    edit ClientGUID field Lisa
  • Do you know if the ClientGUID is visible in EPR anywhere? It is usually a long number, like 4000012345678912 at HSC. There are shorter ones and some start with a different number. If these were actually visible in EPR then the question of whether we ever enter a record otherwise would go away, as we would be ale to just enter them explicitly as neededTtenbergen 15:32, 2022 August 4 (CDT)
  • 2022-08-10 6:52:07 PM
    edit Cognos2 Service Starter Lisa
  • Does the above "exception" only apply to ICU patients transferring to med? Are there implications for patients admitted while in ER? This would also be applicable to transfers from non collection units ie. fam med to med. Pamela Piche 08:09, 2022 May 19 (CDT)
    • It's required for technical reasons, so should apply to all. Ttenbergen 09:47, 2022 May 19 (CDT)
    • What if collectors forget to include reminder notes?
      • Nothing should happen, cross check should catch this, see comment above. Ttenbergen 09:47, 2022 May 19 (CDT)
    • Is there now more than one process to manage cognos service entries by collectors, one being to enter known incorrect data to make corrections later-is this setting collectors up for potential entry errors? Will this complicate cross coverage? Pamela Piche 08:25, 2022 May 19 (CDT)
      • Since everyone is supposed to do it the same way this should, if anything, make cross coverage easier than it is now, where some people enter the Cognos date initially and some enter the final date initially. Ttenbergen 09:47, 2022 May 19 (CDT)
    2022-07-27 3:45:35 PM
    edit Controlling Dx Type for ICD10 codes Task
  • Has Barret had a chance to complete the review of the list? Ttenbergen 17:10, 2022 August 9 (CDT)
  • 2022-08-09 10:10:56 PM
    edit DC Treatment Julie
  • Three of these contain weird values; do we care?
  • D_ID	SentDtTm	R_dc_treat
    STB_ACCU-30009	2016-Sep-16 06:35	c
    HSC_SICa-767	2016-Aug-03 07:51	s
    STB_CCU-29365	2015-Nov-04 10:14	Leslie
    • Do we want to keep this field in CFE or transfer the "DC" values into the new spot, and what would that be?
      • delete the weird values. maybe make a new table L_DC and another for L_FILTER and move to TMS legacy. --JMojica 17:20, 2022 August 12 (CDT)
    2022-08-12 10:20:15 PM
    edit Disorder of the cardiovascular/circulatory system, NOS Allan JALT is this where we would code thoracic outlet obstruction? Lisa Kaita 12:40, 2022 August 11 (CDT) 2022-08-11 5:40:38 PM
    edit Disorder of the immune system, NOS Allan JALT is this where we would code VEXAS syndrome? Lisa Kaita 12:34, 2022 August 11 (CDT) 2022-08-11 5:34:43 PM
    edit ECIP all
  • As per email discussion with Lisa: "We could also have a safety net where by the other ICU collectors could email the collectors at HSC when they receive an admission from HSC ER?"
    • If others receiving an admission from HSC ER would be a filter, we might actually have that info in Cognos, it just would not be showing up in your (ie HSC’s) data at this time. But that would mean collectors would always need to review patients who went to another ICU from the HSC ER (and likely the same for the STB ER, possibly even the GRA one...), so that seems like a lot of overhead. Are we OK to just identify SICU ECIPs as a population we likely usually don't capture? Ttenbergen 15:36, 2020 October 6 (CDT)
  • On the online Bed Board (, there is a column OFF_service Patients which means any patient overflowing to either Resuscitation room in ED, PACU/PARR, ICCS, etc. and entry is real time. For HSC SICU, the common overflow location is PACU (haven’t seen any at ER). Only GRA ICU shows overflows in ER. This may give us a clue for possible ECIP but not sure how DC will crosscheck the online bed board if the timing won't synchronized. maybe we just have to ignore SICU ECIP if there is such a thing. --JMojica 16:27, 2020 October 6 (CDT)
  • 2022-06-14 8:50:14 PM
    edit ER Delay Julie
  • I have re-updated Created_Variables_Common_maker_2021 query, for some reason the change I had made was not reflected in the master version. Ready to test. Ttenbergen 13:25, 2022 June 28 (CDT)
  • 2022-06-28 6:25:06 PM
    edit Error: There isn't enough free memory to update the display. Close unneeded programs and try again. all
  • Are collectors still getting this error? Under what circumstances? Will need more input if we want to fix this. Ttenbergen 15:34, 2022 June 1 (CDT)
  • I just had this happen on the H6 laptop, but I have about 250 records on it and I had forgotten to delete the sent profiles (about 50) so once I did this the error went away Lisa Kaita 08:11, 2022 June 3 (CDT)
  • 2022-06-03 1:11:54 PM
    edit Gaps and overlaps Pagasa
  • Pagasa, we discussed this today, and you said you would put this into L_Problems and then delete the info from the excel sheet (or the whole excel sheet if all has been transitioned). Putting this here so it is on your list. Ttenbergen 15:34, 2022 March 31 (CDT)
  • when all has been moved to l_problem, the "current state" above can be deleted and we can just leave the "future state" portion as documentation. Ttenbergen 15:45, 2022 March 31 (CDT)
  • 2022-03-31 8:45:14 PM
    edit Gaps and overlaps Pagasa
  • Pulled this from Known data errors:
  • The Data processor keeps an Excel workbook that includes: reason some profiles are missing data elements (APACHE - 8 ICU profiles), gaps in database because of deletions including reasons for deletions, overlaps, overs. Example missing all APACHE elements ... and reason why could never be obtained.
    • It sounds like there might be other known error types in addition to lost, gap and overlap. Feel free to add them to L_Problems as well, just put here what any additional options mean. If needed I will pull the wiki pages apart. Ttenbergen 15:41, 2022 March 31 (CDT)
    2022-03-31 8:45:14 PM
    edit Gender identity disorder Allan JALT please clarify when we are to use this, transgender? Lisa Kaita 07:45, 2022 August 9 (CDT) 2022-08-09 12:45:02 PM
    edit Heart transplant, failure or rejection or unspecified complication Julie
  • This is the plan, right, but not executed yet? When the data has been added that should probably be added here for clarification. Ttenbergen 12:09, 2022 June 30 (CDT)
  • 2019-12-11 4:46:08 PM
    edit Heart-lung transplant, failure or rejection or unspecified complication Julie
  • This is the plan, right, but not executed yet? When the data has been added that should probably be added here for clarification. Ttenbergen 12:09, 2022 June 30 (CDT)
  • 2019-09-03 7:34:45 PM
    edit HSC MICU Collection Guide Lisa
  • The following is outdated info, but I am not sure if there is anything special for MICU now, so leaving it. The up-to-date instructions for this are in Boarding Loc and Service tmp entry.
  • Due to the COVID-19 outbreak, some SICU patients are now being treated in MICU, until they are proven to be negative. See COVID-19 (SARS-COV-2)under Cohorting in HSC ICUs.
    • If they are under MICU service, enter them using HSC_MIC service location, and add SICU under MICU in the tmp file. See ICUotherService.
      • Once they are transferred to SICU, make a new file with HSC_SIC service location.
    • If for some reason the patient is in MICU under SICU service, enter them using HSC_SIC service location and treat it as a Boarding Loc.
    • I guess technically it should be under both, as we have a separate page for SI and MI, but maybe we could have just one collection guide that addresses all sites. IICU, SI, and MI? Lisa Kaita 13:06, 2022 April 13 (CDT)
      • Whatever is applicable to all ICUs should be in HSC Critical Care Collection Guide. The unit specific guides should only contain unit specific information. This was more important when we were still assigning records to laptops by unit, and someone might need to know all about a unit while covering. Keeping the distinction would be cleaner, but I can see where putting all in HSC Critical Care Collection Guide might be easier. They are already linked to each other. However we decide to do this, keep both levels or consolidate to one page, the info I flagged should still likely be on HSC Critical Care Collection Guide, not just on this unit page, right? Ttenbergen 10:44, 2022 April 21 (CDT)
      • If thinking like a collector, the first place to look would be the type of patient you are looking at, eg. under MICU service but boarding in SICU, if not sure what to do, first instinct would be to look at the MICU collection guide and vice versa for a SICU patient boarding in MICU Lisa Kaita 09:07, 2022 April 28 (CDT)
        • So do we want to do away with the HSC Critical Care Collection Guide, then? Because it sounds like you would not look there in any scenario. How about the HSC General Collection Guide? If we want to do away with them we would need to include all of that in each specific unit guide. So we have two questions: how do we keep this updated, and how would people use it. Might be easier to discuss in person, Lisa, can we chat about this sometime? Ttenbergen 11:03, 2022 May 4 (CDT)
    2022-05-04 4:03:51 PM
    edit Instructions for importing a batch of DSM Data Allan JALT
  • There is a long-outstanding request to Allan to map the new labs that have come in in the last few months. I emailed a list this evening to get this done. This is currently on the agenda for the Task meeting as well. Ttenbergen 22:11, 2022 April 20 (CDT)
  • 2022-08-10 7:41:34 PM
    edit Level of care hierarchy all JALT
  • We had discussed making this "the level of care of where the pt goes" but the problem in this definition is pts who are discharged or AMA from or die in ER. So I have instead made it about the patient's service. Would that work as a definition? This would also remove the concept of "where the patient actually went" from the definition and might finally eliminate some of the confusion that comes from that. Ttenbergen 12:37, 2022 August 3 (CDT)
    • I agree. --JMojica 13:09, 2022 August 3 (CDT)
      • Yes, but you added HOBS above, and that doesn't work if we do it by service: if the pt never makes it to a unit it would be impossible to find out whether it's HOBS or regular. So if you want to include the option of HOBS we are back to needing a special clause, either for EMIP or for HOBSers, depending how we define them. If we are ready to treat all pts as regular ward while in ER then no extra clause needed. The case not counting ER as HOBS is that, if they were transfer ready in the ER and then went to HOBS then they likely deteriorated from being transfer ready, so it's actually an escalation in care. Sorry I didn't catch this earlier, I can't believe that this sends this back yet again. Ttenbergen 17:21, 2022 August 3 (CDT)
  • 2022-08-03 10:21:30 PM
    edit Link suspect mismatch pre inpt should be ours incomplete query Pagasa
  • You say "Sometimes the error continuous admission the second admission was admitted to ER" - that woldn't come up in this query, though, right? What are you actually telling someone who is doing vac relief with this? Ttenbergen 14:24, 2022 March 24 (CDT)
    • After we talked I initially thought that this was essentially CCMDB Query check prev pre-admit consistent. But it clearly is something different and I still don't understand what it does. We'll need to discuss again. Ttenbergen 16:03, 2022 April 5 (CDT)
  • 2022-06-14 8:30:58 PM
    edit Liver transplant, failure or rejection or unspecified complication Julie
  • This is the plan, right, but not executed yet? When the data has been added that should probably be added here for clarification. Ttenbergen 12:09, 2022 June 30 (CDT)
  • 2019-09-03 7:34:42 PM
    edit Lung transplant, failure or rejection or unspecified complication Julie
  • This is the plan, right, but not executed yet? When the data has been added that should probably be added here for clarification. Ttenbergen 12:09, 2022 June 30 (CDT)
  • 2019-09-03 7:34:43 PM
    edit Minimal Data Set Task JALT
  • With the recent change to initially collect the date and time for service and boarding loc as in cognos initially, and to only change it after pt leaves location, the cross checks that require these to be the same were misfiring. So I moved them to being done only on completion. That change will make the data less useful in the interim. What should we do? Ttenbergen 09:16, 2022 May 26 (CDT)
    • In my opinion the above change could potentially create a lot of confusion for new collectors around processes, may make orientation challenging, and results in additional "head work" to require later reconciliation of service/location start dates/times for all collectors. A question is: Do services/locations eventually drop off the Cognos ADT2 tab for longer stay patients? If so, this would result in even more work for collectors to reconcile service/location start date/times deferred to when the patient is discharged. To always enter known correct data whenever possible is the most logical, easiest, and most consistent approach. The data is of more immediate value to main office staff. Pamela Piche 09:58, 2022 May 26 (CDT)
      • The service dates will drop off after 28 days, but if we use COGNOS correctly, the service changes will come through COGNOS and a new service entry should be entered by the collector in the tmp whenever there is a change. Does that answer the question Pam? I am sending an email out, if there is further clarification needed, please let me know Lisa Kaita 13:36, 2022 August 3 (CDT)
      • I think the change and decision below may address this, but leaving this question for Lisa since it is about collection practice rather than what is being collected. Let me know if you need me to resolve it. Ttenbergen 12:54, 2022 August 3 (CDT)
  • 2022-08-03 6:36:38 PM
    edit Mycobacterium tuberculosis (M. TB) Lisa :
  • I tried to make the above list via query so it would remain updated if we add codes; it doesn't include Spine, tuberculosis (Pott's disease) because that is not in the an infectious disease category. Should it be? This also affects how we treat this as data. If it's an infection it would likely also need to be an Infection with implied pathogen. Ttenbergen 17:11, 2022 August 3 (CDT)
  • 2022-08-03 10:11:57 PM
    edit Non-standard ICD10 Diagnoses Allan Dx grouping JALT
  • 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.
    • Actually, neither BOOP nor SARS would currently be captured by our APACHE Acute Dxs in ICD10 codes filter - they likely should be. So this is still an issue and we would miss them if we did something similar. How do we fix it for the Apache codes and prevent this problem going fwd? Ttenbergen 15:22, 2022 June 30 (CDT)
  • 2022-08-03 2:23:39 PM
    edit Off ward field Julie
  • Any reason we would want to keep the data in this field? Ttenbergen 13:48, 2022 August 10 (CDT)
    • Allan suggested this OFFWARD field for some reasons related to outcome. you are right the tmp Boarding will indicate patients staying in offward locations. Offward started July 2016. CC started tmp Boarding July 2018 while Med on Sept2019. since offward start date was before any of these BL dates, we need to keep those data in prior dates. --JMojica 16:18, 2022 August 12 (CDT)
  • 2022-08-12 9:26:27 PM
    edit Pancreas transplant, failure or rejection or unspecified complication Julie
  • This is the plan, right, but not executed yet? When the data has been added that should probably be added here for clarification. Ttenbergen 12:09, 2022 June 30 (CDT)
  • 2019-09-03 7:34:42 PM
    edit Previous Service field Task
  • To clarify the first point above is this applicable to admissions from nursing stations direct to collection units?
    • What makes you wonder, why would it not be applicable? Ttenbergen 11:42, 2022 March 24 (CDT)
    • I added text to the first point, is this clearer now?
  • To clarify the second point above is "Emergency Medicine" entered for direct admits to a collection service from nursing stations via ER? Thanks!
    • What makes you wonder, why would it not be applicable? Ttenbergen 11:42, 2022 March 24 (CDT)
      • The questions were asked with new collectors in mind for clarification tweaking purposes in regards to phrasing such as "dropped by ER" if the patient is a direct admit to service via ER from a nursing station should the previous service entry also be "other (known, but not on list)"?.
        • What does "dropped by ER" mean in this context? Is it "dropped by" as in visited, or as in someone dropped the ball? Ttenbergen 10:47, 2022 April 7 (CDT)
  • valid question thanks Pam, makes me wonder why we differentiate between the two situations, in my opinion they should be consistent and we should put Emergency Medicine for both situations. The previous location will identify that they were from a nursing station, which in my mind functions like an urgent care/ER triage. We (HSC) rarely get direct admits to the ward from a nursing station, but we get lot of direct admits via the ER from a nursing station. Pull in Julie to see if/how she reports on this. Lisa Kaita 12:41, 2022 April 13 (CDT)
    • emailed Julie Ttenbergen 10:25, 2022 April 21 (CDT)
      • this is a case of direct admits from nursing station parked at ER, correct? we have the list of specific MB nursing stations and generic outside MB nursing stations. why put unknown? In terms of previous service, this is seldom requested so I have not quality checked this field. Just did a quick browse on the database and filter previous location having '(parked)' - found 1269 entries and the previous service is not consistent. There are 940 already in-patients and 82 entered Emergency Medicine as previous service ( 67 out of 82 from HSC) while the 858 entered the actual service or unknown. With regards to the new process starting Oct2020, we won't know if direct admits even if already an inpatient. Example from Oct 2020, I found 134 already an inpatient from other facilities with previous location own ER and previous service Emergency Med while 49 enter the actual service. If known as direct admit parked at ER waiting for available bed then enter the prior inpatient service. Otherwise enter Emergency Medicine. --JMojica 11:29, 2022 April 21 (CDT)
        • I thought Previous Service was part of a standing report, and that that is the main or only reason we even capture it. If it's not used, should we still collect it? I will flag this for task. Ttenbergen 15:22, 2022 April 28 (CDT)
  • 2022-04-28 8:22:25 PM
    edit Query check long transfer delay Julie
  • At the meeting about cross checks (a long time ago) it was decided to change the cut-off to SD*3; if we want to proceed with this check, I will need values for that. Ttenbergen 23:08, 2020 October 15 (CDT)
  • 2022-08-04 1:52:29 PM
    edit Query check tmp ER Boarding Loc should exist if from ER Task JALT
  • how about the cases who did not wait at all at ER but immediately went to the Ward or ICU ? - do they still need the first boarding loc be ER? Some DCs entered at least 1 minute difference between first boarding loc ER and second boarding loc - if this is being done, what does the LOS per Location mean when there is 1 minute or 5 minutes or 30 minutes at ER. Are the ICU or Med service really taking care of them at ER in such short stay? --JMojica 14:16, 2022 March 21 (CDT)
    • Good questions. I think this needs to go to Task to get input from Collectors and Allan. Ttenbergen 11:52, 2022 March 24 (CDT)
    • This was discussed at TASK and the decision was create a soft check for collectors to check this, as we know that stays in ER less than 30 minutes are often errors, can this be removed? Lisa Kaita 08:32, 2022 April 28 (CDT)
      • The soft check would flag it for review, but Julie's question was what is the correct thing to actually enter in that scenario. The check can't address that. Ttenbergen 10:58, 2022 May 4 (CDT)
  • 2022-06-14 8:16:16 PM
    edit Query Mgmt StartDelays Lisa
  • Not currently used since Trish retired. If we want to use these we will need to update this to using Admit DtTm instead. But this may not be the right query anyway. Emailed Lisa to have conversation if she wants to use this. Ttenbergen 15:08, 2022 April 27 (CDT)
  • 2022-04-27 8:08:40 PM
    edit Query NDC Bad Postal Code Tina
  • I think this is the process where you said you are having problems with copy/pasting. Copy pasting isn't even mentioned here, so maybe update the process to show how you actually do this, so that someone like Sheila Rusnak would be able to follow the instructions. Ttenbergen 15:45, 2022 March 17 (CDT)
    • Do you create that query each time? Would we be able to update the NDC query that finds these in the first place to include the info you need? We can discuss at our next meeting. Ttenbergen 16:23, 2022 March 17 (CDT)
      • Taking this off Pagasa's list for now, since if we can get this data from DSS we won't need to do this any more. Ttenbergen 15:36, 2022 March 24 (CDT)
  • 2022-08-10 9:22:01 PM
    edit R Filter Field Julie Don't understand where or how Julie wants these moved, I don't thin we have a tmp project for these; we can make one but then I'd need a clear definition of what these are. Emailed Julie Ttenbergen 09:52, 2022 August 4 (CDT)
  • CCN/CC (co managed CCU patients intubated/non ventilated) – 633 records from 1989-2004 at STB/HSC MICU
  • H/B/HB/BH (HSC CCU at H7, B3 or both) – 1100 records from 2003 – 2006 at HSC CCU
  • 2022-08-10 6:47:12 PM
    edit R Filter Field Pagasa
  • Emailed Pagasa to please run the following queries to clear out this field. Ttenbergen 09:52, 2022 August 4 (CDT)
  • 2022-08-10 6:47:12 PM
    edit Repeat clicks being needed when entering CCI PX Type all
  • I can't replicate this. Pulled test data, deleted all CCIs Picklist entries from one profile, closed profile, re-opened, clicked type dropdown and it worked. Can someone provide a series of steps to recreate the above error? The report is old and I must have pasted it from somewhere else, so I don't even have a collector to go back to. The problem may be the step just before clicking in the dropdown, so if you get this problem, please include that step. Ttenbergen 16:59, 2022 February 10 (CST)
  • 2022-02-10 10:59:34 PM
    edit Retropharyngeal or parapharyngeal abscess Allan JALT - How would you code a prevertebral space abscess from osteomyelitis? Would it fall under this code? Brynn 2022-07-27 8:14:14 PM
    edit Run-time error when closing CFE Pagasa
  • Pagasa, do you have more details about this? Ttenbergen 20:54, 2022 June 1 (CDT)
  • Right now I don't get this error message.PTorres 16:11, 2022 June 22 (CDT)
  • 2022-06-22 9:11:06 PM
    edit Saluvision Lisa How does this relate to the info in HSC Death Registry? Ttenbergen 09:37, 2022 May 19 (CDT)
  • They don't need to be linked, they are separate entities Lisa Kaita 08:52, 2022 June 3 (CDT)
    • Separate entities yes, but if I was a new collector needing to find out how to deal with records for dead patients, when would I use either? They likely are related. Ttenbergen 15:20, 2022 June 8 (CDT)
  • 2022-06-08 8:20:46 PM
    edit SBGH Swing Beds Lisa
  • to be sure, if I remember right STB ICU does that for ALL Boarding Loc entries, not just swing beds, right? Just trying to confirm, because if that's true then it's not a swing bed instruction but instead a STB Critical Care Collection Guide instruction (or possibly a Boarding Loc one). Ttenbergen 11:33, 2022 January 27 (CST)
  • 2022-06-30 7:31:51 PM
    edit SBGH Swing Beds Lisa Are there actually differences in how CC, Med or different laptops do this? Or is the following correct for all?
    • Since any CUS entry at STB could be either a swing bed or a real bed, all of these service locations and times need to be reviewed.
    • If a CUS entry is for a swing bed, enter the correct entries (service location, date/time)
    • The applicable Cognos line(s) can then be manually excluded using the "exclude" button
    2022-06-30 7:31:51 PM
    edit Template:ICD10 Guideline MRSA Allan z "It was decided that Allan with contact Dr. Embil after COVID is over and see if we can obtain this data from Infection Control. If so, we could import it into the database, and have our data collectors cease obtaining it." - did anything come of that? 2021-01-12 8:59:00 PM
    edit Template:ICD10 Guideline Transplant Failure Julie
  • This is the plan, right, but not executed yet? When the data has been added that should probably be added here for clarification. Ttenbergen 12:09, 2022 June 30 (CDT)
  • 2022-06-30 5:09:26 PM
    edit The "make loc" button will sometimes enter a different record than the line that it is clicked on. Lisa
  • Not allowing a scroll in those fields isn't ideal, but is it actually causing any frustration? If not, then maybe this is a final solution. Ttenbergen 11:50, 2022 June 16 (CDT)
  • 2022-06-16 4:50:52 PM
    edit Transfer Delay (Critical Care) Task JALT one of the DC mentioned in the TASK meeting that GRA Med patient with transfer ready dttm and went to GRA ICU should be considered as bed wasted. In the current process, all with transfer ready dttm are included as bed wasted regardless where the patient went or died. but in this new way of reporting, this is not the case. can we discuss again which is the final way? --JMojica 13:28, 2022 June 24 (CDT) 2022-06-29 2:46:56 PM
    edit Transfer Delay (Medicine) Julie
    • This function is now ready to test. Ttenbergen 15:17, 2022 June 29 (CDT)
    2022-06-29 8:17:25 PM
    edit Transplanted organ NOS, failure or rejection or unspecified complication Julie
  • This is the plan, right, but not executed yet? When the data has been added that should probably be added here for clarification. Ttenbergen 12:09, 2022 June 30 (CDT)
  • 2019-09-03 7:34:41 PM