Update Title from Ms or Miss to Mrs for Married Constituents

This integrity check identifies constituents with a title of Miss or Ms. but who have a spouse constituent in DART with the same or a hyphenated last name so that their title can be updated to Mrs.. 

The OUD-DS3 best practice is for married constituents with traditionally female titles (Miss/Ms/Mrs) to have the title of Mrs. unless they have requested a different title. It is a more risk-averse approach to only apply this rule only when the constituent’s last name is consistent with their spouse’s last name (i.e., their last names are the same or their last name is hyphenated with their spouse’s).

This integrity check queries constituents with a title of Miss or Ms. who have a spouse constituent in DART so that their title can be updated to Mrs.. This change is only done if the constituent has the same last name as their spouse or if their name contains their spouse's last name (i.e., is hyphenated). Constituents who have a constituent documentation note with a title of “Title” and content like “Constituent confirmed%” are excluded from this integrity check.

Examples:

• Miss VanElls married to Barnebee -> No Change (last name does not match)

• Ms. VanElls-Barnebee married to Barnebee -> Change to Mrs.

• Ms. Barnebee married to Barnebee -> Change to Mrs.

• Mx. VanElls-Barnebee married to Barnebee -> No Change (current title isn’t Miss or Ms.)

The output of this integrity check is a batch of title updates. Additionally, a Constituent Documentation Note is added to the constituent’s record, with the following structure:

• 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: Updated title from [Miss/Ms.] because constituent has a spouse in DART with [same/hyphenated] last name”