Table: BILLINGREGIONEXPORTS

BILLINGREGIONEXPORTS

Name

BILLINGREGIONEXPORTS

Comment

BILLINGREGIONEXPORTS sets out the region summary table of overall energy exported to and from each region for each billing run.


Description

BILLINGREGIONEXPORTS data is public, and is available to all participants.

Source

BILLINGREGIONEXPORTS is populated by the posting of a billing run.

Volume

Eight records inserted per billing run, or 88 records inserted per week.


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

EXPORTTO

REGIONID

WEEKNO


Index Columns

Name

LASTCHANGED


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

REGIONID

VARCHAR2(10)

X

Unique region identifier

EXPORTTO

VARCHAR2(10)

X

Region exported to

ENERGY

NUMBER(16,6)

 

MWh Energy value exported

VALUE

NUMBER(15,5)

 

$ Value of energy exported

SURPLUSENERGY

NUMBER(16,6)

 

This field is populated with 0

SURPLUSVALUE

NUMBER(15,5)

 

$ Interregional residue

LASTCHANGED

DATE

 

Last date and time record changed