|
Name |
|
|
Comment |
Billing reconciliation result table for both provisional and final directions using the FPP methodology (prior to 1st July 2011) |
|
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 |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
DIRECTION_ID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|