BILLING_DAILY_ENERGY_SUMMARY
Billing result table containing daily summary data for customer and generator energy amounts.
Package
BILLING_RUN
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
Billing Contract Year |
| WEEKNO |
numeric(3, 0) |
smallint |
Billing Week number |
| BILLRUNNO |
numeric(3, 0) |
smallint |
Billing Run number |
| SETTLEMENTDATE |
datetime(3) |
datetime2(0) |
settlement date |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
participant identifier |
| REGIONID |
varchar(20) |
varchar(20) |
Unique Region Identifier |
| CUSTOMER_ENERGY_PURCHASED |
numeric(18, 8) |
numeric(18, 8) |
Customer energy amount purchased on this settlement day by the participant in the region. NULL for Billing Week post the IESS rule effective date. |
| GENERATOR_ENERGY_SOLD |
numeric(18, 8) |
numeric(18, 8) |
Generator energy amount sold on this settlement day by the participant in the region. NULL for Billing Week post the IESS rule effective date. |
| GENERATOR_ENERGY_PURCHASED |
numeric(18, 8) |
numeric(18, 8) |
Generator energy amount purchased on this settlement day by the participant in the region. NULL for Billing Week post the IESS rule effective date. |
| ACE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Sum of ACE Amount for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date |
| ACE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Sum of ACE MWh value for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date |
| ASOE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Sum of ASOE Amount for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date |
| ASOE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Sum of ASOE MWh value for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date |
| CE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Sum of CE MWh value for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date |
| TOTAL_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Sum of Total Amount for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date |
| TOTAL_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Sum of Total MWh value for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date |
| UFEA_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Sum of UFEA MWh value for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLING_DAILY_ENRGY_SUMMARY_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, SETTLEMENTDATE, PARTICIPANTID, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLING_DAILY_ENERGY_SUMMARY |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, SETTLEMENTDATE, PARTICIPANTID, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLING_DAILY_ENRGY_SUMMARY_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, SETTLEMENTDATE, PARTICIPANTID, REGIONID |