Table: GSH_SECDEPOSIT_INTEREST_RATE

GSH_SECDEPOSIT_INTEREST_RATE

Name

GSH_SECDEPOSIT_INTEREST_RATE

Comment

The Security Deposit Interest Rate On Daily Basis. This is the public table published when a new floating daily interest rate is entered and authorised


Primary Key Columns

Name

EFFECTIVEDATE

INTEREST_ACCT_ID

VERSION_DATETIME


Content

Name

Data Type

Mandatory

Comment

INTEREST_ACCT_ID

VARCHAR2(20)

X

The Interest Account Id for calculating the Interest Payment. This is NULL if the INTEREST_CALC_TYPE = FIXED

EFFECTIVEDATE

DATE

X

The Effective Date of the Interest Rate Change

VERSION_DATETIME

DATE

X

The Version Date time of the Effective Date for the Interest Rate Change

INTEREST_RATE

NUMBER(18,8)

 

The Interest Rate for the Interest Account ID as on the Effective Date