SECDEPOSIT_PROVISION
The security deposit provision entry details.
Package
BILLING_CONFIG
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SECURITY_DEPOSIT_ID |
varchar(20)  |
varchar(20) |
The security deposit ID |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
The Participant ID linked to the security deposit ID |
| TRANSACTION_DATE |
datetime(3) |
datetime2(0) |
The date the security deposit ID is entered and authorised by settlements |
| MATURITY_CONTRACTYEAR |
numeric(4, 0) |
smallint |
The contract year of the billing week when the security deposit is maturing |
| MATURITY_WEEKNO |
numeric(3, 0) |
smallint |
The week no of the billing week when the security deposit is maturing |
| AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The security deposit amount |
| INTEREST_RATE |
numeric(18, 8) |
numeric(18, 8) |
The interest rate assigned to the security deposit ID. Null if INTEREST_CALC_TYPE <> FIXED |
| INTEREST_CALC_TYPE |
varchar(20) |
varchar(20) |
FIXED OR DAILY |
| INTEREST_ACCT_ID |
varchar(20) |
varchar(20) |
The Interest Account ID for calculating the Interest Payment. This is NULL if the INTEREST_CALC_TYPE = FIXED |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SECDEPOSIT_PROVISION_PK |
clustered, unique, primary key |
SECURITY_DEPOSIT_ID, PARTICIPANTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SECDEPOSIT_PROVISION |
clustered, unique, primary key |
SECURITY_DEPOSIT_ID, PARTICIPANTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SECDEPOSIT_PROVISION_PK |
clustered, unique, primary key |
SECURITY_DEPOSIT_ID, PARTICIPANTID |