Table: APEVENTREGION

APEVENTREGION

Name

APEVENTREGION

Comment

APEVENTREGION is the Region detail for an administered pricing event defined through APEVENT.


Primary Key Columns

Name

APEVENTID

REGIONID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

APEVENTID

NUMBER(22,0)

X

Unique identifier for this administered pricing event

REGIONID

VARCHAR2(10)

X

Date-Time of the first Dispatch Interval to which the administered event applies

LASTCHANGED

DATE

 

Date Time of the final Dispatch Interval to which the administered event applies

ENERGYAPFLAG

NUMBER(1,0)

 

flag indicating if the apevent covers an energy AP

RAISE6SECAPFLAG

NUMBER(1,0)

 

flag indicating if the apevent covers a raise6sec AP

RAISE60SECAPFLAG

NUMBER(1,0)

 

flag indicating if the apevent covers a raise60sec AP

RAISE5MINAPFLAG

NUMBER(1,0)

 

flag indicating if the apevent covers a raise5min AP

RAISEREGAPFLAG

NUMBER(1,0)

 

flag indicating if the apevent covers a raisereg AP

LOWER6SECAPFLAG

NUMBER(1,0)

 

flag indicating if the apevent covers a lower6sec AP

LOWER60SECAPFLAG

NUMBER(1,0)

 

flag indicating if the apevent covers a lower60sec AP
flag indicating if the apevent covers a lower5min AP
flag indicating if the apevent covers a lowerreg AP
flag indicating if the apevent covers a lower60sec AP

LOWER5MINAPFLAG

NUMBER(1,0)

 

flag indicating if the apevent covers a lower5min AP

LOWERREGAPFLAG

NUMBER(1,0)

 

flag indicating if the apevent covers a lowerreg AP

RAISE1SECAPFLAG

NUMBER(3,0)

 

Flag indicating if the APEvent covers a Raise1Sec AP

LOWER1SECAPFLAG

NUMBER(3,0)

 

Flag indicating if the APEvent covers a Lower1Sec AP