|
Name |
|
|
Comment |
SETGENDATAREGION sets out summary settlement data for generation within the specified region. |
|
SETGENDATAREGION shows the regional summary. SETGENDATAREGION is public data. Source SETGENDATAREGION updates with each Settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|