15. Glossary

15.1 Introduction

This chapter contains the following sections:

• Section 15.2, "IC Formulae"
• Section 15.3, "PII Masking Table Matrix"

15.2 IC Formulae

15.2.1 Sweep

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)

15.2.2 Pool

15.2.2.1 Interest Method

Header/Child	Condition	Formula
Header	(LMVD_CR_POOLBAL>0) AND (LMVD_CR_POOL­BAL<=10000)	(LMVD_CR_POOLBAL * RATE4*DAYS)/(YEAR*100)
	(LMVD_CR_POOL­BAL>10000) AND (LMVD_CR_POOL­BAL<=9999999)	(LMVD_CR_POOLBAL * RATE5*DAYS)/(YEAR*100)
	LMVD_DR_POOLBAL<0	(LMVD_DR_POOLBAL*RATE6*DAYS)/(YEAR*100)
Child	Not Applicable	Not Applicable

 

15.2.2.2 Advantage Method

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)

 

15.2.2.3 Optimization Method

Header/Child	Condition	Formula
Header	Not Applicable	Not Applicable
Child	LM_OPT_POOLBAL>0 AND LMVD_CR_BAL>0	(((LMVD_CR_BAL*LM_CRCOV_RA­TIO*COVRATE*DAYS)/ (YEAR*100)) + ((LMVD_CR_BAL*LM_CRRES_RATIO*RES­RATE*DAYS)/ (YEAR*100)))
	LM_OPT_POOLBAL<0 AND LMVD_DR_BAL<0	(((LMVD_DR_BAL*LM_DRCOV_RA­TIO*COVRATE*DAYS)/(YEAR*100))+ ((LMVD_DR_BAL*LM_DRRES_RATIO*RES­RATE*DAYS)/(YEAR*100))

 

 

 

15.2.2.4 Interest Enhancement

Condition	Formula
(LMVD_CR_BAL>0) AND (LMVD_CR_BAL<=10000) AND (LM_IESTR­BALTHCCY>=IETHRESHOLDBAL) AND (LM_IECCYTOTALBAL<LM_IECCYTHRESH­OLDBAL)	((LMVD_CR_BAL*RATE12*DAYS)+ (LMVD_CR_BAL*LM_IECCYERATE*DAYS))/(YEAR*100)
(LMVD_CR_BAL>10000) AND (LMVD_CR_BAL<=9999999) AND (LM_I­ESTRBALTHCCY>=IETHRESHOLDBAL) AND (LM_IECCYTOTALBAL<LM_IECCYTHRESH­OLDBAL)	((LMVD_CR_BAL*RATE13*DAYS)+ (LMVD_CR_BAL*LM_IECCYERATE*DAYS))/(YEAR*100)
(LMVD_CR_BAL>0) AND (LMVD_CR_BAL<=10000) AND (LM_IESTR­BALTHCCY>=IETHRESHOLDBAL) AND (LM_IECCYTOTALBAL>=LM_IECCYTHRESH­OLDBAL)	(((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_I­ESTRBALTHCCY>=IETHRESHOLDBAL) AND (LM_IECCYTOTALBAL>=LM_IECCYTHRESH­OLDBAL)	(((LMVD_CR_BAL*RATE15)+ (LMVD_CR_BAL*LM_IECCYERATE)+ (LMVD_CR_BAL*LM_IECCYPRATE))*DAYS)/ (YEAR*100)
LMVD_DR_BAL <0 AND LM_IESTR­BALTHCCY<IETHRESHOLDBAL	(LMVD_DR_BAL*RATE16*DAYS)/YEAR

 

 

 

 

 

 

 

 

 

 

 

15.2.3 List of SDE’s

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 bal­ance	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

 

15.3 PII Masking Table Matrix

PII MASKING
Group	Group Description	Tables	Columns
Customer Information	Include all tables and required columns in PII Mask­ing screen to mask informa­tions related to customer	LM_CUS­TOMER LM_CUSTOM­ER_AUDIT LM_CUSTOM­ER_RM	ADDRESS,CUSTOM­ER_NAME,EXTER­NAL_REFERENCE,CUSTOMER_DESC ADDRESS,CUSTOM­ER_NAME,EXTER­NAL_REFERENCE,CUSTOMER_DESC CUSTOM­ER_NAME,USER_NAME
User Infor­mation	Include all tables and required columns in PII Mask­ing screen to mask informa­tions related to users	SSTB_USER SMTB_USER	USER_NAME,USER_EMAIL USER_NAME
Account Information	Include all tables and required columns in PII Mask­ing screen to mask informa­tions related to accounts	LM_ACC_DE­TAILS LM_ACC_DE­TAILS_AUDIT	ACCOUNT_­DESC,ACY_CURR_BAL ACCOUNT_­DESC,ACY_CURR_BAL