PRUDENTIALCOMPANYPOSITION
The prudential position of each company as at the datetime of a specific prudential run.
Package
PRUDENTIALS
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PRUDENTIAL_DATE |
datetime(3)  |
datetime2(0) |
The prudential date |
| RUNNO |
numeric(3, 0) |
smallint |
The run number for the prudential date |
| COMPANY_ID |
varchar(20) |
varchar(20) |
The company identifier |
| MCL |
numeric(16, 6) |
numeric(16, 6) |
The Maximum Credit Limit of the company at the time of the prudential run |
| CREDIT_SUPPORT |
numeric(16, 6) |
numeric(16, 6) |
The Credit Support of the company at the time of the prudential run |
| TRADING_LIMIT |
numeric(16, 6) |
numeric(16, 6) |
The Trading Limit of the company at the time of the prudential run |
| CURRENT_AMOUNT_BALANCE |
numeric(16, 6) |
numeric(16, 6) |
The balance of the company for all unpaid billing weeks at the time of the prudential run |
| SECURITY_DEPOSIT_PROVISION |
numeric(16, 6) |
numeric(16, 6) |
The sum of all active security deposit provision amounts at the time of the prudential run |
| SECURITY_DEPOSIT_OFFSET |
numeric(16, 6) |
numeric(16, 6) |
The sum of all active security deposit application amounts at the time of the prudential run |
| SECURITY_DEPOSIT_BALANCE |
numeric(16, 6) |
numeric(16, 6) |
The balance of all active security deposits at the time of the prudential run |
| EXPOST_REALLOC_BALANCE |
numeric(16, 6) |
numeric(16, 6) |
The balance of all ex-post reallocations for the company that were calculated outside of billing runs at the time of the prudential run |
| DEFAULT_BALANCE |
numeric(16, 6) |
numeric(16, 6) |
The balance of all defaults for the company at the time of the prudential run |
| OUTSTANDINGS |
numeric(16, 6) |
numeric(16, 6) |
The total outstandings for the company at the time of the prudential run |
| TRADING_MARGIN |
numeric(16, 6) |
numeric(16, 6) |
The trading margin for the company at the time of the prudential run |
| TYPICAL_ACCRUAL |
numeric(16, 6) |
numeric(16, 6) |
The typical accrual for the company at the time of the prudential run |
| PRUDENTIAL_MARGIN |
numeric(16, 6) |
numeric(16, 6) |
The prudential margin is the current value determined by AEMO for the registered participant. It represents the buffer below the value of credit support which is used to set the trading limit |
| EARLY_PAYMENT_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The early payment amount deducted from Outstandings in the prudential run |
| PERCENTAGE_OUTSTANDINGS |
numeric(18, 8) |
numeric(18, 8) |
The percentage of outstandings calculated against the trading margin and prudential margin |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The datetime that the record was last changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PRUDENTIALCOMPANYPOSITION_LCX |
nonclustered |
LASTCHANGED |
| PRUDENTIALCOMPANYPOSITION_PK |
clustered, unique, primary key |
PRUDENTIAL_DATE, RUNNO, COMPANY_ID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_PRUDENTIALCOMPANYPOSITION_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_PRUDENTIALCOMPANYPOSITION |
clustered, unique, primary key |
PRUDENTIAL_DATE, RUNNO, COMPANY_ID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PRUDENTIALCOMPANYPOSITION_LCX |
nonclustered |
LASTCHANGED |
| PRUDENTIALCOMPANYPOSITION_PK |
clustered, unique, primary key |
PRUDENTIAL_DATE, RUNNO, COMPANY_ID |