BILLING_SECDEP_INTEREST_RATE
The DAILY interest rates used by billing when calculating the interest amount.
Package
BILLING_RUN
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
The billing contract year the SDA application is processed and interest calculated |
| WEEKNO |
numeric(3, 0) |
tinyint |
The billing week no. the SDA application is processed and interest calculated |
| BILLRUNNO |
numeric(3, 0) |
smallint |
The billing run no. the SDA application is processed and interest calculated |
| INTEREST_ACCT_ID |
varchar(20) |
varchar(20) |
The interest account ID used by security deposit interest calculation |
| EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
The effective date of the new interest change |
| INTEREST_RATE |
numeric(18, 8) |
numeric(18, 8) |
The interest rate to apply from the effective date |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILL_SECDEP_INTEREST_RATE_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, INTEREST_ACCT_ID, EFFECTIVEDATE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLING_SECDEP_INTEREST_RATE |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, INTEREST_ACCT_ID, EFFECTIVEDATE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILL_SECDEP_INTEREST_RATE_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, INTEREST_ACCT_ID, EFFECTIVEDATE |