Table: REGIONAPCINTERVALS

REGIONAPCINTERVALS

Name

REGIONAPCINTERVALS

Comment

REGIONAPCINTERVALS contains Administered Price profiles (Energy and FCAS) applicable to each interval for a region.


Description

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

Source

REGIONAPCINTERVALS is updated whenever an Administered Price Cap occurs.


Primary Key Columns

Name

EFFECTIVEDATE

PERIODID

REGIONID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

REGIONID

VARCHAR2(10)

X

Region Identifier

EFFECTIVEDATE

DATE

X

Date the APC profile applies from

VERSIONNO

NUMBER(3,0)

X

Version number for the same date

PERIODID

NUMBER(3,0)

X

30-minute period

APCVALUE

NUMBER(16,6)

 

Administered price cap in $

LASTCHANGED

DATE

 

Last date and time record changed

APCTYPE

NUMBER(3,0)

 

not used

FCASAPCVALUE

NUMBER(16,6)

 

FCAS Administered price cap in $

APFVALUE

NUMBER(16,6)

 

Administered price floor in $