Table Of Contents
Database Schema Tables
1.1 CTM Sequence Numbers
1.2 CTM Tables (Non-MGX Voice Gateway)
1.2.1 Ack_Table
1.2.2 Active_Alarm_Table
1.2.3 Additional_Device_Info
1.2.4 Admin_Job_Table
1.2.5 Alarm_Ack_Config_Table
1.2.6 Alarm_Count_Table
1.2.7 Alarm_Event_Cause_Table
1.2.8 Alarm_Event_Table
1.2.9 Alarm_Event_Type_ENUM_Table
1.2.10 APC_Domain_Table
1.2.11 APS_Group_Table
1.2.12 Audit_Log_Mapping_Table
1.2.13 Audit_Log_Table
1.2.14 BLSR_Node
1.2.15 BLSR_Span
1.2.16 BLSR_Table
1.2.17 Bridge_Group_Table
1.2.18 C_MetaData
1.2.19 C_MetaData_Attr_Presentation
1.2.20 C_MetaData_Col
1.2.21 C_MetaData_Col_Custom
1.2.22 C_MetaData_Filter
1.2.23 C_MetaData_Grp_Presentation
1.2.24 C_MetaData_NETypes
1.2.25 C_Property_Sheet_Info_Table
1.2.26 C_Tab_Metadata_Info_Table
1.2.27 C_Tab_Metadata_Table
1.2.28 Cerent_NE_Group_Table
1.2.29 Circuit_BS_Tbl
1.2.30 Circuit_Ctp_Tbl
1.2.31 Circuit_Dest_Tbl
1.2.32 Circuit_Size_Table
1.2.33 Circuit_Span_BS_Tbl
1.2.34 Circuit_Span_Tbl
1.2.35 Circuit_Tbl
1.2.36 Circuit_VCG_Tbl
1.2.37 Circuit_VLAN_Tbl
1.2.38 CLISession_Command_History_Tbl
1.2.39 CORBA_Functions_Table
1.2.40 CORBA_GW_Active_User_Table
1.2.41 CORBA_Interface_Table
1.2.42 CORBA_Permission_Table
1.2.43 CTC_Model_Const_Table
1.2.44 CTC_UserProfile_Table
1.2.45 CTM_Config_Table
1.2.46 CTM_Unique_ObjectType_Table
1.2.47 CTM_Unknown_User_Table
1.2.48 Custom_View_Table
1.2.49 DB_Auditing_Table
1.2.50 DB_CONNECTION_CONFIG_TABLE
1.2.51 DB_History_Table
1.2.52 DB_OperationID_Table
1.2.53 DB_Pruning_Table
1.2.54 Debug_Module_Mapping_Table
1.2.55 Debug_Module_Table
1.2.56 Deleted_User_Table
1.2.57 Diskspace_Usage_Table
1.2.58 Domain_Table
1.2.59 Ems_Alarm_Table
1.2.60 Enum_Table
1.2.61 EQPT_Info_Table
1.2.62 Eqpt_Relationship_Table
1.2.63 Error_Log_Table
1.2.64 Forwarding_Table
1.2.65 GNE_Table
1.2.66 Group_Info_Table
1.2.67 GW_SNMP_OSS_Info_Table
1.2.68 GWCORBA_PM_Mapping_Table
1.2.69 IF_Cross_Connect
1.2.70 IF_DWDM_Channel_Group
1.2.71 IF_Optical_Phy_Config_Table
1.2.72 IFIndex_Rule_Table
1.2.73 Interface_APS_Info
1.2.74 Interface_DWDM_Frequency
1.2.75 Interface_Stack_Table
1.2.76 Interface_Table
1.2.77 IOS_Parser_Static_Tree_Table
1.2.78 L2_FrontPort_Table
1.2.79 L2_Interface_QoSClass_Table
1.2.80 L2_Interface_Table
1.2.81 L2_Ipsla_Attribute_Table
1.2.82 L2_Ipsla_Table
1.2.83 L2QoSTemplate_QoSClass_Table
1.2.84 L2QoSTemplate_Table
1.2.85 L2Topology_Circuits_Table
1.2.86 L2Topology_Table
1.2.87 L2_Vlan_Table
1.2.88 Link_Layer_Mapping_Table
1.2.89 Link_Table
1.2.90 Managed_Et_Table
1.2.91 Map_Coordinate_Table
1.2.92 Map_Cust_Table
1.2.93 Map_Image_Table
1.2.94 Map_Link_Table
1.2.95 MIB2_Interface_Table
1.2.96 MLPPP_Bundle_Data
1.2.97 MLPPP_Link_Data
1.2.98 MLPPP_Mux_Data
1.2.99 Model_Type_Table
1.2.100 Module155xx_Community_String
1.2.101 Module155xx_VTOID_Table
1.2.102 Module_Type_Mll_Info
1.2.103 Module_Type_Table
1.2.104 NE_Audit_Trail_Table
1.2.105 NE_INFO_TABLE
1.2.106 NE_Inventory_Table
1.2.107 NE_Model_State_Table
1.2.108 NE_Model_Type_Table
1.2.109 NE_Module_Level_Debug
1.2.110 NE_Port_Status_Table
1.2.111 NE_SNMPv3_Groups_Table
1.2.112 NE_SNMPv3_NFILTER_TABLE
1.2.113 NE_SNMPv3_PROXY_FWD_TABLE
1.2.114 NE_SNMPv3_PROXY_TRAP_FWD_TABLE
1.2.115 NE_SNMPv3_Users_Table
1.2.116 NE_SNMPv3_Views_Table
1.2.117 NE_SNMPv3_TRAP_DEST_TABLE
1.2.118 NE_Swimage_Table
1.2.119 Network_Partition_Table
1.2.120 Object_Relationship_Table
1.2.121 ObjectAttributeTable
1.2.122 ObjectTypeTable
1.2.123 ONS15216_Active_User_Table
1.2.124 ONS15216_NE_Inventory_Table
1.2.125 ONS15216_Privilege_Table
1.2.126 ONS15216_User_Table
1.2.127 ONS1530x_HO_PM_Table
1.2.128 ONS1530x_IP_PM_Table
1.2.129 ONS1530x_LO_PM_Table
1.2.130 ONS1530x_MS_PM_Table
1.2.131 ONS1530x_NE_Inventory_Table
1.2.132 ONS1530x_RS_PM_Table
1.2.133 ONS15454_327_NE_Table
1.2.134 ONS15454_8B10B_PM_Table
1.2.135 ONS15454_Active_User_Table
1.2.136 ONS15454_CBQoS_Info_Table
1.2.137 ONS15454_CLASSMAP_PM_Table
1.2.138 ONS15454_CMS_Storage_Table
1.2.139 ONS15454_COS_PM_Table
1.2.140 ONS15454_DS1_PM_Table
1.2.141
Table 1-138 ONS15454_DS1_PM_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
NEDBAccessID
|
NUMBER(10)
|
NOT NULL
|
ID to access this table for an NE; same as NEDBAccessID in NE_INFO_TABLE.
|
ModuleType
|
NUMBER(4)
|
NOT NULL
|
Module type to which this PM pertains.
|
PhysicalLoc
|
NUMBER(20)
|
DEFAULT 0
|
Physical location.
|
NEIfIndex
|
NUMBER(20)
|
NOT NULL
|
Table index for the interface; same as IfStaticIndex in the Interface_Table.
|
TimeStamp
|
DATE
|
NOT NULL
|
Time stamp that shows the interval at which the set of statistics was stored.
|
NEIfPMStatus
|
NUMBER(20)
|
DEFAULT 0
|
Status of the PM bucket. Values are:
0: Valid period
Other: Bit mask value (information about PM statistics)
|
inMaintenance
|
NUMBER(1)
|
—
|
Whether the NE was under maintenance when the PM bucket was collected.
|
fifteenMinThresholdMask
|
NUMBER(10)
|
—
|
Threshold value for the PM bucket for the 15-minute interval.
|
thresholdList
|
VARCHAR2(1024)
|
—
|
Threshold value for the PM bucket for the day.
|
DS1LineCodeViolations
|
NUMBER(10)
|
DEFAULT -1
|
Number of line code violations (LCVs) encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1LineErrSecs
|
NUMBER(10)
|
DEFAULT -1
|
Number of errored seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1LineSevErrSecs
|
NUMBER(10)
|
DEFAULT -1
|
Number of severely errored seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1RxPathAIS
|
NUMBER(10)
|
DEFAULT -1
|
Number of alarm indication signal seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS3XM card and the DS1 line card.
|
DS1RxPathErrSecs
|
NUMBER(10)
|
DEFAULT -1
|
Number of errored seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS3XM card and the DS1 line card.
|
DS1RxPathSAS
|
NUMBER(10)
|
DEFAULT -1
|
Number of severely alarmed seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS3XM card and the DS1 line card.
|
DS1RxPathSevErrSecs
|
NUMBER(10)
|
DEFAULT -1
|
Number of severely errored seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS3XM card and the DS1 line card.
|
DS1RxPathUnavailableSecs
|
NUMBER(10)
|
DEFAULT -1
|
Number of unavailable seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS3XM card and the DS1 line card.
|
DS1RxPathCodeViolations
|
NUMBER(10)
|
DEFAULT -1
|
Number of LCVs encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS3XM card and the DS1 line card.
|
DS1TxPathAIS
|
NUMBER(10)
|
DEFAULT -1
|
Number of alarm indication signal seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1TxPathErrSecs
|
NUMBER(10)
|
DEFAULT -1
|
Number of errored seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1TxPathSAS
|
NUMBER(10)
|
DEFAULT -1
|
Number of severely alarmed seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1TxPathSevErrSecs
|
NUMBER(10)
|
DEFAULT -1
|
Number of severely errored seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1TxPathUnavailableSecs
|
NUMBER(10)
|
DEFAULT -1
|
Number of unavailable seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1TxPathCodeViolations
|
NUMBER(10)
|
DEFAULT -1
|
Number of line code violations encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1LineLOSS
|
NUMBER(10)
|
DEFAULT -1
|
Loss of signal seconds line. Count of 1-second intervals containing one or more LOS defects.
|
IS24H
|
NUMBER(1)
|
NOT NULL
|
Whether the PM data is collected in 24-hour or 15-minute increments. Values are:
1: 24 hour
0: 15-minute
|
FeDS1Fd1PathCV
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path CV (ESF).
|
FeDS1Fd1PathES
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path ES (ESF).
|
FeDS1Fd1PathESA
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path ES-Type A(ESF).
|
FeDS1Fd1PathESB
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path ES-Type B (ESF).
|
FeDS1Fd1PathSES
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path SES (ESF).
|
FeDS1Fd1PathSEFS
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path SEFS (ESF).
|
FeDS1Fd1PathCSS
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path Controlled Slip Seconds (ESF).
|
FeDS1Fd1PathUAS
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path UAS (ESF).
|
FeDS1Fd1PathFC
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path FC (ESF).
|
FeDS1Fd1LineES
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end line ES (ESF).
|
ModelType
|
NUMBER(10)
|
DEFAULT 0
|
Model type.
|
ObjectType
|
NUMBER(10)
|
DEFAULT 0
|
Object type.
|
StrObjInstance
|
VARCHAR2(256)
|
—
|
StrObjInstance name.
|
InvalidityList
|
VARCHAR2(1024)
|
—
|
Invalidity list for PM data.
|
FeDS1FdlEsNP
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end network performance errored seconds.
|
FeDS1FdlSesNP
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end network performance severely errored seconds.
|
FeDS1FdlUasNP
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end network performance unavailable seconds.
|
DS1EsNP
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end network performance errored seconds.
|
DS1SesNP
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end network performance severely errored seconds.
|
DS1UasNP
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end network performance unavailable seconds.
|
DS1RxPathBBE
|
NUMBER(10)
|
DEFAULT -1
|
Number of receive path background block errors.
|
DS1RxPathESR
|
NUMBER(10)
|
DEFAULT -1
|
Receive path errored seconds ratio.
|
DS1RxPathSESR
|
NUMBER(10)
|
DEFAULT -1
|
Receive path severely errored seconds ratio.
|
DS1RxPathBBER
|
NUMBER(10)
|
DEFAULT -1
|
Receive path background block error ratio.
|
DS1TxPathBBE
|
NUMBER(10)
|
DEFAULT -1
|
Number of transmit path background block errors.
|
DS1TxPathESR
|
NUMBER(10)
|
DEFAULT -1
|
Transmit path errored seconds ratio.
|
DS1TxPathSESR
|
NUMBER(10)
|
DEFAULT -1
|
Transmit path severely errored seconds ratio.
|
DS1TxPathBBER
|
NUMBER(10)
|
DEFAULT -1
|
Transmit path background block error ratio.
|
DS1RxPathFC
|
NUMBER(10)
|
DEFAULT -1
|
Receive path failure count.
|
FeDS1FdlPathESR
|
NUMBER(10)
|
DEFAULT -1
|
Far-end path errored seconds ratio.
|
FeDS1FdlPathSESR
|
NUMBER(10)
|
DEFAULT -1
|
Far-end path severely errored seconds ratio.
|
DS1TxPathFC
|
NUMBER(10)
|
DEFAULT -1
|
Transmit path failure count.
|
Table 1-139 ONS15454_DS1_PM_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
NEDBAccessID
|
NUMBER(10)
|
NOT NULL
|
ID to access this table for an NE; same as NEDBAccessID in NE_INFO_TABLE.
|
ModuleType
|
NUMBER(4)
|
NOT NULL
|
Module type to which this PM pertains.
|
PhysicalLoc
|
NUMBER(20)
|
DEFAULT 0
|
Physical location.
|
NEIfIndex
|
NUMBER(20)
|
NOT NULL
|
Table index for the interface; same as IfStaticIndex in the Interface_Table.
|
TimeStamp
|
DATE
|
NOT NULL
|
Time stamp that shows the interval at which the set of statistics was stored.
|
NEIfPMStatus
|
NUMBER(20)
|
DEFAULT 0
|
Status of the PM bucket. Values are:
0: Valid period
Other: Bit mask value (information about PM statistics)
|
inMaintenance
|
NUMBER(1)
|
—
|
Whether the NE was under maintenance when the PM bucket was collected.
|
fifteenMinThresholdMask
|
NUMBER(10)
|
—
|
Threshold value for the PM bucket for the 15-minute interval.
|
thresholdList
|
VARCHAR2(1024)
|
—
|
Threshold value for the PM bucket for the day.
|
DS1LineCodeViolations
|
NUMBER(10)
|
DEFAULT -1
|
Number of line code violations (LCVs) encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1LineErrSecs
|
NUMBER(10)
|
DEFAULT -1
|
Number of errored seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1LineSevErrSecs
|
NUMBER(10)
|
DEFAULT -1
|
Number of severely errored seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1RxPathAIS
|
NUMBER(10)
|
DEFAULT -1
|
Number of alarm indication signal seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS3XM card and the DS1 line card.
|
DS1RxPathErrSecs
|
NUMBER(10)
|
DEFAULT -1
|
Number of errored seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS3XM card and the DS1 line card.
|
DS1RxPathSAS
|
NUMBER(10)
|
DEFAULT -1
|
Number of severely alarmed seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS3XM card and the DS1 line card.
|
DS1RxPathSevErrSecs
|
NUMBER(10)
|
DEFAULT -1
|
Number of severely errored seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS3XM card and the DS1 line card.
|
DS1RxPathUnavailableSecs
|
NUMBER(10)
|
DEFAULT -1
|
Number of unavailable seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS3XM card and the DS1 line card.
|
DS1RxPathCodeViolations
|
NUMBER(10)
|
DEFAULT -1
|
Number of LCVs encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS3XM card and the DS1 line card.
|
DS1TxPathAIS
|
NUMBER(10)
|
DEFAULT -1
|
Number of alarm indication signal seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1TxPathErrSecs
|
NUMBER(10)
|
DEFAULT -1
|
Number of errored seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1TxPathSAS
|
NUMBER(10)
|
DEFAULT -1
|
Number of severely alarmed seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1TxPathSevErrSecs
|
NUMBER(10)
|
DEFAULT -1
|
Number of severely errored seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1TxPathUnavailableSecs
|
NUMBER(10)
|
DEFAULT -1
|
Number of unavailable seconds encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1TxPathCodeViolations
|
NUMBER(10)
|
DEFAULT -1
|
Number of line code violations encountered by a DS1 interface in the interval. This field is valid for the DS1 interface on the DS1 line card only.
|
DS1LineLOSS
|
NUMBER(10)
|
DEFAULT -1
|
Loss of signal seconds line. Count of 1-second intervals containing one or more LOS defects.
|
IS24H
|
NUMBER(1)
|
NOT NULL
|
Whether the PM data is collected in 24-hour or 15-minute increments. Values are:
1: 24 hour
0: 15-minute
|
FeDS1Fd1PathCV
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path CV (ESF).
|
FeDS1Fd1PathES
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path ES (ESF).
|
FeDS1Fd1PathESA
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path ES-Type A(ESF).
|
FeDS1Fd1PathESB
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path ES-Type B (ESF).
|
FeDS1Fd1PathSES
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path SES (ESF).
|
FeDS1Fd1PathSEFS
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path SEFS (ESF).
|
FeDS1Fd1PathCSS
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path Controlled Slip Seconds (ESF).
|
FeDS1Fd1PathUAS
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path UAS (ESF).
|
FeDS1Fd1PathFC
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end path FC (ESF).
|
FeDS1Fd1LineES
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end line ES (ESF).
|
ModelType
|
NUMBER(10)
|
DEFAULT 0
|
Model type.
|
ObjectType
|
NUMBER(10)
|
DEFAULT 0
|
Object type.
|
StrObjInstance
|
VARCHAR2(256)
|
—
|
StrObjInstance name.
|
InvalidityList
|
VARCHAR2(1024)
|
—
|
Invalidity list for PM data.
|
FeDS1FdlEsNP
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end network performance errored seconds.
|
FeDS1FdlSesNP
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end network performance severely errored seconds.
|
FeDS1FdlUasNP
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end network performance unavailable seconds.
|
DS1EsNP
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end network performance errored seconds.
|
DS1SesNP
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end network performance severely errored seconds.
|
DS1UasNP
|
NUMBER(10)
|
DEFAULT -1
|
Number of far-end network performance unavailable seconds.
|
DS1RxPathBBE
|
NUMBER(10)
|
DEFAULT -1
|
Number of receive path background block errors.
|
DS1RxPathESR
|
NUMBER(10)
|
DEFAULT -1
|
Receive path errored seconds ratio.
|
DS1RxPathSESR
|
NUMBER(10)
|
DEFAULT -1
|
Receive path severely errored seconds ratio.
|
DS1RxPathBBER
|
NUMBER(10)
|
DEFAULT -1
|
Receive path background block error ratio.
|
DS1TxPathBBE
|
NUMBER(10)
|
DEFAULT -1
|
Number of transmit path background block errors.
|
DS1TxPathESR
|
NUMBER(10)
|
DEFAULT -1
|
Transmit path errored seconds ratio.
|
DS1TxPathSESR
|
NUMBER(10)
|
DEFAULT -1
|
Transmit path severely errored seconds ratio.
|
DS1TxPathBBER
|
NUMBER(10)
|
DEFAULT -1
|
Transmit path background block error ratio.
|
DS1RxPathFC
|
NUMBER(10)
|
DEFAULT -1
|
Receive path failure count.
|
FeDS1FdlPathESR
|
NUMBER(10)
|
DEFAULT -1
|
Far-end path errored seconds ratio.
|
FeDS1FdlPathSESR
|
NUMBER(10)
|
DEFAULT -1
|
Far-end path severely errored seconds ratio.
|
DS1TxPathFC
|
NUMBER(10)
|
DEFAULT -1
|
Transmit path failure count.
|
ONS15454_DS3_PM_Table
1.2.142 ONS15454_ENET_PM_Table
1.2.143 ONS15454_FC_PM_Table
1.2.144 ONS15454_GFP_PM_Table
1.2.145 ONS15454_IFX_PM_Table
1.2.146 ONS15454_IPSLA_PM_Table
1.2.147 ONS15454_LAG_PM_Table
1.2.148 ONS15454_Match_STMT_PM_Table
1.2.149 ONS15454_NE_Inventory_Table
1.2.150 ONS15454_OTN_Fec_PM_Table
1.2.151 ONS15454_OTN_Path_PM_Table
1.2.152 ONS15454_OTN_Sec_PM_Table
1.2.153 ONS15454_PHY_LAYER_PM_Table
1.2.154 ONS15454_Police_PM_Table
1.2.155 ONS15454_POS_PM_Table
1.2.156 ONS15454_Privilege_Table
1.2.157 ONS15454_RPR_PM_Table
1.2.158 ONS15454_SONET_Line_PM_Table
1.2.159 ONS15454_SONET_Path_PM_Table
1.2.160 ONS15454_SONET_Sec_PM_Table
1.2.161 ONS15454_SONET_VT_PM_Table
1.2.162 ONS15454_User_Table
1.2.163 ONS15454SDH_E1_PM_Table
1.2.164 ONS15454SDH_E3_PM_Table
1.2.165 ONS15454SDH_E4_PM_Table
1.2.166 ONS15454SDH_HO_PM_Table
1.2.167 ONS15454SDH_LO_PM_Table
1.2.168 ONS15454SDH_MS_PM_Table
1.2.169 ONS15454SDH_RS_PM_Table
1.2.170 ONS15501_NE_Explorer_Table
1.2.171 ONS15501_Opt_Power_PM_Table
1.2.172 ONS155xx_CDL_Flow_Config
1.2.173 ONS155xx_CDL_IF_Config
1.2.174 ONS155xx_CDL_PM_Table
1.2.175 ONS155xx_Circuit_CC_Tbl
1.2.176 ONS155xx_Circuit_Path_Tbl
1.2.177 ONS155xx_Circuit_Stack_Tbl
1.2.178 ONS155xx_Condtype_Map
1.2.179 ONS155xx_DCRP_Definition_Table
1.2.180 ONS155xx_DCRP_Table
1.2.181 ONS155xx_Discovery_Info_Table
1.2.182 ONS155xx_Ether_Hist_PM_Table
1.2.183 ONS155xx_FCM_PE_PM_Table
1.2.184 ONS155xx_Flash_Device_Table
1.2.185 ONS155xx_Flash_Partition_Table
1.2.186 ONS155xx_GRA_CC_To_CKT_CC_Tbl
1.2.187 ONS155xx_Granular_CC_Tbl
1.2.188 ONS155xx_IF_Circuit_Params_Tbl
1.2.189 ONS155xx_IF_Optical_Power
1.2.190 ONS155xx_IF_Phy_Info_Table
1.2.191 ONS155xx_NE_Info_Table
1.2.192 ONS155xx_NE_Type_Table
1.2.193 ONS155xx_Opt_Power_PM_Table
1.2.194 ONS155xx_Path_Hop_Tbl
1.2.195 ONS155xx_Path_Tbl
1.2.196 ONS155xx_Phy_PM_Table
1.2.197 ONS155xx_SONET_Sec_PM_Table
1.2.198 ONS15600_ENET_PM_Table
1.2.199 ONS15600_POS_PM_Table
1.2.200 ONS15600_Sonet_Line_PM_Table
1.2.201 ONS15600_Sonet_Path_PM_Table
1.2.202 ONS15600_Sonet_Sec_PM_Table
1.2.203 ONS15600SDH_HO_PM_Table
1.2.204 ONS15600SDH_MS_PM_Table
1.2.205 ONS15600SDH_RS_PM_Table
1.2.206 ONS158xx_Amplifier_PM_Table
1.2.207 ONS158xx_BCS_PM_Table
1.2.208 ONS158xx_CMP_PM_Table
1.2.209 ONS158xx_IOC_W_PM_Table
1.2.210 ONS158xx_LAC_Active_User_Table
1.2.211 ONS158xx_LAC_Log_Status_Table
1.2.212 ONS158xx_LAC_Log_Table
1.2.213 ONS158xx_LAC_Profile_Table
1.2.214 ONS158xx_LAC_User_Table
1.2.215 ONS158xx_LSM_PM_Table
1.2.216 ONS158xx_NE_IP_Table
1.2.217 ONS158xx_OAD_PM_Table
1.2.218 ONS158xx_OADM_PM_Table
1.2.219 ONS158xx_OSU_PM_Table
1.2.220 ONS158xx_OTS_PTP_Table
1.2.221 ONS158xx_PM_ACT_MOD_Table
1.2.222 ONS158xx_PTPType_Table
1.2.223 ONS158xx_SCF_PM_Table
1.2.224 ONS158xx_TimeStamp_PM_Table
1.2.225 ONS158xx_Transponder_PM_Table
1.2.226 ONS158xx_WD_PM_Table
1.2.227 ONS158xx_WD_RX_PM_Table
1.2.228 Operation_Permissions_Table
1.2.229 Operations_Table
1.2.230 OSS_Active_User_Table
1.2.231 OSS_AID_ENUM_Table
1.2.232 OSS_Alarm_Filter_Table
1.2.233 OSS_Alarm_Fltr_AID_Deny_Tbl
1.2.234 OSS_Alarm_Fltr_TID_Deny_Tbl
1.2.235 OSS_CORBA_User_Table
1.2.236 OSS_User_Table
1.2.237 Password_History_Table
1.2.238 PatchCord_Table
1.2.239 PM_ATTR_Value_Mapping_Table
1.2.240 PM_ATTRID_Mapping_Table
1.2.241 PM_Category_View_Table
1.2.242 PM_Cerent_Info_Table
1.2.243 PM_Historical_Appointments
1.2.244 PM_Metadata_Info_Table
1.2.245 PM_Metadata_Table
1.2.246 PMService_Associated_Tab_Table
1.2.247 Port_Channel_Table
1.2.248 Port_Channel_Members_Table
1.2.249 Proxy_Server_Table
1.2.250 Purged_NE_Table
1.2.251 Roll_Table
1.2.252 Schedule_Info_Table
1.2.253 Server_Monitor_Table
1.2.254 Server_Parameter_Table
1.2.255 Service_Availability_Table
1.2.256 Subnetwork_Table
1.2.257 SVC_Config_Table
1.2.258 SVC_Info_Table
1.2.259 SVC_NEModel_Table
1.2.260 SVC_Package_Table
1.2.261 SVC_Property_Table
1.2.262 Sway_User_Port_Table
1.2.263 Table_Info
1.2.264 TCA_Event_Table
1.2.265 TCA_Event_Type_Table
1.2.266 Threshold_Table
1.2.267 TL1_Encoding_Table
1.2.268 TL1_Tunnel_Gateway_Table
1.2.269 TL1_Tunnel_Info_Table
1.2.270 Transaction_Log_Table
1.2.271 Unmanaged_NE_Inventory_Table
1.2.272 User_Map_Table
1.2.273 User_NE_Table
1.2.274 User_Preference_Table
1.2.275 User_Table
1.2.276 User_Type_Table
1.2.277 Version_Table
1.2.278 Version_Table_Enhanced
1.2.279 Wavelength_Table
1.2.280 Wavemux_NE
1.2.281 XML_Parser_Static_Tree_Table
1.3 CTM Tables (MGX Voice Gateway)
1.3.1 AAL1_CROSS_CONN
1.3.2 AAL1_DATA_PROFILE
1.3.3 AAL2_5_DATA_PROFILE
1.3.4 AAL2_CROSS_CONN
1.3.5 AAL5_CROSS_CONN
1.3.6 ADDR_CUG
1.3.7 APS
1.3.8 ATM_ADDR
1.3.9 ATM_CONNECTION
1.3.10 ATM_PHY
1.3.11 AU4TUG3
1.3.12 AUSM_PORT
1.3.13 AUSM_PORT_DATA
1.3.14 AXIST3_LINE_DATA
1.3.15 AXSM_CONN_DATA
1.3.16 AXSME_CONN_DATA
1.3.17 CALL_CONTROL_PROFILE
1.3.18 CARD_DESC
1.3.19 Card_Uptime_Data
1.3.20 Chanfr_Conn_Data
1.3.21 COLL_ERR_LOG
1.3.22 COLL_INFO
1.3.23 COLL_SUMM_LIST
1.3.24 COLLSVR_ERR_LOG
1.3.25 COLLSVR_INFO
1.3.26 COLLSVR_ROLE
1.3.27 COMP_FILE_LIST
1.3.28 CONN_TEMPL_PARAM
1.3.29 CONN_TEMPLATE
1.3.30 CONN_ROUTE_STATISTICS
1.3.31 CONNECTION
1.3.32 CONTROLLER
1.3.33 CORBA_DISCONNECT
1.3.34 CUG
1.3.35 CURRENT_ROUTE_ELEM
1.3.36 CWM_ROLE_INFO
1.3.37 DBKR_TEMP
1.3.38 DC_LOOKUP_FIELD
1.3.39 DC_LOOKUP_TABLE
1.3.40 DC_VXSM_RSCUTIL
1.3.41 DESTROYNODE
1.3.42 DS0_CONNECT
1.3.43 DS1_AU3_PATH_DATA
1.3.44 DS1_AU4_PATH_DATA
1.3.45 DS1_DS3_AU3_PATH_DATA
1.3.46 DS1_DS3_AU3_PIF_DATA
1.3.47 DS1_DS3_STS1_IMA_LINK_DATA
1.3.48 DS1_DS3_STS1_PATH_DATA
1.3.49 DS1_DS3_STS1_PIF_DATA
1.3.50 DS1_DS3LINE_IMA_LINK_DATA
1.3.51 DS1_DS3LINE_PATH_DATA
1.3.52 DS1_DS3LINE_PIF_DATA
1.3.53 DS1_T3LINE_PATH_DATA
1.3.54 DS1_TU11_AU3_PATH_DATA
1.3.55 DS1_TU11_AU3_PIF_DATA
1.3.56 DS1_TU11_AU4_PATH_DATA
1.3.57 DS1_TU11_AU4_PIF_DATA
1.3.58 DS1_VT_STS1_PATH_DATA
1.3.59 DS1_VT_STS1_PIF_DATA
1.3.60 DS1_TU11_AU3_IMA_LINK_DATA
1.3.61 DS1_TU11_AU4_IMA_LINK_DATA
1.3.62 DS1_VT_STS1_IMA_LINK_DATA
1.3.63 DS1LINE_PIF_DATA
1.3.64 DS3_AU3_PATH_DATA
1.3.65 DS3_AU3_PIF_DATA
1.3.66 DS3_AU4_PATH_DATA
1.3.67 DS3_AU4_PIF_DATA
1.3.68 DS3_STS1_PATH_DATA
1.3.69 DS3_STS1_PF_DATA
1.3.70 DS3LINE_PIF_DATA
1.3.71 DSP_STATUS
1.3.72 E1_AU3_PATH_DATA
1.3.73 E1_AU4_PATH_DATA
1.3.74 E1_TU12_AU3_PIF_DATA
1.3.75 E1_TU12_AU3_PATH_DATA
1.3.76 E1_TU12_AU4_PATH_DATA
1.3.77 E1_TU12_AU4_PIF_DATA
1.3.78 E1_TU12_AU3_IMA_LINK_DATA
1.3.79 E1_TU12_AU4_IMA_LINK_DATA
1.3.80 E1_VT_STS1_IMA_LINK_DATA
1.3.81 E1_VT_STS1_PATH_DATA
1.3.82 E1_VT_STS1_PIF_DATA
1.3.83 E1LINE_PIF_DATA
1.3.84 E3_AU3_PATH_DATA
1.3.85 E3_AU3_PIF_DATA
1.3.86 E3_AU4_PATH_DATA
1.3.87 E3_AU4_PIF_DATA
1.3.88 E3_STS1_PATH_DATA
1.3.89 E3_STS1_PIF_DATA
1.3.90 ELEMENT_TEMPL_PARAM
1.3.91 ELEMENT_TEMPLATE
1.3.92 FAX_RELAY
1.3.93 FILE_ERR_LOG
1.3.94 FILE_INFO
1.3.95 FILE_QUEUE_LOG
1.3.96 FILE_TRANSFER_LOG
1.3.97 FRP
1.3.98 IF_SHUTDOWN
1.3.99 IMA_GROUP
1.3.100 IMA_GROUP_DESC
1.3.101 IMA_LINK
1.3.102 IMA_LINK_DESC
1.3.103 IMAGROUP_PIF_DATA
1.3.104 LAPD_DS1_AU3_DATA
1.3.105 LAPD_DS1_AU4_DATA
1.3.106 LAPD_DS1_DS3_DATA
1.3.107 LAPD_DS1_VT_DATA
1.3.108 LAPD_E1_AU3_DATA
1.3.109 LAPD_E1_AU4_DATA
1.3.110 LAPD_E1_VT_STS1_Data
1.3.111 LAPD_T1E1_DATA
1.3.112 LAPD_T3E3_DATA
1.3.113 LAPD_TRUNK
1.3.114 LICENSE_IN_USE
1.3.115 LICENSE_POOL
1.3.116 LIF
1.3.117 LINE_DESC
1.3.118 LINEDISTRIBUTION
1.3.119 LINEDISTRIBUTION_DESC
1.3.120 LOOKUP_FIELD
1.3.121 LOOKUP_TABLE
1.3.122 MAINTLOG
1.3.123 MCARD_Table
1.3.124 MEGACO_CONFIG
1.3.125 MEGACO_DATA
1.3.126 MEGACO_EPH_TERM_DATA
1.3.127 MEGACO_PHY_TERM_DATA
1.3.128 MEGACO_PROFILE
1.3.129 MEGACO_TERM
1.3.130 MG_DNAME
1.3.131 MG_SUP_PRTCL
1.3.132 MGC_GRP
1.3.133 MGC_IP
1.3.134 MGC_RES
1.3.135 MGCG_PARAM
1.3.136 MGCG_PROTOCOL
1.3.137 MGX8880_NE_INFO_TABLE
1.3.138 MGX8880_SNMPV3_USERS_TABLE
1.3.139 MPBUNDLE
1.3.140 NETWORK
1.3.141 NETWORK_DESC
1.3.142 NHM_MANAGEABILITY
1.3.143 NHM_STATS
1.3.144 NODE_DESC
1.3.145 NODE_GROOM
1.3.146 NODE_PARENT
1.3.147 NODE_THRESH
1.3.148 PATH_DESC
1.3.149 PEND_FILE_LIST
1.3.150 PLCP
1.3.151 PNNI_IF
1.3.152 PNNI_NODAL_DATA
1.3.153 PNNI_PORT_DATA
1.3.154 PORT_DESC
1.3.155 PORT_QUEST
1.3.156 PPP_LINK
1.3.157 PROGRAM_TONE
1.3.158 PXM1E_CONN_DATA
1.3.159 PXM1E_LINE_DATA
1.3.160 PXM1E_PORT_DATA
1.3.161 PXM1ET1E1_PL_DATA
1.3.162 PXM1EE3_PL_DATA
1.3.163 PXM1ESONET_PL_DATA
1.3.164 PXM1ET3_PL_DATA
1.3.165 REDUNDANTCARD
1.3.166 RPM_CONNECTION
1.3.167 RPM_PORT
1.3.168 RSC_PART
1.3.169 RSC_POLICY
1.3.170 RTP_CONN
1.3.171 RUDP_SESSION
1.3.172 SCMCARDCOLLSTATUS
1.3.173 SCMDB_NODE_INFO
1.3.174 SCMNODECOLLSTATUS
1.3.175 SCTP_ADDR
1.3.176 SCTP_ASSOC
1.3.177 SCTP_ASSOCIATION_DATA
1.3.178 SCTP_GATEWAY_DATA
1.3.179 SENSOR_THRHD
1.3.180 SESSION_DATA
1.3.181 SESSION_GROUP
1.3.182 SESSION_SET
1.3.183 SHELF
1.3.184 SONET_LINE_DATA
1.3.185 SRCP_PARAM
1.3.186 SRCP_PEER
1.3.187 SRTFILTERLIST
1.3.188 SRTREPORTKEY
1.3.189 STAT_ENABLE
1.3.190 STATSDB_INFO
1.3.191 STATSDB_SCMCOLLSVR
1.3.192 STM1_PATH_DATA
1.3.193 STM1_PIF_DATA
1.3.194 STS1_PATH_DATA
1.3.195 STS1_PIF_DATA
1.3.196 STSDS3DS1PATH_DATA
1.3.197 STSVTGDS1PATH_DATA
1.3.198 SVC_CAC
1.3.199 SVC_OPERATION
1.3.200 SVC_PORT
1.3.201 SYNC_INFO
1.3.202 SYNC_LIST
1.3.203 TONE_DETECT
1.3.204 TONE_ID
1.3.205 TONE_PLAN
1.3.206 TRAP_FILTER
1.3.207 TU3_AU4_PATH_DATA
1.3.208 TU11_AU3_PATH_DATA
1.3.209 TU11_AU4_PATH_DATA
1.3.210 USER_CONNECTION
1.3.211 USER_CONN_DESC
1.3.212 USER_INFO
1.3.213 VIRTUAL_PORT
1.3.214 VISM_ANNOUNCE
1.3.215 VISM_CARD
1.3.216 VISM_CAS_BIT
1.3.217 VISM_CID
1.3.218 VISM_CID_DATA
1.3.219 VISM_CODEC
1.3.220 VISM_CONN_DATA
1.3.221 VISM_DS0
1.3.222 VISM_E1_LINE_DATA
1.3.223 VISM_ENDPT
1.3.224 VISM_HDLC
1.3.225 VISM_LAPD
1.3.226 VISM_LINE
1.3.227 VISM_MGC
1.3.228 VISM_MGCP
1.3.229 VISM_PROFILE
1.3.230 VISM_T1_LINE_DATA
1.3.231 VISM_TEMPLATE
1.3.232 VOICE_CONN
1.3.233 VT_STS1_PATH_DATA
1.3.234 VXSM_AS
1.3.235 VXSM_ASP
1.3.236 VXSM_ASP_IP
1.3.237 VXSM_BPVC_BW_DATA
1.3.238 VXSM_CARD
1.3.239 VXSM_CAS_PROFILE
1.3.240 VXSM_CAS_VARIANT
1.3.241 VXSM_CCD_PROFILE
1.3.242 VXSM_CODEC_DATA
1.3.243 VXSM_Codecpools
1.3.244 VXSM_DPNSS
1.3.245 VXSM_DPNSS_DLC
1.3.246 VXSM_DPNSS_DLC_E1_AU3_DATA
1.3.247 VXSM_DPNSS_DLC_E1_AU4_DATA
1.3.248 VXSM_DPNSS_DLC_E1_LINE_DATA
1.3.249 VXSM_DPNSS_DLC_E1_STS_DATA
1.3.250 VXSM_DPNSS_E1_AU3_DATA
1.3.251 VXSM_DPNSS_E1_AU4_DATA
1.3.252 VXSM_DPNSS_E1_LINE_DATA
1.3.253 VXSM_DPNSS_E1_STS_DATA
1.3.254 VXSM_DS0_UTIL_GW_DATA
1.3.255 VXSM_DS0_UTIL_VGW_DATA
1.3.256 VXSM_DS0_UTIL_DS1_LN_DATA
1.3.257 VXSM_DS0_UTIL_E1_LN_DATA
1.3.258 VXSM_DS0_UTIL_T3_LN_DATA
1.3.259 VXSM_DS0_UTIL_OC3_LN_DATA
1.3.260 VXSM_DS0_UTIL_STM1_LN_DATA
1.3.261 VXSM_DS0_UTIL_DS1_T3_DATA
1.3.262 VXSM_DS0_UTIL_DS1_STS_DATA
1.3.263 VXSM_DS0_UTIL_DS1_DS3_STS_DATA
1.3.264 VXSM_DS0_UTIL_DS1_AU3_DATA
1.3.265 VXSM_DS0_UTIL_DS1_AU4_DATA
1.3.266 VXSM_DS0_UTIL_E1_STS_DATA
1.3.267 VXSM_DS0_UTIL_E1_AU3_DATA
1.3.268 VXSM_DS0_UTIL_E1_AU4_DATA
1.3.269 VXSM_EPH_TERM_GW_DATA
1.3.270 VXSM_EPH_TERM_VGW_DATA
1.3.271 VXSM_EPH_TERM_BPVC_DATA
1.3.272 VXSM_EVENT_MAP
1.3.273 VXSM_FAX_RELAY
1.3.274 VXSM_Gateway_Rsrc
1.3.275 VXSM_GENERAL_CONFIG
1.3.276 VXSM_GSP_INST
1.3.277 VXSM_GSP_LINK
1.3.278 VXSM_GSP_LINK_SET
1.3.279 VXSM_GSP_LINK_TIMER
1.3.280 VXSM_GSP_POINT_CODE
1.3.281 VXSM_GSP_PROF_TIMER
1.3.282 VXSM_GSP_ROUTE
1.3.283 VXSM_GRT_ROUTE
1.3.284 VXSM_GTT_APP_GROUP
1.3.285 VXSM_GTT_GTA
1.3.286 VXSM_GTT_MAP
1.3.287 VXSM_GTT_PREF
1.3.288 VXSM_GTT_SEL
1.3.289 VXSM_IKE_PEER_AUTH
1.3.290 VXSM_IKE_TUNNEL
1.3.291 VXSM_IN_LINE_SIGNAL
1.3.292 VXSM_IPSEC_TUNNEL
1.3.293 VXSM_L3UA_ASP_DATA
1.3.294 VXSM_LINE_SIGNAL_TIMER
1.3.295 VXSM_MTP_LINKSLC_DATA
1.3.296 VXSM_NETWORK_INTERFACE
1.3.297 VXSM_OUT_LINE_SIGNAL
1.3.298 VXSM_OVER_LOAD_RSR_DATA
1.3.299 VXSM_PH1_PTRF_ASSOC
1.3.300 VXSM_PH2_PTRF_ASSOC
1.3.301 VXSM_PHASE1_PROPOSAL
1.3.302 VXSM_PHASE1_TRANSFORM
1.3.303 VXSM_PHASE2_PROPOSAL
1.3.304 VXSM_PHASE2_TRANSFORM
1.3.305 VXSM_PHY_GW_DATA
1.3.306 VXSM_PLFM_SYS_DATA
1.3.307 VXSM_PLFM_SCALAR_DATA
1.3.308 VXSM_PLFM_GW_RSC_DATA
1.3.309 VXSM_PVC_IP
1.3.310 VXSM_RTCP_ALERT_TRIGGER
1.3.311 VXSM_RTCP_CIPHERSUITE
1.3.312 VXSM_RTCP_PROFILE
1.3.313 VXSM_RTCP_PROFILE_CODEC
1.3.314 VXSM_RTP_CIPHERSUITE
1.3.315 VXSM_SCCP_DATA
1.3.316 VXSM_SCTP_CONFIG
1.3.317 VXSM_SECURITY_POLICY
1.3.318 VXSM_SPD_KEY_MGR_ASSOC
1.3.319 VXSM_TTY_PROFILE
1.3.320 VXSM_VBD_CALL_DATA
1.3.321 VXSM_VDB_PROFILE
1.3.322 VXSM_VIF
1.3.323 VXSM_VQM_GW_DATA
1.3.324 VXSM_VQM_VGW_DATA
1.3.325 VXSM_VQM_BPVC_DATA
1.3.326 VXSM_VQM_DS1_LN_DATA
1.3.327 VXSM_VQM_E1_LN_DATA
1.3.328 VXSM_VQM_T3_LN_DATA
1.3.329 VXSM_VQM_OC3_LN_DATA
1.3.330 VXSM_VQM_STM1_LN_DATA
1.3.331 VXSM_VQM_STS_DATA
1.3.332 VXSM_VQM_AU3_DATA
1.3.333 VXSM_VQM_AU4_DATA
1.3.334 VXSM_VQM_DS1_T3_DATA
1.3.335 VXSM_VQM_DS1_STS_DATA
1.3.336 VXSM_VQM_DS1_DS3_STS_DATA
1.3.337 VXSM_VQM_DS1_AU3_DATA
1.3.338 VXSM_VQM_DS1_AU4_DATA
1.3.339 VXSM_VQM_E1_STS_DATA
1.3.340 VXSM_VQM_E1_AU3_DATA
1.3.341 VXSM_VQM_E1_AU4_DATA
1.3.342 VXSM_XUA_AS
1.3.343 VXSM_XUA_AS_ROUTE
1.3.344 VXSM_XUA_AS_ROUTE_AS
1.3.345 VXSM_XUA_ASP
1.3.346 VXSM_XUA_ASP_AS
1.3.347 VXSM_XUA_INST
1.3.348 VXSM_XUA_LOCAL_IP
1.3.349 VXSM_XUA_QOS
1.3.350 VXSM_XUA_REMOTE_IP
1.3.351 XG_CONN_DATA
1.3.352 XG_DS3PATH_DATA
1.3.353 XG_LINE_DATA
1.3.354 XG_LINE_DS3_DATA
1.3.355 XG_PATH_DATA
1.3.356 XG_PL_DATA
1.3.357 XG_PORT_DATA
1.3.358 XGCP_DATA
1.3.359 XGCP_GW
1.3.360 XGCP_MGC
1.3.361 XGCP_PEER
1.4 NE Statistics-Related Tables
1.4.1 AXSM_CARD_DATA
1.4.2 AXSM_CONN_DATA
1.4.3 AXSM_LINE_DATA
1.4.4 AXSM_PORT_DATA
1.4.5 AXSME_CONN_DATA
1.4.6 AXSME_LINE_DATA
1.4.7 AXSME_PORT_DATA
1.4.8 AXSMESONET_PL_DATA
1.4.9 AXSMET1E1_PL_DATA
1.4.10 AXSMET3E3_PL_DATA
1.4.11 IMA_GROUP_DATA
1.4.12 IMA_LINK_DATA
1.4.13 LAPD_IN_DS1INDS3_DATA
1.4.14 LAPD_IN_DS1INVT_DATA
1.4.15 LAPDIN_T1E1_DATA
1.4.16 LAPD_IN_T3E3_DATA
1.4.17 MEGACO_DATA
1.4.18 MEGACO_EPH_TERM_DATA
1.4.19 MEGACO_PHY_TERM_DATA
1.4.20 SCMCARD
1.4.21 SCMCARDCOLL
1.4.22 SCMCARDCOLLHOST
1.4.23 SCMCARDENABLE
1.4.24 SCMCARDFAMILY
1.4.25 SCMCARDFAMILYDEF
1.4.26 SCMCARDFAMILYSTAT
1.4.27 SCMCARDTEMPLATE
1.4.28 SCMCOLLSVR
1.4.29 SCMCOLPAR
1.4.30 SCMCOLPARSTAT
1.4.31 SCMCOLPARSUBOBJ
1.4.32 SCMENABLETYPE
1.4.33 SCMIDMAP
1.4.34 SCMNODECOLL
1.4.35 SCMNODECOLLHOST
1.4.36 SCMNODEENABLE
1.4.37 SCMNODESTAT
1.4.38 SCMNODETEMPLATE
1.4.39 SCMOBJ
1.4.40 SCMSTAT
1.4.41 SCMSTATSKEY
1.4.42 SCMSUBOBJ
1.4.43 SCMDB_SCMCOLLSVR
1.4.44 SCMENABLELIST
1.4.45 SCMENABLESUBTYPE
1.4.46 SCMFRAGDATATABLES
1.4.47 SCMIDMAPDEF
1.4.48 SCMNODESTAT
1.4.49 SCMNODE
1.4.50 SCMOLDSTATKEY
1.4.51 SCMSTATKEY
1.4.52 SCMTABLEKEY
1.4.53 SCTP_ASSOCIATION_DATA
1.4.54 SCTP_GATEWAY_DATA
1.4.55 SESSION_DATA
1.4.56 SONET_LINE_DATA
1.4.57 SRTPERFKEY
1.4.58 SRTRPORTKEY
1.4.59 STATSDB_CONFIG
1.4.60 STS_DS3_DS1_PATH_DATA
1.4.61 STS_VTGROUP_DS1_PATH_DATA
1.4.62 XG_CONN_DATA
1.4.63 XGCP_DATA
1.4.64 XG_DS3PATH_DATA
1.4.65 XG_PATH_DATA
1.4.66 XG_PL_DATA
1.4.67 XG_PORT_DATA
Database Schema Tables
This chapter describes tables and table sequence numbers. It contains the following sections:
•
CTM Sequence Numbers
•CTM Tables (Non-MGX Voice Gateway)
•CTM Tables (MGX Voice Gateway)
•NE Statistics-Related Tables
1.1 CTM Sequence Numbers
Sequence numbers are Oracle integers of up to 38 digits that are defined in the database. A sequence generates a serial list of unique numbers for numeric columns in a database's tables. Sequences simplify application programming by automatically generating unique numerical values for the rows in one or in multiple tables. The sequence numbers used in the CTM schema are listed in the following table.
Table 1-1 Sequence Numbers used in the CTM Schema
Sequence Number
|
Description
|
ACKINDEX_SEQ
|
Used when an alarm acknowledgement is added to Ack_Table.
|
ACTIVEALARMINDEX_SEQ
|
Used when an alarm is added to the Active_Alarm_Table.
|
ALARMFILTERID_SEQ
|
Used when adding a filter profile name to the OSS_Alarm_Filter_Table.
|
BLSRID_SEQ
|
Used to generate ID number when adding a new BLS ring to the BLSR_Table.
|
COORDINDEX_SEQ
|
Used when adding a map coordinate to the Map_Coordinate_Table.
|
CKTSPANID_SEQ
|
Used when adding a circuit span to the Circuit_Span_Tbl.
|
CUSTOMIZATIONID_SEQ
|
Used when adding a map customization to the Map_Cust_Table.
|
DCRPDBID_SEQ
|
Used when discrepancies are added to the ONS155xx_Dcrp_Table.
|
DEVICEID_SEQ
|
Used when adding a device to Additional_Device_Info.
|
DT_TREENODEID_SEQ
|
Used when group or NE nodes are added to the Domain_Table.
|
EVENTINDEX_SEQ
|
Used while inserting alarms and events in the Alarm_Event_Table.
|
FILTER_ID_SEQ
|
Used when a filter is added to the Syslog_Filter_Table.
|
FLASHDEVDBID_SEQ
|
Used for the Flash devices in the ONS155xx_Flash_Device_Table.
|
FLASHPARTDBID_SEQ
|
Used for Flash devices in the ONS155xx_Flash_Partition_Table.
|
GNEID_SEQ
|
Used when a GNE is added to the GNE_Table.
|
GROUPID_SEQ
|
Used when groups are added to the Group_Info_Table.
|
IF_XC_SEQ
|
Used when adding cross-connects to the IF_Cross_Connect.
|
IFDACCESSID_SEQ
|
Used for parameters in the MIB2_Interface_Table.
|
IFSTACK_SEQ
|
Used for underlying/overlaying layer relationships in the Interface_Stack_Table.
|
JARID_SEQ
|
Used for the ONS15454_CMS_Storage_Table.
|
JOBID_SEQ
|
Used when a job is added to the Admin_Job_Table.
|
LINKID_SEQ
|
Used when adding a link to the Link_Table.
|
MAPIMAGEID_SEQ
|
Used when adding a map image to the Map_Image_Table.
|
MAPLINKID_SEQ
|
Used when adding a map link to the Map_Link_Table.
|
MGX8880_SNMP_INDEX_SEQ
|
Used when user connections are added to the User_Connection_Table.
|
NEDBACCESSID_SEQ
|
Used when NEs are added to the NE_INFO_TABLE.
|
NPID_SEQ
|
Used when adding a new network partition to Network_Partition_Table.
|
ONS155XX_CIRCUIT_CC_DBID_SEQ
|
Used for circuit-specific cross-connects in the ONS155xx_Circuit_CC_Tbl.
|
ONS155XX_GRANULAR_CC_DBID_SEQ
|
Used for NE-specific cross-connects in the ONS155xx_Granular_CC_Tbl.
|
ONS155XX_PATH_DBID_SEQ
|
Used for the ONS155xx_Path_Tbl.
|
QOSTEMPLATEID_SEQ
|
Used to generate a QoS template ID when a new QoS template is added.
|
SERVER_PARAMETER_SEQ
|
Used as parameter index in Server_Parameter_Table.
|
SID_SEQ
|
Used to generate a service ID when a service is added.
|
SUBNETID_SEQ
|
Used when adding a subnetwork to the Subnetwork_Table.
|
SYSLOG_MESSAGE_ID_SEQ
|
Used when a syslog message is added to Syslog_Message_Table.
|
TASKID_SEQ
|
Used when a task is added to the Admin_Job_Table.
|
TEMPLATE_DATA_ID_SEQ
|
Generates a sequential Primary Key ID (PKID) for each variable value added to the Template_Job_Data_Table.
|
TEMPLATE_JOB_DATA_ID_SEQ
|
Generates a sequential PKID for each variable added to the Template_Data_Table.
|
TEMPLATE_JOB_ID_SEQ
|
Used when a job is added to the Template_Job_Table.
|
TEMPLATE_ID_SEQ
|
Used when a template is added to the Template_Table.
|
TRANSID_SEQ
|
Used when adding a transaction to the NE_SWIMAGE_Table.
|
USERID_SEQ
|
Used when CTM users are added to the User_Table.
|
USERTYPEID_SEQ
|
Used when a new usertype is added to the User_Type_Table.
|
1.2 CTM Tables (Non-MGX Voice Gateway)
This section describes the non-MGX Voice Gateway database tables created by CTM, listed in alphabetical order.
MGX Voice Gateway database tables are described in CTM Tables (MGX Voice Gateway).
Note The following tables are partitioned in medium, large, and high-end configurations:
•ONS 1530x PM tables
•ONS 15454 PM tables
•ONS 155xx PM tables
•ONS 15600 PM tables
•ONS 158xx PM tables
1.2.1 Ack_Table
The Ack_Table provides information about the user who acknowledged an alarm and the time that the alarm was acknowledged.
Primary key: ALARM_ACK_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-2 Ack_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
AckIndex
|
NUMBER(10)
|
—
|
Index of the alarm acknowledgement. A unique sequence number whose value is saved in the database and incremented in memory. There is a single value of 0 for all unacknowledged alarms. Acknowledged alarms have an entry in this table and the AckIndex is stored in the AckIndex of the Active_Alarm_Table. Values are:
0: Unacknowledged
Any other number: Acknowledged
-1: Automatic Acknowledge
|
AckUserName
|
VARCHAR2(64)
|
—
|
Name of the user.
|
AckTimeStamp
|
DATE
|
—
|
Date and time of the acknowledgement.
|
IsAutoAck
|
NUMBER(1)
|
—
|
Whether acknowledgment is manual or automatic:
0: Manual
1: Automatic
|
1.2.2 Active_Alarm_Table
The Active_Alarm_Table contains information about all standing conditions on NEs.
Note For medium, large, and high-end configurations, this table is partitioned.
Primary key: ACTIVE_ALARM_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-3 Active_Alarm_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
NEDBAccessID
|
NUMBER(10)
|
NOT NULL
|
ID to access this table for an NE; same as NEDBAccessID in the NE_INFO_TABLE.
|
AlarmSeqNum
|
NUMBER(20)
|
NOT NULL
|
Unique sequence number of the alarm as referenced by the NE.
|
ModuleOrIfIndex
|
NUMBER(20)
|
NOT NULL
|
Unique long data type that identifies an interface in the NE; same as ifStaticIndex in the Interface_Table.
|
ActiveAlarmTimeStamp
|
DATE
|
NOT NULL
|
Date and time when the active alarm was generated.
|
ActiveAlarmType
|
NUMBER(5)
|
NOT NULL
|
Alarm event type. Values are rows of the Alarm_Event_Type_Enum_Table.
|
ActiveAlarmSeverity
|
NUMBER(1)
|
NOT NULL
|
Severity level of the alarm. Values are:
3: Not alarmed
4: Warning
5: Minor
6: Major
7: Critical
|
ActiveAlarmServEff
|
NUMBER(1)
|
NOT NULL
|
Values are:
0: Alarm does not affect service
1: Alarm affects service
2: Unknown
|
ActiveAlarmAdditionalInfo
|
VARCHAR2(512)
|
—
|
Additional information about the current alarm.
|
AckIndex
|
NUMBER(10)
|
NOT NULL
|
Index of the alarm acknowledgement.
|
ActiveAlarmFlag
|
NUMBER(1)
|
DEFAULT 0
|
Active alarm flag, which the server uses to synchronize the database to the NE information.
|
ActiveAlarmComment
|
VARCHAR2(2014)
|
—
|
Alarm comments.
|
ClearAlarmTimeStamp
|
DATE
|
DEFAULT NULL
|
Date and time when the alarm was cleared.
|
NEAlarmTimeStamp
|
DATE
|
NOT NULL
|
Date and time when the alarm was generated as viewed by the NE.
|
ActiveAlarmIndex
|
NUMBER(16)
|
NOT NULL
|
Unique alarm sequence number as created by the database.
|
ModuleType
|
NUMBER(8)
|
DEFAULT 0
|
Module type.
|
PhysicalLoc
|
NUMBER(20)
|
DEFAULT 0
|
Physical location.
|
Alarmstatus
|
NUMBER(1)
|
NOT NULL
|
Indiactes whether an alarm is active or clear. Values are:
0: Active
1: Clear
|
NEAlarmClearTimeStamp
|
DATE
|
—
|
When the NE alarm was cleared.
|
ExternalCondition
|
VARCHAR2(1024)
|
—
|
External environment condition for the NEs.
|
ModelType
|
NUMBER(10)
|
DEFAULT 0
|
Model type.
|
ObjectType
|
NUMBER(10)
|
DEFAULT 0
|
Object type.
|
StrObjectInstance
|
VARCHAR2(256)
|
—
|
StrObjInstance name.
|
Direction
|
VARCHAR2(8)
|
DEFAULT NULL
|
TL1 direction.
|
Location
|
VARCHAR2(4)
|
DEFAULT NULL
|
TL1 location.
|
1.2.3 Additional_Device_Info
The Additional_Device_Info contains information on additional devices.
Primary key: ADDITIONAL_DEVICE_INFO
Tablespace: BASE_DATA_TABLESPACE
Table 1-4 Additional_Device_Info
Column Name
|
Oracle Data
Type
|
Integrity Constraints
|
Description
|
DeviceID
|
NUMBER(10)
|
NOT NULL
|
Unique ID generated by the database.
|
NEDBAccessID
|
NUMBER(10)
|
NOT NULL
|
ID to access the Additional_Device_Info table; same as NEDBAccessID in the NE_INFO_TABLE.
|
PhyLoc
|
NUMBER(20)
|
NOT NULL
|
Physical location of the card.
|
ModuleType
|
NUMBER(8)
|
NOT NULL
|
Module type of the additional device.
|
State
|
NUMBER(1)
|
NOT NULL
|
State of the additional device. Values are:
1: Device In Service
2: Device Out of Service
3: Device Preprovisioned
4: Device Under Maintenance
|
isConnected
|
NUMBER(1)
|
NOT NULL
|
Values are:
0: Unreachable
1: Device is reachable from CTM server
|
DiscoveryState
|
NUMBER(1)
|
—
|
Device discovery state. Values are:
1: Device undiscovered
2: Device Initializing
3: Device synchronization configuration
4: Device discovered
|
1.2.4 Admin_Job_Table
The Admin_Job_Table contains information about all administrative tasks and their status.
Primary key: ADMIN_JOB_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-5 Admin_Job_Table
Column Name
|
Oracle Data
Type
|
Integrity Constraints
|
Description
|
JobID
|
NUMBER(12)
|
NOT NULL
|
Unique job identifier.
|
TaskID
|
NUMBER(12)
|
NOT NULL
|
Unique identifier for the task within a job.
|
JobType
|
NUMBER(2)
|
NOT NULL
|
Type of job. Valid types are:
0: NE User Add
1: NE User Modify
2: NE User Delete
3: NE User Logout
4: NE User Conn Delete
5: NE User Enable Log
6: NE User Disable Log
7: NE User Delete Log
8: Image Activate
9: Image Revert
10: Image Download
11: Memory Auto Backup
12: Memory Backup
13: Memory Restore
14: Image Download and Activate
15: SNTP Setup Job
22: BLSR Exercise Ring Backup
|
JobOwner
|
VARCHAR2(64)
|
—
|
Owner of job.
|
NEDBAccessID
|
NUMBER(10)
|
—
|
NEDBAccessID of the NE for which the job was scheduled; same as NEDBAccessID in the NE_INFO_TABLE.
|
JobStatus
|
NUMBER(1)
|
—
|
Status of the job. Values are:
0: Uninitialized
1: Queued
2: Running
3: Cancelled
4: Failed
5: Succeeded
6: Unknown
7: Waiting
|
CreationTime
|
DATE
|
—
|
Time stamp when the job was created.
|
ScheduledTime
|
DATE
|
—
|
Time stamp when the job was scheduled to run.
|
StartTime
|
DATE
|
—
|
Time stamp when the job was actually started.
|
EndTime
|
DATE
|
—
|
Time stamp when the job was completed.
|
AdditionalInfo
|
VARCHAR2(4000)
|
—
|
Any additional information.
|
UserComments
|
VARCHAR2(2048)
|
—
|
Any comments entered by the user.
|
operation_info
|
VARCHAR2(4000)
|
—
|
List of parameters specific to a job.
|
display_info
|
VARCHAR2(4000)
|
—
|
String that displays job-specific information according to specific criteria.
|
1.2.5 Alarm_Ack_Config_Table
The Alarm_Ack_Config_Table stores information about whether or not automatic alarm acknowledgement is enabled.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-6 Alarm_Ack_Config_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
ConfigAlarmAck
|
NUMBER(1)
|
NOT NULL
|
A global, C-style, Boolean variable that represents whether alarm acknowledgement is on for all alarms. Values are:
0: Automatic Acknowledge
1: Manual Acknowledge
|
1.2.6 Alarm_Count_Table
The Alarm_Count_Table stores the alarm count for each level of severity for every NE.
Primary key: ALARM_COUNT_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-7 Alarm_Count_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
nedbaccessid
|
NUMBER(10)
|
NOT NULL
|
ID to access this table for an NE; same as NEDBAccessID in the NE_INFO_TABLE.
|
ackalarmcount
|
NUMBER(20)
|
DEFAULT 0
|
Acknowledged alarm count.
|
clearedalarmcount
|
NUMBER(20)
|
DEFAULT 0
|
Cleared alarm count.
|
minoralarmcount
|
NUMBER(20)
|
DEFAULT 0
|
Minor alarm count.
|
majoralarmcount
|
NUMBER(20)
|
DEFAULT 0
|
Major alarm count.
|
criticalalarmcount
|
NUMBER(20)
|
DEFAULT 0
|
Critical alarm count.
|
warningalarmcount
|
NUMBER(20)
|
DEFAULT 0
|
Warning alarm count.
|
1.2.7 Alarm_Event_Cause_Table
The Alarm_Event_Cause_Table statically maps alarm and event cause indexes to strings.
Primary key: ALARM_EVENT_CAUSE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-8 Alarm_Event_Cause_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
EnumIndex
|
NUMBER(4)
|
—
|
Index of alarm or event cause.
|
EnumString
|
VARCHAR2(64)
|
—
|
Alarm or event cause string for the EnumIndex.
|
1.2.8 Alarm_Event_Table
The Alarm_Event_Table contains information about all events reported by NEs.
Primary key: None
Tablespace: EVENT_DATA_TABLESPACE
Table 1-9 Alarm_Event_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
NEDBAccessID
|
NUMBER(10)
|
NOT NULL
|
ID to access this table for an NE; same as NEDBAccessID in the NE_INFO_TABLE.
|
EventIndex
|
NUMBER(10)
|
NOT NULL
|
Index of alarm or event. Unique sequence number generated by the database.
|
ModuleOrIfIndex
|
NUMBER(20)
|
NOT NULL
|
Unique integer that identifies an interface in the NE; same as ifStaticIndex in the Interface_Table.
|
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.
|
AlarmEventTimeStamp
|
DATE
|
NOT NULL
|
Date and time when the alarm or 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.
|
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
|
OtherInfo
|
VARCHAR2(512)
|
DEFAULT Not 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
|
TL1 direction.
|
Location
|
VARCHAR2(4)
|
DEFAULT NULL
|
TL1 location.
|
1.2.9 Alarm_Event_Type_ENUM_Table
The Alarm_Event_Type_ENUM_Table statically maps alarm and event type indexes to strings.
Primary key: ALARM_EVENT_TYPE_ENUM_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-10 Alarm_Event_Type_ENUM_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
EnumIndex
|
NUMBER(5)
|
—
|
Index of alarm or event type.
|
EnumString
|
VARCHAR2(128)
|
—
|
Alarm or event type string for the EnumIndex.
|
TL1String
|
VARCHAR2(64)
|
—
|
Transaction language 1 (TL1) string for the alarm.
|
TMFString
|
VARCHAR2(64)
|
DEFAULT UNIDENTIFIED
|
TMF mapping string for the alarm
|
EventType
|
NUMBER(1)
|
DEFAULT 1
|
Type of event. Values are:
1: NE_ALARM
2: NE_EVENT
3: EMS_EVENT
4: EMS_ALARM
|
1.2.10 APC_Domain_Table
The APC_Domain_Table contains information about the adjacent point code (APC) domains.
Primary Key: APC_DOMAIN_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-11 APC_Domain_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
NEDBAccessID
|
NUMBER(10)
|
NOT NULL
|
NEDBAccessID in NE_INFO_TABLE.
|
SideOut
|
NUMBER(10)
|
DEFAULT 0
|
ID of the outgoing side.
|
ApcState
|
NUMBER(10)
|
DEFAULT 0
|
APC state.
|
ApcAdminState
|
NUMBER(10)
|
DEFAULT 0
|
APC admin state.
|
Sides
|
VARCHAR2(1000)
|
—
|
All sides of the domain. This is a string of separated sides. Each side is defined by NEDBAccessID, SideIn, SideOut. SideOut is not defined for the last side of a domain. NEDBAccessID and SideOut of the first side are not stored in this column; so this column may contain nothing for a domain which does not have any sides; for example, "2 2 3,4 3 2,3 4."
|
1.2.11 APS_Group_Table
The APS_Group_Table contains information about the automatic protection switching (APS) groups configured in each device.
Primary key: APS_GROUP_PK
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-12 APS_Group_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
NEDBAccessID
|
NUMBER(10)
|
NOT NULL
|
Specific NE instance; same as NEDBAccessID in the NE_INFO_TABLE.
|
GroupName
|
VARCHAR2(64)
|
NOT NULL
|
Group name for APS.
|
ConfigMode
|
NUMBER(2)
|
DEFAULT 1
|
APS group architecture. Values are:
1: 1+1
2: 1:N
3: 1+1 compatible
4: 1+1 optimized
|
ConfigRevert
|
NUMBER(2)
|
DEFAULT 1
|
Revertive mode. Values are:
1: Nonrevertive
2: Revertive
|
ConfigDirection
|
NUMBER(2)
|
DEFAULT 1
|
Direction. Values are:
1: Unidirectional
2: Bidirectional
|
ConfigCreationTime
|
DATE
|
—
|
Time when this group was created.
|
ConfigSpan
|
NUMBER(2)
|
DEFAULT 1
|
Type of span. Values are:
1: Hop-by-hop
2: End-to-end
|
ProtectionType
|
NUMBER(2)
|
DEFAULT 1
|
Type of protection. Values are:
1: None
2: Splitter
3: Y-cable
4: Trunk
|
YCableConfig
|
NUMBER(2)
|
DEFAULT 1
|
Y-cable configuration if y-cable protection is used. Values are:
1: Not y-cable
2: Y-cable
3: Y-cable cross-connect common
|
SwitchedChannelStatus
|
NUMBER(2)
|
DEFAULT 0
|
Protection channel number.
|
1.2.12 Audit_Log_Mapping_Table
The Audit_Log_Mapping_Table contains information about audit log mapping.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-13 Audit_Log_Mapping_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
UserType
|
NUMBER(10)
|
—
|
Defines whether user type is Service or User.
|
ActualName
|
VARCHAR(256)
|
—
|
Name agreed upon by client and server.
|
CurrentName
|
VARCHAR(256)
|
—
|
Name currently used by the server.
|
1.2.13 Audit_Log_Table
The Audit_Log_Table is obsolete.
1.2.14 BLSR_Node
The BLSR_Node contains information about the BLSR node.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-14 BLSR_Node
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
BLSRID
|
NUMBER(8)
|
NOT NULL
|
BLSR ID.
|
RINGID
|
VARCHAR(8)
|
NOT NULL
|
Ring ID.
|
NODEID
|
NUMBER(8)
|
NOT NULL
|
Node ID.
|
RINGNODEID
|
NUMBER(8)
|
NOT NULL
|
Ring node ID.
|
1.2.15 BLSR_Span
The BLSR_Span contains information about the BLSR span.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-15 BLSR_Span
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
BLSRID
|
NUMBER(8)
|
NOT NULL
|
BLSR ID.
|
RINGID
|
VARCHAR(8)
|
NOT NULL
|
Ring ID.
|
LINKID
|
NUMBER(8)
|
NOT NULL
|
Link ID.
|
WORKINGSPAN
|
NUMBER(1)
|
NOT NULL
|
Working span.
|
WESTNODEID
|
NUMBER(10)
|
NOT NULL
|
Node ID of the BLSR (west line).
|
EASTNODEID
|
NUMBER(10)
|
NOT NULL
|
Node ID of the BLSR (east line).
|
1.2.16 BLSR_Table
The BLSR_Table contains information about BLSRs.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-16 BLSR_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
BLSRID
|
NUMBER(8)
|
NOT NULL
|
BLSR ID.
|
RINGID
|
VARCHAR(8)
|
NOT NULL
|
Ring ID.
|
RINGTYPE
|
NUMBER(2)
|
NOT NULL
|
Ring type.
|
LINERATE
|
NUMBER(2)
|
NOT NULL
|
Line rate.
|
STATUS
|
VARCHAR2(12)
|
NOT NULL
|
Ring status.
|
RINGREVERSION
|
NUMBER(8, 2)
|
NOT NULL
|
Ring reversion time.
|
SPANREVERSION
|
NUMBER(8, 2)
|
NOT NULL
|
Span reversion time.
|
NODES
|
VARCHAR2(512)
|
NOT NULL
|
Nodes associated with the ring.
|
1.2.17 Bridge_Group_Table
The Bridge_Group_Table contains information about the bridge group table.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-17 Bridge_Group_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
TopoNodeID
|
NUMBER(10)
|
NOT NULL
|
Node ID of the source node of the circuit.
|
TopoUniqueId
|
NUMBER(10)
|
NOT NULL
|
Unique number within the node.
|
Vlan_Number
|
NUMBER(10)
|
NOT NULL
|
Unique number to identify the VLAN.
|
NEID
|
NUMBER(10)
|
NOT NULL
|
NE ID.
|
Slot_Number
|
NUMBER(3)
|
NOT NULL
|
Slot number.
|
Bridge_Group_Number
|
NUMBER(3)
|
NOT NULL
|
Bridge group number.
|
BRIDGE_PROTOCOL
|
VARCHAR2(30)
|
—
|
—
|
1.2.18 C_MetaData
The C_MetaData table defines overall graphical user interface (GUI) information about a given database table or view.
Note C_MetaData is the parent table; C_MetaData_Col, C_MetaData_Filter, and C_MetaData_NETypes are the children.
Primary key: C_METADATA_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-18 C_MetaData
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
TableID
|
NUMBER(4)
|
NOT NULL
|
Unique ID for each GUI table metadata.
|
TableName
|
VARCHAR2(30)
|
NOT NULL
|
Name of the table.
|
TableJDAQName
|
VARCHAR2(128)
|
—
|
JDAQ name.
|
TableType
|
NUMBER(1)
|
—
|
Title of table frame. Values are FM (fault management), PM (performance management), CM (configuration management), and other.
|
Title
|
VARCHAR2(132)
|
—
|
Title of the table.
|
Report
|
VARCHAR2(132)
|
—
|
String used as the name of the HTML report.
|
ReportFile
|
VARCHAR2(132)
|
—
|
String used as a filename when the HTML report is generated.
|
TitleIconStr
|
VARCHAR2(132)
|
—
|
Filename of the .gif file that appears in the upper-left corner of the table frame.
|
Help
|
VARCHAR2(132)
|
—
|
Help button on the table frame.
|
HelpStrFilterDlg
|
VARCHAR2(132)
|
—
|
Help button on the filter dialog box.
|
DbColCount
|
NUMBER(3)
|
—
|
Count of the number of columns in the database table or view.
|
TCAColIndex
|
NUMBER(3)
|
—
|
Index number of the threshold crossing alert (TCA). Number is usually -1, except for the PM tables where it is the index of the TCAColumn used to color the background of the cells in red.
|
DefSortCol
|
NUMBER(3)
|
—
|
Index of the default column. The table is presorted when it is launched the first time.
|
FilterMask
|
NUMBER(10)
|
—
|
Bit mask that contains bits for each tab in the filter dialog box.
|
AutoRef
|
NUMBER(1)
|
—
|
AutoRefresh = true if the table is updated automatically when an event occurs. AutoRefresh = false if the table is not updated automatically when an event occurs.
|
DispRowCount
|
NUMBER(3)
|
—
|
Total number of rows in the main table.
|
ColDispRow
|
NUMBER(3)
|
—
|
Total number of rows in the vertical table.
|
ColCount
|
NUMBER(3)
|
—
|
Total number of columns in the table.
|
BtnMask
|
NUMBER(20)
|
—
|
Bit mask that contains bits for each GUI table toolbar and for menu bar buttons.
|
NeDbaccessidcolindb
|
NUMBER(3)
|
DEFAULT -1
|
Database column index of the NEDBAccessId column in the respective view or table.
|
1.2.19 C_MetaData_Attr_Presentation
The C_MetaData_Attr_Presentation table stores information about ONS 15327 and ONS 15454 attributes. This information is used to lay out the property sheets in the NE Explorer.
Primary key: C_METADATA_ATTR_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-19 C_MetaData_Attr_Presentation
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
METADATAINDEX
|
NUMBER(5)
|
NOT NULL
|
Metadata index of the event.
|
ATTRINDEX
|
NUMBER(5)
|
NOT NULL
|
Index of attribute.
|
WIDGET_ID
|
NUMBER(2)
|
NOT NULL
|
Values taken by widget IDs are:
0: Default value
1: Text field
2: Password field
3: Subnet mask
4: IP address
5: Timing Communications and Control Card (TCC) Common Object Request Broker Architecture (CORBA) port
6: List
|
WIDGET_ID
(continued)
|
NUMBER(2)
|
NOT NULL
|
7: Check box
8: Combo box
9: Buttons
10: Combo text field
11: Button group
12: Dynamic combo box
13: ENUM check box
14: Number field
15: Time field
16: Dynamic ENUM combo box
17: Time zone combo box
18: Soak time
19: Pattern text field
20: Spin editor
21: Fixed length string
22: Editor pane
23: Text area
24: Double spin editor
25: Slider
26: Letter or digit text field
27: Area ID text field
28: ENUM text field
29: Dynamic generic combo box
30: Hexadecimal field
31: IPv6 address
32: IPMIX address
99: Adjacent text fields
|
|
1.2.20 C_MetaData_Col
The C_MetaData_Col table stores overall information about all of the columns in the CTM GUI.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-20 C_MetaData_Col
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
TableID
|
NUMBER(4)
|
NOT NULL
|
ID in the parent table (C_MetaData).
|
ColName
|
VARCHAR2(50)
|
—
|
String used for the table header.
|
ColHeaderTip
|
VARCHAR2(350)
|
—
|
String used when you point your mouse over a column header.
|
ColWidth
|
NUMBER(4)
|
—
|
Width (in pixels) of the table column.
|
DisplayOrder
|
NUMBER(3)
|
—
|
Order in which the columns are displayed.
|
Sortable
|
NUMBER(1)
|
—
|
Specifies whether the table column is sortable.
|
Editable
|
NUMBER(1)
|
—
|
Specifies whether the cells in the column are editable.
|
DbColIndex
|
NUMBER(3)
|
—
|
Actual database column index for this GUI table column.
|
ClassName
|
VARCHAR2(128)
|
—
|
Renderer class used for the column.
|
FilterCol
|
NUMBER(3)
|
—
|
Specifies which columns are filterable.
|
SortColInDB
|
NUMBER(3)
|
—
|
Actual database column index used for sorting this GUI table column.
|
Renderer
|
VARCHAR2(128)
|
—
|
Used to display an icon instead of a value.
|
ColEnumBases
|
NUMBER(3)
|
—
|
Used to interpret the values from the database.
|
ColTCABitIndex
|
NUMBER(3)
|
—
|
Used for PM tables that have a TCA value.
|
ColSortOrder
|
NUMBER(1)
|
—
|
True if ascending; false if descending.
|
IsPhysicallocCol
|
NUMBER(1)
|
DEFAULT 0
|
Identifies a column as a physical location column.
|
IsInterfaceCol
|
NUMBER(1)
|
DEFAULT 0
|
Identifies a column as a logical interface location column.
|
IsTimestampCol
|
NUMBER(1)
|
DEFAULT 0
|
Identifies a column as a time stamp column.
|
IDENTIFIER
|
VARCHAR2(1000)
|
—
|
Identifies whether or not a particular column is graphable.
|
1.2.21 C_MetaData_Col_Custom
The C_MetaData_Col_Custom table contains the customized columns that users have selected for display in the CTM GUI.
Primary key: C_METADATA_COL_CUSTOM_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-21 C_MetaData_Col_Custom
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
ViewID
|
NUMBER(4)
|
NOT NULL
|
Identifier of the customized view.
|
ColName
|
VARCHAR(50)
|
NOT NULL
|
Column name.
|
ColWidth
|
NUMBER(4)
|
NOT NULL
|
Column width.
|
DisplayOrder
|
NUMBER(3)
|
NOT NULL
|
Display order.
|
IsHidden
|
NUMBER(1)
|
NOT NULL
|
Values when column has to be displayed. Values are:
0: Hidden
1: Visible
|
1.2.22 C_MetaData_Filter
The C_MetaData_Filter table stores overall information about all the filters in the CTM GUI.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-22 C_MetaData_Filter
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
TableID
|
NUMBER(4)
|
NOT NULL
|
ID in the parent table (C_MetaData).
|
FilterCols
|
NUMBER(3)
|
—
|
Index of a filterable column.
|
InitialFilterCols
|
NUMBER(3)
|
—
|
Index of a filterable column if this column is used in the initial filter. The value is -1 if it is not used in the initial filter.
|
DisplayOrder
|
NUMBER(3)
|
—
|
Order in which the columns are displayed.
|
1.2.23 C_MetaData_Grp_Presentation
The C_MetaData_Grp_Presentation table stores group information about ONS 15327 and ONS 15454. This information is used to lay out group attributes in NE Explorer property sheets.
Primary key: C_METADATA_GRP_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-23 C_MetaData_Grp_Presentation
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
METADATAINDEX
|
NUMBER(5)
|
NOT NULL
|
Foreign key from ObjectAttributeTable.
|
GROUPINDEX
|
NUMBER(5)
|
NOT NULL
|
Attribute group.
|
PARENTINDEX
|
NUMBER(5)
|
NOT NULL
|
Parent group index.
|
NAME
|
VARCHAR2(32)
|
—
|
Group name.
|
DISPLAYTEXT
|
VARCHAR2(256)
|
—
|
User interface (UI) display text used as border text in a panel.
|
ATTRCLASS
|
NUMBER(4)
|
—
|
Not used (reserved for future use).
|
ATTRTYPE
|
NUMBER(4)
|
—
|
Not used (reserved for future use).
|
ENUMVAL
|
VARCHAR2(1024)
|
—
|
List of AATRIDs from ObjectAttributeTable that are children of this group. The IDs are separated by vertical bars (|).
|
ATTRGROUP
|
NUMBER(3)
|
—
|
User interface panel type.
|
1.2.24 C_MetaData_NETypes
The C_MetaData_NETypes table stores information about the supported NE types for the table identified in the C_MetaData table.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-24 C_MetaData_NETypes
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
TableID
|
NUMBER(4)
|
NOT NULL
|
ID in the parent table (C_MetaData).
|
NETypes
|
VARCHAR2(15)
|
—
|
Models supported by this table.
|
DisplayOrder
|
NUMBER(3)
|
—
|
Order in which the columns are displayed.
|
1.2.25 C_Property_Sheet_Info_Table
The C_Property_Sheet_Info_Table stores metadata information about the various CTM property sheets.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-25 C_Property_Sheet_Info_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
ModelIndex
|
NUMBER(4)
|
—
|
NE model index. Number in this column corresponds to a number in the Version_Table.
|
PropSheetIndex
|
NUMBER(4)
|
—
|
Number to identify a specific property sheet in the NE specified by the ModelIndex.
|
TabIndex
|
NUMBER(5)
|
—
|
Number to identify a tab in the property sheet. This number refers to TabIndex in the C_Tab_Metadata_Table.
|
TabPosition
|
NUMBER(2)
|
—
|
Number to identify the position of the tab in the property sheet.
|
1.2.26 C_Tab_Metadata_Info_Table
The C_Tab_Metadata_Info_Table stores information about the relationship between the tabs and subtabs in the CTM property sheets.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-26 C_Tab_Metadata_Info_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
TabIndex
|
NUMBER(5)
|
—
|
Number to identify a tab on the property sheet.
|
SubtabIndex
|
NUMBER(5)
|
—
|
Number to identify a subtab in the tab corresponding to the TabIndex.
|
SubtabPosition
|
NUMBER(2)
|
—
|
Number to identify the subtab position.
|
1.2.27 C_Tab_Metadata_Table
The C_Tab_Metadata_Table stores information about the tabs in the CTM property sheets.
Primary key: C_TAB_METADATA_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-27 C_Tab_Metadata_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
TabIndex
|
NUMBER(5)
|
UNIQUE
|
Number to identify the tab on a property sheet.
|
TabName
|
VARCHAR2(200)
|
—
|
Name of the tab.
|
TabDataObjects
|
VARCHAR2(512)
|
—
|
Stores a list of data objects represented on the tab. The data objects in the list are separated by vertical bars (|). Each data object contains the following values, separated by a colon:
ObjectIndex:MetaDataGroupIndex:GroupName:editable
|
Description
|
VARCHAR2(512)
|
—
|
Comment field.
|
OperationId
|
VARCHAR2(128)
|
—
|
Key that is cross-referenced in the user's security profile, which stores the user's access for this tab.
|
1.2.28 Cerent_NE_Group_Table
The Cerent_NE_Group_Table indicates how the CTC-based NEs' discovered NEs are grouped based on the grouping rule.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-28 Cerent_NE_Group_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
NEDBAccessID
|
NUMBER(10)
|
NOT NULL
|
NE database access ID.
|
GroupOption
|
NUMBER(4)
|
DEFAULT 0
|
Values are:
0: Default grouping
1: Group by discovered NE
2: Group by subnet
|
1.2.29 Circuit_BS_Tbl
The Circuit_BS_Tbl stores basic information about the circuit.
Primary key: CIRCUIT_BS_TBL_PK
Tablespace: BASE_DATA_TABLESPACE
Note For medium, large, and high-end configurations, this table is partitioned.
Table 1-29 Circuit_BS_Tbl
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
CktNodeId
|
NUMBER(10)
|
NOT NULL
|
Node ID of the source node of the circuit.
|
CktUniqueId
|
NUMBER(10)
|
NOT NULL
|
Unique number within each source node. The CktNodeId and CktUniqueId combine to form a circuit ID that is unique in the network. Note that these are internal fields and should not be displayed.
|
CktName
|
VARCHAR2(64)
|
—
|
Name of the circuit.
|
CktDescription
|
VARCHAR2(256)
|
—
|
Description of the circuit.
|
CustomerId
|
VARCHAR2(256)
|
—
|
Customer ID.
|
ServiceId
|
VARCHAR2(256)
|
—
|
Service ID.
|
CktType
|
NUMBER(2)
|
—
|
Type of circuit. Values are:
0: ETHERNET
1: STS_CIRCUIT
2: VT_CIRCUIT
3: VT_TUNNEL
4: VT_AGGREGATION
5: STS_VCAT_CIRCUIT
6: VT_VCAT_CIRCUIT
7: GIGABIT_ETHERNET
8: TENGIGABIT_ETHERNET
9: FIBERCHANNEL
10: FICON
11: ESCON
12: SDH_CIRCUIT
13: ISC_COMPATIBLE
14: ISC_PEER
15: SYSPLEX
16: DWDM_TRANSPARENT_ANY
|
CktType (continued)
|
NUMBER(2)
|
—
|
17: VC_HO_PATH_CIRCUIT
18: VC_LO_PATH_CIRCUIT
19: VC_LO_PATH_TUNNEL
20: VC_LO_PATH_AGGREGATION
21: VC_HO_VCAT_CIRCUIT
22: VC_LO_VCAT_CIRCUIT
23: DWDM_WAVELENGTH
24: FAST_ETHERNET
25: FDDI
26: SYSPLEX_TIMER_ETR
27: SYSPLEX_TIMER_CLO
28: TENGIGABIT_ETHERNET_WAVELENGTH
29: POINT5GIGABIT_ETHERNET_WAVELENGTH
30: TENGIGABIT_ETHERNET_TRUNK
31: SONET_CIRCUIT
32: OCHNC_CIRCUIT
33: TWO_GIGABIT_ETHERNET
34: E1_CIRCUIT
35: T1 CIRCUIT
36: DVB_CIRCUIT
37: SDI_CIRCUIT
38: OCHCC_CIRCUIT
39: OCHTRAIL_TUNNEL_CIRCUIT
|
CktSize
|
NUMBER(2)
|
—
|
Size of circuit. Values are:
0: VT1_5
1: 1 = STS1
2: STS3C
3: STS6C
4: STS9C
5: STS12C
6: STS24C
7: STS48C
8: STS192C
9: TS768C
10: DWDM_2POINT5G
11: DWDM_10G
12: VC_11
13: VC_12
14: VC_3
15: VC_4
16: VC_4_2C
17: VC_4_3C
18: VC_4_4C
19: VC_4_8C
20: VC_4_16C
21: VC_4_64C
22: FIBERCHANNEL1
23: FIBERCHANNEL2
24: FICON
25: ESCON
26: SYSPLEX
27: FAST_ETHERNET
28: GIGABIT_ETHERNET
29: TENGIGABIT_ETHERNET
30: VT_2
|
CktSize (continued)
|
NUMBER(2)
|
—
|
31: FDDI
32: OCHNC_NOTEQUIPPED
33: OCHNC_MULTIRATE
34: OCHNC_2_5G_FEC
35: OCHNC_2_5G_NOFEC
36: OCHNC_10G_FEC
37: OCHNC_10G_NOFEC
38: STS36C
39: VC_4_12C
40: STS18C
41: VC_4_6C
42: STM1C
43: STM4C
44: STM16C
45: STM64C
46: ISC_COMPATIBLE
47: ISC_PEER
48: SYSPLEX_TIMER_ETR
49: SYSPLEX_TIMER_CLO
50: TWO_GIGABIT_ETHERNET
51: E1
52: T1
53: DVB
54: SDI
55: OCHCC_OC_192
56: OCHCC_OC_48
57: OCHCC_OC_12
58: OCHCC_OC_3
59: OCHCC_10_GE
60: OCHCC_1_GE
61: OCHCC_10_GFC
62: OCHCC_4_GFC
63: OCHCC_2_GFC
|
CktSize (continued)
|
NUMBER(2)
|
—
|
64: OCHCC_1_GFC
65: OCHCC_4_GFICON
66: OCHCC_2_GFICON
67: OCHCC_1_GFICON
68: OCHCC_ESCON
69: OCHCC_ETR_CLO
70: OCHCC_ISC_PEER
71: OCHCC_ISC3_PEER_1G
72: OCHCC_ISC3_PEER2G
73: OCHCC_ISC_COMPAT
74: OCHCC_HVDT
75: OCHCC_SD1_D1
76: OCHCC_DV_6000
77: OCHCC_PASS_THROUGH
78: OCHCC_OC_768
79: STS96C
80: VC_4_32C
81: OCHCC_STM_256
|
CktDirection
|
NUMBER(1)
|
—
|
Type of traffic that the circuit carries. Values are:
0: Unidirectional
1: Bidirectional
|
CktIsMonitor
|
NUMBER(1)
|
—
|
Whether the circuit is a monitor circuit. Values are:
0: False
1: True
|
CktState
|
NUMBER(2)
|
—
|
State of the circuit. Values are:
0: CREATING
1: ACTIVE
2: DELETING
3: DROP_PENDING
4: INCOMPLETE
5: UPGRADABLE
6: INCOMPLETE_UPGRADABLE
7: ERRORED
8: NOT_UPGRADABLE
9: INCOMPLETE_NOT_UPGRADABLE
10: ROLL_PENDING
11: NOT_ACTIVATED
12: NOT_ACTIVE (A circuit assumes this temporary state during an NE service restart, or after a circuit removal on an entry that will be removed later. This state also applies to curcuits that no longer exist.)
|
CktEnhancedState
|
NUMBER(2)
|
—
|
Administrative state of the circuit.
|
CktProtectionType
|
NUMBER(2)
|
—
|
Circuit protection type.
|
CktAdditionalInfo
|
VARCHAR2(64)
|
—
|
Additional information about the circuits.
|
cktComment
|
VARCHAR2(2014)
|
—
|
—
|
CktUseLap
|
NUMBER(1)
|
—
|
Whether the circuit uses LAP. Values are:
0: False
1: True
|
CktOchncChannel
|
NUMBER(3)
|
—
|
Values are:
0: NOT_APPLICABLE
1: OCHNC_30_33
2: OCHNC_31_12
3: OCHNC_31_90
4: OCHNC_32_68
5: OCHNC_34_25
6: OCHNC_35_04
7: OCHNC_35_82
8: OCHNC_36_61
9: OCHNC_38_19
10: OCHNC_38_98
11: OCHNC_39_77
12: OCHNC_40_56
13: OCHNC_42_14
14: OCHNC_42_94
15: OCHNC_43_73
16: OCHNC_44_53
17: OCHNC_46_12
18: OCHNC_46_92
19: OCHNC_47_72
20: FALSE OCHNC_48_51
21: FALSE OCHNC_50_12
22: OCHNC_50_92
23: OCHNC_51_72
24: MANUAL OCHNC_52_52
25: OCHNC_54_13
26: OCHNC_54_94
27: OCHNC_55_75
28: OCHNC_56_55
29: OCHNC_58_17
30: CHNC_58_98
31: OCHNC_59_79
32: OCHNC_60_61
|
CktOchncChannel
(continued)
|
NUMBER(3)
|
—
|
33: OCHCC_77_44
34: OCHCC_77_86
35: OCHCC_78_27
36: OCHCC_78_69
37: OCHCC_79_10
38: OCHCC_79_52
39: OCHCC_79_93
40: OCHCC_80_35
41: OCHCC_80_77
42: OCHCC_81_18
43: OCHCC_81_60
44: OCHCC_82_02
45: OCHCC_82_44
46: OCHCC_82_85
47: OCHCC_83_27
48: OCHCC_83_69
49: OCHCC_84_11
50: OCHCC_84_53
51: OCHCC_84_95
52: OCHCC_85_36
53: OCHCC_85_78
54: OCHCC_86_20
55: OCHCC_86_62
56: OCHCC_87_04
57: OCHCC_87_46
58: OCHCC_87_88
59: OCHCC_88_30
60: OCHCC_88_73
61: OCHCC_89_15
62: OCHCC_89_57
63: OCHCC_89_99
64: OCHCC_90_41
65: OCHCC_90_83
|
CktOchncChannel
(continued)
|
NUMBER(3)
|
—
|
66: OCHCC_91_26
67: OCHCC_91_68
68: OCHCC_92_10
69: OCHCC_92_52
70: OCHCC_92_95
71: OCHCC_93_37
72: OCHCC_93_79
73: WV_1310
74: WV_1550
75: WV_1470
76: WV_1490
77: WV_1510
78: WV_1530
79: WV_1570
80: WV_1590
81: WV_1610
82: OCHCC_29_55
83: OCHCC_29_94
84: OCHCC_30_73
85: OCHCC_31_51
86: OCHCC_32_29
87: OCHCC_33_07
88: OCHCC_33_47
89: OCHCC_33_86
90: OCHCC_34_64
91: OCHCC_35_43
92: OCHCC_36_22
93: OCHCC_37_00
94: OCHCC_37_40
95: OCHCC_37_79
96: OCHCC_38_58
97: OCHCC_39_37
98: OCHCC_40_16
99: OCHCC_40_95
|
CktOchncChannel
(continued)
|
NUMBER(3)
|
—
|
100: OCHCC_41_35
101: OCHCC_41_75
102: OCHCC_42_54
103: OCHCC_43_33
104: OCHCC_44_13
105: OCHCC_44_92
106: OCHCC_45_32
107: OCHCC_45_72
108: OCHCC_46_52
109: OCHCC_47_32
110: OCHCC_48_12
111: OCHCC_48_92
112: OCHCC_49_32
113: OCHCC_49_71
114: OCHCC_50_52
115: OCHCC_51_32
116: OCHCC_52_12
117: OCHCC_52_93
118: OCHCC_53_33
119: OCHCC_53_73
120: OCHCC_54_54
121: OCHCC_55_34
122: OCHCC_56_15
123: OCHCC_56_96
124: OCHCC_57_36
125: OCHCC_57_77
126: OCHCC_58_58
127: OCHCC_59_39
128: OCHCC_60_20
129: OCHCC_61_01
130: OCHCC_70_83
131: OCHCC_71_24
132: OCHCC_71_65
133: OCHCC_72_06
|
CktOchncChannel
(continued)
|
NUMBER(3)
|
—
|
134: OCHCC_72_48
135: OCHCC_72_89
136: OCHCC_73_30
137: OCHCC_73_71
138: OCHCC_74_13
139: OCHCC_74_54
140: OCHCC_74_95
141: OCHCC_75_37
142: OCHCC_75_78
143: OCHCC_76_20
144: OCHCC_76_61
145: OCHCC_77_03
146: OCHCC_94_22
147: OCHCC_94_64
148: OCHCC_95_06
149: OCHCC_95_49
150: OCHCC_95_91
151: OCHCC_96_34
152: OCHCC_96_76
153: OCHCC_97_19
154: OCHCC_97_62
155: OCHCC_98_04
156: OCHCC_98_47
157: OCHCC_98_89
158: OCHCC_99_32
159: OCHCC_99_75
160: OCHCC_00_17
161: OCHCC_00_60
162: OCHCC_01_03
163: OCHCC_01_46
164: OCHCC_01_88
165: OCHCC_02_31
166: OCHCC_02_74
167: OCHCC_03_17
|
CktOchncChannel
(continued)
|
NUMBER(3)
|
—
|
168: OCHCC_03_60
169: OCHCC_04_03
170: OCHCC_61_42
171: OCHCC_61_83
172: WV_850_00
|
CktOchncDir
|
NUMBER(1)
|
—
|
Direction of the OCHNC circuit. Values are:
0: East-to-west
1: West-to-east
2: Not applicable
|
isDuplicateName
|
NUMBER(1)
|
DEFAULT 1
|
Whether or not the circuit has a duplicate name. Values are:
0: Duplicate
1: Not duplicate
|
NPID
|
NUMBER(10)
|
—
|
Network partition ID to which the subnetwork belongs.
|
CktAliasName
|
VARCHAR2(64)
|
—
|
Circuit alias name.
|
isOpenVcat
|
NUMBER(1)
|
DEFAULT 0
|
Indicates whether or not the circuit is an open VCAT. Values are:
0: False
1: True
|
isOverlay
|
NUMBER(1)
|
DEFAULT 0
|
Indicates whether or not the circuit is an overlay. Values are:
0: False
1: True
|
1.2.30 Circuit_Ctp_Tbl
The Circuit_Ctp_Tbl stores the circuit termination points.
Foreign key: FK_CIRCUIT_CTPNPID
Tablespace: BASE_DATA_TABLESPACE
Note For medium, large, and high-end configurations, this table is partitioned.
Table 1-30 Circuit_Ctp_Tbl
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
CTPAccessID
|
NUMBER(10)
|
NOT NULL
|
Unique sequence number generated by the database. This is the link between the table and the Circuit_Span_BS_Tbl that contains CTPs. Values are:
1: Circuit termination point CTP
2: L2 VLAN
|
CTP_Type
|
NUMBER(5)
|
NOT NULL
|
CTP entity type. Values are:
0: SRC
1: SEC_SRC
2: DROP
3: SPAN_SRC
4: SPAN_DEST
5: SPAN_SRC_THRU_TUNNEL
6: SPAN_DEST_THRU_TUNNEL
7: SPAN_SRC_VTT_EXPANDED
8: SPAN_DEST_VTT_EXPANDED
|
CktNodeId
|
NUMBER(10)
|
NOT NULL
|
Node ID of the source node of the circuit.
|
CktUniqueId
|
NUMBER(10)
|
NOT NULL
|
Unique number within each source node. The CktNodeId and CktUniqueId combine to form a circuit ID that is unique in the network. Note that these are internal fields and should not be displayed.
|
CktCtpNodeId
|
NUMBER(10)
|
—
|
CTP circuit node ID.
|
CKTCTPNeDBAccessId
|
NUMBER(10)
|
NOT NULL
|
NE database ID.
|
CktCtpModuleType
|
NUMBER(8)
|
—
|
Module type of the CTP.
|
CktCtpIfIndex
|
NUMBER(20)
|
—
|
If_Static_Index at the destination.
|
CktCtpObjectType
|
NUMBER(10)
|
—
|
Object type at the destination.
|
CktCtpPhysicalLoc
|
NUMBER(20)
|
—
|
Physical location of the destination node.
|
CktCtpModelType
|
NUMBER(4)
|
—
|
Model type of the destination node.
|
CktCtpDropProt
|
NUMBER(1)
|
—
|
Whether the endpoint is protected. Values are:
0: False
1: True
|
CktCtpPathProt
|
NUMBER(1)
|
—
|
Path protection for this drop. Values are:
0: PATH FULLY PROTECTED
1: PATH PROTECTED
2: PATH UNPROTECTED
3: PATH FULLY UNPROTECTED
|
CktCtpDropProtType
|
NUMBER(1)
|
—
|
Protection type. Values are:
0: NO_PROTECTION
1: UNKNOWN_PROTECTION
2: SPLITTER_PROTECTION
3: Y_CABLE_OR_LINE_CARD_PROTECTION
4: TRUNK_CARD_PROTECTION
|
CktCtpPortName
|
VARCHAR2(64)
|
—
|
Destination port name of the circuit.
|
CktCtpAdditionalInfo
|
VARCHAR2(64)
|
DEFAULT NULL
|
Additional information about the circuit destination.
|
NPID
|
NUMBER(10)
|
DEFAULT 0
|
Network partition ID to which the subnetwork belongs.
|
1.2.31 Circuit_Dest_Tbl
The Circuit_Dest_Tbl shows the end and drop points for network circuits.
Primary key: None
Foreign key: FK_CIRCUIT_DEST_NPID
Tablespace: BASE_DATA_TABLESPACE
Note For medium, large, and high-end configurations, this table is partitioned.
Table 1-31 Circuit_Dest_Tbl
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
CktNodeId
|
NUMBER(10)
|
NOT NULL
|
Node ID of the source node of the circuit.
|
CktUniqueId
|
NUMBER(10)
|
NOT NULL
|
Unique number within each source node. The CktNodeId and CktUniqueId combine to form a circuit ID that is unique in the network. Note that these are internal fields and should not be displayed.
|
CktDestNodeId
|
NUMBER(10)
|
—
|
Destination node ID.
|
CktDestModuleType
|
NUMBER(8)
|
—
|
Module type at destination.
|
CktDestIfIndex
|
NUMBER(20)
|
—
|
Static index of the interface at the destination.
|
CktDestObjectType
|
NUMBER(10)
|
—
|
Object type at the destination.
|
CktDestPhysicalLoc
|
NUMBER(20)
|
—
|
Physical location of the destination node.
|
CktDestModelType
|
NUMBER(4)
|
—
|
Model type of the destination node.
|
CktDestDropProt
|
NUMBER(1)
|
—
|
Whether the endpoint is protected. Values are:
0: False
1: True
|
CktDestPathProt
|
NUMBER(1)
|
—
|
Path protection for this drop. Values are:
0: Path fully protected
1: Path protected
2: Path unprotected
3: Path fully unprotected
|
CktDestDropProtType
|
NUMBER(1)
|
—
|
Protection type for ONS 15540:
0: No protection
1: Unknown protection
2: Splitter protection
3: Y-cable or line-card protection
4: Trunk card protection
|
CktDestPortName
|
VARCHAR2(64)
|
—
|
Destination port name of the circuit.
|
CktDestAdditionalInfo
|
VARCHAR2(64)
|
DEFAULT NULL
|
Additional information about the circuit destination.
|
NPID
|
NUMBER(10)
|
DEFAULT 0
|
Network partition ID.
|
1.2.32 Circuit_Size_Table
The Circuit_Size_Table contains information about the circuit sizes.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-32 Circuit_Size_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
UserId
|
NUMBER(4)
|
—
|
User ID.
|
CircuitSizeType
|
NUMBER(2)
|
—
|
Circuit size.
|
CircuitSizeId
|
NUMBER(2)
|
—
|
Circuit size ID.
|
CircuitSizeName
|
VARCHAR2(32)
|
—
|
Name of the circuit size.
|
1.2.33 Circuit_Span_BS_Tbl
The Circuit_Span_BS_Tbl stores circuit span information. Each span consists of the span base information, span source circuit termination point, and span destination circuit termination point. The span base information is stored in the Circuit_Span_BS_Tbl. The span source circuit termination point is stored in the Circuit_CTP_Tbl and a reference to the CIRCUIT_CTP_TBL row (that is, database row ID) is stored in the Circuit_Span_BS_Tbl as CIRCUIT_SPAN_SRC_CTP_ACCESSID. Similarly, the span destination circuit termination point is stored in the Circuit_CTP_Tbl and a reference to the CIRCUIT_CTP_TBL row (database row ID) is stored in the Circuit_Span_BS_Tbl as CIRCUIT_SPAN_DEST_CTP_ACCESSID.
Foreign key: FK_CIRCUIT_SPAN_BS_NPID
Tablespace: BASE_DATA_TABLESPACE
Note For medium, large, and high-end configurations, this table is partitioned.
Table 1-33 Circuit_Span_BS_Tbl
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
CktSpanBSId
|
NUMBER(10)
|
NOT NULL
|
Unique sequence number generated by the database.
|
CktNodeId
|
NUMBER(10)
|
—
|
Node ID of the source node of the circuit to which the span belongs.
|
CktUniqueId
|
NUMBER(10)
|
—
|
Unique number within each source node. The CktNodeId and CktUniqueId combine to form a circuit ID that is unique in the network. Note that these are internal fields and should not be displayed.
|
CktLinkId
|
NUMBER(10)
|
—
|
ID of the link to which this span belongs.
|
Span_Type
|
NUMBER(5)
|
NOT NULL
|
Type of span.
|
CktSpanSrcCtpAccessId
|
NUMBER(10)
|
—
|
CTP ID of the span source.
|
CktSpanDstCtpAccessId
|
NUMBER(10)
|
—
|
CTP ID of the span destination.
|
CktSpanSrcState
|
NUMBER(1)
|
—
|
State of the circuit span from the source circuit node's point of view. Values are:
0: INACTIVE
1: STRANDED
2: ROUTED
3: TENTATIVE
4: ACTIVE
|
CktSpanDestState
|
NUMBER(1)
|
—
|
State of the circuit span from the destination circuit node's point of view. Values are:
0: INACTIVE
1: STRANDED
2: ROUTED
3: TENTATIVE
4: ACTIVE
|
IsCktForwarding
|
NUMBER(1)
|
—
|
Whether the circuit span is forwarding; valid for Ethernet circuit spans only. Values are:
0: False
1: True
|
IsCktSpanInUPSR
|
NUMBER(1)
|
—
|
Whether the circuit span is part of a UPSR ring. Values are:
0: False
1: True
|
IsCktSpanWorking
|
NUMBER(1)
|
—
|
Whether the circuit span is a working span. Values are:
0: False
1: True
|
IsCktSpanActive
|
NUMBER(1)
|
—
|
Whether the circuit span carries active traffic. Values are:
0: False
1: True
|
CktSpanProtOp
|
NUMBER(1)
|
—
|
Last successful span protection operation performed on this span. Values are:
1: Manual
2: Force
3: Lockout
|
CktSpanCDLFlowID
|
NUMBER(3)
|
DEFAULT -1
|
(Applicable only to ONS 155xx circuits) Source CDL flow identifier. The valid range is from 0 to 254.
|
CktSpanSrcPortName
|
VARCHAR2(64)
|
—
|
Span source port name of the circuit.
|
CktSpanDestPortName
|
VARCHAR2(64)
|
—
|
Span destination name of the circuit.
|
NPID
|
NUMBER(10)
|
DEFAULT 0
|
Network partition ID to which the subnetwork belongs.
|
1.2.34 Circuit_Span_Tbl
The Circut_Span_Tbl contains information about spans associated with circuits.
Primary key: None
Foreign key: FK_CIRCUIT_SPAN_NPID
Tablespace: BASE_DATA_TABLESPACE
Note For medium, large, and high-end configurations, this table is partitioned.
Table 1-34 Circuit_Span_Tbl
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
CktSpanId
|
NUMBER(10)
|
NOT NULL
|
Unique sequence number generated by the database.
|
CktNodeId
|
NUMBER(10)
|
—
|
Node ID of the source node of the circuit to which the span belongs.
|
CktUniqueId
|
NUMBER(10)
|
—
|
Unique number within each source node. The CktNodeId and CktUniquieId combine to form a circuit ID that is unique in the network. Note that these are internal fields and should not be displayed.
|
CktLinkId
|
NUMBER(10)
|
—
|
ID of the link to which this span belongs.
|
CktSpanSrcNodeId
|
NUMBER(10)
|
—
|
Node ID of the span source.
|
CktSpanSrcModuleType
|
NUMBER(8)
|
—
|
Module type at the span source.
|
CktSpanSrcIfIndex
|
NUMBER(20)
|
—
|
Static index of the interface at the span source.
|
CktSpanSrcObjectType
|
NUMBER(10)
|
—
|
Object type at span source.
|
CktSpanSrcPhysicalLoc
|
NUMBER(20)
|
—
|
Physical location of the source node of the span.
|
CktSpanSrcModelType
|
NUMBER(4)
|
—
|
Model type for source node of span.
|
CktSpanDestNodeId
|
NUMBER(10)
|
—
|
Node ID of the span destination.
|
CktSpanDestModuleType
|
NUMBER(8)
|
—
|
Module type at the span destination.
|
CktSpanDestIfIndex
|
NUMBER(20)
|
—
|
Static index of the interface at the span destination.
|
CktSpanDestObjectType
|
NUMBER(10)
|
—
|
Object type at span destination.
|
CktSpanDestPhysicalLoc
|
NUMBER(20)
|
—
|
Physical location of the destination node of the span.
|
CktSpanDestModelType
|
NUMBER(4)
|
—
|
Model type for destination node of span.
|
CktSpanSrcState
|
NUMBER(1)
|
—
|
State of the circuit span from the source circuit node. Values are:
0: Inactive
1: Stranded
2: Routed
3: Tentative
4: Active
|
CktSpanDestState
|
NUMBER(1)
|
—
|
State of the circuit span from the destination circuit. Values are:
0: Inactive
1: Stranded
2: Routed
3: Tentative
4: Active
|
IsCktForwarding
|
NUMBER(1)
|
—
|
Whether the circuit span is forwarding (for Ethernet circuit spans only):
0: False
1: True
|
IsCktSpanInUPSR
|
NUMBER(1)
|
—
|
Whether the circuit span is part of a unidirectional path switched ring (UPSR) ring. Values are:
0: False
1: True
|
IsCktSpanWorking
|
NUMBER(1)
|
—
|
Whether the circuit span is a working span. Values are:
0: False
1: True
|
IsCktSpanActive
|
NUMBER(1)
|
—
|
Whether the circuit span carries active traffic. Values are:
0: False
1: True
|
CktSpanProtOp
|
NUMBER(1)
|
—
|
Last successful span protection operation performed on this span. Values are:
0: Clear
1: Manual
2: Force
3: Lockout
|
CktSpanAdditionalInfo
|
VARCHAR2(64)
|
DEFAULT NULL
|
Additional information about the circuit span.
|
CktSpanCDLFlowID
|
NUMBER(3)
|
DEFAULT -1
|
Source converged data link (CDL) flow identifier; applies only to ONS 15501, ONS 15530, and ONS 15540 circuits. Valid range is 0 to 254.
|
CktSpanSrcPortName
|
VARCHAR2(64)
|
—
|
Span source port name of the circuit.
|
CktSpanDestPortName
|
VARCHAR2(64)
|
—
|
Span destination port name of the circuit.
|
NPID
|
NUMBER(10)
|
DEFAULT 0
|
Network partition ID.
|
1.2.35 Circuit_Tbl
The Circuit_Tbl shows circuit information about an entire network.
Primary key: CIRCUIT_TBL_PK
Foreign key: FK_CIRCUIT_NPID
Tablespace: BASE_DATA_TABLESPACE
Note For medium, large, and high-end configurations, this table is partitioned.
Table 1-35 Circuit_Tbl
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
CktNodeId
|
NUMBER(10)
|
NOT NULL
|
Node ID of the source node of the circuit.
|
CktUniqueId
|
NUMBER(10)
|
NOT NULL
|
Unique number within each source node. The CktNodeId and CktUniqueId combine to form a circuit ID that is unique in the network. Note that these are internal fields and should not be displayed.
|
CktName
|
VARCHAR2(64)
|
—
|
Name of the circuit.
|
CktDescription
|
VARCHAR2(256)
|
—
|
Description of the circuit.
|
CustomerID
|
VARCHAR2(256)
|
—
|
Customer ID.
|
ServiceID
|
VARCHAR2(256)
|
—
|
Service ID.
|
CktType
|
NUMBER(2)
|
—
|
Circuit type. Values are:
0: Ethernet
1: Synchronous transport signal (STS) circuit
2: Virtual Tributary (VT) circuit
3: VT tunnel
4: VT aggregation
5: STS VCAT circuit
6: VT VCAT circuit
7: Gigabit Ethernet
8: 10-Gigabit Ethernet
9: Fiber channel
10: Fiber connectivity (FICON)
11: Enterprise System Connection (ESCON)
12: SDH circuit
13: Intersystem channel (ISC)-compatible
14: ISC peer
15: SYSPLEX
16: Dense wavelength division multiplexing (DWDM) transparent any
17: Virtual channel (VC) high order path circuit
18: VC low order path circuit
19: VC low order path tunnel
|
CktType (continued)
|
NUMBER(2)
|
—
|
20: VC low order path aggregation
21: VC high order VCAT circuit
22: VC low order VCAT circuit
23: DWDM wavelength
24: Fast Ethernet
25: FDDI
26: SYSPLEX_TIMER_ETR
27: SYSPLEX_TIMER_CLO
28: 10-Gigabit Ethernet wavelength
29: 2.5-Gigabit Ethernet wavelength
30: 10-Gigabit Ethernet trunk
31: SONET circuit
32: OCHNC circuit
33: Two_Gigabit_Ethernet
34: E1 circuit
35: T1 circuit
36: DVB_CIRCUIT
37: SDI_CIRCUIT
38: OCHCC_CIRCUIT
39: OCHTRAIL_TUNNEL_CIRCUIT
|
CktSize
|
NUMBER(2)
|
—
|
Size of the circuit. Values are:
0: VT 1.5
1: STS1
2: STS3C
3: STS6C
4: STS9C
5: STS12C
6: STS24C
7: STS48C
8: STS192C
9: STS768C
10: DWDM 2.5 G
11: DWDM 10 G
12: VC_11
13: VC_12
14: VC_3
15: VC_4
|
CktSize (continued)
|
NUMBER(2)
|
—
|
16: VC_4_2C
17: VC_4_3C
18: VC_4_4C
19: VC_4_8C
20: VC_4_16C
21: VC_4_64C
22: Fiber channel 1
23: Fiber channel 2
24: FICON
25: ESCON
26: SYSPLEX
27: Fast Ethernet
28: Gigabit Ethernet
29: 10-Gigabit Ethernet
30: VT_2
31: FDDI
32: Optical Channel Network Connection (OCHNC) not equipped
33: OCHNC multirate
34: OCHNC 2.5G FEC
35: OCHNC 2.5G NOFEC
36: OCHNC 10G FEC
37: OCHNC 10G NOFEC
38: STM 1C
39: STM 4C
40: STM 16C
41: STM 64C
42: ISC compatible
43: ISC peer
44: SYSPLEX_TIMER_ETR
45: SYSPLEX_TIMER_CLO
46: TWO_GIGABIT_ETHERNET
47: E1
48: T1
|
CktDirection
|
NUMBER(1)
|
—
|
Type of traffic that the circuit carries. Values are:
0: Unidirectional
1: Bidirectional
|
CktIsMonitor
|
NUMBER(1)
|
—
|
Whether the circuit is a monitor circuit. Values are:
0: False
1: True
|
CktState
|
NUMBER(2)
|
—
|
State of the circuit. Values are:
0: Creating
1: Active
2: Deleting
3: Drop-pending
4: Incomplete
5: TL1 active
6: TL1 incomplete
7: Errored
8: Roll-pending
9. Sig-pending
10: Sig-failed
11: Conversion-pending
12: Not activated
|
CktEnhancedState
|
NUMBER(2)
|
—
|
Administrative state of the circuit. Values are:
0: IS
1: OOS
2: OOS_MT
3: OOS_AINS
4: CES_NOT_DEFINED
5: OOS_PARTIAL
6: OOS_MT_PARTIAL
7: OOS_AINS_PARTIAL
8: IS_PARTIAL
9: UNKNOWN_ADMIN_STATE
|
CktProtectiontype
|
NUMBER(2)
|
—
|
Circuit protection type. Values are:
0: BLSR2F
1: OnePlusOne
2: NotDefined
3: UnProt
4: BLSR4F
5: PCA2F
6: PCA4F
7: NotDefined1
8: Protected
9: BLSR
10: UPSR
11: PCA
12: Lost
13: Unknown
14: None
15: UPSRDRI
|
CktSrcNodeId
|
NUMBER(10)
|
—
|
Source node ID.
|
CktSrcModuleType
|
NUMBER(8)
|
—
|
Module type at source.
|
CktSrcIfIndex
|
NUMBER(20)
|
—
|
Static index of the interface at the source.
|
CktObjectType
|
NUMBER(10)
|
—
|
Source object type.
|
CktSrcPhysicalLoc
|
NUMBER(20)
|
—
|
Source node physical location.
|
CktModelType
|
NUMBER(4)
|
—
|
Source node model type.
|
CktSrcDropProt
|
NUMBER(1)
|
—
|
Whether the endpoint is protected. Values are:
0: False
1: True
|
CktSrcDropProtType
|
NUMBER(1)
|
—
|
Protection type for ONS 15540:
0: No protection
1: Unknown protection
2: Splitter protection
3: Y-cable or line-card protection
4: Trunk card protection
|
CktSecSrcNodeId
|
NUMBER(10)
|
—
|
Secondary source node ID.
|
CktSecSrcModuleType
|
NUMBER(8)
|
—
|
Module type at secondary source node.
|
CktSecSrcIfIndex
|
NUMBER(20)
|
—
|
Static index of the interface at the secondary source node.
|
CktSecSrcObjectType
|
NUMBER(10)
|
—
|
Secondary source object type.
|
CktSecSrcPhysicalLoc
|
NUMBER(20)
|
—
|
Secondary source node physical location.
|
CktSecSrcModelType
|
NUMBER(4)
|
—
|
Model type for the secondary source node.
|
CktSecSrcDropProt
|
NUMBER(1)
|
—
|
Whether the secondary endpoint is protected. Values are:
0: False
1: True
|
CktSecSrcDropProtType
|
NUMBER(1)
|
—
|
Protection type for ONS 15540:
0: No protection
1: Unknown protection
2: Splitter protection
3: Y-cable or line-card protection
4: Trunk card protection
|
CktAdditionalInfo
|
VARCHAR2(64)
|
—
|
Additional information about the circuits.
|
CktDesNodeName
|
VARCHAR2(4000)
|
—
|
Node name of the circuit destination.
|
CktDestModuleName
|
VARCHAR2(4000)
|
—
|
Module name of the circuit destination.
|
CktDestPhysicalLoc
|
VARCHAR2(4000)
|
—
|
Physical location of the circuit destination.
|
CktDestModelType
|
VARCHAR2(4000)
|
—
|
Model type of the circuit destination.
|
CktDestIfIndex
|
VARCHAR2(4000)
|
—
|
Circuit destination node ifindex.
|
CktDestObjectType
|
VARCHAR2(4000)
|
—
|
Object type.
|
CktComment
|
VARCHAR2(2014)
|
—
|
Circuit comment.
|
CktSrcPortName
|
VARCHAR2(64)
|
—
|
Port name of the circuit source.
|
CktSecSrcPortName
|
VARCHAR2(64)
|
—
|
Port name of the circuit secondary circuit source.
|
CktDestPortName
|
VARCHAR2(4000)
|
—
|
Port name of the circuit destination.
|
CktUseLap
|
NUMBER(1)
|
—
|
Indicates if the circuit uses a lap. Values are:
0: False
1: True
|
CktOchncChannel
|
NUMBER(2)
|
—
|
Circuit OCHNC channel number. Values are:
0: Not applicable
1: OCHNC_30_33
2: OCHNC_31_12
3: OCHNC_31_90
4: OCHNC_32_68
5: OCHNC_34_25
6: OCHNC_35_04
7: OCHNC_35_82
8: OCHNC_36_61
9: OCHNC_38_19
10: OCHNC_38_98
11: OCHNC_39_77
12: OCHNC_40_56
13: OCHNC_42_14
14: OCHNC_42_94
15: OCHNC_43_73
16: OCHNC_44_53
17: OCHNC_46_12
18: OCHNC_46_92
19: OCHNC_47_72
20: OCHNC_48_51
21: OCHNC_50_12
22: OCHNC_50_92
23: OCHNC_51_72
24: OCHNC_52_52
25: OCHNC_54_13
26: OCHNC_54_94
27: OCHNC_55_75
28: OCHNC_56_55
29: OCHNC_58_17
30: OCHNC_58_98
31: OCHNC_59_79
32: OCHNC_60_61
|
CktOchncDir
|
NUMBER(1)
|
—
|
Direction of the OCHNC circuit. Values are:
0: East to west
1: West to east
2: Not applicable
|
isDuplicateName
|
NUMBER(1)
|
DEFAULT 1
|
Values are:
0: DUPLICATE
1: NOT_DUPLICATE
|
NPID
|
NUMBER(10)
|
DEFAULT 0
|
Network partition ID.
|
CktAliasName
|
VARCHAR2(64)
|
—
|
Circuit alias name.
|
1.2.36 Circuit_VCG_Tbl
The Circuit_VCG_Tbl contains the inventory of virtual concatenation group circuits.
Primary key: none
Foreign key: FK_CIRCUIT_VCG_NPID
Tablespace: BASE_DATA_TABLESPACE
Note For medium, large, and high-end configurations, this table is partitioned.
Table 1-36 Circuit_VCG_Tbl
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
CktNodeId
|
NUMBER(10)
|
NOT NULL
|
Node ID of the source circuit node.
|
CktUniqueId
|
NUMBER(10)
|
NOT NULL
|
Unique number within each source node. The combination of the CktNodeId and CktUniqueId result in a unique circuit ID in the whole network. Note that these are internal fields and should not be displayed.
|
ParentCktNodeId
|
NUMBER(10)
|
NOT NULL
|
Node ID of the source node of the parent VCAT circuit.
|
ParentCktUniqueId
|
NUMBER(10)
|
NOT NULL
|
Unique number within each source node. The combination of ParentCktNodeId and ParentCktUniqueId result in a unique circuit ID in the whole network. Note that these are internal fields and should not be displayed.
|
VCGDirection
|
NUMBER(1)
|
—
|
VCG direction. Values are:
0: None
1: Forward
2: Backward
3: Bidirectional
|
NPID
|
NUMBER(10)
|
DEFAULT 0
|
Network partition ID.
|
VCATSTATE
|
NUMBER(1)
|
DEFAULT 0
|
VCAT member state.
|
1.2.37 Circuit_VLAN_Tbl
The Circuit_VLAN_Tbl contains information about VLANs associated with circuits.
Primary key: CIRCUIT_VLAN_PK
Foreign key: FK_CIRCUIT_VLAN_NPID
Tablespace: BASE_DATA_TABLESPACE
Note For medium, large, and high-end configurations, this table is partitioned.
Table 1-37 Circuit_VLAN_Tbl
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
CktNodeId
|
NUMBER(10)
|
NOT NULL
|
Node ID of the source node of the circuit.
|
CktUniqueId
|
NUMBER(10)
|
NOT NULL
|
Unique number within each source node. The CktNodeId and CktUniqueId combine to form a circuit ID that is unique in the network. Note that these are internal fields and should not be displayed.
|
CktVlanId
|
NUMBER(10)
|
—
|
VLAN ID.
|
CktVlanName
|
VARCHAR2(64)
|
—
|
VLAN name.
|
NPID
|
NUMBER(10)
|
DEFAULT 0
|
Network partition ID.
|
1.2.38 CLISession_Command_History_Tbl
The CLISession_Command_History_Tbl provides a list of commands used by a specific user in a CLI session.
Primary key: CLISESSION_COMMAND_HISTORY_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-38 CLISession_Command_History_Tbl
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
SessionTag
|
VARCHAR2(32)
|
NOT NULL
|
Session tag.
|
UserName
|
VARCHAR2(64)
|
NOT NULL
|
Name of the user.
|
Command_History
|
VARCHAR2(256)
|
NOT NULL
|
Command history.
|
1.2.39 CORBA_Functions_Table
The CORBA_Functions_Table contains information about the different GateWay/CORBA function name and types.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-39 CORBA_Functions_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
InterfaceIndex
|
NUMBER(10)
|
NOT NULL
|
Interface to which the function belongs.
|
FunctionName
|
VARCHAR(32)
|
NOT NULL
|
Name of function.
|
FunctionType
|
NUMBER(10)
|
NOT NULL
|
Type of the function. Values are:
1: Read
2: Modify
|
1.2.40 CORBA_GW_Active_User_Table
The CORBA_GW_Active_User_Table contains information about the active CTM GateWay/CORBA users.
Primary key: CORBA_GW_ACTIVE_USER_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-40 CORBA_GW_Active_User_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
active_session_id
|
VARCHAR2(128)
|
NOT NULL
|
Session ID.
|
user_name
|
VARCHAR2(128)
|
NOT NULL
|
Username of the OSS user.
|
client_end_ip
|
NUMBER(10)
|
NOT NULL
|
IP address of the OSS user.
|
LastLoginTime
|
DATE
|
—
|
Most recent user login date and time.
|
client_end_ipv6
|
RAW(16)
|
—
|
IPv6 address.
|
is_ipv6
|
NUMBER(1)
|
—
|
Flag indicating the IP version. Values are:
0: IPv4
1: IPv6
|
1.2.41 CORBA_Interface_Table
The CORBA_Interface_Table contains information about the GateWay/CORBA interface.
Primary key: CORBA_INTERFACE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-41 CORBA_Interface_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
InterfaceIndex
|
NUMBER(10)
|
NOT NULL
|
Index used for mapping of operations.
|
InterfaceName
|
VARCHAR(32)
|
NOT NULL
|
Name of the interface.
|
AdditionalPermissions
|
NUMBER(1)
|
NOT NULL
|
Type of interface. Values are:
0: No permissions
1: All read
2: All write
|
HelperClass
|
VARCHAR(128)
|
NOT NULL
|
Helper class name used to get the repository ID.
|
BaseInterface
|
NUMBER(10
|
NOT NULL
|
Base interface.
|
1.2.42 CORBA_Permission_Table
The CORBA_Permission_Table contains information about the GateWay/CORBA interface operation permissions.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-42 CORBA_Permission_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
InterfaceIndex
|
NUMBER(10)
|
NOT NULL
|
Index of the CORBA interface.
|
OperationID
|
NUMBER(10)
|
NOT NULL
|
Operation ID from the Operations_Table.
|
1.2.43 CTC_Model_Const_Table
The CTC_Model_Const_Table contains information about Cisco Transport Controller (CTC) models.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-43 CTC_Model_Const_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
CTCPackageName
|
VARCHAR2(40)
|
—
|
CTC package name.
|
CTCModel
|
VARCHAR2(40)
|
—
|
CTC model name.
|
CTMModel
|
VARCHAR2(128)
|
—
|
Corresponding CTM model name.
|
CTMObjectIndex
|
NUMBER(10)
|
—
|
Metadata object Index as defined in ObjectAttributeTable.
|
ModelType
|
NUMBER(10)
|
—
|
Model type as defined in Model_Type_Table.
|
1.2.44 CTC_UserProfile_Table
The CTC_UserProfile_Table contains information about CTC user profiles.
Primary key: CTC_USR_PROF_TABLE_PK
Tablespace: None
Table 1-44 CTC_UserProfile_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
UserID
|
VARCHAR2(64)
|
—
|
User ID of the CTC user type.
|
UserPassword
|
VARCHAR2(64)
|
NOT NULL
|
Password of the CTC user type.
|
PrivilegeID
|
NUMBER(10)
|
NOT NULL
|
Privilege ID of the CTC user type.
|
UserDesc
|
VARCHAR2(256)
|
NOT NULL
|
Description of the CTC user type.
|
1.2.45 CTM_Config_Table
The CTM_Config_Table stores CTM configuration information. For detailed definitions of the parameters in this table, see Appendix B, "Ctm_Config_Table Parameters."
Primary key: ctm_config_table_pk
Tablespace: BASE_DATA_TABLESPACE
Table 1-45 CTM_Config_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
SectionName
|
VARCHAR2(40)
|
NOT NULL
|
Name of the section.
|
PropertyName
|
VARCHAR2(40)
|
NOT NULL
|
Name of the parameter.
|
ActiveValue
|
VARCHAR2(128)
|
—
|
Active value of the parameter.
|
IsPermanent
|
NUMBER(1)
|
NOT NULL
|
Whether or not the value can be changed. Values are:
0: False
1: True
|
PermanentValue
|
VARCHAR2(128)
|
—
|
Permanent value of the parameter.
|
1.2.46 CTM_Unique_ObjectType_Table
The CTM_Unique_ObjectType_Table contains a list of unique object types.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-46 CTM_Unique_ObjectType_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
ObjectType
|
NUMBER(10)
|
NOT NULL UNIQUE
|
Object type.
|
ObjectName
|
VARCHAR2(256)
|
NOT NULL
|
Object name of the object type.
|
1.2.47 CTM_Unknown_User_Table
The CTM_Unknown_User_Table contains information about login attempts by unknown CTM users.
Primary key: CTM_Unknown_USER_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-47 CTM_Unknown_User_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
IPAddress
|
NUMBER(10)
|
NOT NULL
|
IP address of the unknown user.
|
FailedAttempts
|
NUMBER(2)
|
DEFAULT 0
|
Number of login attempts from the unknown user associated with a specific IP address.
|
LastLoginFailTime
|
DATE
|
—
|
Most recent time when the unknown user attempted to log into the CTM client.
|
LockedState
|
NUMBER(1)
|
DEFAULT 0
|
Status of the unknown user's account (locked or unlocked). Values are:
0: Not locked
1: Locked
|
1.2.48 Custom_View_Table
The Custom_View_Table contains the customized views that users have selected for display in the CTM GUI.
Primary key: CUSTOM_VIEW_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-48 Custom_View_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
ViewID
|
NUMBER(10)
|
NOT NULL
|
Unique number created by the database.
|
UserID
|
NUMBER(4)
|
NOT NULL
|
User identifier.
|
TableID
|
NUMBER(4)
|
NOT NULL
|
Table identifier.
|
1.2.49 DB_Auditing_Table
The DB_Auditing_Table contains database audit information. This is an Internal table updated only by CTM processes.
Primary key: DB_AUDITING_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-49 DB_Auditing_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
OPERATIONID
|
NUMBER(4)
|
NOT NULL
|
Audit operation identification.
|
OP_DATE
|
TIMESTAMP(6)
|
NOT NULL
|
Audit operation date.
|
STATUS
|
VARCHAR2(32)
|
—
|
Audit operation status.
|
DESCRIPTION
|
VARCHAR2(4000)
|
NOT NULL
|
Database audit description.
|
1.2.50 DB_CONNECTION_CONFIG_TABLE
The DB_CONNECTION_CONFIG_TABLE is an internal configuration table used by CTM. It contains database connection initialization parameters and should not be modified.
Primary key: DB_CONNECTION_CONFIG_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-50 DB_CONNECTION_CONFIG_TABLE
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
SERVER_ID
|
VARCHAR2(256)
|
NOT NULL
|
|
INITIALIMIT
|
NUMBER(10)
|
NOT NULL
|
|
MINLIMIT
|
NUMBER(10)
|
NOT NULL
|
|
MAXSTATMLIMIT
|
NUMBER(10)
|
NOT NULL
|
|
INACTIVITY_TMO
|
NUMBER(10)
|
NOT NULL
|
|
ABANDONED_TMO
|
NUMBER(10)
|
NOT NULL
|
|
CONNECT_WAIT_TMO
|
NUMBER(10)
|
NOT NULL
|
|
PROPERTY_CHECK_INTERVAL
|
NUMBER(10)
|
NOT NULL
|
|
1.2.51 DB_History_Table
The DB_History_Table contains historical database information. It is an internal table updated only by CTM. The table logs all major database operations such as export, import, installation, backup, and restore.
Primary key: DB_HISTORY_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-51 DB_History_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
OPERATIONID
|
NUMBER(4)
|
NOT NULL
|
Operation identification.
|
OP_DATE
|
TIMESTAMP(6)
|
NOT NULL
|
Operation date.
|
STARTING_VERSION
|
VARCHAR2(32)
|
—
|
Starting version.
|
FINAL_VERSION
|
VARCHAR2(32)
|
—
|
Final version.
|
FINAL_SIZE
|
VARCHAR2(32)
|
—
|
Final size.
|
STARTING_MODULES
|
VARCHAR2(32)
|
—
|
Starting modules.
|
FINAL_MODULES
|
VARCHAR2(32)
|
—
|
Final modules.
|
STATUS
|
VARCHAR2(32)
|
—
|
Operation status.
|
ADDITIONAL_INFO
|
VARCHAR2(4000)
|
—
|
Additional information.
|
1.2.52 DB_OperationID_Table
The DB_OperationID_Table contains the database operation identification.
Primary key: DB_OPERATIONID_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-52 DB_OperationID_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
OPERATIONID
|
NUMBER(4)
|
NOT NULL
|
The database operation ID. Values are:
0: Installation
1: Migration
2: Patch
3: SP
4: Import
5: Export
6: Backup
7: Restore
|
DESCRIPTION
|
VARCHAR2(4000)
|
NOT NULL
|
The database operation description.
|
1.2.53 DB_Pruning_Table
The DB_Pruning_Table contains contains the names of the stored procedures that are used for pruning.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-53 DB_Pruning_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
DBProcedure
|
VARCHAR(32)
|
NOT NULL
|
Name of the database procedure.
|
ConfigProperty
|
VARCHAR(32)
|
NOT NULL
|
Property name in the CTM_Config_Table.
|
MonitorParam
|
VARCHAR(32)
|
NOT NULL
|
Threshold parameter name in the Server_Threshold_Parameter_Table.
|
1.2.54 Debug_Module_Mapping_Table
The Debug_Module_Mapping_Table defines the mapping between classes and modules, and defines which class belongs to which module.
Primary key: none
Tablespace: BASE_DATA_TABLESPACE
Table 1-54 Debug_Module_Mapping_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
PackageOrClass
|
VARCHAR2(80)
|
—
|
Class or package name.
|
ModuleId
|
NUMBER(10)
|
NOT NULL
|
Module ID.
|
1.2.55 Debug_Module_Table
The Debug_Module_Table contains a list of modules for module level debugging.
Primary key: DEBUG_MODULE_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-55 Debug_Module_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
ModuleId
|
NUMBER(10)
|
NOT NULL
|
Module ID.
|
ModuleName
|
VARCHAR2(40)
|
—
|
Name of module.
|
ConfigProperty
|
VARCHAR2(20)
|
—
|
Located under debug section in the CTM_Config_Table where the module severity is stored.
|
1.2.56 Deleted_User_Table
The Deleted_User_Table contains information about CTM users that were deleted.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-56 Deleted_User_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
username
|
VARCHAR2(64)
|
—
|
Username.
|
deletedtime
|
DATE
|
—
|
Date username was deleted.
|
1.2.57 Diskspace_Usage_Table
The Diskspace_Usage_Table stores information about database disk space usage.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-57 Diskspace_Usage_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
partitionname
|
NUMBER(2)
|
NOT NULL
|
Name of the partition. Values are:
0: oracle
1: db01
2: db02
3: db03
4: db04
5: db05
|
usage
|
NUMBER(3)
|
—
|
Database usage threshold.
|
1.2.58 Domain_Table
The Domain_Table contains information about the hierarchy of group and NE nodes in the domain.
Primary key: DOMAIN_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-58 Domain_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
TreeNodeID
|
NUMBER(10)
|
NOT NULL
|
Unique sequence number generated by the database. Each node in the Domain Explorer tree is assigned a unique number that is used as an index to access group information in other tables.
|
ParentType
|
NUMBER(2)
|
NOT NULL
|
Indicates that the parent is a group.
|
ParentId
|
NUMBER(10)
|
NOT NULL
|
ID of the group.
|
ChildType
|
NUMBER(2)
|
NOT NULL
|
Type of tree node. Values are:
1: Root node
2: Group node
3: NE node
|
ChildId
|
NUMBER(10)
|
NOT NULL
|
ID of the group or NE.
|
1.2.59 Ems_Alarm_Table
The Ems_Alarm_Table shows information about EMS alarms.
Primary key: EMS_ALARM_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-59 Ems_Alarm_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
Name
|
VARCHAR2(128)
|
—
|
Name of the alarm displayed to client.
|
alarmIndex
|
NUMBER(5)
|
—
|
EMS index of alarm or group.
|
isGroup
|
NUMBER(1)
|
—
|
Whether or not this alarm belongs to a group. Values are:
0: FALSE
1: TRUE
|
Severity
|
NUMBER(1)
|
DEFAULT 4
|
Alarm severity. Values are:
-1: N/A
4: Warning
5: Minor
6: Major
7: Critical
|
isEnabled
|
NUMBER(1)
|
DEFAULT 1
|
Whether or not the alarm is enabled. Values are:
0: False
1: True
|
1.2.60 Enum_Table
The Enum_Table is used by link management to display link information in the link table.
Primary key: ENUM_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-60 Enum_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
EnumBase
|
NUMBER(4)
|
—
|
Value of attribute base.
|
EnumInt
|
NUMBER(3)
|
—
|
Possible values of the attribute base.
|
UIValue
|
VARCHAR2(128)
|
—
|
String representation of attribute base.
|
1.2.61 EQPT_Info_Table
The EQPT_Info_Table stores equipment provisioning information.
Primary key: EQPT_INFO_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-61 EQPT_Info_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
NEDBACCESSID
|
NUMBER(10)
|
NOT NULL
|
Database access ID; same as NEDBAccessID in the NE_INFO_TABLE.
|
PHYSICALLOC
|
NUMBER(20)
|
NOT NULL
|
Physical location.
|
IFINDEX
|
NUMBER(20)
|
NOT NULL
|
Interface index.
|
MODULETYPE
|
NUMBER(8)
|
—
|
Module type.
|
OBJECTINDEX
|
NUMBER(10)
|
NOT NULL
|
Metadata object index.
|
MODELTYPE
|
NUMBER(4)
|
NOT NULL
|
Model type.
|
COL1
|
VARCHAR2(256)
|
—
|
Columns 1 to 250 store attribute values as defined by the metadata.
|
COL2
|
VARCHAR2(256)
|
—
|
Columns 1 to 250 store attribute values as defined by the metadata.
|
COL3
|
VARCHAR2(256)
|
—
|
Columns 1 to 250 store attribute values as defined by the metadata.
|
COL4
|
VARCHAR2(256)
|
—
|
Columns 1 to 250 store attribute values as defined by the metadata.
|
COL5
|
VARCHAR2(256)
|
—
|
Columns 1 to 250 store attribute values as defined by the metadata.
|
...
|
COL248
|
VARCHAR2(4000)
|
—
|
Columns 1 to 250 store attribute values as defined by the metadata.
|
COL249
|
VARCHAR2(4000)
|
—
|
Columns 1 to 250 store attribute values as defined by the metadata.
|
COL250
|
VARCHAR2(4000)
|
—
|
Columns 1 to 250 store attribute values as defined by the metadata.
|
1.2.62 Eqpt_Relationship_Table
The Eqpt_Relationship_Table contains information about the equipment relationship table.
Primary key: EQPT_RELATIONSHIP_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-62 Eqpt_Relationship_Table
Column Name
|
Oracle Data
Type
|
Integrity Constraints
|
Description
|
NEDBACCESSID
|
NUMBER(10)
|
NOT NULL
|
NE database access ID.
|
SELFPHYSICALLOC
|
NUMBER(20)
|
NOT NULL
|
Physical location (equipment 1).
|
SELFIFINDEX
|
NUMBER(20)
|
NOT NULL
|
If index (equipment 1).
|
SELFMODULETYPE
|
NUMBER(10)
|
NOT NULL
|
Module type (equipment 1).
|
SELFMODELTYPE
|
NUMBER(10)
|
NOT NULL
|
Model type.
|
SELFOBJECTINDEX
|
NUMBER(10)
|
NOT NULL
|
Object index.
|
SELFSTROBJINST
|
VARCHAR2(4000)
|
NOT NULL
|
—
|
RELATEDPHYSICALLOC
|
NUMBER(20)
|
NOT NULL
|
Physical location (equipment 2).
|
RELATEDIFINDEX
|
NUMBER(20)
|
NOT NULL
|
If index (equipment 2).
|
RELATEDMODULETYPE
|
NUMBER(10)
|
NOT NULL
|
Module type (equipment 2).
|
RELATEDMODELTYPE
|
NUMBER(10)
|
NOT NULL
|
Model type.
|
RELATEDOBJECTINDEX
|
NUMBER(10)
|
NOT NULL
|
Object index.
|
RELATEDSTROBJINST
|
VARCHAR2(4000)
|
NOT NULL
|
—
|
1.2.63 Error_Log_Table
The Error_Log_Table contains information about all errors reported by CTM.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-63 Error_Log_Table
Column Name
|
Oracle Data
Type
|
Integrity Constraints
|
Description
|
TimeStamp
|
DATE
|
—
|
Time stamp of log message.
|
Module
|
NUMBER(2)
|
NOT NULL
|
One of the predefined modules. Values are:
1: ServiceWay
2: TL1
3: ThruWay
4: Transport Manager
|
Severity
|
NUMBER(2)
|
NOT NULL
|
Severity of error message. Values are:
1: Critical
2: Major
3: Minor
4: Informational
|
SubModule
|
NUMBER(2)
|
—
|
Submodules for modules.
|
FileName
|
VARCHAR2(256)
|
—
|
Name of the file from which the message was printed.
|
LineNumber
|
NUMBER(4)
|
—
|
Line number from which the message was printed.
|
LogMessage
|
VARCHAR2(1024)
|
—
|
Text of the error message.
|
1.2.64 Forwarding_Table
The Forwarding_Table is obsolete.
1.2.65 GNE_Table
The GNE_Table contains information about the various GNEs in the network.
Primary key: GNE_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-64 GNE_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
GNEID
|
NUMBER(8)
|
NOT NULL
|
GNE identifier. Unique sequence number generated by the database. This is the link between this table and GNEID in the NE_INFO_TABLE.
|
GNEType
|
NUMBER(4)
|
DEFAULT 1
|
Values are:
1: Unknown
2: Self
3: ISR_as_GNE
4: Foreign_GNE_TL1
5: Foreign_GNE_CLNP
6: Foreign_GNE_IP
|
RINGID
|
NUMBER(8)
|
—
|
Identifies the ring to which the NE is connected. NEs with similar RING_IDs are in the same ring.
|
GNESysId
|
VARCHAR2(128)
|
NOT NULL
|
Name of the GNE.
|
NextHopIPAddr
|
NUMBER(10)
|
NOT NULL
|
IP address of the next hop used to reach the GNE.
|
GNEComment
|
VARCHAR2(512)
|
—
|
Comment for the GNE.
|
GroupOption
|
NUMBER(1)
|
DEFAULT 0
|
Values are:
0: Default grouping
1: Group by GNE
2: Group by Subnet
|
GroupPrefix
|
VARCHAR2(12)
|
—
|
Group prefix that may be used for group names.
|
UserID
|
NUMBER(4)
|
DEFAULT 0
|
Value of 0 means no owner.
|
1.2.66 Group_Info_Table
The Group_Info_Table contains information about all groups defined in the Domain Explorer tree.
Primary key: GROUP_INFO_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-65 Group_Info_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
GroupID
|
NUMBER(4)
|
NOT NULL
|
ID of the group; a unique sequence number generated by the database.
|
GroupName
|
VARCHAR2(64)
|
UNIQUE NOT NULL
|
Name of the group.
|
GroupDescription
|
VARCHAR2(256)
|
—
|
Description field.
|
GroupUserLabel
|
VARCHAR2(64)
|
—
|
Users for this group.
|
GroupLocationName
|
VARCHAR2(64)
|
—
|
Location of this group.
|
1.2.67 GW_SNMP_OSS_Info_Table
The GW_SNMP_OSS_Info_Table contains information about the CTM GateWay/Simple Network Management Protocol (SNMP) Operating Support System (OSS). The CTM GateWay/SNMP feature provides an SNMP trap forwarding service, where any trap received by CTM is forwarded to the set of defined trap destinations.
Primary key: GW_SNMP_OSS_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-66 GW_SNMP_OSS_Info_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
SNMPV3_USERNAME
|
VARCHAR2(64)
|
—
|
Name of the user who authenticates the SNMPv3 trap.
|
SNMPV3_COMMUNITY
|
VARCHAR2(64)
|
—
|
The SNMPv3 community name.
|
SNMPV3_AUTH_PROT
|
VARCHAR2(64)
|
—
|
The SNMPv3 authentication protocol.
|
SNMPV3_AUTH_PWD
|
VARCHAR2(64)
|
—
|
The SNMPv3 authentication password.
|
SNMPV3_PRIV_PROT
|
VARCHAR2(64)
|
—
|
The SNMPv3 privacy protocol.
|
SNMPV3_PRIV_PWD
|
VARCHAR2(64)
|
—
|
The SNMPv3 privacy password.
|
SNMP_VERSION
|
NUMBER(4)
|
—
|
The SNMP version:
0: SNMPv1
1: SNMPv2
2: SNMPv3
|
SNMP_COMMUNITY
|
VARCHAR2(64)
|
—
|
The SNMP community name.
|
SNMP_PORT
|
NUMBER(10)
|
—
|
The SNMP OSS destination port.
|
SNMPV3_EID
|
VARCHAR2(64)
|
—
|
The SNMPv3 engine identification.
|
SNMPV3_IP
|
RAW(16)
|
NOT NULL
|
The SNMPv3 IP address.
|
SNMPV3_IS_IP6
|
NUMBER(1)
|
—
|
The SNMPv3 IPv6 flag.
|
1.2.68 GWCORBA_PM_Mapping_Table
The GWCORBA_PM_Mapping_Table contains PM data mapping information about CTM GateWay/CORBA.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-67 GWCORBA_PM_Mapping_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
MODELTYPE
|
NUMBER(4)
|
NOT NULL
|
Unique number associated with each NE model type.
|
LAYERRATE
|
NUMBER(10)
|
NOT NULL
|
Layer rate(s) associated with each PM type.
|
OBJECTINDEX
|
NUMBER(10)
|
NOT NULL
|
Unique object type associated with a specific PM type.
|
LOCATION
|
NUMBER(2)
|
NOT NULL
|
Whether the PM data is near-end or far-end data. Values are:
1: Near end
2: Far end
|
DIRECTION
|
NUMBER(2)
|
NOT NULL
|
Whether the PM data is receive or transmit. Values are:
1: Receive (Rx)
2: Transmit (Tx)
|
TERMINATIONPOINT
|
NUMBER(2)
|
NOT NULL
|
Whether the PM parameters are for noncircuit or circuit data. Values are:
0: Noncircuit
1: Circuit
|
PMVIEWNAME
|
VARCHAR2(64)
|
NOT NULL
|
Name of the PM view in the CTM database from which the PM data is retrieved.
|
1.2.69 IF_Cross_Connect
The IF_Cross_Connect table contains information about cross-connects between interfaces on the same NE. Point-to-point (p2p) and point-to-multipoint (p2mp) are supported.
Primary key: None
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-68 IF_Cross_Connect
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
XCDBAccessID
|
NUMBER(10)
|
NOT NULL
|
Unique sequence number (can be a foreign key).
|
NEDBAccessId
|
NUMBER(10)
|
NOT NULL
|
ID to access this table for an NE; same as NEDBAccessID in the NE_INFO_TABLE.
|
SrcIFDBAccessID
|
NUMBER(10)
|
NOT NULL
|
Source interface endpoint.
|
DestIFDBAccessID
|
NUMBER(10)
|
NOT NULL
|
Destination interface endpoint.
|
XCType
|
NUMBER(2)
|
DEFAULT 4
|
Type of switching element used:
1: Unknown
2: Electrical cross-connect
3: Optical cross-connect
4: Autoselect
|
XCKind
|
NUMBER(2)
|
DEFAULT 5
|
Type of call control to establish cross-connect:
1: Provisioned
2: Automatic
3: Dynamic
4: Protection
5: Other
|
CreationTime
|
DATE
|
—
|
Time when this cross-connect was created.
|
Src2DestOperStatus
|
NUMBER(2)
|
NOT NULL
|
Operational state from source to destination:
1: Up
2: Down
3: Dormant
4: Unknown
|
Dest2SrcOperStatus
|
NUMBER(2)
|
NOT NULL
|
Operational state from destination to source:
1: Up
2: Down
3: Dormant
4: Unknown
|
Src2DestLastChange
|
DATE
|
—
|
Sysuptime value when the cross-connect in this direction changed its operational state.
|
Dest2SrcLastChange
|
DATE
|
—
|
Sysuptime value when the cross-connect in this direction changed its operational state.
|
1.2.70 IF_DWDM_Channel_Group
The IF_DWDM_Channel_Group table contains information about interfaces representing groups of DWDM channels.
Primary key: IF_DWDM_CHAN_FREQ_PK
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-69 IF_DWDM_Channel_Group
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
IFDBAccessID
|
NUMBER(10)
|
NOT NULL
|
Reference to IFDBAccessID in the MIB2_Interface_Table.
|
NEDBAccessID
|
NUMBER(10)
|
NOT NULL
|
ID to access this table for an NE; same as NEDBAccessID in the NE_INFO_TABLE.
|
MinFrequency
|
NUMBER(10)
|
NOT NULL
|
Lowest frequency in the bitmap for bit 0.
|
Spacing
|
NUMBER(4)
|
NOT NULL
|
Frequency spacing between successive bits.
|
BitmapLogic
|
NUMBER(2)
|
DEFAULT 1
|
Whether frequencies in the bitmap are carried or blocked. Values are:
1: Carried
2: Blocked
|
Bitmap
|
VARCHAR2(64)
|
NOT NULL
|
List of frequencies as a bitmap.
|
1.2.71 IF_Optical_Phy_Config_Table
The IF_Optical_Phy_Config_Table describes extended physical properties for certain interfaces.
Primary key: IF_OPTICAL_PHY_PK
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-70 IF_Optical_Phy_Config_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
IFDBAccessID
|
NUMBER(10)
|
NOT NULL
|
Reference to IFDBAccessID in the MIB2_Interface_Table.
|
NEDBAccessID
|
NUMBER(10)
|
NOT NULL
|
ID to access this table for an NE; same as NEDBAccessID in the NE_INFO_TABLE.
|
IfMode
|
NUMBER(2)
|
DEFAULT 1
|
Mode of operation. Values are:
1: mode2R
2: mode3R
|
IfProtocol
|
NUMBER(2)
|
DEFAULT 1
|
Client-side protocol to be monitored. Values are:
1: Other
2: Unknown
3: Gigabit Ethernet
4: 10-Gigabit Ethernet
5: Fiber channel
6: FICON
7: ESCON
8: SONET
|
IfClockRate
|
NUMBER(4)
|
—
|
Clock rate for client interface.
|
IfMonitorState
|
NUMBER(1)
|
—
|
Monitor state. Values are:
1: Enabled
2: Disabled
|
IfLoopback
|
NUMBER(2)
|
DEFAULT 1
|
Loopback status. Values are:
1: No loop
2: Diagnostic loop
3: Line loop
4: Other loop
|
IfOFC
|
NUMBER(1)
|
—
|
OFC state. Values are:
1: Enabled
2: Disabled
|
IfLaserSafteyControl
|
NUMBER(1)
|
—
|
Trunk-side laser safety control (LSC) state. Values are:
1: Enabled
2: Disabled
|
IfFLC
|
NUMBER(1)
|
—
|
State of forward laser control (FLC). Values are:
1: Enabled
2: Disabled
|
1.2.72 IFIndex_Rule_Table
The IFIndex_Rule_Table contains information on the rules to construct the IfIndex for each object type of an NE model.
Primary key: IFINDEX_RULE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-71 IFIndex_Rule_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
ModelType
|
NUMBER(10)
|
NOT NULL
|
Model type.
|
ObjectType
|
NUMBER(10)
|
NOT NULL
|
Object type.
|
AttributeNameConst
|
NUMBER(10)
|
NOT NULL
|
Integer constant of the attribute.
|
AttrOrder
|
NUMBER(10)
|
NOT NULL
|
Sequential number.
|
AttrSize
|
NUMBER(10)
|
NOT NULL
|
Size of the attribute in bytes.
|
AttrType
|
NUMBER(10)
|
NOT NULL
|
Type of the attribute.
|
1.2.73 Interface_APS_Info
The Interface_APS_Info table contains APS information about interfaces that are members of an APS group.
Primary key: IF_APS_INFO_PK
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-72 Interface_APS_Info
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
IFDBAccessID
|
NUMBER(10)
|
NOT NULL
|
Reference to IFDBAccessID in the MIB2_Interface_Table.
|
NEDBAccessID
|
NUMBER(10)
|
NOT NULL
|
ID to access this table for an NE; same as NEDBAccessID in the NE_INFO_TABLE.
|
ApsGroupName
|
VARCHAR2(64)
|
—
|
APS group name.
|
ApsChanNumber
|
NUMBER(2)
|
DEFAULT -1
|
Working or protected channel.
|
ApsChanStatusCurrent
|
NUMBER(2)
|
DEFAULT -1
|
Current state of interface in the group:
1: Locked out
2: Signal degrade
3: Signal failure
4: Switched
|
ApsChanLastSwitchover
|
DATE
|
—
|
Time since switch to protection channel.
|
ApsInterfaceState
|
NUMBER(2)
|
DEFAULT -1
|
Active or standby:
-1: Unknown
1: Active
2: Standby
|
1.2.74 Interface_DWDM_Frequency
The Interface_DWDM_Frequency table contains wavelength information about certain optical interfaces carrying DWDM frequencies.
Primary key: IF_DWDM_FREQ_PK
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-73 Interface_DWDM_Frequency
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
IFDBAccessID
|
NUMBER(10)
|
NOT NULL
|
Reference to IFDBAccessID in the MIB2_Interface_Table.
|
NEDBAccessID
|
NUMBER(10)
|
NOT NULL
|
ID to access this table for an NE; same as NEDBAccessID in the NE_INFO_TABLE.
|
Frequency
|
NUMBER(10)
|
NOT NULL
|
DWDM frequency.
|
1.2.75 Interface_Stack_Table
The Interface_Stack_Table provides information about underlying and overlaying layer relationships between interfaces.
Primary key: IFSTACK_PK
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-74 Interface_Stack_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
UniqueID
|
NUMBER(10)
|
NOT NULL
|
Unique sequence number. Acts as foreign key.
|
NEDBAccessID
|
NUMBER(10)
|
NOT NULL
|
ID to access this table for an NE; same as NEDBAccessID in the NE_INFO_TABLE.
|
HighIfDBAccessID
|
NUMBER(10)
|
NOT NULL
|
IFDBAccessID at the higher layer in the stack.
|
LowIfDBAccessID
|
NUMBER(10)
|
NOT NULL
|
IFDBAccessID at the lower layer in the stack.
|
Status
|
NUMBER(2)
|
NOT NULL
|
Operational state of lower layer. Values are:
1: Up
2: Down
3: Testing
4: Unknown
5: Dormant
6: Not present
7: Lower layer down
|
1.2.76 Interface_Table
The Interface_Table contains static interface indexes and names for an NE managed by CTM.
Primary key: INTERFACE_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-75 Interface_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
NEType
|
NUMBER(1)
|
NOT NULL
|
Type of NE. Values are:
-1: Common ifNames
Any-other-number: NEModelIndex of the NE_INFO_TABLE
|
ifStaticIndex
|
NUMBER(4)
|
NOT NULL
|
Interface table static index; unique value for each interface on the NE.
|
ifName
|
VARCHAR2(64)
|
NOT NULL
|
Name of the interface.
|
1.2.77 IOS_Parser_Static_Tree_Table
The IOS_Paerser_Static_Tree_Table contains information about the IOS parser static tree table.
Primary key: IOS_PARSER_STATIC_TREE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-76 IOS_Parser_Static_Tree_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
ModelIndex
|
NUMBER(8)
|
NOT NULL
|
Model index for the static tree.
|
IOSModelName
|
VARCHAR(128)
|
NOT NULL
|
Index of the static tree.
|
NodeIndex
|
NUMBER(8)
|
NOT NULL
|
Index of the node.
|
ParentIndex
|
NUMBER(8)
|
NOT NULL
|
Parent node index: -1 for the root node.
|
NodeName
|
VARCHAR(128)
|
NOT NULL
|
Name of the IOS node.
|
NodeValue
|
VARCHAR(128)
|
—
|
Value of the nodes.
|
CTMAttributeName
|
VARCHAR(128)
|
—
|
Corresponding CTM attribute name.
|
AttributeLocation
|
NUMBER(8)
|
NOT NULL
|
Position of the attribute in the object index.
|
1.2.78 L2_FrontPort_Table
The L2_FrontPort_Table contains information about the L2 front port table.
Primary key: L2_FRONTPORT_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-77 L2_FrontPort_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
NEID
|
NUMBER(10)
|
NOT NULL
|
NE ID.
|
SLOT_NUMBER
|
NUMBER(2)
|
NOT NULL
|
Slot number.
|
PORT_NUMBER
|
NUMBER(2)
|
NOT NULL
|
Port number.
|
NNI
|
NUMBER(1)
|
—
|
Port type.
|
UNI
|
NUMBER(1)
|
—
|
Port type.
|
DOT1Q
|
NUMBER(1)
|
—
|
Connection type.
|
QINQ
|
NUMBER(1)
|
—
|
Connection type.
|
UNTAGGED
|
NUMBER(1)
|
—
|
Connection type.
|
BG_COUNT
|
NUMBER(3)
|
—
|
—
|
SUB_IF_COUNT
|
NUMBER(3)
|
—
|
—
|
PORT_STATE
|
NUMBER(1)
|
—
|
Port state. Values are:
0: PORT_STATE_DISABLED
1: PORT_STATE_ENABLED
|
PM_STATUS
|
NUMBER(1)
|
—
|
—
|
MTU_SIZE
|
VARCHAR(6)
|
—
|
—
|
SPEED
|
VARCHAR(6)
|
—
|
—
|
DUPLEX
|
VARCHAR(6)
|
—
|
—
|
FLOWCONTROL_SEND
|
VARCHAR(30)
|
—
|
—
|
FLOWCONTROL_RECEIVE
|
VARCHAR(30)
|
—
|
—
|
CDP
|
VARCHAR(30)
|
—
|
Cisco Discovery Protocol.
|
1.2.79 L2_Interface_QoSClass_Table
The L2_Interface_QoSClass_Table stores all the QoS parameters that are configured on a Layer 2 service drop. The Layer 2 services are configured on a Layer 2 topology. The table is populated when a new Layer 2 service is created or discovered in CTM.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-78 L2_Interface_QoSClass_Table
Column Name
|
Oracle Data Type
|
Integrity Constraints
|
Description
|
NEID
|
NUMBER(10)
|
NOT NULL
|
NE ID.
|
Slot_Number
|
NUMBER(3)
|
NOT NULL
|
Slot number.
|
Bridge_Group_Number
|
NUMBER(3)
|
|
