Table: SET_FCAS_REGULATION_TRK

SET_FCAS_REGULATION_TRK

Name

SET_FCAS_REGULATION_TRK

Comment

SET_FCAS_REGULATION_TRK shows FCAS Regulation Service Constraint tracking for Regional FCAS Regulation recovery


Description

SET_FCAS_REGULATION_TRK contains public data and is available to all participants.

Volume

Approximately 350,000 per week.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

CONSTRAINTID

INTERVAL_DATETIME

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Settlement Date

VERSIONNO

NUMBER(3,0)

X

Settlement Run No

INTERVAL_DATETIME

DATE

X

Dispatch Interval Date Time

CONSTRAINTID

VARCHAR2(20)

X

Generic Constraint ID

CMPF

NUMBER(18,8)

 

Constraint Market Participant Factor

CRMPF

NUMBER(18,8)

 

Constraint Residual Market Participant Factor

RECOVERY_FACTOR_CMPF

NUMBER(18,8)

 

Recovery factor for CMPF based recovery

RECOVERY_FACTOR_CRMPF

NUMBER(18,8)

 

Recovery factor for CRMPF based recovery

LASTCHANGED

DATE

 

Last date and time record changed

USESUBSTITUTEDEMAND

NUMBER(1,0)

 

Flag to indication that substitute demand was used to recover this requirement

REQUIREMENTDEMAND

NUMBER(18,8)

 

the aggregate customer demand value used to recover the cost of this requirement