Name |
|
Comment |
Billing reconciliation result table for both provisional and final directions |
Name |
Comment |
Value |
Visibility |
Data in this table is: |
Public |
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 |
REGIONAL_GENERATOR_ENERGY |
NUMBER(18,8) |
|
The total generator energy for this region, over the duration of the direction |
REGIONAL_BENEFIT_FACTOR |
NUMBER(18,8) |
|
The regional benefit factor allocated to this region for the direction |
|
|
|