Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
56
1.1.26 Circuit_UPSR_BS_Tbl
The Circuit_UPSR_BS_Tbl shows information about the UPSR and SNCP selectors in the
Prime Optical database.
Prime Optical database.
Primary key: None
Foreign key: FK_CIRCUIT_UPSR_BS_NPID
Tablespace: BASE_DATA_TABLESPACE
In CTM R9.2, the Circuit_UPSR_BS_Tbl is present in the database, but it is blank and
contains no data. When a future Prime Optical patch is applied, the
Circuit_UPSR_BS_Tbl will populate during the discovery of NEs and circuits.
Circuit_UPSR_BS_Tbl will populate during the discovery of NEs and circuits.
Table 1-25: Circuit_UPSR_BS_Tbl
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
CktNodeId
NUMBER(10)
NOT NULL
Node ID of the circuit's source node.
This is an internal field.
This is an internal field.
CktUniqueId
NUMBER(10)
NOT NULL
Unique number within each source
node. This is an internal field. The
CktNodeId and CktUniqueId combine
to form a circuit ID that is unique in
the network.
node. This is an internal field. The
CktNodeId and CktUniqueId combine
to form a circuit ID that is unique in
the network.
NodeId
NUMBER(10)
NOT NULL
The status of the device.
WorkingCtpIfindex
NUMBER(20)
NOT NULL
—
WorkingCtpPhysicalLoc NUMBER(20)
NOT NULL
—
ProtectCtpIfindex
NUMBER(20)
NOT NULL
—
ProtectCtpPhysicalLoc
NUMBER(20)
NOT NULL
—
CurrentIsWorking
NUMBER(2)
NOT NULL
—
SwitchState
NUMBER(2)
NOT NULL
—
NPID
NUMBER(10)
DEFAULT 0
Network partition ID.
1.1.27 Circuit_VCG_Tbl
The Circuit_VCG_Tbl contains the inventory of virtual concatenation group circuits.