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 |