MARKET_FEE_CAT_EXCL
Market fee exclusions for participant categories.
Package
SETTLEMENT_CONFIG
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| MARKETFEEID |
varchar(20)  |
varchar(20) |
The excluded market fee |
| EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
The date the exclusion is effective from |
| VERSION_DATETIME |
datetime(3) |
datetime2(0) |
The version information for this record |
| PARTICIPANT_CATEGORYID |
varchar(20) |
varchar(20) |
Participant category to be excluded from this market fee |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MARKET_FEE_CAT_EXCL |
clustered, unique, primary key |
MARKETFEEID, EFFECTIVEDATE, VERSION_DATETIME, PARTICIPANT_CATEGORYID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MARKET_FEE_CAT_EXCL |
clustered, unique, primary key |
MARKETFEEID, EFFECTIVEDATE, VERSION_DATETIME, PARTICIPANT_CATEGORYID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MARKET_FEE_CAT_EXCL |
clustered, unique, primary key |
MARKETFEEID, EFFECTIVEDATE, VERSION_DATETIME, PARTICIPANT_CATEGORYID |