13.4.3 Create a Regulatory Reporting based Data Adjustment

To create a data adjustment for the action type Data Adjustments - Regulatory Reporting, follow these steps:

Note:

You can create a data adjustment for a regulatory reporting-based adjustment, only if the actions are in a new status.

1. From the Issues & Actions page, under an action created, click View More.
2. In the Data Adjustment page, click Create.

   The Adjustments Rule Details window is displayed.

3. In the Adjustment Rule Details window, enter values in the Name and Description fields.

   Figure 13-7 Adjustment Rule Details

   
   

   

   
   
4. Select the Assignment Type as either User Input or Rule Driven.
5. For User Input:
   1. In the Select Report section, in the Report and Schedule drop-downs, select the required report and schedule.
   2. Click Next.
   3. In the Data Update section, select Add Line Item.
   4. In the Add Line Item window, in the Line Item drop-down, select a value, and then click OK.
   5. Click Next, and then click Save.
   6. In the Manual Data section, select Export.
   7. In the Export window, in the MIS Date section, select the date for which the assessment has been performed, and then click Export.
   8. Save the Excel file to your system.
   9. Enter the adjustment amount in the column N_ADJUSTED_AMT, and then save the Excel.
   10. In the Manual Data section, in the Id column, select the required ID and then click Import.
   11. In the Import window, attach the Excel that you added data to, and then click Upload.
   12. Click Import.
   13. In the Manual Data section, in the Id column, select the required ID.
   14. Click Submit if you want to send the Data Adjustment for approval or click Save.
6. For Rule Driven:
   1. To go to the next section, click Next or click Dataset.
   2. In the Adjustment Entity, Report, Schedule, and Dataset drop-down boxes select a value.
   3. Click Next.
   4. Click Add Expression.
   5. In the Add Expression window, enter values in the following fields:

      Table 13-6 Add Expression Fields

      Field	Description
      Line Item	Select a value from the drop-down box.
      Expression Type	Select either Business Processor or Build Expression.
      Build Processor	Select a value from the drop-down box. This field is only available if you selected the Expression type as Build Expression.
      Measure	Select a value from the drop-down box. This field is only available if you selected the Expression type as Business Processor.
      Business Processor	Select a value from the drop-down box. This field is only available if you selected the Expression type as Business Processor.
      Aggregate	Select a value from the drop-down box. This field is only available if you selected the Expression type as Business Processor.
      Comparison	Select a value from the drop-down box. This field is only available if you selected the Expression type as Business Processor.
      Logical Operators	Select a value from the drop-down box. This field is only available if you selected the Expression type as Business Processor.
      Others	Select a value from the drop-down box. This field is only available if you selected the Expression type as Business Processor.
      Date and Time	Select a value from the drop-down box. This field is only available if you selected the Expression type as Business Processor.
      Mathematical	Select a value from the drop-down box. This field is only available if you selected the Expression type as Business Processor.
      Others	Select a value from the drop-down box. This field is only available if you selected the Expression type as Business Processor.
      String	Select a value from the drop-down box. This field is only available if you selected the Expression type as Business Processor.
      Mathematical operators	Select a value from the drop-down box. This field is only available if you selected the Expression type as Business Processor.
      Concatenation	Select a value from the drop-down box. This field is only available if you selected the Expression type as Business Processor.
      Expression	Enter an expression.

7. Click OK and then click Next.
8. In the Review and Save section, click Save.

   The Data Adjustment for the action is created.