User:Ttenbergen/questions for tina

From CCMDB Wiki
Jump to navigationJump to search

Questions

No questions found

To dos

wiki page question todo added todo action Last modified
"almost same patient" check If we need this page at all it needs to be integrated better. 2020-12-17 7:25:56 PM
2020-10 EMIP changes Will need to reconcile the following: 1969-12-31 1969-12-31 2021-03-18 8:41:05 PM
Accept DtTm Equiv Don't think that's used any more, but need to check to be sure before deleting it. 2021-01-19 6:38:13 PM
ADL General Collection Information 2021-02-22 6:16:43 PM
ApLab Complete Legacy field cleanup. 2019-03-21 6:08:30 PM
ApLab Complete Legacy field cleanup. 2020-05-05 9:53:33 PM
Attribution of infections When this is all settled, the details need to be integrated into Template: ICD10 Guideline Infection, Lab and culture reports, Infections in ICD10 2021-04-01 5:11:49 PM
Bacteremia This lists as Apache Neuro and is in APACHE Acute Dxs in ICD10 codes because it is in the following range:

Nonop - Large categories - Neuro NOS - A17. - A69.22 When we touched on this at an Allan's list meeting you agreed that probably wasn't right. Emailed Allan. Ttenbergen 15:42, 2019 June 25 (CDT)

    • Allan and Tina reviewed Allan's list, and it;s not consistent with our implementation. Allan has emailed Tina his list, Tina will review. Ttenbergen 09:58, 2019 November 5 (CST)
 2019-11-05 3:58:55 PM
Bacteremia This lists as Apache Neuro and is in APACHE Acute Dxs in ICD10 codes because it is in the following range:

Nonop - Large categories - Neuro NOS - A17. - A69.22 When we touched on this at an Allan's list meeting you agreed that probably wasn't right. Emailed Allan. Ttenbergen 15:42, 2019 June 25 (CDT)

    • Allan and Tina reviewed Allan's list, and it;s not consistent with our implementation. Allan has emailed Tina his list, Tina will review. Ttenbergen 09:58, 2019 November 5 (CST)
 2020-05-05 9:53:33 PM
Bed holds duplication on wiki needs to be cleaned up once we are on same page 2021-03-12 1:02:08 PM
Boarding Loc
  • inactivate legacy entry Home Medicine ward once last pt using it is discharged
    • Inactivated HSC and GRA, STB has one left so need to leave it for one more round
 2021-03-01 2021-04-06 9:09:46 PM
Carrier of infectious disease, unspecified
  • Presumably this would be used for Typhoid Marys and asymptomatic carriers of other pathogens as well? Ttenbergen 11:37, 2020 November 20 (CST)
    • As confirmed by Allan, The answer is "yes". I still need to integrate this. Ttenbergen 13:08, 2021 February 22 (CST)
 2021-02-22 7:08:03 PM
Centralized data front end.accdb Still has old name, need to update. Also, isn't really documented here yet 2019-01-30 4:18:10 PM
Centralized data front end.accdb Change Request _dev_CFE
  • add button for link suspect queries to patient list, then update Correcting suspect links with change in steps
  • 2019 March 01 - move priority number column for ICD10 to be after the primary type column. This would make it the same as CCMDB.
  • add TDI column to query L_CCI_Combined
  • fix dc treatment box that isn't showing up in form Ttenbergen 15:52, 2018 April 11 (CDT)
  • fix table reconnector to not look for L_Labs_DSM any longer, since it's now elsewhere. Ttenbergen 15:52, 2018 April 11 (CDT)
  • CCI and ICD10 make button for Pagasa
 2019-07-04 9:10:32 PM
Centralized data front end.accdb Change Request _dev_CFE
  • add button for link suspect queries to patient list, then update Correcting suspect links with change in steps
  • 2019 March 01 - move priority number column for ICD10 to be after the primary type column. This would make it the same as CCMDB.
  • add TDI column to query L_CCI_Combined
  • fix dc treatment box that isn't showing up in form Ttenbergen 15:52, 2018 April 11 (CDT)
  • fix table reconnector to not look for L_Labs_DSM any longer, since it's now elsewhere. Ttenbergen 15:52, 2018 April 11 (CDT)
  • CCI and ICD10 make button for Pagasa
 2020-05-05 9:53:38 PM
Centralized data front end.accdb Change Request _dev_CFE Linked pairs, better storage 2019-07-04 9:10:32 PM
Centralized data front end.accdb Change Request _dev_CFE Linked pairs, better storage 2020-05-05 9:53:38 PM
Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry
  • 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 Grace Medicine on this wiki? Ttenbergen 18:11, 2020 October 13 (CD per ward is being reported.
 2021-02-11 6:08:07 PM
Change of GRA 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-01-19 5:52:32 PM
Change of GRA location names from "our" names to EPR/Cognos names
  • inactivate the old options on Change Date + 5
    • emailed Trish to find out what steps to take next Ttenbergen 11:52, 2021 January 19 (CST)
 2021-01-19 5:52:32 PM
Change Priorities kind of a leftover page; need to either make it the process, or clean it up. 2019-11-14 12:01:24 AM
Change Priorities kind of a leftover page; need to either make it the process, or clean it up. 2020-05-05 9:53:36 PM
Change to collect TISS data in CCI Picklist When this is settled, there need to be wiki updates to many pages: 2021-02-25 12:00:16 AM
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-02-25 12:00:16 AM
Charlson Comorbid Score query {{{1}}} 2019-10-04 3:16:32 PM
Charlson Comorbid Score query {{{1}}} 2020-05-05 10:07:41 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
Check TISS Intubation consistent {{{1}}} 2019-10-04 3:18:47 PM
Check TISS Intubation consistent {{{1}}} 2020-05-05 10:07:41 PM
Chronic Health APACHE
  • when sent for import into TMSX the chronic health score is translated into yes or no
    • no more TMSX, how is this now? Ttenbergen 13:44, 2021 February 22 (CST)
 2021-03-11 5:51:36 PM
Clinical Assessment Unit
  • Emailed Collectors to change the remaining entries to local ward instead. Waiting to hear back now. Ttenbergen 17:03, 2021 April 1 (CDT)
  • need to consider what to do with records that are in Boarding Loc.
 2021-04-01 10:03:15 PM
Clinical Practice Management (CPM) Check up with Alan Madick about this in 6 months if we still need it. 2019-12-04 4:22:42 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
Close - WITH or NO Updates buttons Needs content 2021-01-07 3:40:39 AM
Cognos Integrator forms not returning to the line you were on when you close Patient Viewer Confirm if that's true, and if so, see if I can also store the sort order before refreshing and then restore it. Ttenbergen 22:26, 2020 November 26 (CST) 2020-12-02 6:11:11 PM
Cognos2 No Service or Loc in some time query Tina says: "I plan to turn this into a form with a button to open the records directly, just wanted to get the first round of tweaking done before. Once I make a form where I can add a button to open I will always have to edit two things, and then one gets missed. " 2021-04-06 8:41: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-03-08 3:17:35 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-01-28 10:25:50 PM
COVID-19 (SARS-COV-2)
  • how should this be done now under PatientFollow Project / Boarding Loc ? Is it even still applicable? Likely should live under Boarding Loc instead and just be linked from here? Ttenbergen 12:24, 2020 October 29 (CDT)
    • It seems this instruction is more related to differentiating between Admit Diagnosis & Acquired Diagnosis. The note about transferring location could be taken out because what we're doing for patient follow will capture the move, but the rest of the instruction still applies I would think.
2021-02-22 6:39:03 PM
COVID-19 (SARS-COV-2)
  • What are we doing for COVID recovered cases? So if MB Health considers someone to be non-infectious after 14 days, if someone is admitted to hospital >14 days from their swab date are we still coding them COVID POS? Are we using whether they are/are not isolated on admission as the deciding factor in how these are coded? Do we need a code for the recovered folks who are still needing acute care (for example patients admitted to medicine from ICU after the 14 day isolation period) Surbanski 08:21, 2020 December 10 (CST)
    • I have changed this to a Task discussion because we will need Julie and Allan for this. Could you bring it up there, please? Ttenbergen 11:26, 2020 December 10 (CST)
    • We added Post COVID-19 condition, but some of these pt are simply recovered so would not have that. Ttenbergen 09:44, 2021 February 4 (CST)
2021-02-22 6:39:03 PM
CTE CTU vs NTU 2019-05-10 1:13:36 AM
CTE CTU vs NTU 2020-05-05 9:53:41 PM
Dispo field Since no one person knows when this is the case on all laptops for all fields Tina will need to make a query that checks for this in the centralized data. Ttenbergen 15:42, 2020 October 20 (CDT) 2021-02-14 2020-11-06 2:51:32 AM
Eliminating a diagnosis from collection Will need to confirm that all the checks from the old system will apply to the new one. 2020-04-10 2:52:53 AM
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
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_data 2019-10-04 7:10:19 PM
FinalCheck field _DEV_CCMDB_data 2020-05-05 9:53:43 PM
FinalCheck field _DEV_Centralized_data 2019-10-04 7:10:19 PM
FinalCheck field _DEV_Centralized_data 2020-05-05 9:53:43 PM
Gamma knife one day I might integrate this properly 2020-04-08 3:02:48 PM
Guideline for coding organ donation after death _dev_CFE

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

2019-10-30 2:54:44 PM
Guideline for coding organ donation after death _dev_CFE

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

2020-05-05 9:53:29 PM
HD (Hemodialysis)
  • We used to have a special procedure for indicating if a renal transplant patient received dialysis post transplant under the tasks. If we are now only coding HD once, it will often be missed if the patient required HD post renal transplant. Do we care about collecting this information? There is the post procedural renal failure code that will be coded in the acquireds, but this does not automatically mean that they received dialysis.
    • AG REPLY -- I don't see any special reason to need this info. Unless Julie tells us it's being requested, I think we can do without it.
      • Julie, what are your thoughts on this? Ttenbergen 11:53, 2019 February 13 (CST)
        • Discussed at AJTT: we agreed that we can't and won't do this and this is fine. I still need to integrate that and make sure consistent. Ttenbergen 12:52, 2021 February 22 (CST)
 2021-04-08 9:16:54 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"
 2019-10-30 2:40:10 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 ICD/CCI remove once old pt gone 1 2019-03-28 3:13:45 PM
ICD/CCI remove once old pt gone ICD/CCI remove once old pt gone 1 2020-05-05 9:53:32 PM
L Hospitalization table still need to figure out if I need an s_table for this. 2019-03-10 3:23:42 AM
L Hospitalization table z
  • implementation was never finalized, and it wasn't tested and isn't used.
 2019-03-10 3:23:42 AM
LOS this article has evil twins, need to reconcile, search for LOS Ttenbergen 21:13, 2014 October 23 (CDT) 2020-12-15 4:41:27 PM
Microsoft Access Security Notice Tina has started INC 3863696 with help desk to fix this. Ttenbergen 16:50, 2019 December 12 (CST) 2019-12-12 10:51:57 PM
Microsoft Access Security Notice Tina has started INC 3863696 with help desk to fix this. Ttenbergen 16:50, 2019 December 12 (CST) 2020-05-05 9:53:42 PM
Multiple encounter consistency checks The task is currently done by the Statistician and we'd like to get it off her plate. 2020-10-19 3:05:06 AM
Multiple encounter linking checks lost of list 2020-10-19 3:04:53 AM
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-03-18 8:35:38 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
Patient record or move shows in Cognos but not in EPR
  • check with Chastity if there is an update.
 2021-03-18 7:21:21 PM
Pharm Flow Complete legacy data field 2019-03-10 4:26:37 AM
Pharm Flow Complete legacy data field 2020-05-05 9:53:30 PM
PL 2Phin Fake or Blank _dev_CFE As per meeting with Allan, Julie and Pagasa: (1) only if complete AND (2) only do links in incomplete if have PHIN. 2019-10-04 4:17:49 PM
PL 2Phin Fake or Blank _dev_CFE As per meeting with Allan, Julie and Pagasa: (1) only if complete AND (2) only do links in incomplete if have PHIN. 2020-05-05 9:53:34 PM
PL missing L Tables content dev_CFE
  • Confirm this only deals with complete records
  • Needs to check not listing missing Dispo, Previous Location - email Pagasa when fixed.
 2021-02-04 4:07:30 PM
PL SamePHIN Site Diff chart _dev_CFE 1 this query has reached the 2GB limit, must see if I can lean it out or otherwise reduce the size 2019-07-04 9:14:10 PM
PL SamePHIN Site Diff chart _dev_CFE 1 this query has reached the 2GB limit, must see if I can lean it out or otherwise reduce the size 2020-05-05 9:53:31 PM
Pre-admit Inpatient Institution field Since no one person knows when this is the case on all laptops for all fields Tina will need to make a query that checks for this in the centralized data. Ttenbergen 15:42, 2020 October 20 (CDT) 2021-02-14 2021-03-04 9:46:58 PM
Pre-linking checks not working right now due to PL_SamePHIN_Site_Diff_chart size limit 2020-12-17 7:25:57 PM
Previous Location field Since no one person knows when this is the case on all laptops for all fields Tina will need to make a query that checks for this in the centralized data. Ttenbergen 15:42, 2020 October 20 (CDT) 2021-02-14 2020-12-03 8:56:35 PM
Process for bad data in Cognos This page has an evil twin, need to integrate it here: Wrong service or unit entries in Cognos. 2021-02-12 7:56:45 PM
Processes around changing a PatientFollow assignment Fix the cross checks so this can work; one way would be to exempt records with a visit admit dttm before follow-ending and a dispo (or now) after a follow-ending; messy query for messy times. 2021-01-15 2:58:01 AM
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.
 2019-07-04 9:38:21 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.
 2020-05-05 9:53:36 PM
Project Discharge Documentation if this ever goes life we need to include Category:Site Specific Collection Guide 2020-05-06 2:18:46 AM
Query ''check ER Delay not too big'' Still implemented, but needs to be changed over to use the new Boarding Loc entries. 2021-01-28 8:15:42 PM
Query check ICD10 duplicates the count is wrong, there wasn't a quick fix, so disabling the query for now. Ttenbergen 15:56, 2019 March 27 (CDT) 2019-09-22 5:01:20 PM
Query check ICD10 duplicates the count is wrong, there wasn't a quick fix, so disabling the query for now. Ttenbergen 15:56, 2019 March 27 (CDT) 2020-05-05 9:53:33 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. 2019-10-30 2:40:07 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 This can now include: 2020-12-02 11:58:29 PM
Query NDC CLI unacceptable date ICD/CCI remove once old pt gone 2019-02-07 2:06:19 PM
Query NDC CLI unacceptable date ICD/CCI remove once old pt gone 2020-05-05 9:53:40 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)		 2019-03-10 4:32:26 AM
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 ICD/CCI remove once old pt gone 2020-04-21 5:09:05 PM
R Filter Field ICD/CCI remove once old pt gone 2020-05-05 9:53:41 PM
R Filter Field move into dx and eliminate this field 2020-04-21 5:09:05 PM
R Filter Field move into dx and eliminate this field 2020-05-05 9:53:41 PM
Reconnect CFE and initial error checks Fix why it gives this error as part of fixing DSM process. 2019-02-07 4:00:02 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 2019-02-07 4:00:02 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. 2019-02-07 4:00:02 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 investigate and fix 2019-03-10 3:41:41 AM
Repeat clicks being needed when entering CCI PX Type investigate and fix 2020-05-05 9:53:31 PM
Reset Button
  • remove reset button. Ttenbergen 12:30, 2021 February 11 (CST)
 2021-02-11 6:30:09 PM
Room nr legacy data 2019-03-10 4:34:41 AM
Room nr legacy data 2020-05-05 9:53:27 PM
S AP Chronic table Dx grouping 2020-03-18 3:09:00 PM
S AP Chronic table Dx grouping 2020-05-05 9:53:46 PM
S dispo chooser _DEV_CCMDB - if no further noise, remove form Ttenbergen 14:48, 2020 March 2 (CST) 2020-04-23 4:53:46 PM
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 if we keep it, we need to document the data structure 2020-03-12 4:08:10 PM
S dispo Collector Location table need to review what this table does and how we can make sure that it is included in updates, or deleted if not used. May need integration with S laptops table and others. 2020-03-12 4:08:10 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
S TISS Report table TISS: not really sure where and how this is used, will need to update 2019-03-10 4:35:14 AM
S TISS Report table TISS: not really sure where and how this is used, will need to update 2020-05-05 9:53:41 PM
SBGH Swing Beds 2020-12-15 9:17:07 PM
Searching the wiki planning to try ElasticSearch when I next update the wiki software via elastica or CirrusSearch - timeframe: next 2 months Ttenbergen 13:53, 2019 February 13 (CST) 2019-02-13 7:59:19 PM
Searching the wiki planning to try ElasticSearch when I next update the wiki software via elastica or CirrusSearch - timeframe: next 2 months Ttenbergen 13:53, 2019 February 13 (CST) 2020-05-05 9:53:44 PM
Searching the wiki There are ongoing problems searching the wiki. Better search functionality would be nice 2019-02-13 7:59:19 PM
Searching the wiki There are ongoing problems searching the wiki. Better search functionality would be nice 2020-05-05 9:53:44 PM
Service/Location field Since no one person knows when this is the case on all laptops for all fields Tina will need to make a query that checks for this in the centralized data. Ttenbergen 15:42, 2020 October 20 (CDT) 2021-02-14 2021-01-22 2:19:33 AM
Template:Collection Location wiki housekeeping
  • Template:Collection Location fields "Collection Service Type Legacy" and "Collection Workload Split" and "Collection Service Type" and "Collection Collector" are becoming meaningless, what is the best way to clean that up? This whole template needs to move to Cargo instead of SMW. Ttenbergen 17:39, 2020 October 15 (CDT)
 2021-03-18 7:22:52 PM
Template:Location dropdown cleanup Since no one person knows when this is the case on all laptops for all fields Tina will need to make a query that checks for this in the centralized data. Ttenbergen 15:42, 2020 October 20 (CDT) 2021-02-14 2020-11-26 7:51:23 PM
TISS {{{1}}} 2018-09-26 11:26:11 PM
TISS {{{1}}} 2020-05-05 10:06:14 PM
TISS quality checks
  • Need to decide which cross-checks we need for this. They can now all be in CCMDB.
 2020-12-16 8:40:59 PM
TISS quality checks
  • These need to be integrated into a cross check and then implemented or rejected or whatever.
  1. if ventilated any time (#18) then ETT (#22) or trach (#23) should be marked
  1. if extubated unplanned (#28) or planned (#29) is marked then ETT (#22) should be marked
  2. if ETT is inserted in ICU (#40) then ETT present (#22) should be marked
  3. if previous date has no ETT (#22) and today date has ETT(#22) then new insertion (#40) should be marked
  4. if previous date has ETT (#22) and today date has no ETT (#22) then previous date of the extubated unplanned (#28) or planned (#29) should have marked
  5. if previous date has ETT(#22) and today date has ETT(#22) and new insertion (#40) are marked then today date of extubated unplanned (#28) or planned (#29) should be marked
 2020-12-16 8:40:59 PM
Update of D ID to include a laptop identifier Will this change cause issues with DSM imports? Only if there DSM data has been requested with records that are subject to this change. Do we have any outstanding DSM request right now? Emailed Pagasa/Trish/Julie. 2020-07-24 6:30:32 PM
Retrieved from "https://ccmdb.kuality.ca/index.php?title=User:Ttenbergen/questions_for_tina&oldid=143980"