Add Missing Title from Identity Information

Category: Identity

Frequency: Monthly

Platform: SQL Server

Developer: IDS, DEI

Analyst: DMT
 

What Does It Do?

The OUD-DS3 best practice is for constituents to have a title wherever possible to facilitate name formats. Constituents can have their title updated based on 2 or more supporting consistent pieces of identity information as outlined in the Development Identity and Affinity Data Acquisition and Usage Implementation Guidelines .

This integrity check identifies constituents who do not have a title and who have two or more consistent supporting pieces of identity information (gender, gender identity, pronouns) so that a title can be added to their record and name formats. 

How Is This Done?

This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[INTEGRITY_IDENTITY_Add Missing Title(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.

That view queries constituents who do not have a title and who have two or more consistent pieces of identity information. It uses the Identity and Affinity Gendered Data Translations crosswalk to insert titles for those constituents.

A Constituent Documentation Note is also added to the constituent’s record, with the following standards, using [INTEGRITY_CHECKS].[dbo].[INTEGRITY_IDENTITY_Add Missing Title - Document with Note(DW)]:

  • Type of Note is “Personal Data Comments”

  • Title of Note is “Title”

  • Date of Note is the run date

  • Author of Note is Jessica VanElls (14100782)

  • Content of the Note is “Integrity Check: <new title>   Updated title from blank/missing to <new title> based on 2 constituent pieces of constituent identity data: Gender=<gender>, GenderIdentity=<genderidentity>, Pronoun=<pronoun>, HasSpouse=<Yes/No>”, where the spouse note will only be applied for Ms./Mrs. title updates. 

Constituents who already have a constituent documentation note with a title of “Title” and content like “Constituent confirmed” are excluded from this integrity check.

Resources and References

S:\IDS\MES\SQL Scripts\DATA QUALITY\IDENTITY

Snapshot GUID: BBDW.DIM_Constituent.ConstituentSystemID

Development Identity and Affinity Data Acquisition and Usage Implementation Guidelines-DRAFT

 

Print Article