8       Report Submission

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

Report Submission: AgileREPORTER to Regulator

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.

Edit Checks or Validity Check or Quality Checks

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 

Executing Edit Check Batch for AnaCredit CBM

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

This illustration shows the Edit check AnaCredit CBM batch execution navigation steps. Starting from FSDF, then Operations, then Batch Execution and then the Batch Infodom.

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

This illustration shows the Edit check AnaCredit CBM batch execution navigation steps. Starting from FSDF, then Operations and then the Batch Monitor .

Executing Edit Check Batch for AnaCredit ECB

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

This illustration shows the Edit check AnaCredit ECB batch execution navigation steps. Starting from FSDF, then Operations, then Batch Execution and then the Batch Infodom.

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

This illustration shows the Edit check AnaCredit ECB batch execution navigation steps. Starting from FSDF, then Operations and then the Batch Monitor .

Edit Check Validation Results

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

This illustration shows the AnaCredit CBM Edit Check Summary page for the batches executed for AnaCredit CBM.

2.     DQ_RESULT_SUMM_MASTER: Detailed results

Figure 143: Detailed Results Screen

This illustration shows the AnaCredit Data Quality Detailed Results page for the batches executed for AnaCredit account.

3.     DQ_AUDIT_TRAIL: Record level details

Figure 144: Record Level Details Screen

This illustration shows the AnaCredit Data Quality Record Level Details page for the batches executed for AnaCredit account.

Report Templates to be used in AgileREPORTER

The report templates to be used in AgileREPORTER are listed in the following table.

Table 20: Report Templates for AgileREPORTER

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

Supported Report Template Version and Activation Date

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

This illustration shows the AgileREPORTER Entity Setup which enables you to add, modify and delete entities.

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

This illustration shows the AgileREPORTER Entity Setup for an entity to access report template based on the version and the activation date and assign the necessary privilege.