CASH_SECURITY
Indicates the amount of cash security the participant has with AEMO.
Package
PRUDENTIALS
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CASH_SECURITY_ID |
varchar(20)  |
varchar(20)  |
Unique ID for each cash security record |
| PARTICIPANTID |
varchar(20) |
varchar(10) |
Participant ID(Provider of the Cash Security) |
| TRANSACTION_DATE |
datetime(3) |
datetime2(0) |
Date when the CS was received by AEMO |
| CASH_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
Cash security amount(in dollars) |
| RETURNED_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
Cash amount retuned(In dollars) |
| INTEREST_ACCT_ID |
varchar(20) |
varchar(20) |
Interest Account id used for daily interest calculation |
| STATUS |
varchar(10) |
varchar(10) |
Active/Closed |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The last changed date time of the record |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| CASH_SECURITY_PK |
clustered, unique, primary key |
CASH_SECURITY_ID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_CASH_SECURITY |
clustered, unique, primary key |
CASH_SECURITY_ID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_CASH_SECURITY |
clustered, unique, primary key |
CASH_SECURITY_ID |