PARTICIPANT_BANDFEE_ALLOC
PARTICIPANT_BANDFEE_ALLOC shows the market fee for each Participant / Participant Category over time.
Package
SETTLEMENT_CONFIG
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PARTICIPANTID |
varchar(10)  |
varchar(10) |
Unique participant identifier |
| MARKETFEEID |
varchar(10) |
varchar(10) |
Identifier for Market Fee |
| EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
Date on which this data becomes effective. |
| VERSIONNO |
numeric(3, 0) |
smallint |
Period identifier |
| PARTICIPANTCATEGORYID |
varchar(10) |
varchar(10) |
The participant category that the market fee recovery amount pertains to. |
| MARKETFEEVALUE |
numeric(15, 5) |
numeric(15, 5) |
The value of this market fee |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PARTICIPANT_BANDFEE_ALLOC_PK |
clustered, unique, primary key |
PARTICIPANTID, MARKETFEEID, EFFECTIVEDATE, VERSIONNO, PARTICIPANTCATEGORYID |
| PARTICIPANT_BANDFEE_ALOC_LCX |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_PARTICIPANT_BANDFEE_ALLOC_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_PARTICIPANT_BANDFEE_ALLOC |
clustered, unique, primary key |
PARTICIPANTID, MARKETFEEID, EFFECTIVEDATE, VERSIONNO, PARTICIPANTCATEGORYID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PARTICIPANT_BANDFEE_ALLOC_PK |
clustered, unique, primary key |
PARTICIPANTID, MARKETFEEID, EFFECTIVEDATE, VERSIONNO, PARTICIPANTCATEGORYID |
| PARTICIPANT_BANDFEE_ALOC_LCX |
nonclustered |
LASTCHANGED |