Table: SECDEPOSIT_INTEREST_RATE

SECDEPOSIT_INTEREST_RATE

Name

SECDEPOSIT_INTEREST_RATE

Comment

The security deposit interest rate on a daily basis. This is the public table published when the business enter and authorise a new daily interest rate


Description

SECDEPOSIT_INTEREST_RATE data is public to all participants.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


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

EFFECTIVEDATE

DATE

X

The effective date of the interest rate change

VERSION_DATETIME

DATE

X

Date Time this record was added

INTEREST_RATE

NUMBER(18,8)

 

The interest rate for the interest account ID as on the effective date.