|
Name |
|
|
Comment |
BILLINGGENDATA shows the total energy sold and purchased per participant transmission connection point for a billing period. |
|
BILLINGGENDATA data is confidential to the the relevant participant. Source BILLINGGENDATA is 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 have sold energy from per billrunno. An indicative maximum is approximately 15 records inserted per billrunno, or about 165 records inserted per week. BILLINGGENDATA is confidential to the the relevant participant. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
BILLRUNNO |
|
CONNECTIONPOINTID |
|
CONTRACTYEAR |
|
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 |
Connection point identifier |
|
STATIONID |
VARCHAR2(10) |
|
not populated |
|
DUID |
VARCHAR2(10) |
|
not populated |
|
AGGREGATEENERGY |
NUMBER(16,6) |
|
Aggregate energy sold, in MWh |
|
SALES |
NUMBER(16,6) |
|
$ income |
|
PURCHASES |
NUMBER(16,6) |
|
$ outgoing |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
PURCHASEDENERGY |
NUMBER(16,6) |
|
Amount of energy purchased in MWh |
|
MDA |
VARCHAR2(10) |
|
Metering Data Agent supplying data |
|
|
|