SRA_CASH_SECURITY
Records the Cash Security details provided by an SRA Auction Participant as collateral to cover their Trading Position in the SRA market.
Package
IRAUCTION
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CASH_SECURITY_ID |
varchar(36)  |
varchar(36) |
Unique identifier for the cash security. |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Unique identifier for the auction participant lodging the cash security. |
| PROVISION_DATE |
datetime(3) |
datetime2(0) |
Date AEMO received the Cash Security deposit |
| CASH_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
Dollar amount of the cash security. |
| INTEREST_ACCT_ID |
varchar(20) |
varchar(20) |
The interest account ID for calculating the interest payment |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Authorised date |
| FINALRETURNDATE |
datetime(3) |
datetime2(0) |
Date the entire Cash Security amount was returned to the Auction Participant |
| CASH_SECURITY_RETURNED |
numeric(18, 8) |
numeric(18, 8) |
Returned Dollar amount of the Cash Security. |
| DELETIONDATE |
datetime(3) |
datetime2(0) |
Cash Security deleted date. For valid records, DeletionDate will be Null. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The date and time this record was last modified |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_CASH_SECURITY_PK |
clustered, unique, primary key |
CASH_SECURITY_ID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SRA_CASH_SECURITY |
clustered, unique, primary key |
CASH_SECURITY_ID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_CASH_SECURITY_PK |
clustered, unique, primary key |
CASH_SECURITY_ID |