Link suspect dead then alive query

Data Integrity Checks
Summary:	Used in Correcting suspect links to find records where an earlier record with that PHIN was listed as dispo field deceased, but a later entry then shows up.
Related:	PHIN field, Dispo field, Deceased patients
Firmness:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:	query Link suspect dead then alive
Uses L Problem table:	Yes
Status:	implemented
Implementation Date:	not entered
Backlogged:	true

• Cargo

• SMW

• Categories:  

• form:

Follow steps in Processing errors in patient data to fix errors found.