This global change takes the results of a stored procedure in the data warehouse and adds or updates model score ratings. IMPORTANT NOTE: THE MODEL SCORE/RATING MUST BE SET UP IN ATLAS AND MOVED TO THE DW IN THE ETL IN ORDER FOR THE STORED PROCEDURE TO WORK!
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.