Table: SETCPDATA

SETCPDATA

Name

SETCPDATA

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.


Description

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.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

MDA

PARTICIPANTID

PERIODID

SETTLEMENTDATE

TCPID

VERSIONNO


Index Columns

Name

LASTCHANGED


Index Columns

Name

PARTICIPANTID


Content

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)

 

Adjusted Gross 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.