Query s tmp AHC consistent: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Text replacement - "Project RAH" to "Project AHC"
No edit summary
 
(6 intermediate revisions by the same user not shown)
Line 4: Line 4:
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_timing=complete
|DIC_timing=complete
|DIC_status=
|DIC_status=implemented
|DIC_LProblem=No
|DIC_app=CCMDB.accdb
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
}}
}}
{{DISPLAYTITLE:Query s_tmp_AHC_consistent}}


=== checks ===
=== checks ===
* Medicine records admitted after the start and before the end of project have all four lines
added
* The lines have to be yes or no
* Medicine records admitted after the start and before the end of project have lines required for the project
* If there is a date it has to be after project start, after or at admission, before the project end and before discharge.  
* The lines must not be ""not entered"
* If there is a date it has to be after or at admission and before discharge.
 
still need to be done
{{Discuss |
* If "item" is "yes" there needs to be a date
** waiting for details on unclear dates and times [[User:Ttenbergen|Ttenbergen]] 13:54, 2024 December 2 (CST)
}}
 
 
== Log ==
 
* 2024-12-02
** Medicine records admitted after the start and before the end of project have lines required for the project
** The lines must not be ""not entered"
** If there is a date it has to be after or at admission and before discharge.


== Related articles ==
== Related articles ==

Latest revision as of 11:13, 2024 December 3

Data Integrity Checks
Summary: Checks for Project AHC
Related: Project AHC
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: not entered
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: not entered
Backlogged: No
  • Cargo


  • SMW


  • Categories:  
  • form:


checks

added

  • Medicine records admitted after the start and before the end of project have lines required for the project
  • The lines must not be ""not entered"
  • If there is a date it has to be after or at admission and before discharge.

still need to be done

  • If "item" is "yes" there needs to be a date
    • waiting for details on unclear dates and times Ttenbergen 13:54, 2024 December 2 (CST)
  • SMW


  • Cargo


  • Categories


Log

  • 2024-12-02
    • Medicine records admitted after the start and before the end of project have lines required for the project
    • The lines must not be ""not entered"
    • If there is a date it has to be after or at admission and before discharge.

Related articles

Related articles: