MARKETFEE
MARKETFEE sets out fee type and period for each market fee.
Package
SETTLEMENT_CONFIG
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| MARKETFEEID |
varchar(10)  |
varchar(10) |
Identifier for Market Fee |
| MARKETFEEPERIOD |
varchar(20) |
varchar(20) |
Period type - PERIOD, DAILY, WEEKLY |
| MARKETFEETYPE |
varchar(12) |
varchar(12) |
Type - MW or $ |
| DESCRIPTION |
varchar(64) |
varchar(64) |
Description of market fee |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| GL_TCODE |
varchar(15) |
varchar(15) |
- |
| GL_FINANCIALCODE |
varchar(10) |
varchar(10) |
- |
| FEE_CLASS |
varchar(40) |
varchar(40) |
- |
| METER_SUBTYPE |
varchar(20) |
varchar(10) |
The Meter Sub Type values are ACE, ASOE or ALL. ACE represent ACE_MWH value , ASOE represent ASOE_MWH value and ALL represent sum of ACE_MWh and ASOE_MWh |
| METER_TYPE |
varchar(20) |
varchar(20) |
The Energy Type for the Market Fees Calculation. E.g of Meter Types are CUSTOMER, GENERATOR, NREG, BDU etc. If Meter Type is mentioned as ALL then all the Meter Types for that Participant Category will be used in the Fee calculation |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MARKETFEE_LCX |
nonclustered |
LASTCHANGED |
| MARKETFEE_PK |
clustered, unique, primary key |
MARKETFEEID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_MARKETFEE_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_MARKETFEE |
clustered, unique, primary key |
MARKETFEEID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MARKETFEE_LCX |
nonclustered |
LASTCHANGED |
| MARKETFEE_PK |
clustered, unique, primary key |
MARKETFEEID |