Table: SETMARKETFEES

SETMARKETFEES

Name

SETMARKETFEES

Comment

SETMARKETFEES shows payments for market fees for each settlement date.


Description

SETMARKETFEES is confidential data.

Source

SETMARKETFEES updates with each settlement run.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

MARKETFEEID

PARTICIPANTCATEGORYID

PARTICIPANTID

PERIODID

RUNNO

SETTLEMENTDATE


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Settlement date

RUNNO

NUMBER(3,0)

X

Settlement run no

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

PERIODID

NUMBER(3,0)

X

Settlements Trading Interval.

MARKETFEEID

VARCHAR2(10)

X

Market fee identifier (e.g. V_EST)

MARKETFEEVALUE

NUMBER(15,5)

 

Fee charge

ENERGY

NUMBER(16,6)

 

Energy amount for variable fees

LASTCHANGED

DATE

 

Last date and time record changed

PARTICIPANTCATEGORYID

VARCHAR2(10)

X

The participant category that the market fee recovery pertains to. Corresponds to the PARTICIPANTCATEGORYID column of the PARTICIPANT_BANDFEE_CATEGORYALLOC_C_V view for BAND$ type fees, or to the MARKETFEETYPE column of the MARKETFEE_P_V view for all other fee types.

FEERATE

NUMBER(18,8)

 

The rate applied to this fee for the participant at the settlement date

FEEUNITS

NUMBER(18,8)

 

The number of units applicable to this fee for the participant, in the trading interval.