|
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 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 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.
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