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