7.1.1 Load Maintenance Detail - Criteria Button

This topic explains the Criteria button of the Load Maintenanace Detail screen.

1. Click Criteria button to specify criteria for criteria-based loads.
   The criteria could be based on the parameters given.
   The Query Information screen is displayed.

   Figure 7-2 Load Maintenance Detail_Criteria Button

   
   

   
   Description of "Figure 7-2 Load Maintenance Detail_Criteria Button"

   
   
2. Select one from the list box and select an Operator like (=, >, <) and enter the value you want to assign.
   The system will validate the specified criteria and the load will be applied only on successful validation of the same.
3. On Query Information screen, specify the required criteria fields.
   For more information on fields, refer to the field description table.

   Table 7-2 Query Information - Field Description

   Field	Description
   Query Information	The section displays the following fields.
   Tables	Alphanumeric; 35 Characters; Optional Specify table details to query.
   Distinct	Optional Check this box for distinct query.
   Fields	Display The system displays the fields value.
   Order By field	Display The system displays the order by field value.
   Order By	Optional Select order by option by selecting one of the following options: Ascending Order Descending Order
   Detail	The section displays the following fields.
   Add Table	Click Add Table button to add the table information inside Tables field.
   Delete Table	Click Delete Table button to delete the table information inside Tables field.
   Add Field	Click Add Field button to add the field information inside Fields field.
   Delete Field	Click Delete Field button to delete the field information inside Fields field.
   Add Order By	Click Add Order By button to add the field information inside Fields field.
   Delete Order By	Click Delete Order By button to delete the field information inside Fields field.
   Join Tables	Click Join Tables button to join the 2 tables.
   Group By	Click Group By button to group the tables.

4. Click the Parameters button to input the following details
   The Parameters screen is displayed.

   Figure 7-3 Load Maintenance Detail_Criteria_Parameters

   
   

   
   Description of "Figure 7-3 Load Maintenance Detail_Criteria_Parameters"

   
   
5. On Parameters screen, specify the required criteria fields.
   For more information on fields, refer to the field description table.

   Table 7-3 Parameter - Field Description

   Field	Description
   Parameter Name	Optional Select the name of the parameter from the drop-down list. The list displays the following options: Fund ID Unit Holder ID Load ID Transaction Type Transaction Date Transaction Amount Transaction Units MOP To Unit Holder ID To Fund ID Broker Code Parent Broker Code Agent Code Branch From Date To Date
   ADD	Click ADD button to add the required parameters details to parameters field after selecting the required parameters name.
   Delete	Click Delete button to delete the added parameters by selecting the same if required.

6. Click the Where Criteria button to enter the query details.
   The Query Criteria screen is displayed.

   Figure 7-4 Load Maintenance Detail_Criteria_Where Criteria

   
   

   
   Description of "Figure 7-4 Load Maintenance Detail_Criteria_Where Criteria"

   
   
7. On Query Criteria screen, specify the required criteria fields.
   For more information on fields, refer to the field description table.

   Table 7-4 Query Criteria - Field Description

   Field	Description
   Field For Criteria	Alphanumeric; 50 Characters; Optional Specify the field for criteria.
   Operator	Optional Select operator details from the drop-down list. The list displays the following values: = <> <= < >= > Like Not Like
   Values To Be Used	Alphanumeric; 1 Character; Optional Specify the values to be used.
   Parameter	Optional Select the parameter details.
   Enter Values	Alphanumeric; 6 Characters; Optional Specify the values to be entered to query Click one of the following expressions button to add it in the Query Criteria field: ( And Or Not )
   Clear	Click Clear button to clear the specified details.

8. Click the Show Details button to view the criteria entered.
9. Use the following table.
   Requirement for fee based on communication mode and /or investor account classification / category will be handled via criteria based load in Load Maintenance using the following table.

   Table 7-5 Criteria based load

   Table Name to be used in criteria	Column Name to be used in ‘Where’ clause
   TRANSACTIONDETAILS	TRANSACTIONDETAILS.COMMUNICATIONMODE
   INVESTOR	NVESTOR.UNITHOLDERCATEGORY

10. You need to maintain criteria based load to apply short trade penalty for the applicable outflow transactions.
    • Following are the 2 separate loads to be used for short trade period transactions and transactions with short trade units:
      • For Short Trade Period, select the following options:
      • In Mode field, select Period
      • In Period Basis field, select Days
      • In Criteria field, specify the transaction details table and short trade units column., i.e., for short trade period, specify where TRANSACTIONDETAILS.SHORTTRADEUNITS = 0
    • For Short Trade Units, select the following options:
      • In Mode field, select Date
      • In Criteria field, specify the transaction details table and short trade units column, i.e., for short trade units, specify where TRANSACTIONDETAILS.SHORTTRADEUNITS <> 0

• Load Details
  This topic provides information on Load Details.