Table: BILLINGCPDATA

BILLINGCPDATA

Name

BILLINGCPDATA

Comment

BILLINGCPDATA shows energy quantity and $ value purchased per participant connection point.


Description

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.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BILLRUNNO

CONNECTIONPOINTID

CONTRACTYEAR

MDA

PARTICIPANTID

WEEKNO


Index Columns

Name

LASTCHANGED


Index Columns

Name

PARTICIPANTID


Content

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)

 

Value of energy purchased/sold by customer, in $. Financial value of energy transactions for the Market Customer and FRMP and TNI in the Billing run.When GS commences, this includes the UFEA amount in the settlement runs.

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.