Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
141
1.1.133
ONS1530x_NE_Inventory_Table
The ONS1530x_NE_Inventory_Table contains information about the ONS 1530x
equipment inventory table.
equipment inventory table.
Primary key: ONS1530x_NE_INVENTORY_TABLE_PK
Tablespace: ONS153xx_DATA_TABLESPACE
Table 1-129: ONS1530x_NE_Inventory_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NEDBAccessID
NUMBER(10)
NOT NULL
ID used to access the
ONS1530x_NE_Inventory_Table; same
as NEDBAccessID in the NE_Info_Table.
ONS1530x_NE_Inventory_Table; same
as NEDBAccessID in the NE_Info_Table.
Type
NUMBER(10)
—
Equipment type.
PhysicalLoc
NUMBER(20)
NOT NULL
Physical location of the card.
ModuleName
NUMBER(10)
—
Equipment name.
ServiceState
VARCHAR2(40)
—
State of the module. Values are:
0: In Service
1: Out of Service
2: Out of Service By Maintenance
3: Service N/A
4: Out of Service Pending
0: In Service
1: Out of Service
2: Out of Service By Maintenance
3: Service N/A
4: Out of Service Pending
SoftwareVersion
VARCHAR2(16)
—
Software version of the module.
SerialNumber
VARCHAR2(16)
—
Serial number of the module.
HardwareVersion
VARCHAR2(16)
—
Hardware version of the module.
InstallState
VARCHAR2(40)
—
State of the slot. Values are:
0: Empty
1: Installed and Expected
2: Expected and Not Installed
3: Installed and Not Expected
4: Mismatch of Installed and Expected
5: Unavailable
6: Unknown
0: Empty
1: Installed and Expected
2: Expected and Not Installed
3: Installed and Not Expected
4: Mismatch of Installed and Expected
5: Unavailable
6: Unknown
ExpectedModule
NUMBER(10)
—
Expected module in the slot.