Table: SETGENDATA

SETGENDATA

Name

SETGENDATA

Comment

SETGENDATA shows meter settlement data for each generation meter point. A regional summary is also provided.


Description

SETGENDATA shows generator meter details, and SETGENDATA data is confidential to the participant.

By comparison, the regional summary (SETGENDATAREGION) is public data.

Source

SETGENDATA updates with each Settlement run.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

DUID

GENSETID

PERIODID

REGIONID

SETTLEMENTDATE

STATIONID

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

Settlement Period identifier

PARTICIPANTID

VARCHAR2(10)

 

Unique participant identifier

STATIONID

VARCHAR2(10)

X

Station Identifier

DUID

VARCHAR2(10)

X

Dispatchable Unit identifier

GENSETID

VARCHAR2(10)

X

Physical unit identifier

REGIONID

VARCHAR2(10)

X

Region Identifier

GENERGY

NUMBER(16,6)

 

Generated energy

AENERGY

NUMBER(16,6)

 

Purchased Energy

GPOWER

NUMBER(16,6)

 

Not used

APOWER

NUMBER(16,6)

 

Not used

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

NETENERGY

NUMBER(16,6)

 

Net energy (MWh)

ENERGYCOST

NUMBER(16,6)

 

Cost of net energy $

EXCESSENERGYCOST

NUMBER(16,6)

 

Cost of excess energy $

APC

NUMBER(16,6)

 

Administered Price Compensation

RESC

NUMBER(16,6)

 

Not used

RESP

NUMBER(16,6)

 

Not used

LASTCHANGED

DATE

 

Last date and time record changed

EXPENERGY

NUMBER(15,6)

 

Export Energy (Generator Purchases) (MWh)

EXPENERGYCOST

NUMBER(15,6)

 

Export Energy Cost ($)

METERRUNNO

NUMBER(6,0)

 

Identifier of the meter run used in this settlement calculation

MDA

VARCHAR2(10)

 

Metering Data Agent

SECONDARY_TLF

NUMBER(7,5)

 

Secondary Transmission Loss Factor