APEVENT
APEVENT is the driving data defining the existence and timeframes of an administered pricing event.
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 |
| EFFECTIVEFROMINTERVAL |
datetime(3) |
datetime2(0) |
Date Time of the first Dispatch Interval to which the administered event applies |
| EFFECTIVETOINTERVAL |
datetime(3) |
datetime2(0) |
Date Time of the final Dispatch Interval to which the administered event applies |
| REASON |
varchar(2000) |
varchar(2000) |
Description of the driver for the Event |
| STARTAUTHORISEDBY |
varchar(15) |
varchar(15) |
Authorising staff for start of AP event |
| STARTAUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Date-Time start authorised |
| ENDAUTHORISEDBY |
varchar(15) |
varchar(15) |
Authorising staff for end of AP event |
| ENDAUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Date Time end authorised |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date-Time the record was last modified |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| APEVENT_LCX |
nonclustered |
LASTCHANGED |
| APEVENT_PK |
clustered, unique, primary key |
APEVENTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_APEVENT_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_APEVENT |
clustered, unique, primary key |
APEVENTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| APEVENT_LCX |
nonclustered |
LASTCHANGED |
| PK_APEVENT |
clustered, unique, primary key |
APEVENTID |