|
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 uniqname alternate lookup ID.
This integrity check identifies constituents with multiple distinct uniqnames 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 Uniqnames(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries constituents that have multiple unique uniqnames on their record so that the uniqnames can be reviewed and all incorrect uniqnames removed from the record.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\CONSTITUENT\
Snapshot GUID: bbdw.USR_DM_Cnst_Alt_Look_Up_ID.ConstituentSystemID