2.6.2 Selection Criteria
The sub tab is enabled only for Target Parameters and facilitates to define the
selection criteria indicating the type of accounts to be picked for computation. The
parameters are derived from user defined table - USER DEFINED: ACCOUNT CRITERIA TYPE
CODE and USER DEFINED: COLLATERAL TYPE CODE as per Account and Collateral Entity
type.
- In the Selection Criteria section, perform any of the Basic Operations mentioned in Navigation chapter.
Note:
Although system allows to define customized selection criteria, the execution of additional selection criteria requires additional processing at server level and can have significant performance impact delaying the EOD processing/web services. Hence it is recommended to have careful consideration while defining the additional selection criteria (like using user-defined tables and columns) and/or get approval from your database administrator before using any selection criteria.Table 2-19 Selection Criteria
Field Do this Seq Specify sequence numbers. ( Specify left bracket. Parameter Select the parameter from the drop-down list. The list is populated based on the values maintained in user defined table - Customer Service: USER DEFINED: CUSTOMER SERVICE CRITERIA PARAMETERS. Comparison Operator Select comparison operator from the drop-down list. Criteria Value Specify criteria value. ) Specify right bracket. Logical Expression Select logical operator from the drop-down list. Enabled Check this box to enable the selection criteria. - Perform any of the Basic Actions mentioned in Navigation chapter.
- Click Check Criteria for system to validate the query and display the results.
If the formula expression is mathematically incorrect when parameters are calculated, system displays error indicating ‘INVALID FORMULA EXPRESSION: <<FORMULA PARMETER>>’.
Parent topic: User Defined Parameters