|
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 uniqnames to be between 3 and 8 characters and to only contain alphabetical (a-z) characters.
This integrity check identifies constituents with uniqnames that are not between 3 and 8 characters or which contain non-alphabetical 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 Uniqnames(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries constituents that have uniqnames with a length less than 3, with a length greater than 8, or with non-alphabeticaly (a-z) characters so that the uniqnames can be reviewed and corrected.
GRA will use MPathways to determine the constituent's correct uniqname.
Resources and References
Uniqname Standards
S:\IDS\MES\SQL Scripts\DATA QUALITY\CONSTITUENT\
Snapshot GUID: bbdw.USR_DM_Cnst_Alt_Look_Up_ID.USR_Cnst_Alt_Lookup_ID_Sys_Key