Query s tmp ABO TEE checks: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "{{Data Integrity Check | DIC_summary = Each of the three projects must have one entry on the ITEM for patients with RecordStatus complete | DIC_related_concepts = Project..."
 
mNo edit summary
Line 9: Line 9:
| DIC_implementation_date = 2016-01-28
| DIC_implementation_date = 2016-01-28
}}  
}}  
Checks might have been around before them but were first documented then.


* All the three projects must not have blanks on completion of record.
** automatic functionality, all tmp entries must have matching project/item entries
[[Category:Tmp check]]
[[Category:Site/Location check]]
[[Category:Site/Location check]]

Revision as of 22:53, 2019 January 2

Data Integrity Checks
Summary: Each of the three projects must have one entry on the ITEM for patients with RecordStatus complete
Related: Project ABO TEE, Service/Location field
Firmness: hard check
Timing: complete
App: CCMDB.mdb
Coding: query s_tmp_ABO_TEE_checks
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2016-01-28
Backlogged: true
  • Cargo


  • SMW
"CCMDB.mdb" is not in the list (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) of allowed values for the "DICApp" property. 
  • Categories:  
  • form:

Checks might have been around before them but were first documented then.

  • All the three projects must not have blanks on completion of record.
    • automatic functionality, all tmp entries must have matching project/item entries