|
Name |
|
|
Comment |
PARTICIPANT_BANDFEE_ALLOC shows the market fee for each Participant/Participant Category over time. |
|
Source This view updates only on change of participant configuration. |
|
Name |
|
EFFECTIVEDATE |
|
MARKETFEEID |
|
PARTICIPANTCATEGORYID |
|
PARTICIPANTID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
MARKETFEEID |
VARCHAR2(10) |
X |
Identifier for Market Fee |
|
EFFECTIVEDATE |
DATE |
X |
Date on which this data becomes effective. |
|
VERSIONNO |
NUMBER(3,0) |
X |
Period identifier |
|
PARTICIPANTCATEGORYID |
VARCHAR2(10) |
X |
The participant category that the market fee recovery amount pertains to. |
|
MARKETFEEVALUE |
NUMBER(15,5) |
|
The value of this market fee |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|