Query check ICD10 date

Data Integrity Checks
Summary:	Acquired Diagnosis / Complication must have Dx Date or Dx Date unknown, other Dx Type must have neither, and must be Accept DtTm<Dx_Date<Dispo_DtTm
Related:	ICD10 Diagnosis, Acquired Diagnosis, Admit Diagnosis, Comorbid Diagnosis, Dx Type, Dx Date, Dx Date unknown, Dispo DtTm field, Accept DtTm field
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check ICD10 date
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2018-10-01
Backlogged:	No

• Cargo

• SMW

• Categories:  

• form:

If this check changes, consider whether Query check CCI Date should be changed the same way.

I need to change this check to look at Service tmp entry instead of Accept DtTm.

added: no added date action: no action date

• Cargo

• Categories

Log

• 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.