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:

1. Account Level Delinquency Count

2. Accounted Amount of Delinquencies

Note: If these don't exist, you must create them first before creating a scoring formula.

Create a Scoring Formula

Navigation: Setup and Maintenance > All Tasks > Define Collections > Manage Collections Scoring > Go to Task icon > Manage Scoring Formulas

1. From the Manage Scoring Formulas page, click Create icon.

2. 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

3. 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.

4. Click Add Row icon.

5. In the Name field search for Account Level Delinquency Count data point.

6. Highlight the data point and click OK.

7. Enter a value of 1 in the weight field.

8. 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

9. Click Save.

10. Click Add Row icon.

11. In the Name field search for Accounted Amount of Delinquencies data point.

12. Highlight the data point and click OK.

13. 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

14. 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

15. Click Save button.

16. 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

17. Click Next button.

18. Click Save button.

19. Move to the Scoring Formula Review page.

20. 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

21. Click Score button.

Scoring Formula Results

The following are displayed in the Data Points table:

1. Component Score: the actual number of delinquencies and total amount of delinquencies for the test account.

2. Mapped Component Score: how that number translates to each data point detail.

3. 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

1. Click Schedule New Process button.

2. Select from the list of values: Collections Scoring as Job.

3. 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

4. Click Submit button.

5. 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.