|
Category: Alternate Lookup ID
|
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 any incorrect uniqnames can be removed from the constituent's record.
How Is This Done?
This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[INTEGRITY_ALTLOOKUPID_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.
GRA will use MPathways to determine the constituent's correct uniqname.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\CONSTITUENT\
Snapshot GUID: bbdw.USR_DM_Cnst_Alt_Look_Up_ID.ConstituentSystemID