AScorecst score trend updateSP
| Initial Build | 2011.01 |
| Module | A Score |
| Current Setting Type | Stored Procedure |
This system option allows for running a custom version of the base co_customer_cst_score_trend_update SP if you want to create a a custom scoring trend.
The default for this option is empty.
Creating Your own Custom SP
If you create your own SP for this purpose, it must include the following parameters:
-
@sca_key (av_key). The Scale. Must exist in co_ascore_scale.
-
@cst_key (av_key). Customer Key. Must be nullable.
Ultimately, this SP must set co_customer.cst_score_trend for the given scale (which will always be the primary scale), and for a single customer or all customers.
The cst_score_trend column is an integer and should be -3, -2, -1, 1, 2, or 3. Based on these values, a scoring trend arrow (upward or downward) will appear near the customer's score.
Note: The co_customer_set_cst_ascore SP must be altered to call the custom SP.
Current Setting
The current setting for FundRaisingSummaryUpdateCustomSP is used as follows:
Values: This system option can call a custom version of the base co_ascore_history_set_normalized_score stored procedure (SP).
Default Value: empty
Fields
This system option includes the following fields:
Description: This field gives the description of the system option, including its use and default value.
Important! Do not modify the following fields after the system option is first created. Changing these fields after they have been used can invalidate existing data.
Category: This field sets the category (usually the module) where the system option is used.
Type: The Type field determines the display type of the Current setting field (check box, drop-down list, or text box).
Values: The values field indicates the allowed values for the Current setting field.
Availability
Each system option includes the following availability settings:
Entity Level Option?: Select this check box to make this system option available on an entity level.
Visible To External Systems?: Select this check box to make this system option available in xWeb.