MARKET_FEE_CAT_EXCL_TRK
Tracking table for 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 |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time the record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MARKET_FEE_CAT_EXCL_TRK |
clustered, unique, primary key |
MARKETFEEID, EFFECTIVEDATE, VERSION_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MARKET_FEE_CAT_EXCL_TRK |
clustered, unique, primary key |
MARKETFEEID, EFFECTIVEDATE, VERSION_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MARKET_FEE_CAT_EXCL_TRK |
clustered, unique, primary key |
MARKETFEEID, EFFECTIVEDATE, VERSION_DATETIME |