|
Name |
|
|
Comment |
Billing result table containing daily summary data for customer and generator energy amounts |
|
BILLING_DAILY_ENERGY_SUMMARY data is confidential to the relevant participant. Source Populated by the posting of a billing run. Volume Approximately 20 records per billrunno. |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
SETTLEMENTDATE |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
Billing Week number |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing Run number |
|
SETTLEMENTDATE |
DATE |
X |
settlement date |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
participant identifier |
|
REGIONID |
VARCHAR2(20) |
X |
Unique Region Identifier |
|
CUSTOMER_ENERGY_PURCHASED |
NUMBER(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 |
NUMBER(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 |
NUMBER(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_MWH |
NUMBER(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_MWH |
NUMBER(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 |
|
ACE_AMOUNT |
NUMBER(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 |
|
ASOE_AMOUNT |
NUMBER(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 |
|
CE_MWH |
NUMBER(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 |
|
UFEA_MWH |
NUMBER(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 |
|
TOTAL_MWH |
NUMBER(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 |
|
TOTAL_AMOUNT |
NUMBER(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 |
|
|
|