Name |
|
Comment |
BILLINGEXCESSGEN shows the excess generation cost by period for each participant. |
Source Obsolete; was updated weekly with each billing run. |
Name |
Comment |
Value |
Visibility |
Data in this table is: |
Private |
Name |
BILLRUNNO |
CONTRACTYEAR |
PARTICIPANTID |
PERIODID |
REGIONID |
SETTLEMENTDATE |
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 |
SETTLEMENTDATE |
DATE |
X |
Calendar settlement date record becomes effective |
PERIODID |
NUMBER(3,0) |
X |
Settlement interval within the settlement date (1-48) starting at 00:30 |
EXCESSENERGYCOST |
NUMBER(15,5) |
|
Cost of excess energy attributed to this customer |
LASTCHANGED |
DATE |
|
Last date and time record changed |
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
|
|