APEVENTREGION
APEVENTREGION is the Region detail for an administered pricing event defined through APEVENT.
Package
FORCE_MAJEURE
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| APEVENTID |
numeric(22, 0)  |
int |
Unique identifier for this administered pricing event |
| REGIONID |
varchar(10) |
varchar(10) |
Date-Time of the first Dispatch Interval to which the administered event applies |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date Time of the final Dispatch Interval to which the administered event applies |
| ENERGYAPFLAG |
numeric(1, 0) |
tinyint |
flag indicating if the apevent covers an energy AP |
| RAISE6SECAPFLAG |
numeric(1, 0) |
tinyint |
flag indicating if the apevent covers a raise6sec AP |
| RAISE60SECAPFLAG |
numeric(1, 0) |
tinyint |
flag indicating if the apevent covers a raise60sec AP |
| RAISE5MINAPFLAG |
numeric(1, 0) |
tinyint |
flag indicating if the apevent covers a raise5min AP |
| RAISEREGAPFLAG |
numeric(1, 0) |
tinyint |
flag indicating if the apevent covers a raisereg AP |
| LOWER6SECAPFLAG |
numeric(1, 0) |
tinyint |
flag indicating if the apevent covers a lower6sec AP |
| LOWER60SECAPFLAG |
numeric(1, 0) |
tinyint |
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 |
numeric(1, 0) |
tinyint |
flag indicating if the apevent covers a lower5min AP |
| LOWERREGAPFLAG |
numeric(1, 0) |
tinyint |
flag indicating if the apevent covers a lowerreg AP |
| LOWER1SECAPFLAG |
numeric(3, 0) |
tinyint |
Flag indicating if the APEvent covers a Lower1Sec AP |
| RAISE1SECAPFLAG |
numeric(3, 0) |
tinyint |
Flag indicating if the APEvent covers a Raise1Sec AP |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| APEVENTREGION_LCX |
nonclustered |
LASTCHANGED |
| APEVENTREGION_PK |
clustered, unique, primary key |
APEVENTID, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_APEVENTREGION_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_APEVENTREGION |
clustered, unique, primary key |
APEVENTID, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| APEVENTREGION_LCX |
nonclustered |
LASTCHANGED |
| PK_APEVENTREGION |
clustered, unique, primary key |
APEVENTID, REGIONID |