15. Glossary

15.1 Introduction

This chapter contains the following sections:

• Section 15.2, "IC Formulae"
• Section 15.3, "PII Masking Table Matrix"
• Section 15.4, "Function ID List"

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

 

15.4 Function ID List

Screen Name	Function ID
Account Maintenance	LMMTACCT
Bank Maintenance	LMMTBANK
Branch Holiday Maintenance	LMMTBRHL
Branch Maintenance	LMMTBRAN
BVT Monitor	LMBTBVMO
Currency Holiday Maintenance	LMMTCUHL
Currency Maintenance	LMMTCURR
Currency Exchange Rate Maintenance	LMMTCUXR
Customer Maintenance	LMMTCUST
Customer User Linkage	LMSMCUUL
EOD Batch	LMBTEODB
External System Setup	LMMTEXSY
File Upload	LMMTFLUP
Interest Enhancement	LMSTIENH
Interest Product Mapping	LMMTIPRM
Interest Product Setup	LMMTIPRD
Interest Rule Setup	LMMTIRUL
Interest UDE Setup	LMMTIUDE
Interface Instruction Maintenance	LMMTIFIN
Interface Monitor	LMBTIFMO
Job Scheduler	LMBTJSCH
Manual Customer Purge	LMBTMNPU
Manual User Purge	LMBTMUPU
MBCC Currency Cutoff Maintenance	LMMTMBCC
MBCC Monitor	LMBTMBMO
Password Policy	LMSMPASS
PII Masking	LMMTPIIM
Pool Batch	LMBTMNLP
Regularoty Parameters	LMMTREGP
Reports	LMRPREPS
Reverse Sweep monitor	LMBTRSMO
Role Maintenance	LMSMROLM
Setup Screen	LMMTMENU
Simulation Existing Data	LMSIEXTD
Simulation With New Data	LMSINEWD
Structure Maintenance	LMSTMAIN
Structure Summary	LMSTSUMM
Sweep Batch	LMBTMNLS
Sweep Concentration Methods	LMMTSCON
Sweep Frequency Setup	LMMTSFRQ
Sweep Instruction Setup	LMMTSINT
Sweep Monitor	LMBTSWMO
System Parameters	LMMTSYSP
User Creation	LMSMUSRC
User Maintenance	LMSMUSRM