Table: NETWORK_OUTAGEDETAIL

NETWORK_OUTAGEDETAIL

Name

NETWORK_OUTAGEDETAIL

Comment

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


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

ELEMENTID

EQUIPMENTID

EQUIPMENTTYPE

OUTAGEID

STARTTIME

SUBSTATIONID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

OUTAGEID

NUMBER(15,0)

X

ID uniquely identifying the outage

SUBSTATIONID

VARCHAR(30)

X

The substation this equipment is located at

EQUIPMENTTYPE

VARCHAR(10)

X

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)

X

A unique identifier for this equipment at this substation, and based on its type

STARTTIME

DATE

X

The planned starting date and time of the outage

ENDTIME

DATE

 

The planned ending date and time of the outage

SUBMITTEDDATE

DATE

 

The date and time this outage was first submitted

OUTAGESTATUSCODE

VARCHAR(10)

 

A code representing the status of the outage.
The OUTAGESTATUSCODE table will store a detailed description of each code.

RESUBMITREASON

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

NUMBER(15,0)

 

The new outage id created from a resubmit.

RECALLTIMEDAY

NUMBER(10,0)

 

The recall time in minutes during the day

RECALLTIMENIGHT

NUMBER(10,0)

 

The recall time in minutes during the night

LASTCHANGED

TIMESTAMP(3)

 

The time that this record was last changed

REASON

VARCHAR2(100)

 

The reason provided by the asset owner for this outage

ISSECONDARY

NUMBER(1,0)

 

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

DATE

 

The actual starting date/time of the outage

ACTUAL_ENDTIME

DATE

 

The actual ending date/time of the outage

COMPANYREFCODE

VARCHAR2(20)

 

The asset owners reference code for this outage

ELEMENTID

NUMBER(15,0)

X

Equipment element id