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

From CCMDB Wiki
Jump to navigation Jump to search
Line 30: Line 30:
{{Todo | who = Tina |
{{Todo | who = Tina |
| todo_added = 2021-04-15
| todo_added = 2021-04-15
| todo_action =  
| todo_action = 2021-08-17
| question =  
* 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 40: Line 41:


{{Todo | who = Julie |
{{Todo | who = Julie |
| todo_added = 2021-04-15
| todo_action =
| question =
* change the source of her "admit dttm" that she generates via program
* 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
* work through any reports that currently use this concept, update documentation in process
** [[#Related articles]] provides a good starting list of related concepts
** [[#Related articles]] provides a good starting list of related concepts
| todo_added = 2021-04-15
| todo_action =
}}
}}



Revision as of 15:16, 2021 August 4

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

Todo.svg

Swiss Army Knife.svg

  • 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
Query check TISS each dayCCMDB.accdbdeclined
Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff daysCCMDB.accdbdeclined
Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTmCCMDB.accdbdeclined
Check Sub PharmCheckCCMDB.accdbimplemented
Query s tmp check combined Boarding Loc and TransferReadyDtTmCCMDB.accdbimplemented
Query s tmp Boarding Loc date itemCCMDB.accdbimplemented
Function Dispo Chronological()CCMDB.accdbimplemented
Query s tmp check Boarding Loc and TransferReadyDtTm pairsCCMDB.accdbimplemented
Query check tmp service and program consistencyCCMDB.accdbimplemented
Query check ICD10 dateCCMDB.accdbimplemented
Query check tmp ER Boarding Loc should exist if from ERCCMDB.accdbimplemented
Query check ICD10 awaiting has Transfer Ready DtTmCCMDB.accdbimplemented
Query check tmp Boarding Loc Service first sameCCMDB.accdbimplemented
Query s tmp apostrophe in commentCCMDB.accdbimplemented
Query check CCI TISS NrDays GT LOSCCMDB.accdbimplemented
Query check minimal data set incompleteCCMDB.accdbimplemented
Query check CCI DateCCMDB.accdbimplemented
Query check has transfer ready date or checkboxCCMDB.accdbimplemented
Check duplicate patientCCMDB.accdbimplemented
Query check tmp Transfer Ready not before Boarding LocCCMDB.accdbimplemented
Query s tmp Boarding Loc no borrow but entryCCMDB.accdbimplemented
Query check CCI TISS NrDays LT LOSCCMDB.accdbimplemented
Check AcceptDtTm entered or missing checkedCCMDB.accdbimplemented
Query check transfer DtTm during admissionCCMDB.accdbimplemented
Query check tmp 2 BL TR S same tmCCMDB.accdbimplemented
Query s tmp check combined BL and TRDtTm nonsequentialCCMDB.accdbimplemented
Query check tmp service or location duplicateCCMDB.accdbimplemented
Query check tmp Service and Boarding Loc during admission timeframeCCMDB.accdbneeds review
Query check pt from ERCCMDB.accdbneeds review
Query check CCI TISS time means must be twoCCMDB.accdbneeds review
Query check ER Delay not too bigCCMDB.accdbneeds review
Query check long transfer delayCCMDB.accdbneeds review
Check CCI CXR vs LOSCCMDB.accdbneeds review
Function long LOS()CCMDB.accdbneeds review
Query check has service entryCCMDB.accdbneeds review
Query check CCI TISS matching BoardingLoc timeCCMDB.accdbready to implement
Query check CCI vs LOS count daysCCMDB.accdbready to implement
Function Transfer Ready DtTm vs statusCCMDB.accdbretired
Query check transfer ready tmp for each Boarding LocCCMDB.accdbretired
Check Function Panelling admit transfer sameCCMDB.accdbretired
Function Validate Transfer Ready DtTmCCMDB.accdbretired
Link suspect negative transit time queryCentralized data front end.accdbimplemented
Query NDC CLI unacceptable dateCentralized data front end.accdbretired
Link suspect transfer ready before arrive dateCentralized data front end.accdbretired
Query NDC VAP unacceptable dateCentralized data front end.accdbretired
Query TISS Errors missing daysTISS28.accdbretired
Query TISS Errors TISS date out of admissionTISS28.accdbretired

Plan/notes

Discuss@task.png

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

  • SMW


  • Cargo


  • Categories
Todo.svg

Swiss Army Knife.svg

  • 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
  • added: 2021-04-15
  • action: 2021-08-17
  • Cargo


  • Categories
Todo.svg

StatsLogo.svg

  • 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: