|
Name |
|
|
Comment |
SETCPDATA shows meter settlement data for each connection point. This is the key view for retailers to verify energy charges. A regional summary view is also provided. As the view has values for each connection point by period, for each meter data file, it is a very large view. |
|
The Connection point details (in SETCPDATA) are confidential to the participant and host retailer that the connection points relate to. By comparison, the regional data (SETCPDATAREGION) is publically available. Source SETCPDATA updates with each Settlement run. |
|
Name |
|
MDA |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
TCPID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Calendar Settlement Date |
|
VERSIONNO |
NUMBER(10,0) |
X |
Settlement run no |
|
PERIODID |
NUMBER(10,0) |
X |
Settlements Trading Interval. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
TCPID |
VARCHAR2(10) |
X |
Connection point identifier |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
IGENERGY |
NUMBER(16,6) |
|
Import Gross energy into the pool - MWh |
|
XGENERGY |
NUMBER(16,6) |
|
Export Gross energy from the pool - MWh |
|
INENERGY |
NUMBER(16,6) |
|
Import Nett energy into the pool - MWh, plus UFEA if the UFEA amount is positive. When GS commences, this includes the UFEA amount in the settlement runs. |
|
XNENERGY |
NUMBER(16,6) |
|
Export Nett energy from the pool - MWh, plus (UFEA * -1) if the UFEA amount is negative. When GS commences, this includes the UFEA amount in the settlement runs. |
|
IPOWER |
NUMBER(16,6) |
|
Import reactive power |
|
XPOWER |
NUMBER(16,6) |
|
Export reactive power |
|
RRP |
NUMBER(20,5) |
|
Regional Reference Price |
|
EEP |
NUMBER(16,6) |
|
Excess Energy Price |
|
TLF |
NUMBER(7,5) |
|
Transmission Loss Factor |
|
CPRRP |
NUMBER(16,6) |
|
Connection Point Price = RRP * TLF |
|
CPEEP |
NUMBER(16,6) |
|
Connection Point Excess Energy Price = EEP * TLF |
|
TA |
NUMBER(16,6) |
|
Export - Import of Net energy (MWh) |
|
EP |
NUMBER(16,6) |
|
settlement amount in $ for trading period |
|
APC |
NUMBER(16,6) |
|
Not used |
|
RESC |
NUMBER(16,6) |
|
Not used |
|
RESP |
NUMBER(16,6) |
|
Not used |
|
METERRUNNO |
NUMBER(10,0) |
|
Meter Run Number = version number of the meter file |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
HOSTDISTRIBUTOR |
VARCHAR2(10) |
|
Not used |
|
MDA |
VARCHAR2(10) |
X |
Metering Data Agent |
|
AFE |
NUMBER(18,8) |
|
Accounted For Energy for this Market Customer FRMP and TNI in the Settlements Trading Interval, excluding any UFEA component |
|
DME |
NUMBER(18,8) |
|
Sum of ME- for all NMIs at this Market Customer FRMP and TNI in the Settlements Trading Interval. |
|
UFEA |
NUMBER (18,8) |
|
Share of UFE allocated to this FRMP and TNI in the Settlements Trading Interval. |
|
AGE |
NUMBER (18,8) |
|
Adjusted Gross Energy for this Market Customer FRMP and TNI in the Settlements Trading Interval. When GS commences, this includes the UFEA amount in the settlement runs. |
|
IMPORTENERGYCOST |
NUMBER(18,8) |
|
The total cost of energy sold at the connection point by the participant in this settlement interval |
|
EXPORTENERGYCOST |
NUMBER(18,8) |
|
The total cost of energy purchased at the connection point by the participant in this settlement interval |
|
|
|