Name |
|
Comment |
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 |
Name |
BILLRUNNO |
CONNECTIONPOINTID |
CONTRACTYEAR |
PARTICIPANTID |
REGIONID |
WEEKNO |
Name |
Data Type |
Mandatory |
Comment |
CONTRACTYEAR |
NUMBER(4,0) |
X |
The Billing Contract Year |
WEEKNO |
NUMBER(3,0) |
X |
The Billing WeekNo |
BILLRUNNO |
NUMBER(4,0) |
X |
The Billing RunNo |
PARTICIPANTID |
VARCHAR2(20) |
X |
The Participant Id Identifier |
CONNECTIONPOINTID |
VARCHAR2(20) |
X |
The ConnectionPoint Id for the Billing Aggregation for the Participant Id. |
REGIONID |
VARCHAR2(20) |
X |
The Region Id Identifier |
CE_MWH |
NUMBER(18,8) |
|
The Consumed Energy MWh Consumed for that Connection Point for the Participant Id 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 |
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_MWH |
NUMBER(18,8) |
|
The Total MWh(ACE_MWh + ASOE_MWh) 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 |
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. |
LASTCHANGED |
DATE |
|
The Last Changed date time for the record |
|
|
|