Update Title to Dr. Based on Education

Category: Identity

Frequency: Monthly

Platform: SQL Server

Developer: IDS

Analyst: DMT

 

This integrity check identifies constituents without a title of "Dr." but with education history indicating that they have completed a doctoral program so that their title can be updated to Dr.

The OUD-DS3 best practice is for constituents’ title to be updated to Dr. when they have completed a doctoral degree program.

This integrity check queries active individual constituents with a title of Mr., Ms., Mrs., Miss, Mx., or a missing title and with a graduated education degree of Ph.D., M.D., D.D.S., Ed.D., D.V.M., D.N.P., Dr.P.H., D.O., Pharm.D. so that their title can be updated to Dr..

The output of this integrity check is a batch file for DMT to update titles.

Resources and References

Grad Load