Name |
|
Comment |
BILLINGCPDATA shows energy quantity and $ value purchased per participant connection point. |
BILLINGCPDATA data is confidential to relevant participant. Source Populated by the posting of a billing run, being several times each week. Volume The number of records depends on the number of Transmission ConnectionPointIDs a participant may use to purchase energy. An indicative maximum is approximately 150 records per billrunno, or about 1,500 records inserted per week. |
Name |
BILLRUNNO |
CONNECTIONPOINTID |
CONTRACTYEAR |
MDA |
PARTICIPANTID |
WEEKNO |
Name |
LASTCHANGED |
Name |
PARTICIPANTID |
Name |
Data Type |
Mandatory |
Comment |
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
CONNECTIONPOINTID |
VARCHAR2(10) |
X |
Unique connection point identifier |
AGGREGATEENERGY |
NUMBER(16,6) |
|
Aggregate energy purchased/sold by customer, in MWh, plus UFEA. When GS commences, this includes the UFEA amount in the settlement runs. |
PURCHASES |
NUMBER(16,6) |
|
The Purchase column has the dollar value of the Energy Purchased rather than Aggregate Energy Dollar |
LASTCHANGED |
DATE |
|
Last date and time record changed |
MDA |
VARCHAR2(10) |
X |
relevant MDA for this connection point. |
AFE |
NUMBER(18,8) |
|
Adjusted Gross Energy for this Market Customer FRMP and TNI in the Billing run, excluding any UFEA component. |
DME |
NUMBER(18,8) |
|
Sum of ME- for all NMIs at this Market Customer FRMP and TNI in the Billing run. |
UFEA |
NUMBER(18,8) |
|
Share of UFE allocated to this FRMP and TNI in the Billing run. |
AGE |
NUMBER(18,8) |
|
Adjusted Gross Energy for this Market Customer FRMP and TNI in the trading interval. This will include the UFEA value once financial settlement of UFE commences with GS. |
SOLDENERGY |
NUMBER(18,8) |
|
Energy sold at the connection point by the participant in this billing run |
SALES |
NUMBER(18,8) |
|
The total cost of energy sold at the connection point by the participant in this billing run |
PURCHASEDENERGY |
NUMBER(18,8) |
|
The energy consumed at the connection point by the participant in this billing run |
|
|
|