SETMARKETFEES
SETMARKETFEES shows payments for market fees for each settlement date.
Package
SETTLEMENT_DATA
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Settlement date |
| RUNNO |
numeric(3, 0) |
smallint |
Settlement run no |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Unique participant identifier |
| PERIODID |
numeric(3, 0) |
smallint |
Settlements Trading Interval. |
| MARKETFEEID |
varchar(10) |
varchar(10) |
Market fee identifier (e.g. V_EST) |
| PARTICIPANTCATEGORYID |
varchar(10) |
varchar(10) |
The participant category that the market fee recovery pertains to. Corresponds to the PARTICIPANTCATEGORYID column of the PARTICIPANT_BANDFEE_CATEGORYALLOC_C_V view for BAND$ type fees, or to the MARKETFEETYPE column of the MARKETFEE_P_V view for all other fee types. |
| MARKETFEEVALUE |
numeric(15, 5) |
numeric(15, 5) |
Fee charge |
| ENERGY |
numeric(16, 6) |
numeric(16, 6) |
Energy amount for variable fees |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| FEERATE |
numeric(18, 8) |
numeric(18, 8) |
The rate applied to this fee for the participant at the settlement date |
| FEEUNITS |
numeric(18, 8) |
numeric(18, 8) |
The number of units applicable to this fee for the participant, in the trading interval. |
| METER_SUBTYPE |
varchar(20) |
varchar(20) |
The Meter Sub Type values are ACE, ASOE or ALL. ACE represent ACE_MWH value or 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) |
| SETMARKETFEES_LCX |
nonclustered |
LASTCHANGED |
| SETMARKETFEES_PK |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, PARTICIPANTID, MARKETFEEID, PARTICIPANTCATEGORYID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_SETMARKETFEES_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_SETMARKETFEES |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, PARTICIPANTID, MARKETFEEID, PARTICIPANTCATEGORYID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETMARKETFEES_LCX |
nonclustered |
LASTCHANGED |
| SETMARKETFEES_PK |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, PARTICIPANTID, MARKETFEEID, PARTICIPANTCATEGORYID, PERIODID |