Table: BILLING_DIRECTION_RECON_OTHER

BILLING_DIRECTION_RECON_OTHER

Name

BILLING_DIRECTION_RECON_OTHER

Comment

Billing reconciliation result table for both provisional and final directions


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

DIRECTION_ID

REGIONID

WEEKNO


Index Columns

Name

CONTRACTYEAR

WEEKNO

BILLRUNNO

DIRECTION_ID

REGIONID


Content

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