Create or update a scoring segment for a scoring engine.
| Term | Definition |
|---|---|
| View Name | The name of the database view used to limit the data to be scored. View names must begin with IEX_F_and end in _V. |
| Column Name | A column in the database view that stores the ID key for the object being scored. |
A segment enables the scoring engine to look at a segment or view of the database. Segments limit the scope of a scoring engine and improve system performance.
Does every scoring engine have to have a segment?Yes. You must create a segment for a scoring engine.
Are there any prerequisites?A scoring engine must exist.
Your database administrator must create a database view if existing views are not appropriate.
Who can create a segment?The Collections Administrator can create new segments.
Are there any guidelines?The view name must begin with IEX_F_ and end with _V. The view must be created in the APPS schema (the Database owner of the object must be = 'APPS').
The data type of the column name must be a number.
The view must have a column for the ID of the object being scored as shown in the following table:
| Object Being Scored | Object ID |
|---|---|
| Customer | Party_ID |
| Account | Cust_Account_ID |
| Site | Site_Use_ID |
| Invoice | Payment_Schedule_ID |
| Delinquency | Delinquency_ID |
| Case | Case_ID |
Yes. Advanced Collections provides the following seeded views:
IEX_F_ACCOUNTS_V - Used to score customer accounts
IEX_F_BILLTO_V - Used to score based on customer bill-to information
IEX_F_CASES_V - Used for Leasing
IEX_F_DEL_CASES_V - Used for Leasing
IEX_F_PARTIES_V - Use to score customer/party
IEX_F_SCORE_INVOICES_V - Used to score payment schedules and determine if they are delinquent
IEX_F_PARTIES_GRP - Used to score only parent parties to be used as a segment filter for new scoring engine. And reform the 'IEX_F_PARTIES' view to exclude parent party to avoid duplication.
Click Test to test the scoring engine with your new segment. Advanced Collections displays the number of records the scoring engine will score using this segment.