Table: SET_ENERGY_GENSET_DETAIL

SET_ENERGY_GENSET_DETAIL

Name

SET_ENERGY_GENSET_DETAIL

Comment

The Settlement Energy Genset report contains the Energy Transactions data for each generation meter point.. This report is produced only for Settlement Date post the IESS rule effective date.


Primary Key Columns

Name

DUID

GENSETID

PERIODID

SETTLEMENTDATE

STATIONID

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

The Settlement Date of the Billing Week

VERSIONNO

NUMBER(3,0)

X

The Settlement Run No

PERIODID

NUMBER(3,0)

X

The Period ID Identifier

PARTICIPANTID

VARCHAR2(20)

 

The Participant Id Identifier

STATIONID

VARCHAR2(20)

X

The StationId identifier associated with the GensetId

DUID

VARCHAR2(20)

X

The DUID for the meter associated with the GensetId

GENSETID

VARCHAR2(20)

X

The GensetId for the Meter Id received

REGIONID

VARCHAR2(20)

 

The Region Id for the Connection Point associated with the DUID

CONNECTIONPOINTID

VARCHAR2(20)

 

The Connection Point associated with the DUID

RRP

NUMBER(18,8)

 

The Regional Reference Price for the Settlement Period

TLF

NUMBER(18,8)

 

The Transmission Loss Factor applied to the Connection Point Id. TLF is calculated based on the Net Flow at the TNI.

METERID

VARCHAR2(20)

 

The Meter ID Identifier (NMI)

CE_MWH

NUMBER(18,8)

 

The Consumed Energy for the Meter Id . Energy received in the meter reads (DLF Adjusted)

UFEA_MWH

NUMBER(18,8)

 

The UFEA allocation amount applied to the Meter Data

ACE_MWH

NUMBER(18,8)

 

The Adjusted Consumed Energy for the Meter Id (CE_MWh + UFEA)

ASOE_MWH

NUMBER(18,8)

 

The Adjusted Sent Out Energy for the Meter Id.

TOTAL_MWH

NUMBER(18,8)

 

The Total MWh for the Meter Id (ACE_MWh + ASOE_MWh)

DME_MWH

NUMBER(18,8)

 

The DME MWh value that is used to calculate the UFEA Allocation Amount

ACE_AMOUNT

NUMBER(18,8)

 

The Adjusted Consumed Energy Dollar Amount

ASOE_AMOUNT

NUMBER(18,8)

 

The Adjusted Sent Out Energy Dollar Amount

TOTAL_AMOUNT

NUMBER(18,8)

 

The Total Amount for the Meter Id (ACE_Amount + ASOE_Amount)

LASTCHANGED

DATE

 

The Last changed Date time of the record