Query s tmp AHC consistent: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{DISPLAYTITLE:Query s_tmp_AHC_consistent}}{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=Checks for [[Project AHC]]
|DIC_summary=Checks for [[Project AHC]]
|DIC_related_concepts=Project AHC
|DIC_related_concepts=Project AHC
|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 ===
Line 13: Line 14:
* Medicine records admitted after the start and before the end of project have lines required for the project
* 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"
* 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
== Log ==
* If there is a date it has to be after or at admission and before discharge.
* 2024-12-04 - date and time will not be mandatory so no further checks required for now
* If "item" is "yes" there needs to be a date
* 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 21:25, 2024 December 4

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.

Log

  • 2024-12-04 - date and time will not be mandatory so no further checks required for now
  • 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: