Query check tmp BedHeld: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
Line 4: Line 4:
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_timing=complete
|DIC_timing=complete
|DIC_coding= query ''XXXXX''
|DIC_coding=query ''XXXXX''
|DIC_implementation_date=
|DIC_status=needs review
|DIC_status=
|DIC_app=CCMDB.accdb
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
}}
}}
Required checks as per Julie:  
Required checks as per Julie:  
# for AMA AWOL or procedure, bed held end dttm must always be after dispo dttm.   
# for AMA AWOL or procedure, bed held end dttm must always be after dispo dttm.   
Line 19: Line 18:


== Log ==
== Log ==
* 2023-01-11 Discussed at Task and decided to not have a cross check for "procedure" against "[[Dispo]]"
* 2023-01-11 Discussed at JALT and decided to not have a cross check for "procedure" against "[[Dispo]]"
{{Discuss | JALT
* Checked [[JALT_Meeting_-_Rolling_Agenda_and_Minutes_2023#JALT_Meeting_–_January_11/12,_2023]] and there are no details there... did we decline this check? [[User:Ttenbergen|Ttenbergen]] 16:02, 2023 February 2 (CST)
}}
* 2023-01-10 Julie identified needed checks
* 2023-01-10 Julie identified needed checks



Revision as of 17:02, 2023 February 2

Data Integrity Checks
Summary: Validates that the DtTm for the first Service tmp entry is the same as that for the first Boarding Loc entry
Related: BedHeldEnd DtTm, Dispo DtTm
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query XXXXX
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date: not entered
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:

Required checks as per Julie:

  1. for AMA AWOL or procedure, bed held end dttm must always be after dispo dttm.
  2. if bed held end dttm = dispo dttm and AMA, should be AMA protocol.
  3. If item= AMA protocol , the dttm entry is still required.

Also:

  • For the two AMA entries, Dispo needs to be "AMA"

Log

  • 2023-01-11 Discussed at JALT and decided to not have a cross check for "procedure" against "Dispo"
JALT
  • SMW


  • Cargo


  • Categories
  • 2023-01-10 Julie identified needed checks

Related articles

Related articles: