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