Edit Data Integrity Check: Query check CCI Date

Are you logged on?

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: CCMDB_legit.

Summary (what is the check, one-liner):
links to related pages:
Firmness (is this a warning only (soft check) or will it stop sending (hard check) - applicable only in CCMDB.accdb app):	None/unknown hard check soft check
Timing (does this query run for all records or only complete ones):	None/unknown complete always
Name of the function or query this is implemented as:	query ''check_CCI_Date''
Implementation date:
Implementation Status:
L_Problem (are false positive special cases addressed in table L_Problems - applicable only in CFE):	None/unknown Yes No
App:
Backlogged (is this query cleaned up to date or backlogged? Applicable only in CFE):

Free text:

'''If this check changes, consider whether [[Query check ICD10 date]] should be changed the same way.''' * If exists, [[Px_Date]] must be between first [[Service tmp entry]] and [[Dispo_DtTm]] * [[Px_Date]] mandatory for procedures with [[Px Type]] '''acquired''' / [[Acquired Procedure]] * [[Px_Date]] not allowed for procedures with [[Px Type]] '''admit''' / [[Admit Procedure]] == Log == * 2022-03-31 - updated to use first [[Service tmp entry]] instead of "Accept DtTm" * 2021-03-24 - Julie flagged a false negative that was probably from before the last log * 2021-01-20 - confirmed that both dates before admit and after dispo are caught. * 2020-10-15 - changed start limit from "Arrive DtTm" to "Accept DtTm" since we now collect data on pts starting at ER arrival, and the EMIP distinction is going away. == Related Articles == {{Related Articles}} [[Category:CCI Px check‎]]

Explain your edit, if you think it needs explanation (e.g. "as discussed with ...", or "content moved to ...", or "duplicate content, see ..."):

This is a minor edit

Watch this page

Cancel