Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
266
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
SevErrSecs
NUMBER(10)
—
Number of severely errored seconds
encountered by SONET/SDH section in
the interval.
encountered by SONET/SDH section in
the interval.
SevErrFramingSecs
NUMBER(10)
—
Number of severely errored framing
seconds encountered by SONET/SDH
section in the interval.
seconds encountered by SONET/SDH
section in the interval.
ErrSecs
NUMBER(10)
—
Number of errored seconds
encountered by SONET/SDH section in
the interval.
encountered by SONET/SDH section in
the interval.
CodeViolations
NUMBER(12)
—
Number of code violations encountered
by SONET/SDH section in the interval.
by SONET/SDH section in the interval.
ModelType
NUMBER(5)
NOT NULL
Model type as defined by the object
mapper.
mapper.
ObjectType
NUMBER(10)
NOT NULL
Object type as defined by the object
mapper.
mapper.
1.1.199
ONS15600_ENET_PM_Table
The ONS 15600_ENET_PM_Table is used for ENET PM data where the module type is an
ENET line card.
ENET line card.
Primary key: ONS15600_ENET_PM_PK
Tablespace: ONS15600_DATA_TABLESPACE
Table 1-195: ONS15600_ENET_PM_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NEDBAccessID
NUMBER(10)
NOT NULL
ID to access this table for an NE; same as
NEDBAccessID in the NE_INFO_TABLE.
NEDBAccessID in the NE_INFO_TABLE.
ModuleType
NUMBER(4)
NOT NULL
Module type for which the TM refers.
PhysicalLoc
NUMBER(20)
DEFAULT 0
Physical location.
NEIfIndex
NUMBER(20)
NOT NULL
Table index for the interface.
Timestamp
DATE
NOT NULL
Time stamp that shows the interval at
which the set of statistics was stored.
which the set of statistics was stored.
NEIfPMStatus
NUMBER(20)
DEFAULT 0
Indicates status of the PM bucket. Values
are:
0: Valid period
Other: Bit mask Value
are:
0: Valid period
Other: Bit mask Value
inMaintenance NUMBER(1)
—
Whether the NE was under maintenance
when the PM bucket was collected.
when the PM bucket was collected.