Name |
|
Comment |
The Billing Energy Genset report contains the Genset Energy detail summary for the Billing Week data |
Name |
BILLRUNNO |
CONNECTIONPOINTID |
CONTRACTYEAR |
DUID |
GENSETID |
METERID |
PARTICIPANTID |
REGIONID |
STATIONID |
WEEKNO |
Name |
Data Type |
Mandatory |
Comment |
CONTRACTYEAR |
NUMBER(4,0) |
X |
The Billing Contract Year |
WEEKNO |
NUMBER(3,0) |
X |
The Billing Week No |
BILLRUNNO |
NUMBER(4,0) |
X |
The Billing Run No |
PARTICIPANTID |
VARCHAR2(20) |
X |
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) |
X |
The Region Id for the Connection Point associated with the DUID |
CONNECTIONPOINTID |
VARCHAR2(20) |
X |
The Connection Point associated with the DUID |
METERID |
VARCHAR2(20) |
X |
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) in that Billing Week |
UFEA_MWH |
NUMBER(18,8) |
|
The UFEA Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week |
ACE_MWH |
NUMBER(18,8) |
|
The Adjusted Consumed Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week |
ASOE_MWH |
NUMBER(18,8) |
|
The Adjusted Sent Out Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week |
TOTAL_MWH |
NUMBER(18,8) |
|
The Total MWh(ACE_MWh + ASOE_MWh) for that Connection Point for the Participant Id in that Billing Week |
DME_MWH |
NUMBER(18,8) |
|
The DME MWh for that Connection Point for the Participant Id in that Billing Week. This is the MWh value that is used for the UFEA Allocation |
ACE_AMOUNT |
NUMBER(18,8) |
|
The Adjusted Consumed Energy Dollar Amount for that Connection Point for the Participant Id in that Billing Week |
ASOE_AMOUNT |
NUMBER(18,8) |
|
The Adjusted Sent Out Energy Dollar Amount for that Connection Point for the Participant Id in that Billing Week |
TOTAL_AMOUNT |
NUMBER(18,8) |
|
The Total Amount(ACE_Amount + ASOE_Amount) for that Connection Point for the Participant Id in that Billing Week |
LASTCHANGED |
DATE |
|
The Last changed date time for the record |
|
|
|