Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
302
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
Table.
ModuleType
NUMBER(8)
DEFAULT 0
Module type.
PhysicalLoc
NUMBER(20)
DEFAULT 0
Physical location.
TcaEventType
NUMBER(5)
NOT NULL
Type of TCA. Valid types can be found
in the TCA_Event_Type_
in the TCA_Event_Type_
Table.
TcaLocation
VARCHAR2(20)
DEFAULT ‘Not
Applicable’
Applicable’
Displays near or far end TCA location.
TcaPeriod
VARCHAR2(20)
DEFAULT ‘Not
Applicable’
Applicable’
Displays TCA period: 15 minutes or 24
hours.
hours.
TcaValue
VARCHAR2(20)
—
Displays TCA value, which crossed
threshold.
threshold.
Direction
VARCHAR2(10)
DEFAULT
‘N/A’
‘N/A’
Displays direction of the line, Rx or Tx.
TimeStamp
DATE
NOT NULL
Prime Optical time stamp.
NEEventTimeStamp DATE
NOT NULL
NE time stamp.
ModelType
NUMBER(10)
DEFAULT 0
Model type.
ObjectType
NUMBER(10)
DEFAULT 0
Object type.
StrObjInstance
VARCHAR2(256) —
StrObjInstance name.
1.1.246
TCA_Event_Type_Table
The TCA_Event_Type_Table contains static information about TCA events.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-235: TCA_Event_Type_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NE_Model_Index
NUMBER(10)
NOT NULL
Index used in the
TCA_Event_Type_Table.
TCA_Event_Type_Table.
TCA_Number
NUMBER(10)
NOT NULL
TCA number.
TCA_Type
VARCHAR2(64)
—
TCA type.
TCA_CTM_Type
VARCHAR2(64)
—
TCA Prime Optical type.
TCA_TMF_Type
VARCHAR2(64)
—
TCA TMF type.