|
Name |
|
|
Comment |
BILLWHITEHOLE shows white hole payments based on participant vs region demand. |
|
Confidential Source Obsolete; was updated weekly with each billing run. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(22,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(22,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(22,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
NL |
NUMBER(15,6) |
|
Sum of billing week (RRP * interconnector flow) |
|
PARTICIPANTDEMAND |
NUMBER(15,6) |
|
The sum of all customer purchases in MWh |
|
REGIONDEMAND |
NUMBER(15,6) |
|
Sum of all region purchases in MWh |
|
WHITEHOLEPAYMENT |
NUMBER(15,6) |
|
Payment in $ |
|
LASTCHANGED |
DATE |
|
The latest date and time that a file was updated or inserted |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Interconnector ID |
|
|
|