Skip to content

BANK_GUARANTEE

Indicates the amount of bank guarantee the Company has with AEMO.

Package

PRUDENTIALS

Visibility

Private

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
GUARANTEE_ID varchar(30) 🔑 varchar(30) 🔑 The Bank Guarantee ID
COMPANY_ID varchar(20) varchar(20) Company ID owning the Bank Guarantee
PARTICIPANTID varchar(20) varchar(10) Participant Id belonging to the company (Even though BG belongs to a Company, Participant Id is also added as all reports are published to the Participants)
CREDIT_PROVIDER varchar(20) varchar(20) Bank Guarantee Provider Id
COMMENCEMENT_DATE datetime(3) datetime2(0) Date AEMO received the bank guarantee details
TERMINATION_DATE datetime(3) datetime2(0) Date of Termination
RETURN_DATE datetime(3) datetime2(0) Date of Return
GUARANTEE_AMOUNT numeric(18, 8) numeric(18, 8) Dollar Amount of the bank guarantee
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)
BANK_GUARANTEE_PK clustered, unique, primary key GUARANTEE_ID

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_BANK_GUARANTEE clustered, unique, primary key GUARANTEE_ID

Historical-MMS data model indexes

Index name Index type Index columns (in order)
PK_BANK_GUARANTEE clustered, unique, primary key GUARANTEE_ID