|
Category: Constituent
|
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 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 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.
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