Table: MARKETFEE

MARKETFEE

Name

MARKETFEE

Comment

MARKETFEE sets out fee type and period for each market fee.


Description

MARKETFEE data is public, so is available to all participants.

Source

MARKETFEE updates when fees change.


Primary Key Columns

Name

MARKETFEEID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

MARKETFEEID

VARCHAR2(10)

X

Identifier for Market Fee

MARKETFEEPERIOD

VARCHAR2(20)

 

Period type - PERIOD, DAILY, WEEKLY

MARKETFEETYPE

VARCHAR2(12)

 

Type - MW or $

DESCRIPTION

VARCHAR2(64)

 

Description of market fee

LASTCHANGED

DATE

 

Last date and time record changed

GL_TCODE

VARCHAR2(15)

 

 

GL_FINANCIALCODE

VARCHAR2(10)

 

 

FEE_CLASS

VARCHAR2(40)

 

 

METER_TYPE

VARCHAR2(20)

 

The Energy Type for the Market Fees Calculation. E.g of Meter Types are CUSTOMER, GENERATOR, NREG, BDU etc. If Meter Type is mentioned as ALL then all the Meter Types for that Participant Category will be used in the Fee calculation

METER_SUBTYPE

VARCHAR2(20)

 

The Meter Sub Type values are ACE, ASOE or ALL. ACE represent ACE_MWH value , ASOE represent ASOE_MWH value and ALL represent sum of ACE_MWh and ASOE_MWh