BILLING_ENERGY_GENSET_DETAIL
The Billing Energy Genset report contains the Genset Energy detail summary for the Billing Week data.
Package
BILLING_RUN
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
The Billing Contract Year |
| WEEKNO |
numeric(3, 0) |
tinyint |
The Billing Week No |
| BILLRUNNO |
numeric(4, 0) |
smallint |
The Billing Run No |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
The Participant Id Identifier |
| STATIONID |
varchar(20) |
varchar(20) |
The StationId identifier associated with the GensetId |
| DUID |
varchar(20) |
varchar(20) |
The DUID for the meter associated with the GensetId |
| GENSETID |
varchar(20) |
varchar(20) |
The GensetId for the Meter Id received |
| REGIONID |
varchar(20) |
varchar(20) |
The Region Id for the Connection Point associated with the DUID |
| CONNECTIONPOINTID |
varchar(20) |
varchar(20) |
The Connection Point associated with the DUID |
| METERID |
varchar(20) |
varchar(20) |
The Meter ID Identifier (NMI) |
| CE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Consumed Energy for the Meter Id . Energy received in the meter reads (DLF Adjusted) in that Billing Week |
| UFEA_MWH |
numeric(18, 8) |
numeric(18, 8) |
The UFEA Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week |
| ACE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Consumed Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week |
| ASOE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Sent Out Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week |
| TOTAL_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Total MWh(ACE_MWh + ASOE_MWh) for that Connection Point for the Participant Id in that Billing Week |
| DME_MWH |
numeric(18, 8) |
numeric(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 |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Consumed Energy Dollar Amount for that Connection Point for the Participant Id in that Billing Week |
| ASOE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Sent Out Energy Dollar Amount for that Connection Point for the Participant Id in that Billing Week |
| TOTAL_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Total Amount(ACE_Amount + ASOE_Amount) for that Connection Point for the Participant Id in that Billing Week |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The Last changed date time for the record |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILL_ENERGY_GENSET_DETAIL_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, STATIONID, DUID, GENSETID, REGIONID, CONNECTIONPOINTID, METERID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLING_ENERGY_GENSET_DETAIL |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, STATIONID, DUID, GENSETID, REGIONID, CONNECTIONPOINTID, METERID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILL_ENERGY_GENSET_DETAIL_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, STATIONID, DUID, GENSETID |