Query check CCI if no then none: 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 4: Line 4:
| DIC_firmness = hard check  
| DIC_firmness = hard check  
| DIC_timing = complete
| DIC_timing = complete
| DIC_app = CCMDB.mdb
| DIC_app = CCMDB.accdb
| DIC_coding = query ''check_CCI_if_no_then_none''
| DIC_coding = query ''check_CCI_if_no_then_none''
| DIC_status = implemented
| DIC_status = implemented
| DIC_implementation_date = 2018-10-14
| DIC_implementation_date = 2021-01-20
}}
}}
== Log ==
* 2021-01-20 - the check never worked because it wasn't matching Pat_ID correctly; this was fixed today, meaning effectively this query was only implemented today, so changing the implementation date above.


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

Latest revision as of 23:32, 20 January 2021

Data Integrity Checks
Summary: If No procedure performed in CCI Picklist there must be no other entries in CCI Picklist or CCI Component
Related: CCI Picklist, CCI Component, No procedure performed
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query check_CCI_if_no_then_none
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2021-01-20
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

Log

  • 2021-01-20 - the check never worked because it wasn't matching Pat_ID correctly; this was fixed today, meaning effectively this query was only implemented today, so changing the implementation date above.

Related articles

Related articles: