Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
244
1.1.180
ONS155xx_DCRP_Definition_Table
The ONS155xx_DCRP_Definition_Table stores the definition of all discrepancies
supported within ONS15501, ONS 15530, or ONS 15540 management. The table is
statically populated at the install time.
supported within ONS15501, ONS 15530, or ONS 15540 management. The table is
statically populated at the install time.
Primary key: ONS155XX_DCRP_DEF_PK
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-176: ONS155xx_DCRP_Definition_Table
Column Name
Oracle Data Type
Integrity
Constraints
Constraints
Description
DcrpTypeDBID
NUMBER(4)
NOT NULL
Unique sequence number generated by
database; the link between this table
and other tables that contain
discrepancy data.
database; the link between this table
and other tables that contain
discrepancy data.
DcrpName
VARCHAR2(64)
NOT NULL
Unique name for the discrepancy.
DcrpSeverity
NUMBER(1)
DEFAULT 1
Severity for the discrepancy. Values are:
1: High
2: Medium
3: Low
1: High
2: Medium
3: Low
DcrpProbCause
VARCHAR2(256)
DEFAULT
NULL
NULL
Probable cause of the discrepancy.
DcrpRecAction
VARCHAR2(256)
DEFAULT
NULL
NULL
Recommended action.
1.1.181
ONS155xx_DCRP_Table
The ONS155xx_DCRP_Table contains the discrepancy instances of each type for the
ONS 155xx.
ONS 155xx.
Primary key: ONS155XX_DCRP_PK
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-177 : ONS155xx_DCRP_Table
Column Name
Oracle Data Type
Integrity
Constraints
Constraints
Description
DcrpDBID
NUMBER(10)
NOT NULL
Unique ID generated by the database
to identify a discrepancy.
to identify a discrepancy.
DcrpTypeDBID
NUMBER(4)
NOT NULL
Discrepancy TypeID from
Dcrp_Definition.
Dcrp_Definition.
DcrpIdentifier
VARCHAR2(64)
DEFAULT
Identifier for a discrepancy of a