Table: PARTICIPANT_BANDFEE_ALLOC

PARTICIPANT_BANDFEE_ALLOC

Name

PARTICIPANT_BANDFEE_ALLOC

Comment

PARTICIPANT_BANDFEE_ALLOC shows the market fee for each Participant/Participant Category over time.


Description

Source

This view updates only on change of participant configuration.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

EFFECTIVEDATE

MARKETFEEID

PARTICIPANTCATEGORYID

PARTICIPANTID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

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