Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
29
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
AlarmEventType
NUMBER(5)
NOT NULL
Type of alarm or event. The
Alarm_Event_Type_ENUM_Table
lists valid types. The range is from 1
to n.
Alarm_Event_Type_ENUM_Table
lists valid types. The range is from 1
to n.
AlarmEventTimeStamp DATE
NOT NULL
Date and time when the alarm or
event was generated.
event was generated.
AlarmEventCause
NUMBER(4)
NOT NULL
Cause of alarm or event. The
Alarm_Event_Cause_Table lists valid
types. The range is from 1 to n.
Alarm_Event_Cause_Table lists valid
types. The range is from 1 to n.
AlarmEventSeverity
NUMBER(1)
NOT NULL
Severity level of the alarm.
ServiceEffecting
NUMBER(1)
NOT NULL
Values are:
0: Alarm does not affect service
1: Alarm affects service
2: Unknown
0: Alarm does not affect service
1: Alarm affects service
2: Unknown
OtherInfo
VARCHAR2(512) DEFAULT
Not
applicable
applicable
Display string of alarm or event.
ModuleType
NUMBER(8)
DEFAULT 0
Module type.
PhysicalLoc
NUMBER(20)
DEFAULT 0
Physical location.
NEEventTimeStamp
DATE
NOT NULL
Time stamp of the NE event.
ModelType
NUMBER(10)
DEFAULT 0
Model type.
ObjectType
NUMBER(10)
DEFAULT 0
Model type.
StrObjInstance
VARCHAR2(256) —
StrObjInstance name.
Direction
VARCHAR2(8)
DEFAULT
NULL
NULL
TL1 direction.
Location
VARCHAR2(4)
DEFAULT
NULL
NULL
TL1 location.
1.1.9 Alarm_Event_Type_ENUM_Table
The Alarm_Event_Type_ENUM_Table statically maps alarm and event type indexes to
strings.
strings.
Primary key: ALARM_EVENT_TYPE_ENUM_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-9: Alarm_Event_Type_ENUM_Table
Column Name Oracle Data Type
Integrity
Constraints
Constraints
Description