Table: SETSMALLGENDATA

SETSMALLGENDATA

Name

SETSMALLGENDATA

Comment

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


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


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

Settlement interval identifier (half hour period)

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