This global change takes the results of a stored procedure in the data warehouse and adds or updates model score ratings.
This will typically be set up by MGB staff or affiliate admins.
The rating/score procedure is expected to return a data set with the following columns:
- CONSTITUENTID uniqueidentifer– constituent the rating/score will be applied to.
- RATINGDESCRIPTION nvarchar(100) – text description of the rating value for the constituent.
- RATINGCOMMENT nvarchar(500) – text description for rating’s “comment” field.