Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc

From CCMDB Wiki

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.

Target date

As discussed with Julie, our target date for this change is Oct 1. Ttenbergen 14:39, 2021 September 2 (CDT)

  • Just wondering where this is at, is there a new target date? (Pam)
    • Good question; Julie and I keep finding more things that use the old dates, and we are working on shifting them to the new dates. Not sure about a target date. Ttenbergen 13:23, 2022 January 17 (CST)
  • SMW

  • Cargo

  • Categories

Related Cross-checks


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.

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



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

  • SMW

  • Cargo

  • Categories

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


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