BILLING_DIRECTION_RECON_OTHER
Billing reconciliation result table for both provisional and final directions.
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 |
| REGIONID |
varchar(20) |
varchar(20) |
Region Identifier |
| DIRECTION_DESC |
varchar(200) |
varchar(200) |
Direction description |
| DIRECTION_TYPE_ID |
varchar(20) |
varchar(20) |
The service for which the direction occurred (ENERGY, ANCILLARY, NON_ENERGY_NON_AS, etc) |
| DIRECTION_START_DATE |
datetime(3) |
datetime2(0) |
Settlement day on which the direction starts |
| DIRECTION_END_DATE |
datetime(3) |
datetime2(0) |
Settlement day on which the direction ends. The same value for all regions |
| DIRECTION_START_INTERVAL |
datetime(3) |
datetime2(0) |
Dispatch interval in which the direction starts. The same value for all regions |
| DIRECTION_END_INTERVAL |
datetime(3) |
datetime2(0) |
Dispatch interval in which the direction ends. The same value for all regions |
| COMPENSATION_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The final compensation amount for the direction. The same value for all regions |
| INTEREST_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The interest amount calculated on the final compensation amount for the direction. The same value for all regions |
| INDEPENDENT_EXPERT_FEE |
numeric(18, 8) |
numeric(18, 8) |
The independent expert fee amount for the direction. The same value for all regions |
| CRA |
numeric(18, 8) |
numeric(18, 8) |
The total recovery amount for the direction. The same value for all regions |
| REGIONAL_CUSTOMER_ENERGY |
numeric(18, 8) |
numeric(18, 8) |
The total customer energy for this region, over the duration of the direction. NULL for Billing Week post the IESS rule effective date. |
| REGIONAL_GENERATOR_ENERGY |
numeric(18, 8) |
numeric(18, 8) |
The total generator energy for this region, over the duration of the direction. NULL for Billing Week post the IESS rule effective date. |
| REGIONAL_BENEFIT_FACTOR |
numeric(18, 8) |
numeric(18, 8) |
The regional benefit factor allocated to this region for the direction |
| DIRECTION_SERVICE_ID |
varchar(20) |
varchar(20) |
The Direction Service ID associated with the Direction Type ID. Eg For FCAS Direction Type, Direction Service could be any contingency service. |
| REGION_ACE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Sum of ACE MWh value for the Region over the duration of the direction. NULL for Billing Week prior to the IESS rule effective date |
| REGION_ASOE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Sum of ASOE MWh value for the Region over the duration of the direction. NULL for Billing Week prior to the IESS rule effective date |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLING_DIRECTION_REC_OTHER_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, DIRECTION_ID, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLING_DIRECTION_RECON_OTHER |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, DIRECTION_ID, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLING_DIRECTION_REC_OTHER_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, DIRECTION_ID, REGIONID |