Name |
|
Comment |
SETGENDATA shows meter settlement data for each generation meter point. A regional summary is also provided. |
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. |
Name |
Comment |
Value |
Visibility |
Data in this table is: |
Private |
Name |
DUID |
GENSETID |
PERIODID |
REGIONID |
SETTLEMENTDATE |
STATIONID |
VERSIONNO |
Name |
LASTCHANGED |
Name |
PARTICIPANTID |
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 |
|
|
|