This chapter contains the following sections:
Header/Child |
Condition |
Formula |
Header/Child |
LMVD_DR_BAL<0 |
(LMVD_DR_BAL * RATE1*DAYS)/(YEAR*100) |
(LMVD_CR_BAL>0) AND (LMVD_CR_BAL<=10000) |
(LMVD_CR_BAL * RATE2*DAYS)/(YEAR*100) |
|
(LMVD_CR_BAL>10000) AND (LMVD_CR_BAL<=9999999) |
(LMVD_CR_BAL * RATE3*DAYS)/(YEAR*100) |
Header/Child |
Condition |
Formula |
Header |
(LMVD_CR_POOLBAL>0) AND (LMVD_CR_POOLBAL<=10000) |
(LMVD_CR_POOLBAL * RATE4*DAYS)/(YEAR*100) |
(LMVD_CR_POOLBAL>10000) AND (LMVD_CR_POOLBAL<=9999999) |
(LMVD_CR_POOLBAL * RATE5*DAYS)/(YEAR*100) |
|
LMVD_DR_POOLBAL<0 |
(LMVD_DR_POOLBAL*RATE6*DAYS)/(YEAR*100) |
|
Child |
Not Applicable |
Not Applicable |
Header/Child |
Condition |
Formula |
Header |
LMVD_CR_POOLBAL>0 |
(LMVD_CR_POOLBAL * RATE7*DAYS)/(YEAR*100) |
LMVD_DR_POOLBAL<0 |
(LMVD_DR_POOLBAL*RATE8*DAYS)/(YEAR*100) |
|
Child |
LMVD_DR_BAL<0 |
(LMVD_DR_BAL*RATE9*DAYS)/(YEAR*100) |
(LMVD_CR_BAL>0) AND (LMVD_CR_BAL<=10000) |
(LMVD_CR_BAL * RATE10*DAYS)/(YEAR*100) |
|
(LMVD_CR_BAL>10000) AND (LMVD_CR_BAL<=9999999) |
(LMVD_CR_BAL * RATE11*DAYS)/(YEAR*100) |
Header/Child |
Condition |
Formula |
Header |
Not Applicable |
Not Applicable |
Child |
LM_OPT_POOLBAL>0 AND LMVD_CR_BAL>0 |
(((LMVD_CR_BAL*LM_CRCOV_RATIO*COVRATE*DAYS)/ (YEAR*100)) + ((LMVD_CR_BAL*LM_CRRES_RATIO*RESRATE*DAYS)/ (YEAR*100))) |
LM_OPT_POOLBAL<0 AND LMVD_DR_BAL<0 |
(((LMVD_DR_BAL*LM_DRCOV_RATIO*COVRATE*DAYS)/(YEAR*100))+ ((LMVD_DR_BAL*LM_DRRES_RATIO*RESRATE*DAYS)/(YEAR*100)) |
Condition |
Formula |
(LMVD_CR_BAL>0) AND (LMVD_CR_BAL<=10000) AND (LM_IESTRBALTHCCY>=IETHRESHOLDBAL) AND (LM_IECCYTOTALBAL<LM_IECCYTHRESHOLDBAL) |
((LMVD_CR_BAL*RATE12*DAYS)+ (LMVD_CR_BAL*LM_IECCYERATE*DAYS))/(YEAR*100) |
(LMVD_CR_BAL>10000) AND (LMVD_CR_BAL<=9999999) AND (LM_IESTRBALTHCCY>=IETHRESHOLDBAL) AND (LM_IECCYTOTALBAL<LM_IECCYTHRESHOLDBAL) |
((LMVD_CR_BAL*RATE13*DAYS)+ (LMVD_CR_BAL*LM_IECCYERATE*DAYS))/(YEAR*100) |
(LMVD_CR_BAL>0) AND (LMVD_CR_BAL<=10000) AND (LM_IESTRBALTHCCY>=IETHRESHOLDBAL) AND (LM_IECCYTOTALBAL>=LM_IECCYTHRESHOLDBAL) |
(((LMVD_CR_BAL*RATE14)+ (LMVD_CR_BAL*LM_IECCYERATE)+ (LMVD_CR_BAL*LM_IECCYPRATE))*DAYS)/(YEAR*100) |
(LMVD_CR_BAL>10000) AND (LMVD_CR_BAL<=9999999) AND (LM_IESTRBALTHCCY>=IETHRESHOLDBAL) AND (LM_IECCYTOTALBAL>=LM_IECCYTHRESHOLDBAL) |
(((LMVD_CR_BAL*RATE15)+ (LMVD_CR_BAL*LM_IECCYERATE)+ (LMVD_CR_BAL*LM_IECCYPRATE))*DAYS)/ (YEAR*100) |
LMVD_DR_BAL <0 AND LM_IESTRBALTHCCY<IETHRESHOLDBAL |
(LMVD_DR_BAL*RATE16*DAYS)/YEAR |
SDE |
SDE Description |
Remarks |
LMVD_CR_POOLBAL |
Credit net pool position |
Interest Method for Pool, Advantage Method |
LMVD_DR_POOLBAL |
Debit net pool position |
Interest Method for Pool, Advantage Method |
LM_CRCOV_RATIO |
Credit coverage Ratio |
Optimization Method |
LM_CRRES_RATIO |
Credit Residual Ratio |
Optimization Method |
LM_DRCOV_RATIO |
Debit Coverage Ratio |
Optimization Method |
LM_DRRES_RATIO |
Debit Residual Ratio |
Optimization Method |
LM_OPT_POOLBAL |
Net Pool position |
Optimization Method |
LMVD_CR_BAL |
Credit Account Balance |
Interest Method for sweep, Interest Enhancement Method , Optimization Method, Advantage Method |
LMVD_DR_BAL |
Debit Account Balance |
Interest Method for sweep, Interest Enhancement Method, Optimization Method, Advantage Method |
IETHRESHOLDBAL |
Structure Level Threshold |
Interest Enhancement Method |
LM_IESTRBALTHCCY |
Total Structure balance in threshold ccy |
Interest Enhancement Method |
LM_IECCYERATE |
Enhancement rate as per account's balance |
Interest Enhancement Method |
LM_IECCYTHRESHOLDBAL |
Currency wise threshold balance |
Interest Enhancement Method |
LM_IECCYTOTALBAL |
Currency wise total balance for structure |
Interest Enhancement Method |
LM_IECCYPRATE |
Premium rate as per account's balance |
Interest Enhancement Method |
PII MASKING |
|
|
|
Group |
Group Description |
Tables |
Columns |
Customer Information |
Include all tables and required columns in PII Masking screen to mask informations related to customer |
LM_CUSTOMER LM_CUSTOMER_AUDIT LM_CUSTOMER_RM |
ADDRESS,CUSTOMER_NAME,EXTERNAL_REFERENCE,CUSTOMER_DESC ADDRESS,CUSTOMER_NAME,EXTERNAL_REFERENCE,CUSTOMER_DESC CUSTOMER_NAME,USER_NAME |
User Information |
Include all tables and required columns in PII Masking screen to mask informations related to users |
SSTB_USER SMTB_USER |
USER_NAME,USER_EMAIL USER_NAME |
Account Information |
Include all tables and required columns in PII Masking screen to mask informations related to accounts |
LM_ACC_DETAILS LM_ACC_DETAILS_AUDIT |
ACCOUNT_DESC,ACY_CURR_BAL ACCOUNT_DESC,ACY_CURR_BAL |