Table: SETSMALLGENDATA

SETSMALLGENDATA

Name

SETSMALLGENDATA

Comment

Publishes metering data and associated settlement values for with a registered Small Generator Aggregator participants connection points.


Primary Key Columns

Name

CONNECTIONPOINTID

PARTICIPANTID

PERIODID

SETTLEMENTDATE

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Settlement date

VERSIONNO

NUMBER(3,0)

X

Version number of the record for the settlement date

CONNECTIONPOINTID

VARCHAR2(20)

X

Transmission Node Identifier (TNI)

PERIODID

NUMBER(3,0)

X

Settlements Trading Interval.

PARTICIPANTID

VARCHAR2(20)

X

Unique participant identifier

REGIONID

VARCHAR2(20)

 

Region Identifier

IMPORTENERGY

NUMBER(18,8)

 

The import direction value for the meter read (MWh)

EXPORTENERGY

NUMBER(18,8)

 

The export direction value for the meter read (MWh)

RRP

NUMBER(18,8)

 

Regional Reference Price

TLF

NUMBER(18,8)

 

Transmission Loss Factor

IMPENERGYCOST

NUMBER(18,8)

 

Import Energy Cost ($)

EXPENERGYCOST

NUMBER(18,8)

 

Export Energy Cost ($)

LASTCHANGED

DATE

 

Last date and time the record changed