T_LN_E

This transformation rule creates the loans for the enriched input layer.

Scheme dependencies:

Transformation Scheme ID

T_LN_E

Description

Loans enriched input layer.

Classification

Phase Type Subtype Related entity
Enrichment Technical Other LN_E

Natural language

This transformation rule creates the loans for the enriched input layer.

Scheme dependencies:

VTL Syntax

0 LN_E := LN [keep (INSTRMNT_UNQ_ID, ACCMLTD_CHNGS_FV_CR, ACCMLTD_IMPRMNT, ACCMLTD_WRTFFS, ACCNTNG_CLSSFCTN, ACCRD_INTRST, ANNLSD_AGRD_RT, APPRCH_CRDT_QLTY_STTS, ARRRS, CMLTV_RCVRS_SNC_DFLT, CMMTMNT_INCPTN, CNNCTD_FCTRNG_ID, CNTRCT_ID, CRDT_QLTY_STTS, CRRNCY_DNMNTN, DT_DFLT_STTS, DT_END_INTRST_ONLY, DT_FRBRNC_STTS, DT_INCPTN, DT_LGL_FNL_MTRTY, DT_NXT_INTRST_RT_RST, DT_PRFRMNG_STTS, DT_PST_D, DT_STTLMNT, FDCRY, FRBRNC_STTS, FV, FV_CHNG_CR_BFR_PRCHS, FV_CHNG_HDG_ACCNTNG, GRSS_CRRYNG_AMNT_E_INTRST, IMPRMNT_ASSSSMNT_MTHD, IMPRMNT_STTS, INSTRMNT_ID, INTRST_RT_CP, INTRST_RT_FLR, INTRST_RT_RST_FRQNCY, INTRST_RT_SPRD, IS_CRDT_LN_OTHR_RV_CRDT, IS_DBT_FNNCNG, IS_RTL_EXPSR, IS_RVLVNG_LN, IS_SRVCD_OBSRVD_AGNT, OBSRVD_AGNT_INTRNL_ID, OFF_BLNC_SHT_AMNT, OTSTNDNG_NMNL_AMNT, PRCNTG_TRNSFRRD, PRDNTL_PRTFL, PRJCT_FNNC_LN, PRPS, PRVSNS_OFF_BLNC_SHT, PYMNT_FRQNCY, RCRS, RFRNC_RT, RLTNSHP_SCRTSTN_CRDT_TRNSFR, RPYMNT_RGHTS, SBRDNTD_DBT, SCRTSTN_TRNSFR_ID, SRC_ENCMBRNC, SYNDCTD_CNTRCT_ID, TYP_AMRTSTN, TYP_INSTRMNT, TYP_INTRST_RT)];
1 LN_E := [inner LN_E as "A", D_CRRYNG_AMNT1 as "B" on A.INSTRMNT_UNQ_ID = B.INSTRMNT_UNQ_ID] {keep (A.ALL_VARIABLES, B.CRRYNG_AMNT)};
2 LN_E := LN [keep (INSTRMNT_UNQ_ID, ACCMLTD_CHNGS_FV_CR, ACCMLTD_IMPRMNT, ACCMLTD_WRTFFS, ACCNTNG_CLSSFCTN, ACCRD_INTRST, ANNLSD_AGRD_RT, APPRCH_CRDT_QLTY_STTS, ARRRS, CMLTV_RCVRS_SNC_DFLT, CMMTMNT_INCPTN, CNNCTD_FCTRNG_ID, CNTRCT_ID, CRDT_QLTY_STTS, CRRNCY_DNMNTN, CRRYNG_AMNT, DT_DFLT_STTS, DT_END_INTRST_ONLY, DT_FRBRNC_STTS, DT_INCPTN, DT_LGL_FNL_MTRTY, DT_NXT_INTRST_RT_RST, DT_PRFRMNG_STTS, DT_PST_D, DT_STTLMNT, FDCRY, FRBRNC_STTS, FV, FV_CHNG_CR_BFR_PRCHS, FV_CHNG_HDG_ACCNTNG, GRSS_CRRYNG_AMNT_E_INTRST, IMPRMNT_ASSSSMNT_MTHD, IMPRMNT_STTS, INSTRMNT_ID, INTRST_RT_CP, INTRST_RT_FLR, INTRST_RT_RST_FRQNCY, INTRST_RT_SPRD, IS_CRDT_LN_OTHR_RV_CRDT, IS_DBT_FNNCNG, IS_RTL_EXPSR, IS_RVLVNG_LN, IS_SRVCD_OBSRVD_AGNT, OBSRVD_AGNT_INTRNL_ID, OFF_BLNC_SHT_AMNT, OTSTNDNG_NMNL_AMNT, PRCNTG_TRNSFRRD, PRDNTL_PRTFL, PRJCT_FNNC_LN, PRPS, PRVSNS_OFF_BLNC_SHT, PYMNT_FRQNCY, RCRS, RFRNC_RT, RLTNSHP_SCRTSTN_CRDT_TRNSFR, RPYMNT_RGHTS, SBRDNTD_DBT, SCRTSTN_TRNSFR_ID, SRC_ENCMBRNC, SYNDCTD_CNTRCT_ID, TYP_AMRTSTN, TYP_INSTRMNT, TYP_INTRST_RT)];