|
Category: Constituent
|
Frequency: Monthly
|
Platform: SQL Server
|
Developer: IDS
|
Analyst: GRA
|
What Does It Do?
The OUD-DS3 best practice is for each constituent to only have one UMID alternate lookup ID.
This integrity check identifies constituents with multiple distinct UMIDs so that they can be reviewed for correctness.
How Is This Done?
This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-CONSTITUENT-Review Multiple UMIDs(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries constituents that have multiple UMIDs on their record so that the UMIDs can be reviewed and all incorrect UMIDs removed from the record. The constituent’s UMIDs must be distinct and must all meet the requirement of being 8 numbers long; there are other integrity checks for those not meeting the data standards for UMIDs or being duplicated.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\CONSTITUENT\
Snapshot GUID: bbdw.USR_DM_Cnst_Alt_Look_Up_ID.ConstituentSystemID