User:Ttenbergen/questions for tina

From CCMDB Wiki
Jump to navigationJump to search

Questions

edit page question ModDate
edit page question ModDate
edit Cognos EPR Report
  • 2020-06-25 as of about 2 weeks ago, gender is no longer included in the data because it was breaking the export. I have reminded Chastity repeatedly to put it back in but there is no ETA for this.
2020-07-31 2:45:00 AM
edit HSC D4 pre COVID
  • Hi Tina, I am trying to fix up the collection guide for D4, but realized there is no page for D4. Should I be creating a new page, or using this precovid page to update information? I am not savvy enough to create a new page, so I will need some guidance...
    • Please put the instructions on this page. If they need to move I will take care of that. And yes, we need to start our post-COVID cleanup of some of this, at risk of jinxing ourselves. We are discussing in the office what we will need to do to clean all this up on the wiki. For now, you can take out this discussion if your question is answered, we will catch the page for covid cleanup because it is linked from other pages. Thanks Michelle! Ttenbergen 11:23, 2020 July 9 (CDT)
  • 2020-07-09 4:23:03 PM
    edit Patient Viewer Tab Cognos ADT
  • I already know the following:
    • At least some patients show duplicate lines in the Cognos list
  • 2020-07-31 2:45:06 AM
    edit "Delete Sent Patients" button dev_CCMDB
  • disallow individual record delete on the patient lister built-in.
  • add a delete button that does the logical delete correctly on a per-patient basis.
  • this seems to be relatively low priority since we are not basing anything absolute on the logical delete feature, but needs to get done eventually to clean this up.
  • 2020-08-05 1:23:46 AM
    edit Template:ICD10 Guideline Iatrogenic Pneumothorax find page for general rule of not coding iatrogenic events as traumas 2020-03-18 4:19:12 PM
    edit Pneumothorax, tension, nontraumatic find page for general rule of not coding iatrogenic events as traumas 2020-03-18 4:22:19 PM
    edit Pneumothorax, nontension, nontraumatic find page for general rule of not coding iatrogenic events as traumas 2020-03-18 4:22:31 PM
    edit Pneumothorax, nontraumatic, NOS find page for general rule of not coding iatrogenic events as traumas 2020-03-18 4:22:11 PM
    edit Iatrogenic, puncture or laceration, related to a procedure or surgery NOS find page for general rule of not coding iatrogenic events as traumas 2020-03-18 4:22:45 PM
    edit Template:Newsflash needs troubleshooting 2019-09-24 6:25:28 PM
    edit Query NDC zCRRT TISS no tmp _dev_CFE - remove this and *old 2019-10-04 7:32:37 PM
    edit Query NDC zCRRT tmp no TISS _dev_CFE - remove this and *old 2019-10-04 7:33:02 PM


    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. 2019-03-06 8:32:26 PM
    "almost same patient" check If we need this page at all it needs to be integrated better. 2020-05-05 9:53:41 PM
    2020-03 HSC COVID unit transition
    • Once the last of these is sent we can name them back to their longer, more expressive versions.
    • deactivate HSC_D4_P / HSC_D5_P in s_tmp table once last pt has moved.
    2020-06-03 2020-05-28 3:52:02 AM
    2020-03 HSC COVID unit transition
      • This may result in Orphans in Centralized data.mdb for these patients, since the the D5 entry was renamed and therefore the dispo_ID remains the same, but the serial was turned negative. Tina will discuss with Pagasa
    2020-05-28 3:52:02 AM
    2020-03 STB COVID unit transition
    • deactivate STB_E6_P in s_tmp table once last pt has moved.
    2020-06-17 2:38:49 PM
    2020-03 STB COVID unit transition
    • We needed to use P for Pre_COVID and C for COVID since full names would have broken D_ID in sending. Once the last pt of a location is sent, we can change those names in the s_dispo table.
    2020-06-17 2:38:49 PM
    2020-03 STB COVID unit transition Need to deactivate STB_E6_B once transition is over. 2020-06-17 2:38:49 PM
    Adding a CCI or ICD10 entry in CFE we need a better solution, I need to make that ID field populate automatically. 2019-04-10 4:01:51 PM
    Adding a CCI or ICD10 entry in CFE we need a better solution, I need to make that ID field populate automatically. 2020-05-05 9:53:43 PM
    APACHE Comorbidities in ICD10 codes {{{1}}} 2020-03-12 3:02:48 PM
    APACHE Comorbidities in ICD10 codes {{{1}}} 2020-05-05 10:07:41 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
    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 borrow is this about to change with Boarding Loc? 2020-01-31 5:02:47 PM
    Bed borrow is this about to change with Boarding Loc? 2020-05-05 9:53:27 PM
    Bed holds duplication on wiki needs to be cleaned up once we are on same page 2020-01-29 1:16:34 AM
    Bed holds duplication on wiki needs to be cleaned up once we are on same page 2020-05-05 9:53:32 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 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
    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 Inf Potential Infection must have pathogen or alt combined code _dev_CCMDB
    • Discussed on Agarland 09:56, 2019 August 22 (CDT) - we should implement this. At least for a while. If too much extra work, we can take it out.
    2019-10-04 3:18:11 PM
    Check Inf Potential Infection must have pathogen or alt combined code _dev_CCMDB
    • Discussed on Agarland 09:56, 2019 August 22 (CDT) - we should implement this. At least for a while. If too much extra work, we can take it out.
    2020-05-05 9:53:32 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
    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
    Completeness of TISS records Dev_CFE
    • 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
    2019-06-04 5:36:28 PM
    Completeness of TISS records Dev_CFE
    • 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
    2020-05-05 9:53:39 PM
    Completeness of TISS records Dev_CFE
    • 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
    2020-05-05 10:05:20 PM
    CTE CTU vs NTU 2019-05-10 1:13:36 AM
    CTE CTU vs NTU 2020-05-05 9:53:41 PM
    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 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.
    2020-04-10 4:38:26 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 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.
    2020-05-05 9:53:31 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
    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) 2019-07-04 9:37:04 PM
    LOS this article has evil twins, need to reconcile, search for LOS Ttenbergen 21:13, 2014 October 23 (CDT) 2020-05-05 9:53:40 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. 2019-06-20 2:30:45 PM
    Multiple encounter consistency checks The task is currently done by the Statistician and we'd like to get it off her plate. 2020-05-05 9:53:42 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.
    2019-03-21 4:04:56 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.
    2020-05-05 9:53:32 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.
    2019-12-11 10:21:47 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.
    2020-05-05 9:53:39 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-linking checks not working right now due to PL_SamePHIN_Site_Diff_chart size limit 2019-03-20 9:48:48 PM
    Pre-linking checks not working right now due to PL_SamePHIN_Site_Diff_chart size limit 2020-05-05 9:53:24 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.
    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 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 minimal data set incomplete _dev_CCMDB need to add previous location, and confirm all others in Minimal Data Set are checked. 2019-12-11 9:53:06 PM
    Query check minimal data set incomplete _dev_CCMDB need to add previous location, and confirm all others in Minimal Data Set are checked. 2020-05-05 9:53:40 PM
    Query Import request matcher This part of the cross-check is now well understood and ready to program. 2019-05-15 5:39:43 PM
    Query Import request matcher This part of the cross-check is now well understood and ready to program. 2020-05-05 9:53:45 PM
    Query NDC CLI AcqDX but NoCLI DateinTMPV2 ICD/CCI Please removePTorres 11:48, 2019 July 24 (CDT) 2019-09-18 8:58:14 PM
    Query NDC CLI AcqDX but NoCLI DateinTMPV2 ICD/CCI Please removePTorres 11:48, 2019 July 24 (CDT) 2020-05-05 9:53:24 PM
    Query NDC CLI No AcqDX but CLI DateinTMPV2 ICD/CCI Please removePTorres 11:49, 2019 July 24 (CDT) 2019-09-18 8:58:21 PM
    Query NDC CLI No AcqDX but CLI DateinTMPV2 ICD/CCI Please removePTorres 11:49, 2019 July 24 (CDT) 2020-05-05 9:53:46 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
    Query NDC Dialysis TISS CCI _dev_CFE change to wait till complete 2019-10-04 4:17:43 PM
    Query NDC Dialysis TISS CCI _dev_CFE change to wait till complete 2020-05-05 9:53:38 PM
    Query NDC Dxs vs TISS Dialysis _DEV_CFE Discussed 10:00, 2019 August 22 (CDT) - list looks like a good start, ready to implement. 2019-10-04 7:27:03 PM
    Query NDC Dxs vs TISS Dialysis _DEV_CFE Discussed 10:00, 2019 August 22 (CDT) - list looks like a good start, ready to implement. 2020-05-05 9:53:43 PM
    Query NDC TISS Extubation only on TISS Intubated days _DEV_CFE
    • implement check
    2019-10-04 7:28:13 PM
    Query NDC TISS Extubation only on TISS Intubated days _DEV_CFE
    • implement check
    2020-05-05 9:53:45 PM
    Query NDC TISS vs pharmacy {{{1}}} 2019-10-04 8:05:25 PM
    Query NDC Trach Dx TISS _DEV_CFE ready to implement 2019-10-04 7:29:15 PM
    Query NDC Trach Dx TISS _DEV_CFE ready to implement 2020-05-05 9:53:42 PM
    Query NDC VAP AcqDX but NoVAP DateinTMPV2 ICD/CCI remove once old pt gone 2019-02-07 6:30:13 AM
    Query NDC VAP AcqDX but NoVAP DateinTMPV2 ICD/CCI remove once old pt gone 2020-05-05 9:53:41 PM
    Query NDC VAP No AcqDX but VAP DateinTMPV2 ICD/CCI remove once old pt gone 2019-02-07 6:30:13 AM
    Query NDC VAP No AcqDX but VAP DateinTMPV2 ICD/CCI remove once old pt gone 2020-05-05 9:53:44 PM
    Query NDC VAP unacceptable date ICD/CCI remove once old pt gone 2019-02-07 6:23:38 AM
    Query NDC VAP unacceptable date ICD/CCI remove once old pt gone 2020-05-05 9:53:41 PM
    Query TISS Errors missing days _Dev_TISS28 change to wait till complete 2019-10-04 7:40:11 PM
    Query TISS Errors missing days _Dev_TISS28 change to wait till complete 2020-05-05 9:53:36 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
    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. 2019-09-22 5:02:18 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. 2020-05-05 9:53:44 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
    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
    TISS {{{1}}} 2018-09-26 11:26:11 PM
    TISS {{{1}}} 2020-05-05 10:06:14 PM
    TISS28 Form Scanning {{{1}}} 2013-01-02 6:50:36 PM
    TISS28 Form Scanning {{{1}}} 2020-03-12 4:13:29 PM
    TISS28 Form Scanning {{{1}}} 2020-05-05 10:07:40 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