Skip to content

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