Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
Line 6: Line 6:
This page is about the process of eliminating the collection of [[Admit DtTm]] and  [[Accept DtTm]] to avoid that duplication and inconsistencies resulting from it.  
This page is about the process of eliminating the collection of [[Admit DtTm]] and  [[Accept DtTm]] to avoid that duplication and inconsistencies resulting from it.  


== Related Cross-checks ==
{{Todo | who = Tina |
| todo_added = 2021-04-15
| todo_action =2021-07-27
|
* [[CCMDB.accdb Data Integrity Checks]] - which of these?
}}
* [[Query s tmp Boarding Loc date item]] - has question for Julie
This is a list of queries that relate to accept, arrive, boarding loc, service tmp and/or transfer ready.
{{#ask: [[DICRelatedConcepts::Accept DtTm]] || [[DICRelatedConcepts::Arrive DtTm]] || [[DICRelatedConcepts::Boarding Loc]] || [[DICRelatedConcepts::Transfer Ready DtTm tmp entry]] || [[DICRelatedConcepts::Service tmp entry]]
|?DICApp = App
|?DICStatus = Status
|sort=DICApp, DICStatus
|default=none found
|format=broadtable
|limit=100}}


== Plan/notes ==
== Plan/notes ==
Line 13: Line 29:


{{Todo | who = Tina |
{{Todo | who = Tina |
| todo_added = 2021-04-15
| todo_action =
* work through [[#Data Integrity Checks SMW)]], update documentation in process
* work through [[#Data Integrity Checks SMW)]], update documentation in process
* remove ADT2 button that automatically populates this
* remove ADT2 button that automatically populates this
Line 19: Line 37:
* hide fields in [[CCMDB.accdb]] when all done
* hide fields in [[CCMDB.accdb]] when all done
* [[Created Variables]]
* [[Created Variables]]
| todo_added = 2021-04-15
| todo_action =
}}
}}



Revision as of 10:31, 2021 July 27

We used to collect only Admit DtTm; at some point this was split into Accept DtTm and Arrive DtTm. With the collection of Boarding Loc and Service tmp entry under 2021-07 rules, this duplicates info:


This page is about the process of eliminating the collection of Admit DtTm and Accept DtTm to avoid that duplication and inconsistencies resulting from it.

Related Cross-checks


  • added: 2021-04-15
  • action: 2021-07-27
  • Cargo


  • Categories

This is a list of queries that relate to accept, arrive, boarding loc, service tmp and/or transfer ready.

 AppStatus
Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTmCCMDB.accdbdeclined
Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff daysCCMDB.accdbdeclined
Query check tmp ER Boarding Loc should exist if from ERCCMDB.accdbdeclined
Query check TISS each dayCCMDB.accdbdeclined
Query check CCI DateCCMDB.accdbimplemented
Query Check BL TR combiner nullCCMDB.accdbimplemented
Query check ICD10 awaiting has Transfer Ready DtTmCCMDB.accdbimplemented
Query check has transfer ready date or checkboxCCMDB.accdbimplemented
Check duplicate patientCCMDB.accdbimplemented
Query check ICD10 dateCCMDB.accdbimplemented
Query check Transfer DtTm after paired BL and before later BLCCMDB.accdbimplemented
Query check tmp service and program consistencyCCMDB.accdbimplemented
Query check CCI TISS NrDays GT LOSCCMDB.accdbimplemented
Query check CCI TISS NrDays LT LOSCCMDB.accdbimplemented
Query check CCI TISS Pharm VasoactiveCCMDB.accdbimplemented
Query check CCI vs LOS count days componentCCMDB.accdbimplemented
Query check CCI vs LOS count days picklistCCMDB.accdbimplemented
Query s tmp check Boarding Loc and TransferReadyDtTm pairsCCMDB.accdbimplemented
Query check minimal data set incompleteCCMDB.accdbimplemented
Query s tmp Boarding Loc date itemCCMDB.accdbimplemented
Query check tmp service or location duplicateCCMDB.accdbimplemented
Query check tmp Service and Boarding Loc during admission timeframeCCMDB.accdbimplemented
Query check transfer DtTm during admissionCCMDB.accdbimplemented
Query s tmp check combined Boarding Loc and TransferReadyDtTmCCMDB.accdbimplemented
Query s tmp Boarding Loc ER delay reasonableCCMDB.accdbimplemented
Query check tmp Boarding Loc Service first sameCCMDB.accdbimplemented
Query check tmp 2 BL TR S same tmCCMDB.accdbimplemented
Query check CCI TISS matching BoardingLoc timeCCMDB.accdbimplemented
Query check no consecutive same BL or ServiceCCMDB.accdbimplemented
Query check long transfer delayCCMDB.accdbneeds review
Query check CCI CXR vs LOSCCMDB.accdbneeds review
Query check tmp Transfer Ready not before Boarding LocCCMDB.accdbretired
Query s tmp check combined BL and TRDtTm nonsequentialCCMDB.accdbretired
Function Transfer Ready DtTm vs statusCCMDB.accdbretired
Query check transfer ready tmp for each Boarding LocCCMDB.accdbretired
Function Validate Transfer Ready DtTmCCMDB.accdbretired
Query s tmp Boarding Loc no borrow but entryCCMDB.accdbretired

Plan/notes

Is there a target date for eliminating this field? Ttenbergen 15:10, 2021 April 15 (CDT)

  • SMW


  • Cargo


  • Categories


  • added: 2021-04-15
  • action: * work through #Data Integrity Checks SMW), update documentation in process
  • remove ADT2 button that automatically populates this
  • confirm no more actionable links to the two pages
  • replace the summary entries at the top of Patient Viewer; in fact: Do we still need two entries there since all starts at accept now?
  • hide fields in CCMDB.accdb when all done
  • Created Variables
  • Cargo


  • Categories

  • change the source of her "admit dttm" that she generates via program
  • work through any reports that currently use this concept, update documentation in process
  • added: 2021-04-15
  • action:
  • Cargo


  • Categories

Related articles

Related articles: