|
Name |
|
|
Comment |
Billing reconciliation result table for both provisional and final directions |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
DIRECTION_ID |
|
REGIONID |
|
WEEKNO |
|
Name |
|
CONTRACTYEAR |
|
WEEKNO |
|
BILLRUNNO |
|
DIRECTION_ID |
|
REGIONID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4) |
X |
Billing contract year |
|
WEEKNO |
NUMBER(3) |
X |
Billing week no |
|
BILLRUNNO |
NUMBER(3) |
X |
Billing run no |
|
DIRECTION_ID |
VARCHAR2(20) |
X |
Direction identifier |
|
REGIONID |
VARCHAR2(20) |
X |
Region Identifier |
|
DIRECTION_DESC |
VARCHAR2(200) |
|
Direction description |
|
DIRECTION_TYPE_ID |
VARCHAR2(20) |
|
The service for which the direction occurred (ENERGY, ANCILLARY, NON_ENERGY_NON_AS, etc) |
|
DIRECTION_START_DATE |
DATE |
|
Settlement day on which the direction starts |
|
DIRECTION_END_DATE |
DATE |
|
Settlement day on which the direction ends. The same value for all regions |
|
DIRECTION_START_INTERVAL |
DATE |
|
Dispatch interval in which the direction starts. The same value for all regions |
|
DIRECTION_END_INTERVAL |
DATE |
|
Dispatch interval in which the direction ends. The same value for all regions |
|
COMPENSATION_AMOUNT |
NUMBER(18,8) |
|
The final compensation amount for the direction. The same value for all regions |
|
INTEREST_AMOUNT |
NUMBER(18,8) |
|
The interest amount calculated on the final compensation amount for the direction. The same value for all regions |
|
INDEPENDENT_EXPERT_FEE |
NUMBER(18,8) |
|
The independent expert fee amount for the direction. The same value for all regions |
|
CRA |
NUMBER(18,8) |
|
The total recovery amount for the direction. The same value for all regions |
|
REGIONAL_CUSTOMER_ENERGY |
NUMBER(18,8) |
|
The total customer energy for this region, over the duration of the direction. NULL for Billing Week post the IESS rule effective date. |
|
REGIONAL_GENERATOR_ENERGY |
NUMBER(18,8) |
|
The total generator energy for this region, over the duration of the direction. NULL for Billing Week post the IESS rule effective date. |
|
REGIONAL_BENEFIT_FACTOR |
NUMBER(18,8) |
|
The regional benefit factor allocated to this region for the direction |
|
REGION_ACE_MWH |
NUMBER(18,8) |
|
The Sum of ACE MWh value for the Region over the duration of the direction. NULL for Billing Week prior to the IESS rule effective date |
|
REGION_ASOE_MWH |
NUMBER(18,8) |
|
The Sum of ASOE MWh value for the Region over the duration of the direction. NULL for Billing Week prior to the IESS rule effective date |
|
DIRECTION_SERVICE_ID |
VARCHAR2(20) |
|
The Direction Service ID associated with the Direction Type ID. Eg For FCAS Direction Type, Direction Service could be any contingency service. |
|
|
|