NETWORK_OUTAGEDETAIL
Lists asset owners planned outages for transmission equipment. This also includes details for transmission equipment that will not have an outage, but associated secondary equipment has an outage and a related constraint set may be invoked. This scenario is indicated by the ISSECONDARY field in the table.
Package
NETWORK
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| OUTAGEID |
numeric(15, 0)  |
int |
ID uniquely identifying the outage |
| SUBSTATIONID |
varchar(30) |
varchar(30) |
The substation this equipment is located at |
| EQUIPMENTTYPE |
varchar(10) |
varchar(10) |
The type of equipment. Valid values are: LINE = Line TRANS = Transformer CB = Circuit breaker ISOL = Isolator CAP = Capacitor REAC = Reactor UNIT = Unit |
| EQUIPMENTID |
varchar(30) |
varchar(30) |
A unique identifier for this equipment at this substation, and based on its type |
| STARTTIME |
datetime(3) |
datetime2(0) |
The planned starting date and time of the outage |
| ENDTIME |
datetime(3) |
datetime2(0) |
The planned ending date and time of the outage |
| SUBMITTEDDATE |
datetime(3) |
datetime2(0) |
The date and time this outage was first submitted |
| OUTAGESTATUSCODE |
varchar(10) |
varchar(10) |
A code representing the status of the outage. The OUTAGESTATUSCODE table will store a detailed description of each code. |
| RESUBMITREASON |
varchar(50) |
varchar(50) |
Changes to an outage key details may require the outage to be resubmitted. A new outage id will then be allocated and the outage will be reassessed. This field will detail the reason for the change. |
| RESUBMITOUTAGEID |
numeric(15, 0) |
int |
The new outage id created from a resubmit. |
| RECALLTIMEDAY |
numeric(10, 0) |
int |
The recall time in minutes during the day |
| RECALLTIMENIGHT |
numeric(10, 0) |
int |
The recall time in minutes during the night |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The time that this record was last changed |
| REASON |
varchar(100) |
varchar(100) |
The reason provided by the asset owner for this outage |
| ISSECONDARY |
numeric(1, 0) |
tinyint |
1 = The outage is for a secondary piece of equipment that has an associated constraint set. The transmission equipment is still in service. 0 = The outage is for the transmission equipment |
| ACTUAL_STARTTIME |
datetime(3) |
datetime2(0) |
The actual starting date/time of the outage |
| ACTUAL_ENDTIME |
datetime(3) |
datetime2(0) |
The actual ending date/time of the outage |
| COMPANYREFCODE |
varchar(20) |
varchar(20) |
The asset owners reference code for this outage |
| ELEMENTID |
numeric(15, 0) |
bigint |
Equipment element id |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| NETWORK_OUTAGEDETAIL_LCX |
nonclustered |
LASTCHANGED |
| PK_NETWORK_OUTAGEDETAIL |
clustered, unique, primary key |
OUTAGEID, ELEMENTID, SUBSTATIONID, EQUIPMENTTYPE, EQUIPMENTID, STARTTIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_NETWORK_OUTAGEDETAIL_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_NETWORK_OUTAGEDETAIL |
clustered, unique, primary key |
OUTAGEID, ELEMENTID, SUBSTATIONID, EQUIPMENTTYPE, EQUIPMENTID, STARTTIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_NETWORK_OUTAGEDETAIL_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_NETWORK_OUTAGEDETAIL |
clustered, unique, primary key |
OUTAGEID, ELEMENTID, SUBSTATIONID, EQUIPMENTTYPE, EQUIPMENTID, STARTTIME |