# Transformation Scheme ID

D_IMPLCT_CRDT_CRD_DBT_CNVNNC_CRDT

# Description

Derivation of the variables with implict value for “Credit card debt: convenience credit”

# Classification

Phase | Type | Subtype | Related entity |
---|---|---|---|

Preparation | Derivation | Implicit | LN |

# Natural language

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)

**Scheme dependencies:**

# VTL Syntax

0 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT [calc 0 as "ANNLSD_AGRD_RT"]; |

1 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc null as "CNNCTD_FCTRNG_ID"]; |

2 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc "0" as "IS_CRDT_LN_OTHR_RV_CRDT"]; |

3 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc null as "DT_END_INTRST_ONLY"]; |

4 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc null as "DT_NXT_INTRST_RT_RST"]; |

5 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc null as "INTRST_RT_CP"]; |

6 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc null as "INTRST_RT_FLR"]; |

7 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc null as "INTRST_RT_RST_FRQNCY"]; |

8 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc null as "INTRST_RT_SPRD"]; |

9 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc () as "PRPS"]; |

10 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc "4" as "PYMNT_FRQNCY"]; |

11 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc "0" as "RFRNC_RT"]; |

12 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc "2" as "RPYMNT_RGHTS"]; |

13 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc "0" as "IS_RVLVNG_LN"]; |

14 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc "2" as "SBRDNTD_DBT"]; |

15 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc null as "SYNDCTD_CNTRCT_ID"]; |

16 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc "4" as "TYP_AMRTSTN"]; |

17 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc "0" as "TYP_INTRST_RT"]; |

18 | CRDT_CRD_DBT_CNVNNC_CRDT_E := CRDT_CRD_DBT_CNVNNC_CRDT_E [calc "40" as "TYP_INSTRMNT"]; |