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