Table: BILLING_DIRECTION_RECONCILIATN

BILLING_DIRECTION_RECONCILIATN

Name

BILLING_DIRECTION_RECONCILIATN

Comment

Billing reconciliation result table for both provisional and final directions using the FPP methodology (prior to 1st July 2011)


Description

Source

BILLING_DIRECTION_RECONCILIATN is populated by the posting of a billing run.

Volume

One record inserted per direction per billing run, or 11 records inserted per week. Presently


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

DIRECTION_ID

WEEKNO


Index Columns

Name

LASTCHANGED


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

DIRECTION_DESC

VARCHAR2(200)

 

Direction description

DIRECTION_START_DATE

DATE

 

Direction start date time

DIRECTION_END_DATE

DATE

 

Direction end date time

COMPENSATION_AMOUNT

NUMBER(16,6)

 

Direction compensation amount

INDEPENDENT_EXPERT_FEE

NUMBER(16,6)

 

Independent expert fee charged on calculating direction compensation amount

INTEREST_AMOUNT

NUMBER(16,6)

 

Interest occurred on direction compensation amount

CRA

NUMBER(16,6)

 

Direction compensation recovery amount

NEM_FEE_ID

VARCHAR2(20)

 

Fixed settlement fee identifier for direction purpose

NEM_FIXED_FEE_AMOUNT

NUMBER(16,6)

 

Fixed settlement fee for participants between direction start and end date

MKT_CUSTOMER_PERC

NUMBER(16,6)

 

Direction compensation recovery amount percentage breakdown among customers

GENERATOR_PERC

NUMBER(16,6)

 

Direction compensation recovery amount percentage breakdown among generators

LASTCHANGED

DATE

 

Last changed date time