BILLING_ENERGY_TRANSACTIONS
The Billing Energy Transactions is the summary of the Settlement Energy Transactions that has the ACE and ASOE MWh and Dollar values that is used for the Statement.
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 WeekNo |
| BILLRUNNO |
numeric(4, 0) |
smallint |
The Billing RunNo |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
The Participant Id Identifier |
| CONNECTIONPOINTID |
varchar(20) |
varchar(20) |
The ConnectionPoint Id for the Billing Aggregation for the Participant Id. |
| REGIONID |
varchar(20) |
varchar(20) |
The Region Id Identifier |
| CE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Consumed Energy MWh Consumed for that Connection Point for the Participant Id 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 |
| 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_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 |
| 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 |
| 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. |
| 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) |
| BILLING_ENERGY_TRANSACTIONS_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONNECTIONPOINTID, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLING_ENERGY_TRANSACTIONS |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONNECTIONPOINTID, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLING_ENERGY_TRANSACTIONS_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONNECTIONPOINTID |