Query check CCI vs LOS count days component: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
Line 3: Line 3:
|DIC_related_concepts=LOS; Dispo DtTm; Service tmp entry; ECMO, VA; ECMO, VV
|DIC_related_concepts=LOS; Dispo DtTm; Service tmp entry; ECMO, VA; ECMO, VV
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_timing=incomplete
|DIC_timing=always
|DIC_coding=query ''check_CCI_vs_LOS_count_days_component''
|DIC_coding=query ''check_CCI_vs_LOS_count_days_component''
|DIC_implementation_date=2022-02-10
|DIC_status=implemented
|DIC_status=implemented
|DIC_app=CCMDB.accdb
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
|DIC_backlogged=No
}}
}}
This uses [[Function LOS()]].
This uses [[Function LOS()]].



Revision as of 16:23, 10 February 2022

Data Integrity Checks
Summary: Confirm that CCI Collection Mode or CCI Component CCI collect count days items don't have a count > LOS.
Related: LOS, Dispo DtTm, Service tmp entry, ECMO, VA, ECMO, VV
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query check_CCI_vs_LOS_count_days_component
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2022-02-10
Backlogged: No
  • Cargo


  • SMW


  • Categories:  
  • form:

This uses Function LOS().

As of 2022-02-10 there currently aren't any component entries with CCI collect count days but I only realized it after I built the query.

Log

  • 2022-02-10 - implemented

Related articles

Related articles: