|
Name |
|
|
Comment |
The prudential position of each company as at the datetime of a specific prudential run |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
COMPANY_ID |
|
PRUDENTIAL_DATE |
|
RUNNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PRUDENTIAL_DATE |
DATE |
X |
The prudential date |
|
RUNNO |
NUMBER(3) |
X |
The run number for the prudential date |
|
COMPANY_ID |
VARCHAR(20) |
X |
The company identifier |
|
MCL |
NUMBER(16,6) |
|
The Maximum Credit Limit of the company at the time of the prudential run |
|
CREDIT_SUPPORT |
NUMBER(16,6) |
|
The Credit Support of the company at the time of the prudential run |
|
TRADING_LIMIT |
NUMBER(16,6) |
|
The Trading Limit of the company at the time of the prudential run |
|
CURRENT_AMOUNT_BALANCE |
NUMBER(16,6) |
|
The balance of the company for all unpaid billing weeks at the time of the prudential run |
|
SECURITY_DEPOSIT_PROVISION |
NUMBER(16,6) |
|
The sum of all active security deposit provision amounts at the time of the prudential run |
|
SECURITY_DEPOSIT_OFFSET |
NUMBER(16,6) |
|
The sum of all active security deposit application amounts at the time of the prudential run |
|
SECURITY_DEPOSIT_BALANCE |
NUMBER(16,6) |
|
The balance of all active security deposits at the time of the prudential run |
|
EXPOST_REALLOC_BALANCE |
NUMBER(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 |
NUMBER(16,6) |
|
The balance of all defaults for the company at the time of the prudential run |
|
OUTSTANDINGS |
NUMBER(16,6) |
|
The total outstandings for the company at the time of the prudential run |
|
TRADING_MARGIN |
NUMBER(16,6) |
|
The trading margin for the company at the time of the prudential run |
|
TYPICAL_ACCRUAL |
NUMBER(16,6) |
|
The typical accrual for the company at the time of the prudential run |
|
PRUDENTIAL_MARGIN |
NUMBER(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 |
NUMBER(18,8) |
|
The early payment amount deducted from Outstandings in the prudential run |
|
PERCENTAGE_OUTSTANDINGS |
NUMBER(18,8) |
|
The percentage of outstandings calculated against the trading margin and prudential margin |
|
LASTCHANGED |
DATE |
|
The datetime that the record was last changed |
|
Name |
|
|
Comment |
Records the prudential run accepted by Settlements staff for each prudential date |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PRUDENTIAL_DATE |
|
RUNNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PRUDENTIAL_DATE |
DATE |
X |
The prudential date |
|
RUNNO |
NUMBER(3) |
X |
The run number for the prudential date |
|
AUTHORISEDBY |
VARCHAR(15) |
|
The user that authorised the prudential run |
|
AUTHORISEDDATE |
DATE |
|
The datetime that the prudential run was authorised |
|
LASTCHANGED |
DATE |
|
The datetime that the record was last changed |
|
|
|