Search110 Results
- Knowledge Base
- DART Data Updates
- Integrity Checks
- Phone
This integrity check identifies phone records on constituents that have both (1) a phone number that is marked as primary but is invalid (i.e., has a Do Not Call flag), and (2) a valid home or cell phone number so that the valid phone number can be made into the primary and the old primary phone can be end-dated and marked as Do Not Call.
- Knowledge Base
- DART Data Updates
- Integrity Checks
- Address
This integrity check identifies address records on constituents that have both (1) an address that is marked as primary but is invalid (i.e., has a Do Not Mail flag), and (2) a valid home address so that the valid address can be made into the primary and the old primary address can be end-dated and marked as Do Not Mail.
- Knowledge Base
- DART Data Updates
- Integrity Checks
- Constituent
- Identity
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..
- Knowledge Base
- DART Data Updates
- Integrity Checks
- Address
This integrity check identifies duplicate addresses on a constituent’s record so that the duplicated record(s) can be inactivated.
- Knowledge Base
- DART Data Updates
- Integrity Checks
- Constituent
- Identity
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.
- Knowledge Base
- DART Data Updates
- Integrity Checks
- Education
This integrity check identifies Rackham Graduate School and Marsal Family School of Education PhD in Education & Psychology alumni missing either a Rackham or Marsal alumni affiliation so that the missing alumni affiliation attribute can be added.
- Knowledge Base
- DART Data Updates
- Integrity Checks
- Education
This integrity check identifies Rackham Graduate School and Marsal Family School of Education PhD in English and Education alumni missing either a Rackham or Marsal alumni affiliation so that the missing alumni affiliation attribute can be added.
- Knowledge Base
- DART Data Updates
- Integrity Checks
- Education
This integrity check identifies graduated UM education history records that do not have any alumni affiliation attributes so that an alumni affiliation attribute can be added that corresponds with the educational college.
- Knowledge Base
- DART Data Updates
- Integrity Checks
- Email
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.
- Knowledge Base
- DART Data Updates
- Integrity Checks
- Constituent
This integrity check identifies possible duplicate constituents that have the same first name, the same middle initial (if a middle name exists), and the same last name or last names that are substrings of one another with at least one piece of shared contact information so that the two records can be reviewed by GRA and either (1) merged if they are determined to be duplicates or (2) marked as not duplicates or unable to confirm as duplicates.
- Knowledge Base
- DART Data Updates
- Integrity Checks
- Address
This integrity check identifies active address records where the zip code and state combination do not align with USPS so that the address can be re-validated and corrected.
- Knowledge Base
- DART Data Updates
- Integrity Checks
- Social Media
This integrity check identifies LinkedIn social media records that are not in the standard format (
https://www.linkedin.com/my-url-details/) or contain extra information in the URL so that they can be updated to the standard format and the extraneous information at the end of the URL can be removed.
- Knowledge Base
- DART Data Updates
- Integrity Checks
- Social Media
This integrity check identifies constituents that have multiple different LinkedIn social media records so that PDA can review if all URLs are active and relevant.
- Knowledge Base
- DART Data Updates
- Integrity Checks
- Social Media
This integrity check identifies LinkedIn social media records that appear multiple times on a constituent’s record so that duplicated records can be deleted.
- Knowledge Base
- DART Data Updates
- Integrity Checks
- Social Media
This integrity check identifies LinkedIn social media records that are missing a type so that the Personal type can be added.