Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
181
1.1.151
ONS15454_Match_STMT_PM_Table
The ONS15454_Match_STMT_PM_Table is used for PM data where the module type is
an ML-series card.
an ML-series card.
Primary key: None
Tablespace: ONS15454_DATA_TABLESPACE
Table 1-147: ONS15454_Match_STMT_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 to which the PM 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.
CBQosMatchPr
ePolicyPkt64
ePolicyPkt64
NUMBER(20)
DEFAULT 0
—
CBQosMatchPr
ePolicyByte64
ePolicyByte64
NUMBER(20)
DEFAULT 0
—
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
hour or 15-minute increments. Values are:
1: 24 hour
0: 15-minute
ModelType
NUMBER(10)
DEFAULT 0
Model type.
ObjectType
NUMBER(10)
DEFAULT 0
Object type.
StrObjInstance
VARCHAR2(256
)
)
—
StrObjInstance name.
InvalidityList
VARCHAR2(102
4)
4)
—
Invalidity list for PM data.