|
Category: Constituent
|
Frequency: Monthly
|
Platform: SQL Server
|
Developer: IDS
|
Analyst: GRA
|
What Does It Do?
The University of Michigan data standard is for a UMID to only be assigned to a single person.
This integrity check identifies UMIDs that are on multiple constituent records so that they can be removed from any constituents not affiliated with that UMID 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 UMIDs(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries UMIDs with multiple associated constituents so that the UMIDs can be reviewed.
GRA will review the UMID in MPathways to determine the constituent that should have that UMID. The UMID 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