Review Uniqnames Shared by Multiple Constituents

Summary

This integrity check identifies uniqnames that are on multiple constituent records so that they can be reviewed for correctness.

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

Details

Details

Article ID: 13088
Created
Tue 12/3/24 10:44 AM
Modified
Mon 3/17/25 2:57 PM