|
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 |
|
|
|