BILLING_DIRECTION_RECONCILIATN
Billing reconciliation result table for both provisional and final directions using the FPP methodology (prior to 1st July 2011).
Package
BILLING_RUN
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
Billing contract year |
| WEEKNO |
numeric(3, 0) |
smallint |
Billing week no |
| BILLRUNNO |
numeric(3, 0) |
smallint |
Billing run no |
| DIRECTION_ID |
varchar(20) |
varchar(20) |
Direction identifier |
| DIRECTION_DESC |
varchar(200) |
varchar(200) |
Direction description |
| DIRECTION_START_DATE |
datetime(3) |
datetime2(0) |
Direction start date time |
| DIRECTION_END_DATE |
datetime(3) |
datetime2(0) |
Direction end date time |
| COMPENSATION_AMOUNT |
numeric(16, 6) |
numeric(16, 6) |
Direction compensation amount |
| INDEPENDENT_EXPERT_FEE |
numeric(16, 6) |
numeric(16, 6) |
Independent expert fee charged on calculating direction compensation amount |
| INTEREST_AMOUNT |
numeric(16, 6) |
numeric(16, 6) |
Interest occurred on direction compensation amount |
| CRA |
numeric(16, 6) |
numeric(16, 6) |
Direction compensation recovery amount |
| NEM_FEE_ID |
varchar(20) |
varchar(20) |
Fixed settlement fee identifier for direction purpose |
| NEM_FIXED_FEE_AMOUNT |
numeric(16, 6) |
numeric(16, 6) |
Fixed settlement fee for participants between direction start and end date |
| MKT_CUSTOMER_PERC |
numeric(16, 6) |
numeric(16, 6) |
Direction compensation recovery amount percentage breakdown among customers |
| GENERATOR_PERC |
numeric(16, 6) |
numeric(16, 6) |
Direction compensation recovery amount percentage breakdown among generators |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last changed date time |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLING_DIRECTION_RCNCLTN_NDX1 |
nonclustered |
LASTCHANGED |
| BILLING_DIRECTION_RCNCLTN_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, DIRECTION_ID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_BILLING_DIRECTION_RECONCILIATN_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_BILLING_DIRECTION_RECONCILIATN |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, DIRECTION_ID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLING_DIRECTION_RCNCLTN_NDX1 |
nonclustered |
LASTCHANGED |
| BILLING_DIRECTION_RCNCLTN_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, DIRECTION_ID |