Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
175
Table 1-144: ONS15454_INVENTORY_NOTES_Table
Column Name
Oracle Data Type
Integrity
Constraints
Constraints
Description
SERIALNUMBER
VARCHAR2(16)
NOT NULL
—
NOTE
VARCHAR2(4000)
—
—
INSERTED DATE
—
—
—
1.1.149
ONS15454_IPSLA_PM_Table
Primary key: ONS15454_IPSLA_PM_PK
Tablespace: ONS15454_DATA_TABLESPACE
Table 1-145: ONS15454_IPSLA_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 NE_INFO_TABLE.
NEDBAccessID in NE_INFO_TABLE.
ModuleType
NUMBER(4)
NOT NULL
Module type to which this PM pertains.
PhysicalLoc
NUMBER(20)
DEFAULT 0
Physical location.
NEIfIndex
NUMBER(20)
NOT NULL
Interface table index for the interface.
Same as IfStaticIndex of Interface_Table.
Same as IfStaticIndex of Interface_Table.
TimeStamp
DATE
NOT NULL
Interval timestamp for which the set of
statistics is stored.
statistics is stored.
NEIfPMStatus
NUMBER(20)
DEFAULT 0
Indicates status of the PM bucket. Values
are:
0: Valid period
Other: Bit mask value. This information is
about PM statistics.
are:
0: Valid period
Other: Bit mask value. This information is
about PM statistics.
inMaintenance NUMBER(1)
—
Indicates whether the NE is in
Maintenance state when the PM bucket is
collected.
Maintenance state when the PM bucket is
collected.
fifteenMinThre
sholdMask
sholdMask
NUMBER(10)
—
Threshold value for 15-minute PM bucket.
thresholdList
VARCHAR2(102
4)
4)
—
Threshold value for daily PM bucket.
rttMonStatsSta
rtTimeIndex
rtTimeIndex
NUMBER(20)
DEFAULT –1
Received invalid word error count.
rttMonStatsCo
mpletions
mpletions
NUMBER(20)
DEFAULT –1
Received disparity error count.