Query s tmp AHC consistent: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "Project AHC" to "Project AHC (LAU)" |
||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary=Checks for [[Project AHC]] | |DIC_summary=Checks for [[Project AHC (LAU)]] | ||
|DIC_related_concepts=Project AHC | |DIC_related_concepts=Project AHC (LAU) | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_timing=complete | |DIC_timing=complete | ||
Latest revision as of 23:00, 2 July 2025
| Data Integrity Checks | |
| Summary: | Checks for Project AHC (LAU) |
| Related: | Project AHC (LAU) |
| 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 |
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
- 2025-01-20 - turns out I wrote the query and then never set the VBA to run it; so nothing to disable now that the project is over.
- 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: |