Body
Category: Alternate Lookup ID
|
Frequency: Monthly
|
Platform: SQL Server
|
Developer: IDS
|
Analyst: GRA
|
What Does It Do?
The University of Michigan data standard is for a uniqname to only be assigned to a single person.
This integrity check identifies uniqnames that exist on multiple constituent records so that they can be removed from any constituents not affiliated with that uniqname in MPathways.
How Is This Done?
This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-CONSTITUENT-Review Shared Uniqnames(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries uniqnames with multiple associated constituents so that the uniqnames can be reviewed.
GRA will review the uniqname in MPathways to determine the constituent that should have that uniqname. The uniqname should be removed from any other constituents.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\CONSTITUENT\
Snapshot GUID: bbdw.USR_DM_Cnst_Alt_Look_Up_ID.Usr_Cnst_Alt_Lookup_ID_Txt