This chapter provides an understanding of the report submission process.
Topics:
· Report Submission: AgileREPORTER to Regulator
· Edit Checks or Validity Check or Quality Checks
· Report Templates to be used in AgileREPORTER
· Supported Report Template Version and Activation Date
After OFSAA has prepared and hands off the data as required to Lombard Risk, the subsequent activities are performed within the AgileREPORTER.
Lombard takes care of the report format as per the regulatory requirement which may be eXtensible Business Reporting Language (XBRL), XML, Excel, Data, and so on.
The OFSAA UI carries out the report level or submission check comprising Edit Checks or Validity Checks, or Quality Checks as provided by the regulator.
Topics:
· Executing Edit Check Batch for AnaCredit CBM
· Executing Edit Check Batch for AnaCredit ECB
· Edit Check Validation Results
To execute the edit check batch for AnaCredit CBM, perform the following steps:
1. Navigate to Financial Services Data Foundation, select Operations, and then select Batch Execution.
2. Select the batch <<INFODOM>>_ANACREDIT_EDIT_CHECK_CBM to execute all the tasks in CBM.
Figure 138: Edit Check (ANACREDIT CBM) Batch Execution Screen
3. Monitor the status of the batch using the Batch Monitor (Navigate to Financial Services Data Foundation select Operations and then select Batch Monitor).
Figure 139: Edit Check (ANACREDIT CBM) Batch Monitor Screen
To execute the edit check batch for AnaCredit ECB, perform the following steps:
1. Navigate to Financial Services Data Foundation, select Operations, and then select Batch Execution.
2. Select the batch <<INFODOM>>_ANACREDIT_EDIT_CHECK_ECB to execute all the tasks in ECB.
Figure 140: Edit Check (ANACREDIT ECB) Batch Execution Screen
3. Monitor the status of the batch using the Batch Monitor (Navigate to Financial Services Data Foundation, select Operations, and then select Batch Monitor).
Figure 141: Edit Check (ANACREDIT ECB) Batch Monitor Screen
The Edit Check Validation results will be available in the following tables under the Atomic Schema after the batches are successfully executed:
1. FSI_EDIT_CHECK_SUMMARY: Summary results
Figure 142: Summary Results Screen
2. DQ_RESULT_SUMM_MASTER: Detailed results
Figure 143: Detailed Results Screen
3. DQ_AUDIT_TRAIL: Record level details
Figure 144: Record Level Details Screen
The report templates to be used in AgileREPORTER are listed in the following table.
Report or Schedule Name |
Report Template |
---|---|
CA1P1 |
CAR_v11 |
CA1P2 |
CAR_v11 |
CA1P3 |
CAR_v11 |
CA2P1 |
CAR_v11 |
CA2P2 |
CAR_v11 |
CA3P1 |
CAR_v11 |
CA4P1 |
CAR_v11 |
CA4P2 |
CAR_v11 |
CA4P3 |
CAR_v11 |
CA4P4 |
CAR_v11 |
CA5P1 |
CAR_v11 |
CA5P2 |
CAR_v11 |
CA5P3 |
CAR_v11 |
CA5P4 |
CAR_v11 |
CA5P5 |
CAR_v11 |
Page1 |
CRGB_v10 |
Page1 |
CRSA_v9 |
Page2 |
CRSA_v9 |
Page3 |
CRSA_v9 |
Page4 |
CRSA_v9 |
Page5 |
CRSA_v9 |
Page6 |
CRSA_v9 |
FI01 |
FI01_v2 |
FI0101 |
FI01_v2 |
FI0102 |
FI01_v2 |
FI0103 |
FI01_v2 |
FI0200 |
FI02_v4 |
FI0300 |
FI03_v2 |
FI0401 |
FI04_v3 |
FI040201 |
FI04_v3 |
FI040202 |
FI04_v3 |
FI040301 |
FI04_v3 |
FI040401 |
FI04_v3 |
FI0405 |
FI04_v3 |
FI0501 |
FI05_v2 |
FI0601 |
FI06_v3 |
FI07 |
FI07_v3 |
FI0701 |
FI07_v3 |
FI0801 |
FI08_v3 |
FI0802 |
FI08_v3 |
FI090101 |
FI09_v2 |
FI0902 |
FI09_v2 |
FI1000 |
FI10_v2 |
FI1101 |
FI11_v2 |
FI1103 |
FI11_v2 |
FI1104 |
FI11_v2 |
FI1201 |
FI12_v4 |
FI1202 |
FI12_v4 |
FI1301 |
FI13_v3 |
FI1302 |
FI13_v3 |
FI1303 |
FI13_v3 |
FI1400 |
FI14_v2 |
FI1500 |
FI15_v2 |
FI1601 |
FI16_v5 |
FI1602 |
FI16_v5 |
FI1603 |
FI16_v5 |
FI1604 |
FI16_v5 |
FI160401 |
FI16_v5 |
FI1605 |
FI16_v5 |
FI1606 |
FI16_v5 |
FI1607 |
FI16_v5 |
FI1608 |
FI16_v5 |
FI1701 |
FI17_v2 |
FI1702 |
FI17_v2 |
FI1703 |
FI17_v2 |
FI1800 |
FI18_v3 |
FI1801 |
FI18_v3 |
FI1802 |
FI18_v3 |
FI1900 |
FI19_v3 |
FI2001 |
FI20_v4 |
FI2002 |
FI20_v4 |
FI2003 |
FI20_v4 |
FI2004 |
FI20_v4 |
FI2005 |
FI20_v4 |
FI2006 |
FI20_v4 |
FI2007 |
FI20_v4 |
FI2100 |
FI21_v1 |
FI2201 |
FI22_v2 |
FI2202 |
FI22_v2 |
FI3001 |
FI30_v2 |
FI3002 |
FI30_v2 |
FI3101 |
FI31_v2 |
FI3102 |
FI31_v2 |
FI4001 |
FI40_v3 |
FI4002 |
FI40_v3 |
FI4101 |
FI41_v2 |
FI4102 |
FI41_v2 |
FI4200 |
FI42_v1 |
FI4200 |
FI42_v2 |
FI4300 |
FI43_v2 |
FI44 |
FI44_v1 |
FI4401 |
FI44_v1 |
FI4402 |
FI44_v1 |
FI4403 |
FI44_v1 |
FI4401 |
FI44_v2 |
FI4402 |
FI44_v2 |
FI4403 |
FI44_v2 |
FI4404 |
FI44_v2 |
FI4501 |
FI45_v3 |
FI4502 |
FI45_v3 |
FI4503 |
FI45_v3 |
FI4600 |
FI46_v3 |
C72.00 |
LCR_v1 |
C73.00 |
LCR_v1 |
C74 |
LCR_v1 |
C74.00 |
LCR_v1 |
C75.00 |
LCR_v1 |
C26.00 |
LEXP_v4 |
C27.00 |
LEXP_v4 |
C28.00 |
LEXP_v4 |
C29.00 |
LEXP_v4 |
C40.00 |
LR_v5 |
C43.00 |
LR_v5 |
C44.00 |
LR_v5 |
C47.00 |
LR_v5 |
C47.00 |
LR_v5 |
LR |
LR_v4 |
Page1 |
MKEQ_v6 |
Page1 |
MKFX_v8 |
Page2 |
MKFX_v8 |
C60.00 |
NSF_v4 |
C61.00 |
NSF_v4 |
NSF |
NSF_v4 |
C17.00 |
OPRD_v2 |
OPRD |
OPRD_v2 |
Page1 |
OPRS_v1 |
Page2 |
OPRS_v1 |
CRIP |
CRIP_v2 |
C34.01 |
CCR_v1 |
C34.02 |
CCR_v1 |
C34.04 |
CCR_v1 |
The AgileREPORTER contains the details of the Report template version and the activation date of the same. This can be accessed by selecting the Entity setup option in the Settings menu which enables you to Add, Modify, and Delete Entities.
Figure 145: AgileREPORTER Entity Setup
Click on a created Entity to access report templates according to version and the activation date, and assign the necessary privileges as required.
Figure 146: AgileREPORTER Entity Setup: ECB