Add Missing Gender from First Names

Summary

This integrity check identifies gender for records with a current “unknown” gender. This audit uses the First Name/Gender Predictor table from Blacbaud CRM (Integrity Checks table:FirstName_Gender_DART_4_8_2025) to predict the gender for the record based on the first name. If a match is found, this audit will then determine the best gender. The OUD-DS3 best practice is for every record to have a gender when there is an available. The output of this integrity check is a batch of new titles to be

Body

Category: Identity

Frequency: Monthly

Platform: SQL

Developer:IDS

Analyst:DMT

 

This integrity check identifies gender for records with a current “unknown” gender.  This audit uses the First Name/Gender Predictor table from Blacbaud CRM (Integrity Checks table:FirstName_Gender_DART_4_8_2025) to predict the gender for the record based on the first name. If a match is found, this audit will then determine the best gender.

The OUD-DS3 best practice is for every record to have a gender when there is an available.

The output of this integrity check is a batch of new titles to be added to DART records.

Resources and References

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

Version History

Date

Uniqname

Description of Change

2025-04-09

averyag

Documentation created.

 

Details

Details

Article ID: 13711
Created
Wed 4/9/25 3:39 PM