Applies the datapoint ruleset for:

– [simple_tooltip content='TYP_INTRST_RT; Classification of credit exposures based on the base rate for establishing the interest rate for each payment period.']Type of interest rate[/simple_tooltip]
– [simple_tooltip content='RFRNC_RT; Reference rate used for the calculation of the actual interest rate.The Reference rate code is a combination of the reference rate value and maturity value.']Reference rate[/simple_tooltip]
to the dataset [simple_tooltip content='LN']Loan[/simple_tooltip]

Scheme dependencies:

[simple_tooltip content='Applies the datapoint ruleset for:

- Type of interest rate
- Reference rate
to the dataset Loan']V_TYP_INTRST_RT2[/simple_tooltip]
[simple_tooltip content='Creates a single dataset comprising all cubes within the "Loans" entity']T_UNN_LN[/simple_tooltip]
[simple_tooltip content='Where, for Other trade receivables:

- Connected factoring operation identifier is by default null
- Project finance loan is by default Non-project finance loan (2)
- Repayment rights is by default Other (2)
- Subordinated debt is by default Non-subordinated debt (2)
- Type of instrument is Other trade receivables (1023)']D_IMPLCT_OTHR_TRD_RCVBLS[/simple_tooltip]
[simple_tooltip content='Get Other trade receivables data']T_GT_OTHR_TRD_RCVBLS[/simple_tooltip]
[simple_tooltip content='Where Indirect factoring cube is merged with associated records from Factoring cube, keeping:

- Accounting classification
- Contract identifier
- Observed agent internal identifier
- Prudential portfolio
- Is retail exposure
- Is serviced by the observed agent
and variables inherited from associated factoring records are added back to Indirect factoring

And for the new Indirect factoring:

- Is credit line other than revolving credit is by default Not applicable (0)
- End date of the interest-only period is by default null
- Fiduciary instrument is by default Not applicable (0)
- Project finance loan is by default Non-project finance loan (2)
- Payment frequency is by default Bullet (4)
- Exposure with recourse is by default Not applicable (0)
- Repayment rights is by default Other (2)
- Is revolving loan is by default Not applicable (0)
- Subordinated debt is by default Non-subordinated debt (2)
- Syndicated contract identifier is by default null
- Type of amortisation is by default Bullet (4)
- Type of instrument is Indirect Factoring (1021)']D_IMPLCT_INDRCT_FCTRNG[/simple_tooltip]
[simple_tooltip content='Get Indirect factoring data']T_GT_INDRCT_FCTRNG[/simple_tooltip]
[simple_tooltip content='Get Factoring data']T_GT_FCTRNG[/simple_tooltip]
[simple_tooltip content='Where, for Credit card debt: extended credit:

- Connected factoring operation identifier is by default null
- Is credit line other than revolving credit is by default Not applicable (0)
- Repayment rights is by default Other (2)
- Is revolving loan is by default Not applicable (0)
- Subordinated debt is by default Non-subordinated debt (2)
- Syndicated contract identifier is by default null
- Type of instrument is Credit card debt extended credit (50)']D_IMPLCT_CRDT_CRD_DBT_EXTNDD_CRDT[/simple_tooltip]
[simple_tooltip content='Get Credit card debt: extended credit data']T_GT_CRDT_CRD_DBT_EXTNDD_CRDT[/simple_tooltip]
[simple_tooltip content='Where, for Other loans:

- Connected factoring operation identifier is by default null
- Repayment rights is by default Other (2)
- Type of instrument is Other loans (1022)']D_IMPLCT_OTHR_LNS[/simple_tooltip]
[simple_tooltip content='Get Other loans data']T_GT_OTHR_LNS[/simple_tooltip]
[simple_tooltip content='Where, for Other deposits:

- Connected factoring operation identifier is by default null
- Is credit line other than revolving credit is by default Not applicable (0)
- End date of the interest-only period is by default null
- Project finance loan is by default Non-project finance loan (2)
- if Is debt financing is TRUE (T), then Purpose is Debt financing (5)
else Purposes other than real estate purchase, margin lending, debt financing, imports, exports, construction investment, working capital facility (11)
- Is revolving loan is by default Not applicable (0)
- Syndicated contract identifier is by default null
- Type of instrument is Deposits other than reverse repurchase agreements (1000)
']D_IMPLCT_OTHR_DPSTS[/simple_tooltip]
[simple_tooltip content='Get Other deposits data']T_GT_OTHR_DPSTS[/simple_tooltip]
[simple_tooltip content='Where, for Factoring:

- Connected factoring operation identifier is by default null
- End date of the interest-only period is by default null
- Project finance loan is by default Non-project finance loan (2)
- Repayment rights is by default Other (2)
- Subordinated debt is by default Non-subordinated debt (2)
- Type of amortisation is by default Amortisation types other than French, German, Fixed amortisation schedule or bullet (5)
- Type of instrument is Factoring (1020)
']D_IMPLCT_FCTRNG[/simple_tooltip]
[simple_tooltip content='Where, for Transferable deposits:

- Connected factoring operation identifier is by default null
- Is credit line other than revolving credit is by default Not applicable (0)
- End date of the interest-only period is by default null
- Project finance loan is by default Non-project finance loan (2)
- if Is debt financing is TRUE (T), then Purpose is Debt financing (5)
else Purposes other than real estate purchase, margin lending, debt financing, imports, exports, construction investment, working capital facility (11)
- Repayment rights is by default On demand or short notice (1)
- Is revolving loan is by default Not applicable (0)
- Subordinated debt is by default Non-subordinated debt (2)
- Syndicated contract identifier is by default null
- Type of amortisation is by default Amortisation types other than French, German, Fixed amortisation schedule or bullet (5)
- Type of instrument isTransferable deposits (1025)']D_IMPLCT_TRNSFRBL_DPSTS[/simple_tooltip]
[simple_tooltip content='Get Transferable deposits data']T_GT_TRNSFRBL_DPSTS[/simple_tooltip]
[simple_tooltip content='Where, for Overdrafts:

- Connected factoring operation identifier is by default null
- Is credit line other than revolving credit is by default Not applicable (0)
- End date of the interest-only period is by default null
- Repayment rights is by default On demand or short notice (1)
- Is revolving loan is by default Not applicable (0)
- Type of instrument is Overdrafts (20)']D_IMPLCT_OVRDRFTS[/simple_tooltip]
[simple_tooltip content='Get Overdrafts data']T_GT_OVRDRFTS[/simple_tooltip]
[simple_tooltip content='Where for Credit card debt: convenience credit:

- Interest rate is by default not applicable (0)
- Connected factoring operation identifier is by default null
- Is credit line other than revolving credit is by default Not applicable (0)
- End date of the interest-only period is by default null
- Next interest rate reset date is by default null
- Interest rate cap is by default null
- Interest rate floor is by default null
- Interest rate reset frequency is by default null
- Interest rate spread / margin is by default null
- if Is debt financing is TRUE (T), then Purpose is Debt financing (5)
else Purposes other than real estate purchase, margin lending, debt financing, imports, exports, construction investment, working capital facility (11)
- Payment frequency is by default Bullet (4)
- Reference rate is by default Not applicable (0)
- Repayment rights is by default Other (2)
- Is revolving loan is by default Not applicable (0)
- Subordinated debt is by default Non-subordinated debt (2)
- Syndicated contract identifier is by default null
- Type of amortisation is by default Bullet (4)
- Type of interest rate is by default Not applicable (0)
- Type of instrument is Credit card debt convenience credit (40)']D_IMPLCT_CRDT_CRD_DBT_CNVNNC_CRDT[/simple_tooltip]
[simple_tooltip content='Get Credit card debt: convenience credit data']T_GT_CRDT_CRD_DBT_CNVNNC_CRDT[/simple_tooltip]
[simple_tooltip content='Where, for Reverse repurchase loans:

- Connected factoring operation identifier is by default null
- Is credit line other than revolving credit is by default Not applicable (0)
- End date of the interest-only period is by default null
- Project finance loan is by default Non-project finance loan (2)
- if Is debt financing is TRUE (T), then Purpose is Debt financing (5)
else Purposes other than real estate purchase, margin lending, debt financing, imports, exports, construction investment, working capital facility (11)
- Payment frequency is by default Bullet (4)
- Repayment rights is by default Other (2)
- Is revolving loan is by default Not applicable (0)
- Subordinated debt is by default Non-subordinated debt (2)
- Type of amortisation is by default Bullet (4)
- Type of instrument is Reverse repurchase agreements (1003)']D_IMPLCT_RVRS_RPRCHS_LNS[/simple_tooltip]
[simple_tooltip content='Get Reverse repurchase loans data']T_GT_RVRS_RPRCHS_LNS[/simple_tooltip]
[simple_tooltip content='Where, for Financial leases:

- Connected factoring operation identifier is by default null
- Is credit line other than revolving credit is by default Not applicable (0)
- Repayment rights is by default Other (2)
- Is revolving loan is by default Not applicable (0)
- Subordinated debt is by default Non-subordinated debt (2)
- Type of instrument is Finance leases (80)']D_IMPLCT_FNNCL_LSS[/simple_tooltip]
[simple_tooltip content='Get Financial leases data']T_GT_FNNCL_LSS[/simple_tooltip]