|
Name |
|
|
Comment |
SETMARKETFEES shows payments for market fees for each settlement date. |
|
SETMARKETFEES is confidential data. Source SETMARKETFEES updates with each settlement run. |
|
Name |
|
MARKETFEEID |
|
PARTICIPANTCATEGORYID |
|
PARTICIPANTID |
|
PERIODID |
|
RUNNO |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
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. |
|
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 or ASOE represent ASOE_MWH value and ALL represent sum of ACE_MWh and ASOE_MWh |
|
|
|