|
Name |
|
|
Comment |
BILLINGFEES presents pool fees applied to the statement, per billing run. |
|
BILLINGFEES data is confidential to the relevant participant. Source BILLINGFEES is populated by the posting of a billing run, being several times each week. Volume The number of records varies according to the number of pool fee types the participant may be subject to. An indicative maximum is about 13 records inserted per billrunno or 143 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
MARKETFEEID |
|
PARTICIPANTCATEGORYID |
|
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 |
|
MARKETFEEID |
VARCHAR2(10) |
X |
Market fee identifier |
|
RATE |
NUMBER(15,5) |
|
Market fee rate |
|
ENERGY |
NUMBER(16,6) |
|
Energy, in MWh |
|
VALUE |
NUMBER(15,5) |
|
Fee in $ |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
PARTICIPANTCATEGORYID |
VARCHAR2(10) |
X |
The participant category pertaining to the market fee recovery. Corresponds to the PARTICIPANTCATEGORYID column of the SETMARKETFEES table. |
|
|
|