From CCMDB Wiki
Revision as of 22:02, 2022 February 17 by Ttenbergen (talk | contribs) (→‎Questions)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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)
  • 2022-07-06 4:52:54 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 CCI Collection Lisa
  • How would you like us to code CCI procedures, where the pt moves from a collecting location to a temporary procedure location and then to a noncollecting location? Dispo field would be to the temporary procedure location. Lisa Kaita 10:05, 2022 May 10 (CDT)
    • This is actually documented in Visits to temporary locations so we should not duplicate it here and instead link to it. Possibly this might be addressed by the fact that I was supposed to make "Other Procedure Location" available as Dispo entry but had not yet. I have now, will go out with the next version. Ttenbergen 11:47, 2022 May 10 (CDT)
      • I think this was addressed. If so, it can be deleted, but if some part of this is still outstanding please clarify. Ttenbergen 10:48, 2022 June 15 (CDT)
  • 2022-06-15 3:48:06 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 all
  • 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-06-16 4:41:39 PM
    edit ClientGUID field Task
  • 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-06-16 4:41:39 PM
    edit Cognos2 Service Starter all JALT
  • 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-06-15 9:48:39 PM
    edit Created Variables Common 2021 table Tina _after
  • When this is done, Query check_long_transfer_delay and Created Variables Common table will need to be reviewed.Ttenbergen 13:41, 2022 June 14 (CDT)
  • 2022-06-28 5:04:00 PM
    edit Disorder of vein, NOS Allan
  • I turned the above into a template, and only then realized that there are some un-resolved sc entries below (which should be resolved...), and one is "varices". That might mean there is a better code for this... Flagging for Allan. Ttenbergen 12:05, 2022 June 30 (CDT)
  • 2022-06-30 5:05:48 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 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 Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI) Tina _wiki housekeeping
  • we have a page about attribution somewhere, make sure that this is consistent.
  • 2022-06-30 9:12:17 PM
    edit Level of care hierarchy Task JALT
  • I wonder if the above clause is where the confusion keeps coming from that it matters to Transfer Delay where a patient actually goes. Where is the above distinction supposed to be applied, and how? Is it only to apply to when a collector would enter a transfer ready dttm, or also to what Julie might do in reporting after? The former would make some sense, since collectors would have access to additional info. Just changing it in reporting would not make sense, though. If it is the former, then the info is really related to whether it is counted as a transfer ready decision, not what level of care something is. So it should be clarified and moved to Transfer Ready DtTm tmp entry and clarified. Ttenbergen 09:17, 2022 May 19 (CDT)
  • 2022-06-02 9:51:56 PM
    edit Level of care hierarchy Task JALT

    This is kind of awkwardly worded. Is it equivalent to:

    • if discharged to level lower than ward, ED level is ward
      • wording above says this is true only for a med pt, but would it be true if an ICU pt was ever discharged home from ED?
      • further, what if it isn't a decision but an AMA?
    • if discharged to ward, ED level is ward
    • if discharged to ICU, ED level is ICU
    2022-06-02 9:51:56 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 Lost/missing chart Task JALT
  • Are the data entered for Discontinued profiles reliable for reporting? or even their minimal data set ? --JMojica 15:15, 2022 June 24 (CDT)
  • 2022-06-24 8:15:36 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)
  • is is possible to add previous location and postal codes as part of minimal data set. Its addition will expand the use of data for incompletes and answer the question where the patients are coming from which is commonly requested. --JMojica 13:57, 2022 June 24 (CDT)
  • follow up question - are the data in the minimal data set reliable for reporting? --JMojica 13:57, 2022 June 24 (CDT)
    • Both service and location start date/times will be initially incorrect for patients transferring to medicine units from ICUs or other non collection units ie. surgical or family medicine as collectors are to enter what is listed in cognos for the service start date/time in these instances and pair the location start date/time. Service start date/time can precede, be the same or follow the actual boarding location (transfer) start date/time. It is not until profile completion that correction(s) are made.
    • At STB for medicine program, it is often not known whether patients are direct admits via ER until the profile is reviewed during completion. Pamela Piche 14:33, 2022 June 24 (CDT)
  • 2022-06-24 7:33:09 PM
    edit Muscle, disorder NOS all
  • drop foot
    • isn't that usually caused by a nerve problem? not sure what to use instead... could be a DA question Ttenbergen 15:35, 2022 June 8 (CDT)
  • 2022-06-08 8:35:51 PM
    edit Non-standard ICD10 Diagnoses Allan 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.
    • 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-06-30 8:22:39 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 Post COVID-19 condition Task JALT Where should POST COVID appear - as Admit only? Acquired?, Comorbid ? is it correct to have both POST COVID and COVID Positive in Admit? how about having both POST COVID and Past history COVID as Comorbid? --JMojica 14:10, 2022 June 24 (CDT) 2022-06-24 7:10:54 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-06-30 7:34:36 PM
    edit Query check long transfer delay Tina _after
  • This will need to be implemented when the 3SD is available.
  • 2022-06-30 7:34:36 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-06-30 8:49:55 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-06-24 4:16:46 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