This custom Partners global change is used to compare and update spouse ratings so they stay consistent. have found it useful to have the ratings on both spouse records. It can happen that spouses should have different ratings, but it is very rare and most likely it is a case of the rating service missing some key asset because it is only in one spouse’s name or something along those lines.
- If a constituent has a rating, and their spouse does not have a rating with the same model score/rating name, then add the rating to the spouse.
- Spouse is a living constituent sharing a household
- Rating information includes all rating data including comments
When both constituents have an existing “Score”, the following logic is used to determine which score attribute “wins”:
- Most recent date takes precedence
- Sequence order in the code table (higher value takes precedence)