Category: Education
|
Frequency: Monthly
|
Platform: SQL Server
|
Developer: IDS
|
Analyst: DMT
|
This integrity check identifies Rackham Graduate School and Marsal Family School of Education PhD in English and Education alumni missing either a Rackham or Marsal alumni affiliation so that the missing alumni affiliation attribute can be added.
The OUD-DS3 best practice is for shared alumni to have Alumni Affiliation education attributes for all parties involved in the alumni sharing agreement.
That view queries education and education additional information records with
where the education record does not have an alumni affiliation attribute of both Rackham Graduate School and Marsal Family School of Education. Whichever alumni affiliation attribute is missing will be added to the record so that the record will have both.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\EDUCATION
Snapshot GUID: BBDW.DIM_Education.EducationSystemID
Development Alumni Sharing and Transferring Guildelines - OUD, Integrated Data Services