Table: DISPATCH_FCAS_REQ

DISPATCH_FCAS_REQ

Name

DISPATCH_FCAS_REQ

Comment

DISPATCH_FCAS_REQ shows Dispatch Constraint tracking for Regional FCAS recovery.


Description

DISPATCH_FCAS_REQ is public data and is available to all participants.

Source

DISPATCH_FCAS_REQ updates with each dispatch run (5 minutes).

Volume

Approximately 10,000 rows per day


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

BIDTYPE

GENCONID

INTERVENTION

REGIONID

RUNNO

SETTLEMENTDATE


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Settlement date and time of Dispatch Interval

RUNNO

NUMBER(3,0)

X

Dispatch run no; always 1

INTERVENTION

NUMBER(2,0)

X

Intervention Flag

GENCONID

VARCHAR2(20)

X

Generic Constraint ID - Join to table GenConData

REGIONID

VARCHAR2(10)

X

 

BIDTYPE

VARCHAR2(10)

X

DUID offered type

GENCONEFFECTIVEDATE

DATE

 

Generic Constraint EffectiveDate - Join to table GenConData

GENCONVERSIONNO

NUMBER(3,0)

 

Generic Constraint Version number - Join to table GenConData

MARGINALVALUE

NUMBER(16,6)

 

 

LASTCHANGED

DATE

 

Date record is changed

BASE_COST

NUMBER(18,8)

 

The base cost of the constraint for this service, before the regulation/contingency split

ADJUSTED_COST

NUMBER(18,8)

 

The adjusted cost of the constraint for this service, before the regulation/contingency split

ESTIMATED_CMPF

NUMBER(18,8)

 

An estimated value for the constraint CMPF, based on dispatched data

ESTIMATED_CRMPF

NUMBER(18,8)

 

An estimated value for the constraint CRMPF, based on dispatched data

RECOVERY_FACTOR_CMPF

NUMBER(18,8)

 

Estimated recovery factor for CMPF based recovery

RECOVERY_FACTOR_CRMPF

NUMBER(18,8)

 

Estimated recovery factor for CRMPF based recovery