Create a Scoring Formula
This examples shows you how to create a scoring formula.
Create a simple scoring formula based on the following data points:
-
Account Level Delinquency Count
-
Accounted Amount of Delinquencies
Create a Scoring Formula
Navigation: Setup and Maintenance > All Tasks > Define Collections > Manage Collections Scoring > Go to Task icon > Manage Scoring Formulas
-
From the Manage Scoring Formulas page, click Create icon.
-
Enter the following information using the subsequent table:
Field
Value
Name: Required
Simple Scoring Formula
Type: Required
Account: Determines the type of data points can be added to the formula.
Description: Optional
Number and Amount of Delinquencies.
From Score: Required
1: The lowest possible score the formula calculates.
To Score: Required
100: The highest score the formula calculates.
Enabled: Activates the formula
Check
-
From the Data Points sections, you add data points to the formula. Each data point must be mapped across the high and low range of the Scoring Formula.
-
Click Add Row icon.
-
In the Name field search for Account Level Delinquency Count data point.
-
Highlight the data point and click OK.
-
Enter a value of 1 in the weight field.
-
Enter the following information in the Data Point Details section populating 4 rows using the subsequent table:
From Range
to Range
Value
0
10
100
11
50
75
51
100
50
101
999,999,999
1
-
Click Save.
-
Click Add Row icon.
-
In the Name field search for Accounted Amount of Delinquencies data point.
-
Highlight the data point and click OK.
-
Enter the following information in the Data Point Details section populating 4 rows using the subsequent table:
From Range
to Range
Value
0
5,000.00
100
5,000.01
25,000.00
75
25,000.01
50,000.00
50
50,000.01
999,999,999.00
1
-
Adjust the weights of the 2 data points using the following table:
Data Point
Weight
Account Level Delinquency Count
0.25
Accounted Amount of Delinquencies
0.75
Total
1.00
-
Click Save button.
-
Click Next button. Enter the following information in the Scoring Formula Segment page using the subsequent table:
Segment
Value
View Name Select the grouping for the customers, accounts, sites, or transaction that applies to the scoring formula.
IEX_F_ACCOUNTS_V
Identifier Select the unique attribute identifying each customer, account, site or transaction.
CUST_ACCOUNT_ID
-
Click Next button.
-
Click Save button.
-
Move to the Scoring Formula Review page.
-
In the Sample Score section, test your formula using the information in the subsequent table:
Field
Value
Account Number: Select an account that has delinquent or current transactions.
Valid account number
Business Unit: Select a business unit that contains those transactions.
Valid business unit
-
Click Score button.
Scoring Formula Results
The following are displayed in the Data Points table:
-
Component Score: the actual number of delinquencies and total amount of delinquencies for the test account.
-
Mapped Component Score: how that number translates to each data point detail.
-
Weighted Score: the Mapped Component Score multiplied by the data point weight.
The total score displays the sum of the weighted scores for all data points. This is the score assigned to the account.
Applying the Formula
Your formula is now activated and you want to apply it by submitting the Collections Scoring as Job program.
Navigation: Navigator > Scheduled Process > Collections Scoring as Job
-
Click Schedule New Process button.
-
Select from the list of values: Collections Scoring as Job.
-
Enter the Parameters according to the subsequent table:
Parameter
Value
Business Unit: Required
Select a business unit that contains the account.
Scoring Formula: Required
Simple Scoring Formula
-
Click Submit button.
-
Verify by navigating to the Collections Work Area. Query for the customer, account, or bill-to site and review. The score appears in the Customer Hierarchy task pane.