|
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 |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
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 |
Settlement Period identifier |
|
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 6 Feb 2022, 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 6 Feb 2022, 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) |
|
Adjusted Gross Energy for this Market Customer FRMP and TNI in the trading interval, excluding any UFEA component. |
|
DME |
NUMBER(18,8) |
|
Sum of ME- for all NMI’s at this Market Customer FRMP and TNI in the trading interval. |
|
UFEA |
NUMBER (18,8) |
|
Share of UFE allocated to this FRMP and TNI in the Billing run. |
|
AGE |
NUMBER (18,8) |
|
Adjusted Gross Energy for this Market Customer FRMP and TNI in the trading interval. When GS commences 6 Feb 2022, this includes the UFEA amount in the settlement runs. |
|
|
|