Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
183
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
EquipmentState
NUMBER(1)
DEFAULT 1
State of the module. Values are:
0: Not Present
1: Mismatch
2: Loading
3: Failed
4: Standby
5: Active
6: Empty
7: Deleted
8: Present
0: Not Present
1: Mismatch
2: Loading
3: Failed
4: Standby
5: Active
6: Empty
7: Deleted
8: Present
EntityID
NUMBER(10)
—
Entity ID assigned to the module.
HardwareRevision
VARCHAR2(7)
—
Manufacturer/hardware revision.
CleiCode
VARCHAR2(20)
—
CLEI code for the card.
InventoryCode
VARCHAR2(40)
DEFAULT
NULL
NULL
Provisionable inventory code.
ProductId
VARCHAR2(20)
DEFAULT
NULL
NULL
Product ID.
VersionId
VARCHAR2(20)
DEFAULT
NULL
NULL
Version ID.
LastInterfaceChange
NUMBER(20)
DEFAULT 0
Last interface change time stamp.
1.1.153
ONS15454_OTN_Fec_PM_Table
The ONS15454_OTN_Fec_PM_Table is used for OC-N PM data where the module type is
an OC-N line card.
an OC-N line card.
For medium, large, and high-end configurations, this table is partitioned.
Primary key: ONS15454_OTNFEC_PM_PK
Tablespace: ONS15454_DATA_TABLESPACE
Table 1-149 : ONS15454_OTN_Fec_PM_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NEDBAccessID
NUMBER(10)
NOT NULL
ID used to access the
ONS15454_OTN_Fec_PM_Table; same as
NEDBAccessID in the NE_Info_Table.
ONS15454_OTN_Fec_PM_Table; same as
NEDBAccessID in the NE_Info_Table.
ModuleType
NUMBER(4)
NOT NULL
Module type.