|
Name |
|
|
Comment |
BILLINGINTRARESIDUES shows intra-region settlement residue details for each Transmission Network Service Provider participant by region. |
|
BILLINGINTRARESIDUES is confidential to the relevant participant. Source BILLINGINTRARESIDUES is populated by the posting of a billing run, being several times each week. Volume An indicative maximum is two records inserted per billing run, or 22 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
ALLOCATION |
NUMBER(6,3) |
|
TNSP allocation |
|
TOTALSURPLUS |
NUMBER(15,5) |
|
Total $ residue amount for the region |
|
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 |
|
SURPLUSVALUE |
NUMBER(15,6) |
|
Amount TNSP is paid for Intra-Regional Residues |
|
LASTCHANGED |
DATE |
|
Last changed date |
|
REGIONID |
VARCHAR2(10) |
X |
Region ID |
|
|
|