Body
|
Category: Constituent
|
Frequency: Monthly
|
Platform: SQL Server
|
Owner: IDS
|
What Does It Do?
The OUD-DS3 best practice is for deceased constituents to always be listed as inactive.
This integrity check identifies constituent records that are marked as deceased but not marked as inactive so that they can be inactivated.
How Is This Done?
This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-CONSTITUENT-Constituent is Active and Is Deceased(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries constituent records that are marked as deceased and marked as active. It notes that they should be made inactive (active = ‘No’).
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\CONSTITUENT