Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
139
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
STROBJINSTANCE
VARCHAR2(256) —
—
is24H
NUMBER(1)
NOT NULL
Whether the PM data is collected in
24-hour or 15-minute increments.
Values are:
1: 24 hour
0: 15-minute
24-hour or 15-minute increments.
Values are:
1: 24 hour
0: 15-minute
1.1.131
ONS1530x_LO_PM_Table
The ONS1530x_LO_PM_Table contains information about the ONS 1530x low-order PM
parameters.
parameters.
For medium, large, and high-end configurations, this table is partitioned.
Primary key: ONS1530x_LO_PM_PK
Tablespace: ONS153xx_DATA_TABLESPACE
Table 1-127: ONS1530x_LO_PM_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NEDBAccessID
NUMBER(10)
NOT NULL
NE database access ID.
ModuleType
NUMBER(8)
NOT NULL
Module type.
PhysicalLoc
NUMBER(20)
NOT NULL
Physical location.
NEIFINDEX
NUMBER(20)
NOT NULL
—
TimeStamp
DATE
NOT NULL
—
NEBBE
VARCHAR2(40)
—
Background block error.
NEES
VARCHAR2(40)
—
Errored seconds.
NESES
VARCHAR2(40)
—
Severely errored seconds.
NEUAS
VARCHAR2(40)
—
Unavailable seconds.
FEBBE
VARCHAR2(40)
—
Background block error (far end).
FEES
VARCHAR2(40)
—
Errored seconds (far end).
FESES
VARCHAR2(40)
—
Severely errored seconds (far end).
FEUAS
VARCHAR2(40)
—
Unavailable seconds (far end).
OBJECTTYPE
NUMBER(10)
—
Object type.
STROBJINSTANCE
VARCHAR2(256)
—
—