Table: SETGENDATAREGION

SETGENDATAREGION

Name

SETGENDATAREGION

Comment

SETGENDATAREGION sets out summary settlement data for generation within the specified region.


Description

SETGENDATAREGION shows the regional summary. SETGENDATAREGION is public data.

Source

SETGENDATAREGION updates with each Settlement run.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

PERIODID

REGIONID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Calendar Settlement Date

VERSIONNO

NUMBER(22,10)

X

Settlement run no

PERIODID

NUMBER(22,10)

X

Settlement Period identifier

REGIONID

VARCHAR2(10)

X

Region Identifier

GENERGY

NUMBER(22,0)

 

Generated energy - Not used in MMS Data Model

AENERGY

NUMBER(22,0)

 

Purchased Energy - Not used in MMS Data Model

GPOWER

NUMBER(22,0)

 

Not used in MMS Data Model

APOWER

NUMBER(22,0)

 

Not used in MMS Data Model

NETENERGY

NUMBER(27,5)

 

Net energy MW/hours

ENERGYCOST

NUMBER(27,5)

 

Cost of net energy $

EXCESSENERGYCOST

NUMBER(27,5)

 

Cost of excess energy $

EXPENERGY

NUMBER(27,6)

 

Export Energy (Generator Purchases)

EXPENERGYCOST

NUMBER(27,6)

 

Export Energy Cost

LASTCHANGED

DATE

 

current system date, to enable automatic replication