SECDEPOSIT_INTEREST_RATE
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.
Package
BILLING_CONFIG
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| INTEREST_ACCT_ID |
varchar(20)  |
varchar(20) |
The interest account ID for calculating the interest payment |
| EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
The effective date of the interest rate change |
| VERSION_DATETIME |
datetime(3) |
datetime2(0) |
Date Time this record was added |
| INTEREST_RATE |
numeric(18, 8) |
numeric(18, 8) |
The interest rate for the interest account ID as on the effective date. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SECDEPOSIT_INTEREST_RATE_PK |
clustered, unique, primary key |
INTEREST_ACCT_ID, EFFECTIVEDATE, VERSION_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SECDEPOSIT_INTEREST_RATE |
clustered, unique, primary key |
INTEREST_ACCT_ID, EFFECTIVEDATE, VERSION_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SECDEPOSIT_INTEREST_RATE_PK |
clustered, unique, primary key |
INTEREST_ACCT_ID, EFFECTIVEDATE, VERSION_DATETIME |