Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
306
1.1.252
TP_SRV
The TP_SRV describes the TP service as an end-to-end circuit.
Primary key: TP_SRV_PK
Tablespace: NGXP_DATA_TABLESPACE
Table 1-241 : TP_SRV
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
SERVICEID
NUMBER(10)
NOT NULL
Service ID. This is an internal field.
CTMUNIQID
NUMBER(10)
NOT NULL
Unique Prime Optical ID used to identify
the contributor in the service. This is an
internal field.
the contributor in the service. This is an
internal field.
SERVICENAME
VARCHAR2(256
)
)
—
Service name.
DESCRIPTION
VARCHAR2(256
)
)
—
Description of the service has been
provisioned.
provisioned.
CTMWORKING
LSPUNIQID
LSPUNIQID
NUMBER(10)
NOT NULL
Unique Prime Optical ID used to reference
the LSP contributors for the working path.
This is an internal field.
the LSP contributors for the working path.
This is an internal field.
CTMPROTECTL
SPUNIQID
SPUNIQID
NUMBER(10)
NOT NULL
Unique Prime Optical ID used to reference
the LSP contributors for the protected
path.
the LSP contributors for the protected
path.
DISCOVERYSTA
TE
TE
NUMBER(1)
NOT NULL
Discovery status of the service. Values are:
0: Partial
1: Discovered
0: Partial
1: Discovered
OPERSTATE
NUMBER(1)
NOT NULL
Summary of the operational state of all
the contributors.
the contributors.
ISPROTECTED
NUMBER(1)
NOT NULL
Whether the service is protected or
unprotected. Values are:
0: Unprotected
1: Protected
unprotected. Values are:
0: Unprotected
1: Protected
WLSPNUM
NUMBER(10)
NOT NULL
LSP number used for the working path.
PLSPNUM
NUMBER(10)
NOT NULL
LSP number used for the protected path.
TXBANDWIDTH NUMBER(20)
NOT NULL
Transmission bandwidth value has been
provisioned.
provisioned.
RXBANDWIDTH NUMBER(20)
NOT NULL
Receiver bandwidth value has been
provisioned.
provisioned.
TUNKEY
VARCHAR2(256
)
)
—
Tunnel key identifying the service.
EPCOUNT
NUMBER(4)
NOT NULL
Number of the endpoint contributors. This
is an internal field.
is an internal field.