Database Schema
The adapter uses several database views to load information about individual outages and outages information summaries by areas.
CUSTOMERS_SERVED
This materialized view contains the number of customers served by the utility for different geographic areas.
Field
Data Type
Description
AREA_TYPE
VARCHAR2
Geographic area type.
AREA
VARCHAR2
Geographic area name/identifier.
CUST_SERVED
NUMBER
Number of customers served by the utility in this area.
 
CURRENT_AFFECTED_CUSTOMERS
This materialized view contains the list of customers currently affected by outages for different geographic areas.
Field
Data Type
Description
CID
VARCHAR2
NMS customer identifier.
BEGIN_TIME
DATE
Outage start time.
EST_REST_TIME
DATE
Estimated restoration time (ERT).
EVENT_IDX
NUMBER
NMS outage event index.
<AREA_TYPE>
VARCHAR2
Geographic area name/identifier of the affected customer for the area type specified by column name.
The number of these columns depends on the number of used area types. Column name is arbitrary but for convenience AREA_TYPE values from the CUSTOMERS_SERVED view can be used.
 
GEOGRAPHIC_OUTAGES
This view is used to load for publishing information about individual outages.
Field
Data Type
Description
OUTAGE_TYPE
VARCHAR2
Outage type. Populated with values from TE_STATUSES.DESCRIPTION.
STATUS
VARCHAR2
Outage status. Populated with values from TE_VALID_STATES.DESCRIPTION.
NUM_CUSTOMERS_OUT
NUMBER
Number of customers affected by this outage.
BEGIN_TIME
DATE
Outage start time.
EST_REST_TIME
DATE
Estimated restoration time (ERT) for this outage.
CAUSE
VARCHAR2
Primary outage cause.
GEOMETRY
MDSYS.SDO_GEOMETRY
Outage location.
STATE
NUMBER
Outage state bitmask.
EVENT_IDX
NUMBER
NMS outage identifier (event index).
 
GEOGRAPHIC_OUTAGE_AREAS
This view is used to load for publishing outage information summarized by geographic areas.
Field
Data Type
Description
AREA_TYPE
VARCHAR2
Geographic area type.
Should match the value from CUSTOMERS_SERVED.AREA_TYPE.
AREA
VARCHAR2
Geographic area name/identifier.
CUST_SERVED
NUMBER
Number of customers served by the utility in this area
CUST_OUT
NUMBER
Number of affected customers for the area.
NUM_OUTAGES
NUMBER
Number of outage events affecting the area.
EARLIEST_BEGIN_TIME
DATE
Earliest outage begin time for the area.
LATEST_EST_REST_TIME
DATE
Latest estimated restoration time (ERT) for the area.
GEOMETRY
MDSYS.SDO_GEOMETRY
Area boundaries polygon.
 
Note: Materialized views are refreshed by the adapter before loading outage information by executing PL/SQL procedure UPDATE_OUTAGE_MAP_DATA.