This integrity check identifies email records with an end date but not a Do Not Email flag so that the DNE flag can be added.
This integrity check identifies non-primary email records with a Do Not Email flag that are missing an end date so that the end date can be updated to the date that the email record was last modified.
This integrity check identifies email records without a start date so that the start date can be filled in with the date that the record was added to DART.
This integrity check identifies active email address records that do not have a type so that the default type value “E-mail Address” can be added.
This integrity check identifies constituents without a primary email address but with valid email addresses in DART so that one of those email addresses can be made the constituent’s primary email.
This integrity check identifies duplicate email addresses on a constituent’s record so that the duplicated record(s) can be inactivated and invalidated.
This integrity check identifies email address records where the email address is blank so that they can be deleted.
This integrity check identifies email address records on household constituent records so that they can be deleted.
This integrity check identifies active email address records containing “.com.com”, “.gov.gov”, “.edu.edu”, “.net.net”, “.org.org” so that the repeated domain extension can be removed.
This integrity check identifies email address records that do not contain an “@” so that they can be given a Do Not Email flag and end-dated (inactivated).
This integrity check identifies constituents with multiple valid @umich.edu emails so that they can be reviewed for correctness, and any incorrect emails can be inactivated and marked as not belonging to that constituent.
This integrity check identifies email records on constituents that have both (1) an email that is marked as primary but is invalid (i.e., has a Do Not Email flag), and (2) a valid email address so that the valid email can be made into the primary and the old primary email can be end-dated and marked as Do Not Email.
This integrity check identifies when the last email validation is inconsistent with the most recent email attribute so that the email can be revalidated and a corresponding validation attribute is created.
This integrity check identifies email addresses ending in @umich.edu where the type is not Mich E-mail Address so that the type can be corrected.