Table: SRA_CASH_SECURITY

SRA_CASH_SECURITY

Name

SRA_CASH_SECURITY

Comment

Records the Cash Security details provided by an SRA Auction Participant as collateral to cover their Trading Position in the SRA market


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

CASH_SECURITY_ID


Content

Name

Data Type

Mandatory

Comment

CASH_SECURITY_ID

VARCHAR2(36)

X

Unique identifier for the cash security.

PARTICIPANTID

VARCHAR2(10)

 

Unique identifier for the auction participant lodging the cash security.

PROVISION_DATE

DATE

 

Date AEMO received the Cash Security deposit

CASH_AMOUNT

NUMBER(18,8)

 

Dollar amount of the cash security.

INTEREST_ACCT_ID

VARCHAR2(20)

 

The interest account ID for calculating the interest payment

AUTHORISEDDATE

DATE

 

Authorised date

FINALRETURNDATE

DATE

 

Date the entire Cash Security amount was returned to the Auction Participant

CASH_SECURITY_RETURNED

NUMBER(18,8)

 

Returned Dollar amount of the Cash Security.

DELETIONDATE

DATE

 

Cash Security deleted date. For valid records, DeletionDate will be Null.

LASTCHANGED

DATE

 

The date and time this record was last modified