Query check CCI TISS time means must be two: Difference between revisions

Revision as of 16:31, 2021 September 2

Data Integrity Checks
Summary:	If the Px Date component of a CCI Picklist has a time, then there must be a corresponding Boarding Loc entry
Related:	CCI Picklist, Boarding Loc
Firmness:	soft check
Timing:	incomplete
App:	CCMDB.accdb
Coding:	query check_CCI_TISS_matching_BoardingLoc_time
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:
Backlogged:	true

	Julie had said in email: If any CCI date has a matching date on boarding loc, CCI must have at least two records (one with time and without time) if the yesterday and tomorrow have this same item. Here we are identifying missing line. Example H7-3316. Boarding loc move Dec 10 20:57 . CVC has dates Dec 9, 10,11. Dec 10 must have two lines one with time and another with time 20:57. Not necessarily... what if the CVC simply wasn’t there for the MICU portion of the switch day?

Related articles:
Supp O2 through any device, delivered via nose, mouth, ETT or trach (TISS Item) ‎ (← links) ETT Present (TISS Item) ‎ (← links) Trach Tube Present (TISS Item) ‎ (← links) CAM positive (TISS Item) ‎ (← links) Invasive Mechanical Ventilation (TISS Item) ‎ (← links) CCI Collection ‎ (← links) Data Integrity Checks ‎ (← links) CCMDB.accdb Change Log 2023 ‎ (← links)

@@ Line 2: / Line 2: @@
 | DIC_summary = If the [[Px Date]] component of a [[CCI Picklist]] has a time, then there must be a corresponding [[Boarding Loc]] entry
 | DIC_related_concepts = CCI Picklist; Boarding Loc
-| DIC_firmness = hard check
+| DIC_firmness = soft check
 | DIC_timing = incomplete
 | DIC_app = CCMDB.accdb