Table: PRUDENTIALCOMPANYPOSITION

PRUDENTIALCOMPANYPOSITION

Name

PRUDENTIALCOMPANYPOSITION

Comment

The prudential position of each company as at the datetime of a specific prudential run


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

COMPANY_ID

PRUDENTIAL_DATE

RUNNO


Index Columns

Name

LASTCHANGED


Content

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