Body
|
Category: Alternate Lookup IDs
|
Frequency: Monthly
|
Platform: SQL Server
|
Developer: IDS
|
Analyst: GRA
|
What Does It Do?
The University of Michigan data standard is for University of Michigan IDs (UMIDs) to be 8 characters in length and to only contain numeric (0-9) characters.
This integrity check identifies constituents with UMIDs that are not 8 numeric characters so that they can be corrected or removed from the record.
How Is This Done?
This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[INTEGRITY_ALTLOOKUPID_Review Invalid UMIDs(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries University of Michigan ID-UMID alternate lookup IDs that are not 8 characters long or which contain any characters that are not numbers between 0 and 9.
GRA reviews these UMIDs against MPathways to correct them; if a constituent should not have a UMID, the UMID alternate lookup ID record can be removed from their DART record.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\LOOKUP ID
Snapshot GUID: bbdw.usr_dm_cnst_alt_look_up_id.usr_cnst_alt_lookup_id_sys_key