Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
278
Table 1-201: OSS_Alarm_Filter_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
AlarmFilterId
NUMBER(4)
NOT NULL
Unique alarm filter ID for this table.
FilterName
VARCHAR2(128) NOT NULL
UNIQUE
Filter profile name.
AlarmSeverity
NUMBER(1)
DEFAULT 0
Minimum severity of alarms that are
forwarded to the OSS. Values are:
1: Not reported alarm clear
2: Not reported alarm declared
3: Not alarmed
4: Warning
5: Minor
6: Major
7: Critical
forwarded to the OSS. Values are:
1: Not reported alarm clear
2: Not reported alarm declared
3: Not alarmed
4: Warning
5: Minor
6: Major
7: Critical
EventReportingFlag
NUMBER(1)
DEFAULT 0
Whether events should be forwarded
to the Operations Support System
(OSS). Values are:
0: No
1: Yes
to the Operations Support System
(OSS). Values are:
0: No
1: Yes
AlarmReportingFlag NUMBER(1)
DEFAULT 1
Whether alarms should be forwarded
on the OSS connection. Values are:
0: Disabled
1: Enabled
on the OSS connection. Values are:
0: Disabled
1: Enabled
PMReportingFlag
NUMBER(1)
DEFAULT 0
Whether PM data should be
forwarded on the OSS connection.
Values are:
0: Disabled
1: Enabled
forwarded on the OSS connection.
Values are:
0: Disabled
1: Enabled
1.1.212
OSS_Alarm_Fltr_AID_Deny_Tbl
The OSS_Alarm_Fltr_AID_Deny_Tbl contains information about which AIDs are denied
for specific EFD profiles. If one EFD profile denies more than one AID, the table contains
more than one entry for that EFD profile. The AID ID corresponds to the AID stored in
the OSS_AID_ENUM_Table.
for specific EFD profiles. If one EFD profile denies more than one AID, the table contains
more than one entry for that EFD profile. The AID ID corresponds to the AID stored in
the OSS_AID_ENUM_Table.
Primary key: OSS_ALARM_FLTR_AID_DENY_TBL_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-202: OSS_Alarm_Fltr_AID_Deny_Tbl
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description