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. |
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. |
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). |
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. |