Table Of Contents

Database Schema Tables

1.1  CTM Sequence Numbers

1.2  CTM Tables

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  APS_Group_Table

1.2.11  Audit_Log_Mapping_Table

1.2.12  Audit_Log_Table

1.2.13  BLSR_Node

1.2.14  BLSR_SPAN

1.2.15  BLSR_Table

1.2.16  Bridge_Group_Table

1.2.17  C_MetaData

1.2.18  C_MetaData_Attr_Presentation

1.2.19  C_MetaData_Col

1.2.20  C_MetaData_Filter

1.2.21  C_MetaData_Grp_Presentation

1.2.22  C_MetaData_NETypes

1.2.23  C_Property_Sheet_Info_Table

1.2.24  C_Tab_Metadata_Info_Table

1.2.25  C_Tab_Metadata_Table

1.2.26  Cerent_NE_Group_Table

1.2.27  Circuit_Dest_Tbl

1.2.28  Circuit_Size_Table

1.2.29  Circuit_Span_Tbl

1.2.30  Circuit_Tbl

1.2.31  Circuit_VCG_Tbl

1.2.32  Circuit_VLAN_Tbl

1.2.33  CLISession_Command_History_Tbl

1.2.34  CORBA_Functions_Table

1.2.35  CORBA_Interface_Table

1.2.36  CORBA_Permission_Table

1.2.37  CTC_Model_Const_Table

1.2.38  CTC_UserProfile_Table

1.2.39  CTM_Config_Table

1.2.40  CTM_Unique_ObjectType_Table

1.2.41  DB_Pruning_Table

1.2.42  Debug_Module_Mapping_Table

1.2.43  Debug_Module_Table

1.2.44  Deleted_User_Table

1.2.45  Diskspace_Usage_Table

1.2.46  Domain_Table

1.2.47  Ems_Alarm_Table

1.2.48  Enum_Table

1.2.49  EQPT_Info_Table

1.2.50  Eqpt_Relationship_Table

1.2.51  Error_Log_Table

1.2.52  Forwarding_Table

1.2.53  GNE_Table

1.2.54  Group_Info_Table

1.2.55  HA_Table

1.2.56  HFR_ACL_Policy_Config

1.2.57  HFR_BGP_PEER_PM_Table

1.2.58  HFR_Common_Interface_Config

1.2.59  HFR_ETHER_Interface_Config

1.2.60  HFR_Interface_DRC_PM_Table

1.2.61  HFR_Interface_GC_PM_Table

1.2.62  HFR_Interface_Helper_Address

1.2.63  HFR_Interface_MTU_Layer2

1.2.64  HFR_Interface_Secondary_Addr

1.2.65  HFR_MPLS_Interface_PM_Table

1.2.66  HFR_MPLS_LDP_PM_Table

1.2.67  HFR_MPLS_TE_Link_PM_Table

1.2.68  HFR_MPLS_TE_Tunnel_PM_Table

1.2.69  HFR_Node_CPU_PM_Table

1.2.70  HFR_Node_Memory_PM_Table

1.2.71  HFR_Node_Process_PM_Table

1.2.72  HFR_POS_Interface_Config

1.2.73  HFR_SONET_Interface_Config

1.2.74  HFR_SONET_Interface_Path

1.2.75  HFR_Version_Info

1.2.76  IF_Cross_Connect

1.2.77  IF_DWDM_Channel_Group

1.2.78  IF_Optical_Phy_Config_Table

1.2.79  IFIndex_Rule_Table

1.2.80  Interface_APS_Info

1.2.81  Interface_DWDM_Frequency

1.2.82  Interface_Stack_Table

1.2.83  Interface_Table

1.2.84  IOS_Parser_Static_Tree_Table

1.2.85  L2_FrontPort_Table

1.2.86  L2_Interface_QoSClass_Table

1.2.87  L2_Interface_Table

1.2.88  L2QoSTemplate_QoSClass_Table

1.2.89  L2QoSTemplate_Table

1.2.90  L2Topology_Circuits_Table

1.2.91  L2Topology_Table

1.2.92  L2_Vlan_Table

1.2.93  Link_Table

1.2.94  Managed_Et_Table

1.2.95  Map_Coordinate_Table

1.2.96  Map_Cust_Table

1.2.97  Map_Image_Table

1.2.98  Map_Link_Table

1.2.99  MIB2_Interface_Table

1.2.100  Model_Type_Table

1.2.101  Module155xx_Community_String

1.2.102  Module155xx_VTOID_Table

1.2.103  Module_Type_Mll_Info

1.2.104  Module_Type_Table

1.2.105  NE_Audit_Trail_Table

1.2.106  NE_Info_Table

1.2.107  NE_Inventory_Table

1.2.108  NE_Model_State_Table

1.2.109  NE_Model_Type_Table

1.2.110  NE_Port_Status_Table

1.2.111  NE_Swimage_Table

1.2.112  Network_Partition_Table

1.2.113  ObjectAttributeTable

1.2.114  Object_Relationship_Table

1.2.115  ObjectTypeTable

1.2.116  ONS15216_Active_User_Table

1.2.117  ONS15216_NE_Inventory_Table

1.2.118  ONS15216_Privilege_Table

1.2.119  ONS15216_User_Table

1.2.120  ONS1530x_HO_PM_Table

1.2.121  ONS1530x_IP_PM_Table

1.2.122  ONS1530x_LO_PM_Table

1.2.123  ONS1530x_MS_PM_Table

1.2.124  ONS1530x_NE_Inventory_Table

1.2.125  ONS1530x_RS_PM_Table

1.2.126  ONS15454_327_NE_Table

1.2.127  ONS15454_8B10B_PM_Table

1.2.128  ONS15454_Active_User_Table

1.2.129  ONS15454_CBQoS_Info_Table

1.2.130  ONS15454_CLASSMAP_PM_Table

1.2.131  ONS15454_CMS_Storage_Table

1.2.132  ONS15454_COS_PM_Table

1.2.133  ONS15454_DS1_PM_Table

1.2.134  ONS15454_DS3_PM_Table

1.2.135  ONS15454_ENET_PM_Table

1.2.136  ONS15454_FC_PM_Table

1.2.137  ONS15454_IFX_PM_Table

1.2.138  ONS15454_Match_STMT_PM_Table

1.2.139  ONS15454_NE_Inventory_Table

1.2.140  ONS15454_OTN_Fec_PM_Table

1.2.141  ONS15454_OTN_Path_PM_Table

1.2.142  ONS15454_OTN_Sec_PM_Table

1.2.143  ONS15454_PHY_LAYER_PM_Table

1.2.144  ONS15454_Police_PM_Table

1.2.145  ONS15454_POS_PM_Table

1.2.146  ONS15454_Privilege_Table

1.2.147  ONS15454_SONET_Line_PM_Table

1.2.148  ONS15454_SONET_Path_PM_Table

1.2.149  ONS15454_SONET_Sec_PM_Table

1.2.150  ONS15454_SONET_VT_PM_Table

1.2.151  ONS15454_User_Table

1.2.152  ONS15454SDH_E1_PM_Table

1.2.153  ONS15454SDH_E3_PM_Table

1.2.154  ONS15454SDH_E4_PM_Table

1.2.155  ONS15454SDH_HO_PM_Table

1.2.156  ONS15454SDH_LO_PM_Table

1.2.157  ONS15454SDH_MS_PM_Table

1.2.158  ONS15454SDH_RS_PM_Table

1.2.159  ONS15501_NE_Explorer_Table

1.2.160  ONS15501_Opt_Power_PM_Table

1.2.161  ONS155xx_CDL_Flow_Config

1.2.162  ONS155xx_CDL_IF_Config

1.2.163  ONS155xx_CDL_PM_Table

1.2.164  ONS155xx_Circuit_CC_Tbl

1.2.165  ONS155xx_Circuit_Path_Tbl

1.2.166  ONS155xx_Circuit_Stack_Tbl

1.2.167  ONS155xx_Condtype_Map

1.2.168  ONS155xx_DCRP_Definition_Table

1.2.169  ONS155xx_DCRP_Table

1.2.170  ONS155xx_Discovery_Info_Table

1.2.171  ONS155xx_Ether_Hist_PM_Table

1.2.172  ONS155xx_FCM_PE_PM_Table

1.2.173  ONS155xx_Flash_Device_Table

1.2.174  ONS155xx_Flash_Partition_Table

1.2.175  ONS155xx_GRA_CC_TO_CKT_CC_Tbl

1.2.176  ONS155xx_Granular_CC_Tbl

1.2.177  ONS155xx_IF_Circuit_Params_Tbl

1.2.178  ONS155xx_IF_Optical_Power

1.2.179  ONS155xx_IF_Phy_Info_Table

1.2.180  ONS155xx_NE_Info_Table

1.2.181  ONS155xx_NE_Type_Table

1.2.182  ONS155xx_Opt_Power_PM_Table

1.2.183  ONS155xx_Path_Hop_Tbl

1.2.184  ONS155xx_Path_Tbl

1.2.185  ONS155xx_Phy_PM_Table

1.2.186  ONS155xx_SONET_Sec_PM_Table

1.2.187  ONS15600_ENET_PM_Table

1.2.188  ONS15600_POS_PM_Table

1.2.189  ONS15600_Sonet_Line_PM_Table

1.2.190  ONS15600_Sonet_Path_PM_Table

1.2.191  ONS15600_Sonet_Sec_PM_Table

1.2.192  ONS15600SDH_HO_PM_Table

1.2.193  ONS15600SDH_MS_PM_Table

1.2.194  ONS15600SDH_RS_PM_Table

1.2.195  ONS158xx_Amplifier_PM_Table

1.2.196  ONS158xx_BCS_PM_Table

1.2.197  ONS158xx_CMP_PM_Table

1.2.198  ONS158xx_IOC_W_PM_Table

1.2.199  ONS158xx_LAC_Active_User_Table

1.2.200  ONS158xx_LAC_Log_Status_Table

1.2.201  ONS158xx_LAC_Log_Table

1.2.202  ONS158xx_LAC_Profile_Table

1.2.203  ONS158xx_LAC_User_Table

1.2.204  ONS158xx_LSM_PM_Table

1.2.205  ONS158xx_NE_IP_Table

1.2.206  ONS158xx_OAD_PM_Table

1.2.207  ONS158xx_OADM_PM_Table

1.2.208  ONS158xx_OSU_PM_Table

1.2.209  ONS158xx_OTS_PTP_Table

1.2.210  ONS158xx_PM_ACT_MOD_Table

1.2.211  ONS158xx_PTPType_Table

1.2.212  ONS158xx_SCF_PM_Table

1.2.213  ONS158xx_TimeStamp_PM_Table

1.2.214  ONS158xx_Transponder_PM_Table

1.2.215  ONS158xx_WD_PM_Table

1.2.216  ONS158xx_WD_RX_PM_Table

1.2.217  Operation_Permissions_Table

1.2.218  Operations_Table

1.2.219  OSS_Active_User_Table

1.2.220  OSS_AID_ENUM_Table

1.2.221  OSS_Alarm_Filter_Table

1.2.222  OSS_Alarm_Fltr_AID_Deny_Tbl

1.2.223  OSS_Alarm_Fltr_TID_Deny_Tbl

1.2.224  OSS_CORBA_User_Table

1.2.225  OSS_User_Table

1.2.226  Password_History_Table

1.2.227  PatchCord_Table

1.2.228  PM_ATTR_Value_Mapping_Table

1.2.229  PM_ATTRID_Mapping_Table

1.2.230  PM_Cerent_Info_Table

1.2.231  PM_Historical_Appointments

1.2.232  PM_Metadata_Table

1.2.233  Proxy_Server_Table

1.2.234  Purged_NE_Table

1.2.235  Roll_Table

1.2.236  Schedule_Info_Table

1.2.237  Server_Monitor_Table

1.2.238  Server_Parameter_Table

1.2.239  Subnetwork_Table

1.2.240  SVC_Config_Table

1.2.241  SVC_Info_Table

1.2.242  SVC_NEModel_Table

1.2.243  SVC_Package_Table

1.2.244  Sway_User_Port_Table

1.2.245  Table_Info

1.2.246  TCA_Event_Table

1.2.247  TCA_Event_Type_Table

1.2.248  Threshold_Table

1.2.249  Transaction_Log_Table

1.2.250  Unmanaged_NE_Inventory_Table

1.2.251  User_Map_Table

1.2.252  User_NE_Table

1.2.253  User_Preference_Table

1.2.254  User_Table

1.2.255  User_Type_Table

1.2.256  Version_Table

1.2.257  Wavemux_NE

1.2.258  XML_Parser_Static_Tree_Table

Database Schema Tables

---

This chapter describes tables and table sequence numbers.

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 Table 1-1.

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.
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.
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.
TASKID_SEQ	Used when a task is added to the Admin_Job_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

This section describes the database tables created by CTM, listed in alphabetical order.

1.2.1  Ack_Table

The Ack_Table (Table 1-2) 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
AckUserName	VARCHAR2(64)	—	Name of the user.
AckTimeStamp	DATE	—	Date and time of the acknowledgement.
IsAutoAck	NUMBER(1)	—	Indicates whether acknowledgment is manual or automatic: 0: Manual 1: Automatic

1.2.2  Active_Alarm_Table

The Active_Alarm_Table (Table 1-3) 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: 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(8)	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	Indicates whether alarm is active or clear: 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.

1.2.3  Additional_Device_Info

The Additional_Device_Info (Table 1-4) 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.
IpAddress	NUMBER(10)	—	IP address of the additional device.
State	NUMBER(1)	NOT NULL	State of the additional device. Valid values are: 1: Device In Service 2: Device Out of Service 3: Device Pre-Provisioned 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. Valid values are: 1: Device undiscovered 2: Device Initializing 3: Device synch configuration 4: Device discovered

1.2.4  Admin_Job_Table

The Admin_Job_Table (Table 1-5) 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(512)	—	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 (Table 1-6) 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: Off 1: On

1.2.6  Alarm_Count_Table

The Alarm_Count_Table (Table 1-7) 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.
AlarmCountType	NUMBER(1)	NOT NULL	Alarm count type: 4: Warning 5: Minor 6: Major 7: Critical -1: Total cleared -2: Total acknowledged
TOTALALARMCOUNT	NUMBER(20)	—	Total alarm count.

1.2.7  Alarm_Event_Cause_Table

The Alarm_Event_Cause_Table (Table 1-8) 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 (Table 1-9) 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. Range is 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. Range is 1 to n.
AlarmEventSeverity	NUMBER(1)	NOT NULL	Severity level of the alarm.
ServiceEffecting	NUMBER(1)	NOT NULL	Values: 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.

1.2.9  Alarm_Event_Type_ENUM_Table

The Alarm_Event_Type_ENUM_Table (Table 1-10) 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  APS_Group_Table

The APS_Group_Table (Table 1-11) contains information about the automatic protection switching (APS) groups configured in each device.

Primary key: APS_GROUP_PK

Tablespace: ONS155XX_DATA_TABLESPACE

Table 1-11 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.11  Audit_Log_Mapping_Table

The Audit_Log_Mapping_Table (Table 1-12) contains information about the audit log mapping table.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-12 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.12  Audit_Log_Table

The Audit_Log_Table is obsolete.

1.2.13  BLSR_Node

The BLSR_Node (Table 1-13) contains information about the BLSR node.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-13 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.14  BLSR_SPAN

The BLSR_SPAN (Table 1-14) contains information about the BLSR span.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-14 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.15  BLSR_Table

The BLSR_Table (Table 1-15) contains information about BLSRs.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-15 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.16  Bridge_Group_Table

The Bridge_Group_Table (Table 1-16) contains information about the bridge group table.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-16 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 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.

1.2.17  C_MetaData

The C_MetaData table (Table 1-17) defines overall graphical user interface (GUI) information for 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-17 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, 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.18  C_MetaData_Attr_Presentation

The C_MetaData_Attr_Presentation table (Table 1-18) 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-18 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: 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 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

1.2.19  C_MetaData_Col

The C_MetaData_Col table (Table 1-19) stores overall information about all the columns in the CTM GUI.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-19 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, which have a Threshold Crossing Alert (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.20  C_MetaData_Filter

The C_MetaData_Filter table (Table 1-20) stores overall information about all the filters in the CTM GUI.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-20 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.21  C_MetaData_Grp_Presentation

The C_MetaData_Grp_Presentation table (Table 1-21) stores group information for 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-21 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.22  C_MetaData_NETypes

The C_MetaData_NETypes table (Table 1-22) 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-22 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.23  C_Property_Sheet_Info_Table

The C_Property_Sheet_Info_Table (Table 1-23) stores metadata information for the various CTM property sheets.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-23 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.24  C_Tab_Metadata_Info_Table

The C_Tab_Metadata_Info_Table (Table 1-24) stores information about the relationship between the tabs and subtabs in the CTM property sheets.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-24 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.25  C_Tab_Metadata_Table

The C_Tab_Metadata_Table (Table 1-25) stores information about the tabs in the CTM property sheets.

Primary key: C_TAB_METADATA_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-25 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.26  Cerent_NE_Group_Table

The Cerent_NE_Group_Table (Table 1-26) indicates how the CTC-based NEs' discovered NEs are grouped based on the grouping rule.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-26 Cerent_NE_Group_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBAccessID	NUMBER(10)	NOT NULL	NE database access ID.
GroupOption	NUMBER(1)	DEFAULT 0	Values are: 0: Default grouping 1: Group by discovered NE 2: Group by subnet

1.2.27  Circuit_Dest_Tbl

The Circuit_Dest_Tbl (Table 1-27) shows the end and drop points for network circuits.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-27 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)	—	Indicates 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 for the circuit destination.
NPID	NUMBER(10)	DEFAULT 0	Network partition ID.

1.2.28  Circuit_Size_Table

The Circuit_Size_Table (Table 1-28) contains information about the circuit sizes.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-28 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.29  Circuit_Span_Tbl

The Circut_Span_Tbl (Table 1-29) contains information about spans associated with circuits.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-29 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)	—	Indicates whether the circuit span is forwarding (for Ethernet circuit spans only): 0: False 1: True
IsCktSpanInUPSR	NUMBER(1)	—	Indicates whether the circuit span is part of a unidirectional path switched ring (UPSR) ring. Values are: 0: False 1: True
IsCktSpanWorking	NUMBER(1)	—	Indicates whether the circuit span is a working span. Values are: 0: False 1: True
IsCktSpanActive	NUMBER(1)	—	Indicates 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 for 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.30  Circuit_Tbl

The Circuit_Tbl (Table 1-30) shows circuit information for an entire network.

Primary key: CIRCUIT_TBL_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-30 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
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: FDDI 31: Optical CHannel Network Connection (OCHNC) not equipped 32: OCHNC multirate 33: OCHNC 2.5G FEC 34: OCHNC 2.5G NOFEC 35: OCHNC 10G FEC 36: OCHNC 10G NOFEC 37: STM 1C 38: STM 4C 39: STM 16C 40: STM 64C 41: ISC compatible 42: ISC peer 43: SYSPLEX_TIMER_ETR 44: SYSPLEX_TIMER_CLO 45: TWO_GIGABIT_ETHERNET 46: E1 47: T1
CktDirection	NUMBER(1)	—	Type of traffic that the circuit carries. Values are: 0: Unidirectional 1: Bidirectional
CktIsMonitor	NUMBER(1)	—	Indicates 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: Upgradeable 6: Incomplete-upgradeable 7: Errored 8: Not upgradeable 9. Incomplete-not upgradeable 10: Roll-pending 11: Duplicate ID 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)	—	Indicates 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(10)	—	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)	—	Indicates 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	Valid values are: 0: DUPLICATE 1: NOT_DUPLICATE
NPID	NUMBER(10)	DEFAULT 0	Network partition ID.

1.2.31  Circuit_VCG_Tbl

The Circuit_VCG_Tbl (Table 1-31) contains the inventory of virtual concatenation group circuits.

Primary key: none

Tablespace: BASE_DATA_TABLESPACE

Table 1-31 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.

1.2.32  Circuit_VLAN_Tbl

The Circuit_VLAN_Tbl (Table 1-32) contains information about VLANs associated with circuits.

Primary key: CIRCUIT_VLAN_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-32 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.33  CLISession_Command_History_Tbl

The CLISession_Command_History_Tbl (Table 1-33) 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-33 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.34  CORBA_Functions_Table

The CORBA_Functions_Table (Table 1-34) contains information about the different GateWay/CORBA function name and types.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-34 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.35  CORBA_Interface_Table

The CORBA_Interface_Table (Table 1-35) contains information about the GateWay/CORBA interface.

Primary key: CORBA_INTERFACE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-35 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. Valid 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.36  CORBA_Permission_Table

The CORBA_Permission_Table (Table 1-36) contains information about the GateWay/CORBA interface operation permissions.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-36 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 Operations_Table.

1.2.37  CTC_Model_Const_Table

The CTC_Model_Const_Table (Table 1-37) contains information about Cisco Transport Controller (CTC) models.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-37 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.38  CTC_UserProfile_Table

The CTC_UserProfile_Table (Table 1-38) contains information about CTC user profiles.

Primary key: CTC_USR_PROF_TABLE_PK

Tablespace: None

Table 1-38 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.39  CTM_Config_Table

The CTM_Config_Table (Table 1-39) stores CTM configuration information. For detailed definitions on the parameters within this table, refer to Appendix B, "CTM_Config_Table Parameters."

Primary key: ctm_config_table_pk

Tablespace: BASE_DATA_TABLESPACE

Table 1-39 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	Indicates whether or not the value can be changed. Values are: 0: False 1: True
PermanentValue	VARCHAR2(128)	—	Permanent value of the parameter.

1.2.40  CTM_Unique_ObjectType_Table

The CTM_Unique_ObjectType_Table (Table 1-40) contains a list of unique object types.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-40 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.41  DB_Pruning_Table

The DB_Pruning_Table (Table 1-41) contains information about the database pruning table.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-41 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.42  Debug_Module_Mapping_Table

The Debug_Module_Mapping_Table (Table 1-42) defines the mapping between classes and modules, and defines which class belongs to which module.

Primary key: none

Tablespace: BASE_DATA_TABLESPACE

Table 1-42 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.43  Debug_Module_Table

The Debug_Module_Table ( Table 1-43) contains a list of modules for module level debugging.

Primary key: DEBUG_MODULE_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-43 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.44  Deleted_User_Table

The Deleted_User_Table (Table 1-44) contains information about CTM users that were deleted.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-44 Deleted_User_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
username	VARCHAR2(64)	—	Username.
deletedtime	DATE	—	Date username was deleted.

1.2.45  Diskspace_Usage_Table

The Diskspace_Usage_Table (Table 1-45) stores information about database disk space usage.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-45 Diskspace_Usage_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
partitionname	NUMBER(2)	NOT NULL	Name of the partition. Values are: 0: oraclesw9i 1: db01 2: db02 3: db03 4: db04 5: db05
usage	NUMBER(3)	—	Database usage threshold.

1.2.46  Domain_Table

The Domain_Table (Table 1-46) contains information about the hierarchy of group and NE nodes in the domain.

Primary key: DOMAIN_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-46 Domain_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
TreeNodeID	NUMBER(4)	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.47  Ems_Alarm_Table

The Ems_Alarm Table (Table 1-47) shows information about EMS alarms.

Primary key: EMS_ALARM_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-47 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)	—	Indicates 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: NA 4: Warning 5: Minor 6: Major 7: Critical

1.2.48  Enum_Table

The Enum_Table (Table 1-48) is used by link management to display link information in the link table.

Primary key: ENUM_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-48 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.49  EQPT_Info_Table

The EQPT_Info_Table (Table 1-49) stores equipment provisioning information.

Primary key: EQPT_INFO_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-49 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.
...
COL250	VARCHAR2(4000)	—	Columns 1 to 250 store attribute values as defined by the metadata.

1.2.50  Eqpt_Relationship_Table

The Eqpt_Relationship_Table (Table 1-50) contains information about the equipment relationship table.

Primary key: EQPT_RELATIONSHIP_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-50 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.51  Error_Log_Table

The Error_Log_Table (Table 1-51) contains information about all errors reported by CTM.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-51 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.52  Forwarding_Table

The Forwarding_Table is obsolete.

1.2.53  GNE_Table

The GNE_Table (Table 1-52) contains information about the various GNEs in the network.

Primary key: GNE_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-52 GNE_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
GNEID	NUMBER(4)	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.54  Group_Info_Table

The Group_Info_Table (Table 1-53) contains information about all groups defined in the Domain Explorer tree.

Primary key: GROUP_INFO_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-53 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(32)	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.55  HA_Table

The HA_Table (Table 1-54) provides a list of testing dates in a high-availability environment.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-54 HA_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
TStamp	DATE	—	Test table for HA.

1.2.56  HFR_ACL_Policy_Config

The HFR_ACL_Policy_Config (Table 1-55) contains CRS-1 ACL policy configurations data.

Primary key: HFR_ACL_POLICY_CFG_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-55 HFR_ACL_Policy_Config 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBACCESSID	NUMBER(8)	NOT NULL	NE database access ID.
ACLNAME	VARCHAR2(32)	NOT NULL	—
ACLID	NUMBER(10)	NOT NULL	—
ACLGRANT	VARCHAR2(6)	—	—
ACLLOGGING	VARCHAR2(10)	—	—
SOURCEADDRESS	VARCHAR2(16)	—	—
SOURCEWILDCARDBITS	VARCHAR2(16)	—	—
DESTINATIONADDRESS	VARCHAR2(16)	—	—
DESTINATIONWILDCARDBITS	VARCHAR2(16)	—	—
ACLREMARK	VARCHAR2(256)	—	—
PROTOCOL	VARCHAR2(6)	—	—
DSCP	VARCHAR2(8)	—	—
PRECEDENCE	VARCHAR2(15)	—	—
SOURCEOPERATOR	VARCHAR2(12)	—	—
SOURCESTARTPORT	VARCHAR2(15)	—	—
SOURCEENDPORT	VARCHAR2(15)	—	—
DESTINATIONOPERATOR	VARCHAR2(12)	—	—
DESTINATIONSTARTPORT	VARCHAR2(15)	—	—
DESTINATIONENDREPORT	VARCHAR2(15)	—	—
TCPBITS	VARCHAR2(12)	—	—
ICMPMESSAGECODE	NUMBER(3)	—	—
ICMPMESSAGETYPE	NUMBER(3)	—	—
IGMPMESSAGETYPE	VARCHAR2(15)	—	—
CHECKFRAGMENTS	VARCHAR2(5)	—	—

1.2.57  HFR_BGP_PEER_PM_Table

Primary key: HFR_PM_BGP_PEER_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-56 HFR_BGP_PEER_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 the NE_Info_Table.
ModuleType	NUMBER(4)	NOT NULL	Module type to which the PM refers.
PhysicalLoc	NUMBER(20)	DEFAULT 0	Physical location.
NEIFIndex	NUMBER(20)	NOT NULL	Table index for the interface.
BGPPeerTimeStamp	DATE	NOT NULL	Time stamp that shows the interval at which the set of statistics was stored.
NEIfPMStatus	NUMBER(20)	NOT NULL	Indicates the status of the PM bucket. Valid values are: 0: Valid period Other: Bit Mask Value (information about the PM statistics)
inMaintenance	NUMBER(1)	—	Indicates whether NE was in Maintenance state when the PM bucket was collected.
fifteenMinThreshold Mask	NUMBER(10)	—	Threshold value for the PM bucket during the 15-minute interval.
oneDayThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket for the day.
IS24H	NUMBER(1)	NOT NULL	Specifies whether the PM data is for 24-hour or 15-min interval. Valid values are: 1: 24 hour 0: 15 minutes
IPADDRESS	VARCHAR2(16)	NOT NULL	IP address.
INPUTMSGS	NUMBER(10)	DEFAULT -1	—
OUTPUTMSGS	NUMBER(10)	DEFAULT -1	—
INPUTUPDATEMSGS	NUMBER(10)	DEFAULT -1	—
OUTPUTUPDATEMSGS	NUMBER(10)	DEFAULT -1	—
CONNESTABLISHED	NUMBER(10)	DEFAULT -1	—
CONNDROPPED	NUMBER(10)	DEFAULT -1	—
ERRORSRECEIVED	NUMBER(10)	DEFAULT -1	—
ERRORSSENT	NUMBER(10)	DEFAULT -1	—
ModelType	NUMBER(10	DEFAULT 0	Model type.
ObjectType	NUMBER(10)	DEFAULT 0	Object type.
StrObjInstance	VARCHAR2(256)	—	StrObjInstance name.

1.2.58  HFR_Common_Interface_Config

The HRF_Common_Interface_Config (Table 1-57) contains CRS-1 common interface configuration date, including Ethernet and POS.

Primary key: HFR_COM_INTF_CFG_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-57 HFR_Common_Interface_Config 

Column Name	Oracle Data Type	Integrity Constraints	Description
IFID	VARCHAR2(256)	NOT NULL	—
IFACTIVE	VARCHAR2(3)	NOT NULL	—
NEDBACCESSID	NUMBER(8)	NOT NULL	—
MAINIF	VARCHAR2(256)	—	—
OWNER	VARCHAR2(256)	—	—
DESCRIPTION	VARCHAR2(256)	—	—
IPADDRESS	VARCHAR2(16)	—	—
IPMASK	VARCHAR2(16)	—	—
CDP	NUMBER(1)	—	—
UNNUMBERED	VARCHAR2(256)	—	—
IPMTU	NUMBER(6)	—	—
ICMPMASKREPLY	NUMBER(1)	—	—
DIRECTEDBRDCAST	NUMBER(1)	—	—
DISABLEREDIRECTS	NUMBER(1)	—	—
DISABLEUNREACH	NUMBER(1)	—	—
DAMPENINGARGS	VARCHAR2(16)	—	—
HALFLIFE	NUMBER(2)	—	—
REUSETHRESHOLD	NUMBER(6)	—	—
SUPPRESSTHRESHOLD	NUMBER(6)	—	—
SUPPRESSTIME	NUMBER(3)	—	—
IFSHUTDOWN	NUMBER(1)	—	—

1.2.59  HFR_ETHER_Interface_Config

The HFR_ETHER_Interface_Config (Table 1-58) contains CRS-1 Ethernet interface configuration data.

Primary key: HFR_ETHER_INTF_CFG_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-58 HFR_ETHER_Interface_Confg 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBACCESSID	NUMBER(8)	NOT NULL	ID to access this table for an NE; same as NEDBAccessID in the NE_Info_Table.
IFID	VARCHAR2(256)	NOT NULL	—
IFACTIVE	VARCHAR2(3)	NOT NULL	—
FULLDUPLEX	NUMBER(1)	—	—
HALFDUPLEX	NUMBER(1)	—	—
ARPPROXY	NUMBER(1)	—	—
ARPTIMEOUT	NUMBER(8)	—	—
MACADDRESS	VARCHAR2(12)	—	—
MEDIATYPE	VARCHAR2(6)	—	—
SPEED	VARCHAR2(4)	—	—

1.2.60  HFR_Interface_DRC_PM_Table

Primary key: HFR_PM_INTERFACE_DRC_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-59 HFR_Interface_DRC_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 the NE_Info_Table.
ModuleType	NUMBER(4)	NOT NULL	Module type to which the PM refers.
PhysicalLoc	NUMBER(20)	DEFAULT 0	Physical location.
NEIFIndex	NUMBER(20)	NOT NULL	Table index for the interface.
InterfaceDRCTimeStamp	DATE	NOT NULL	Time stamp that shows the interval at which the set of statistics was stored.
NEIfPMStatus	NUMBER(20)	NOT NULL	Indicates the status of the PM bucket. Valid values are: 0: Valid period Other: Bit Mask Value (information about the PM statistics)
inMaintenance	NUMBER(1)	—	Indicates whether NE was in Maintenance state when the PM bucket was collected.
fifteenMinThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket during the 15-minute interval.
oneDayThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket of the day.
IS24H	NUMBER(1)	NOT NULL	Specifies whether the PM data is for 24-hour or 15-min interval. Valid values are: 1: 24 hour 0: 15 minutes
IFNAME	VARCHAR2(64)	NOT NULL	Interface name.
INPUTDATARATE	NUMBER(10)	DEFAULT -1	—
INPUTPACKETRATE	NUMBER(10)	DEFAULT -1	—
OUTPUTDATARATE	NUMBER(10)	DEFAULT -1	—
OUTPUTPACKETRATE	NUMBER(10)	DEFAULT -1	—
INPUTPEAKRATE	NUMBER(10)	DEFAULT -1	—
INPUTPEAKPKTS	NUMBER(10)	DEFAULT -1	—
OUTPUTPEAKRATE	NUMBER(10)	DEFAULT -1	—
OUTPUTPEAKPKTS	NUMBER(10)	DEFAULT -1	—
BANDWIDTH	NUMBER(10)	DEFAULT -1	—
ModelType	NUMBER(10	DEFAULT 0	Model type.
ObjectType	NUMBER(10)	DEFAULT 0	Object type.
StrObjInstance	VARCHAR2(256)	—	StrObjInstance name.

1.2.61  HFR_Interface_GC_PM_Table

Primary key: HFR_PM_INTERFACE_GC_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-60 HFR_Interface_GC_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 the NE_Info_Table.
ModuleType	NUMBER(4)	NOT NULL	Module type to which the PM refers.
PhysicalLoc	NUMBER(20)	DEFAULT 0	Physical location.
NEIFIndex	NUMBER(20)	NOT NULL	Table index for the interface.
InterfaceGCTimeStamp	DATE	NOT NULL	Time stamp that shows the interval at which the set of statistics was stored.
NEIfPMStatus	NUMBER(20)	NOT NULL	Indicates the status of the PM bucket. Valid values are: 0: Valid period Other: Bit Mask Value (information about the PM statistics)
inMaintenance	NUMBER(1)	—	Indicates whether NE was in Maintenance state when the PM bucket was collected.
fifteenMinThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket during the 15-minute interval.
oneDayThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket of the day.
IS24H	NUMBER(1)	NOT NULL	Specifies whether the PM data is for 24-hour or 15-min interval. Valid values are: 1: 24 hour 0: 15 minutes
IFNAME	VARCHAR2(64)	NOT NULL	Interface name.
INPACKETS	NUMBER(10)	DEFAULT -1	—
INOCTETS	NUMBER(10)	DEFAULT -1	—
OUTPACKETS	NUMBER(10)	DEFAULT -1	—
OUTOCTETS	NUMBER(10)	DEFAULT -1	—
INUCASTPACKETS	NUMBER(10)	DEFAULT -1	—
INMULTICASTPACKETS	NUMBER(10)	DEFAULT -1	—
INBROADCASTPACKETS	NUMBER(10)	DEFAULT -1	—
OUTUCASTPACKETS	NUMBER(10)	DEFAULT -1	—
OUTMULTICASTPACKETS	NUMBER(10)	DEFAULT -1	—
OUTBROADCASTPACKETS	NUMBER(10)	DEFAULT -1	—
OUTPUTTOTALDROPS	NUMBER(10)	DEFAULT -1	—
INPUTTOTALDROPS	NUMBER(10)	DEFAULT -1	—
INPUTQUEUEDDROPS	NUMBER(10)	DEFAULT -1	—
INPUTUNKNOWNPROTO	NUMBER(10)	DEFAULT -1	—
OUTPUTTOTALERRORS	NUMBER(10)	DEFAULT -1	—
OUTPUTUNDERRUN	NUMBER(10)	DEFAULT -1	—
INPUTTOTALERRORS	NUMBER(10)	DEFAULT -1	—
INPUTCRC	NUMBER(10)	DEFAULT -1	—
INPUTOVERRUN	NUMBER(10)	DEFAULT -1	—
INPUTFRAME	NUMBER(10)	DEFAULT -1	—
ModelType	NUMBER(10)	DEFAULT 0	Model type.
ObjectType	NUMBER(10)	DEFAULT 0	Object type.
StrObjInstance	VARCHAR2(256)	—	StrObjInstance name.

1.2.62  HFR_Interface_Helper_Address

The HFR_Interface_Helper_Address (Table 1-61) is a subtable of HFR_Common_Interface_Config.

Primary key: HFR_COM_INTF_HELPADDR_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-61 HFR_Interface_Helper_Address 

Column Name	Oracle Data Type	Integrity Constraints	Description
IPADDRESS	VARCHAR2(16)	NOT NULL	Primary key and the actual helper IP address.
NEDBACCESS	NUMBER(8)	NOT NULL	—
ENABLED	NUMBER(1)	—	Boolean status for the helper IP address.
IFID	VARCHAR2(256)	NOT NULL	—
IFACTIVE	VARCHAR2(3)	NOT NULL	—

1.2.63  HFR_Interface_MTU_Layer2

Primary key: HFR_COM_INTF_MTULAYER2_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-62 HFR_Interface_MTU_Layer2 

Column Name	Oracle Data Type	Integrity Constraints	Description
OWNER	VARCHAR2(16)	NOT NULL	—
NEDBACCESSID	NUMBER(8)	NOT NULL	—
MTUVALUE	NUMBER(16)	—	—
IFID	VARCHAR2(256)	NOT NULL	—
IFACTIVE	VARCHAR2(3)	NOT NULL	—

1.2.64  HFR_Interface_Secondary_Addr

The HFR_Interface_Secondary_Addr (Table 1-63) is a subtable of HFR_Common_Interface_Config.

Primary key: HFR_COM_INTF_SECONDADDR_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-63 HFR_Interface_Secondary_Addr 

Column Name	Oracle Data Type	Integrity Constraints	Description
IPADDRESS	VARCHAR2(16)	NOT NULL	Primary key and the actual secondary IP address.
NEDBACCESSID	NUMBER(8)	NOT NULL	—
IP MASK	VARCHAR2(16)	—	IP address representing the subnet mask.
IFID	VARCHAR2(256)	NOT NULL	—
IFACTIVE	VARCHAR2(3)	NOT NULL	—

1.2.65  HFR_MPLS_Interface_PM_Table

Primary key: HFR_PM_MPLS_INTERFACE_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-64 HFR_MPLS_Interface_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 the NE_Info_Table.
ModuleType	NUMBER(4)	NOT NULL	Module type to which the PM refers.
PhysicalLoc	NUMBER(20)	DEFAULT 0	Physical location.
NEIfIndex	NUMBER(20)	NOT NULL	Table index for the interface.
MPLSInterfaceTimeStamp	DATE	NOT NULL	Time stamp that shows the interval at which the set of statistics was stored.
NEIfPMStatus	NUMBER(20)	NOT NULL	Indicates the status of the PM bucket. Valid values are: 0: Valid period Other: Bit Mask Value (information about the PM statistics)
inMaintenance	NUMBER(1)	—	Indicates whether NE was in Maintenance state when the PM bucket was collected.
fifteenMinThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket during the 15-minute interval.
oneDayThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket of the day.
IS24H	NUMBER(1)	NOT NULL	Specifies whether the PM data is for 24-hour or 15-min interval. Valid values are: 1: 24 hour 0: 15 minutes
IFNAME	VARCHAR2(64)	NOT NULL	Interface name.
FAILEDLABELLOOKUP	NUMBER(10)	DEFAULT -1	—
FRAGMENTEDPKTS	NUMBER(10)	DEFAULT -1	—
ModelType	NUMBER(10)	DEFAULT 0	Model type.
ObjectType	NUMBER(10)	DEFAULT 0	Object type.
StrObjInstance	VARCHAR2(256)	—	StrObjInstance name.

1.2.66  HFR_MPLS_LDP_PM_Table

Primary key: HFR_PM_MPLS_LDP_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-65 HFR_MPLS_LDP_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 the NE_Info_Table.
ModuleType	NUMBER(4)	NOT NULL	Module type to which the PM refers.
PhysicalLoc	NUMBER(20)	DEFAULT 0	Physical location.
NEIfIndex	NUMBER(20)	NOT NULL	Table index for the interface.
MPLSLDPTimeStamp	DATE	NOT NULL	Time stamp that shows the interval at which the set of statistics was stored.
NEIfPMStatus	NUMBER(20)	NOT NULL	Indicates the status of the PM bucket. Valid values are: 0: Valid period Other: Bit Mask Value (information about the PM statistics)
inMaintenance	NUMBER(1)	—	Indicates whether NE was in Maintenance state when the PM bucket was collected.
fifteenMinThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket during the 15-minute interval.
oneDayThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket of the day.
IS24H	NUMBER(1)	NOT NULL	Specifies whether the PM data is for 24-hour or 15-min interval. Valid values are: 1: 24 hour 0: 15 minutes
IPADDRESS	VARCHAR2(16)	NOT NULL	IP address
TOTALMSGSSENT	NUMBER(10)	DEFAULT -1	—
TOTALMSGSRCVD	NUMBER(10)	DEFAULT -1	—
INITMSGSSENT	NUMBER(10)	DEFAULT -1	—
INITMSGSRCVD	NUMBER(10)	DEFAULT -1	—
ADDRESSMSGSSENT	NUMBER(10)	DEFAULT -1	—
ADDRESSMSGSRCVD	NUMBER(10)	DEFAULT -1	—
ADDRESSWITHDRAWMSGSSENT	NUMBER(10)	DEFAULT -1	—
ADRESSWITHDRAWMSGSRCVD	NUMBER(10)	DEFAULT -1	—
LABELMAPPINGMSGSSENT	NUMBER(10)	DEFAULT -1	—
LABELMAPPINGMSGSRCVD	NUMBER(10)	DEFAULT -1	—
LABELWITHDRAWMSGSSENT	NUMBER(10)	DEFAULT -1	—
LABELWITHDRAWMSGSRCVD	NUMBER(10)	DEFAULT -1	—
LABELRELEASEMSGSSENT	NUMBER(10)	DEFAULT -1	—
LABELRELEASEMSGSRCVD	NUMBER(10)	DEFAULT -1	—
NOTIFICATIONMSGSSENT	NUMBER(10)	DEFAULT -1	—
NOTIFICATIONMSGSRCVD	NUMBER(10)	DEFAULT -1	—
KEEPALIVEMSGSSENT	NUMBER(10)	DEFAULT -1	—
KEEPALIVEMSGSRCVD	NUMBER(10)	DEFAULT -1	—
ModelType	NUMBER(10)	DEFAULT 0	Model type.
ObjectType	NUMBER(10)	DEFAULT 0	Object type.
StrObjInstance	VARCHAR2(256)	—	StrObjInstance name.

1.2.67  HFR_MPLS_TE_Link_PM_Table

Primary key: HFR_PM_MPLS_TE_LINK_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-66 HFR_MPLS_TE_Link_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 the NE_Info_Table.
ModuleType	NUMBER(4)	NOT NULL	Module type to which the PM refers.
PhysicalLoc	NUMBER(20)	DEFAULT 0	Physical location.
NEIfIndex	NUMBER(20)	NOT NULL	Table index for the interface.
MPLSTETimeStamp	DATE	NOT NULL	Time stamp that shows the interval at which the set of statistics was stored.
NEIfPMStatus	NUMBER(20)	NOT NULL	Indicates the status of the PM bucket. Valid values are: 0: Valid period Other: Bit Mask Value (information about the PM statistics)
inMaintenance	NUMBER(1)	—	Indicates whether NE was in Maintenance state when the PM bucket was collected.
fifteenMinThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket during the 15-minute interval.
oneDayThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket of the day.
IS24H	NUMBER(1)	NOT NULL	Specifies whether the PM data is for 24-hour or 15-min interval. Valid values are: 1: 24 hour 0: 15 minutes
IFNAME	VARCHAR2(64)	NOT NULL	Interface name.
LINKUTILIZATION	NUMBER(10)	DEFAULT -1	—
ModelType	NUMBER(10)	DEFAULT 0	Model type.
ObjectType	NUMBER(10)	DEFAULT 0	Object type.
StrObjInstance	VARCHAR2(256)	—	StrObjInstance name.

1.2.68  HFR_MPLS_TE_Tunnel_PM_Table

Primary key: HFR_PM_MPLS_TE_TUNNEL_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-67 HFR_MPLS_TE_Link_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 the NE_Info_Table.
ModuleType	NUMBER(4)	NOT NULL	Module type to which the PM refers.
PhysicalLoc	NUMBER(20)	DEFAULT 0	Physical location.
NEIfIndex	NUMBER(20)	NOT NULL	Table index for the interface.
MPLSTETunnelTimeStamp	DATE	NOT NULL	Time stamp that shows the interval at which the set of statistics was stored.
NEIfPMStatus	NUMBER(20)	NOT NULL	Indicates the status of the PM bucket. Valid values are: 0: Valid period Other: Bit Mask Value (information about the PM statistics)
inMaintenance	NUMBER(1)	—	Indicates whether NE was in Maintenance state when the PM bucket was collected.
fifteenMinThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket during the 15-minute interval.
oneDayThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket of the day.
IS24H	NUMBER(1)	NOT NULL	Specifies whether the PM data is for 24-hour or 15-min interval. Valid values are: 1: 24 hour 0: 15 minutes
IFNAME	VARCHAR2(64)	NOT NULL	Interface name.
INPUTDATARATE	NUMBER(10)	DEFAULT -1	—
INPUTPACKETRATE	NUMBER(10)	DEFAULT -1	—
OUTPUTDATARATE	NUMBER(10)	DEFAULT -1	—
OUTPUTPACKETRATE	NUMBER(10)	DEFAULT -1	—
INPUTPEAKRATE	NUMBER(10)	DEFAULT -1	—
INPUTPEAKPKTS	NUMBER(10)	DEFAULT -1	—
OUTPUTPEAKRATE	NUMBER(10)	DEFAULT -1	—
OUTPUTPEAKPKTS	NUMBER(10)	DEFAULT -1	—
BANDWIDTH	NUMBER(10)	DEFAULT -1	—
ModelType	NUMBER(10)	DEFAULT 0	Model type.
ObjectType	NUMBER(10)	DEFAULT 0	Object type.
StrObjInstance	VARCHAR2(256)	—	StrObjInstance name.

1.2.69  HFR_Node_CPU_PM_Table

Primary key: HFR_PM_NODE_CPU_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-68 HFR_Node_CPU_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 the NE_Info_Table.
ModuleType	NUMBER(4)	NOT NULL	Module type to which the PM refers.
PhysicalLoc	NUMBER(20)	DEFAULT 0	Physical location.
NEIfIndex	NUMBER(20)	NOT NULL	Table index for the interface.
NodeCPUTimeStamp	DATE	NOT NULL	Time stamp that shows the interval at which the set of statistics was stored.
NEIfPMStatus	NUMBER(20)	NOT NULL	Indicates the status of the PM bucket. Valid values are: 0: Valid period Other: Bit Mask Value (information about the PM statistics)
inMaintenance	NUMBER(1)	—	Indicates whether NE was in Maintenance state when the PM bucket was collected.
fifteenMinThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket during the 15-minute interval.
oneDayThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket of the day.
IS24H	NUMBER(1)	NOT NULL	Specifies whether the PM data is for 24-hour or 15-min interval. Valid values are: 1: 24 hour 0: 15 minutes
NODEID	NUMBER(10)	NOT NULL	Node ID.
NUMPROCESSES	NUMBER(10)	DEFAULT -1	—
AVERAGECPUUSED	NUMBER(10)	DEFAULT -1	—
ModelType	NUMBER(10)	DEFAULT 0	Model type.
ObjectType	NUMBER(10)	DEFAULT 0	Object type.
StrObjInstance	VARCHAR2(256)	—	StrObjInstance name.

1.2.70  HFR_Node_Memory_PM_Table

Primary key: HFR_PM_NODE_MEMORY_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-69 HFR_Node_Memory_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 the NE_Info_Table.
ModuleType	NUMBER(4)	NOT NULL	Module type to which the PM refers.
PhysicalLoc	NUMBER(20)	DEFAULT 0	Physical location.
NEIFIndex	NUMBER(20)	NOT NULL	Table index for the interface.
NodeMemoryTimeStamp	DATE	NOT NULL	Time stamp that shows the interval at which the set of statistics was stored.
NEIfPMStatus	NUMBER(20)	NOT NULL	Indicates the status of the PM bucket. Valid values are: 0: Valid period Other: Bit Mask Value (information about the PM statistics)
inMaintenance	NUMBER(1)	—	Indicates whether NE was in Maintenance state when the PM bucket was collected.
fifteenMinThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket during the 15-minute interval.
oneDayThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket of the day.
IS24H	NUMBER(1)	NOT NULL	Specifies whether the PM data is for 24-hour or 15-min interval. Valid values are: 1: 24 hour 0: 15 minutes
NODEID	NUMBER(10)	NOT NULL	Node ID.
APPMEMORY	NUMBER(10)	DEFAULT -1	—
PEAKMEMORY	NUMBER(10)	DEFAULT -1	—
ModelType	NUMBER(10)	DEFAULT 0	Model type.
ObjectType	NUMBER(10)	DEFAULT 0	Object type.
StrObjInstance	VARCHAR2(256)	—	StrObjInstance name.

1.2.71  HFR_Node_Process_PM_Table

Primary key: HFR_PM_NODE_PROCESS_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-70 HFR_Node_Process_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 the NE_Info_Table.
ModuleType	NUMBER(4)	NOT NULL	Module type to which the PM refers.
PhysicalLoc	NUMBER(20)	DEFAULT 0	Physical location.
NEIFIndex	NUMBER(20)	NOT NULL	Table index for the interface.
NodeProcessTimeStamp	DATE	NOT NULL	Time stamp that shows the interval at which the set of statistics was stored.
NEIfPMStatus	NUMBER(20)	NOT NULL	Indicates the status of the PM bucket. Valid values are: 0: Valid period Other: Bit Mask Value (information about the PM statistics)
inMaintenance	NUMBER(1)	—	Indicates whether NE was in Maintenance state when the PM bucket was collected.
fifteenMinThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket during the 15-minute interval.
oneDayThresholdMask	NUMBER(10)	—	Threshold value for the PM bucket of the day.
IS24H	NUMBER(1)	NOT NULL	Specifies whether the PM data is for 24-hour or 15-min interval. Valid values are: 1: 24 hour 0: 15 minutes
NODEID	NUMBER(10)	NOT NULL	Node ID.
PROCESSID	NUMBER(10)	NOT NULL	Process ID.
TOTALMEMORY	NUMBER(10)	DEFAULT -1	—
AVERAGECPUUSED	NUMBER(10)	DEFAULT -1	—
NUMTHREADS	NUMBER(10)	DEFAULT -1	—
ModelType	NUMBER(10)	DEFAULT 0	Model type.
ObjectType	NUMBER(10)	DEFAULT 0	Object type.
StrObjInstance	VARCHAR2(256)	—	StrObjInstance name.

1.2.72  HFR_POS_Interface_Config

The HFR_POS_Interface_Config (Table 1-71) contains CRS-1 POS (Packet Over SONET) interface configuration data.

Primary key: HFR_POS_INTF_CFG_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-71 HFR_POS_Interface_Config 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBACCESSID	NUMBER(8)	NOT NULL	ID to access this table for an NE; same as NEDBAccessID in the NE_Info_Table.
IFID	VARCHAR2(256)	NOT NULL	—
IFACTIVE	VARCHAR2(3)	NOT NULL	—
ENCAPTYPE	VARCHAR2(5)	—	—
ENCAPUNUSED	NUMBER(10)	—	—
PPPAUTHATTEMPTS	NUMBER(2)	—	—
MAXUNACKCONFREQS	NUMBER(2)	—	—
MAXCONSECCONFNAKS	NUMBER(2)	—	—
MAXUNACKTERMREQS	NUMBER(2)	—	—
PAPCHECK	NUMBER(1)	—	—
CHAPCHECK	NUMBER(1)	—	—
MSCCHECK	NUMBER(1)	—	—
AUTHLIST	VARCHAR2(256)	—	—
AUTHTIMEOUT	NUMBER(2)	—	—
NCPTIMEOUT	NUMBER(3)	—	—
FSMRETRY	NUMBER(2)	—	—
PAPREFUSE	VARCHAR2(8)	—	—
PAPUSERNAME	VARCHAR2(128)	—	—
PAPPROPPASSWORD	VARCHAR2(128)	—	—
CHAPREFUSE	VARCHAR2(8)	—	—
CHAPHOSTNAME	VARCHAR2(128)	—	—
CHAPPROPPASSWORD	VARCHAR2(128)	—	—

1.2.73  HFR_SONET_Interface_Config

The HFR_SONET_Interface_Config (Table 1-72) contains CRS-1 SONET controllers configuration data.

Primary key: HFR_SONET_INTF_CFG_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-72 HFR_SONET_Interface_Config 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBACCESSID	NUMBER(8)	NOT NULL	ID to access this table for an NE; same as NEDBAccessID in the NE_Info_Table.
IFID	VARCHAR2(256)	NOT NULL	—
IFACTIVE	VARCHAR2(3)	NOT NULL	—
SONETCREATED	NUMBER(1)	—	—
SONETPORTCLOCKSOURCE	VARCHAR2(10)	—	—
SONETPORTFRAMING	VARCHAR2(5)	—	—
SONETPORTLOOPBACK	VARCHAR2(10)	—	—
TXJ0	NUMBER(3)	—	—
TXS1S0	NUMBER(1)	—	—
LINEHOLDOFFDELAY	NUMBER(3)	—	—
SONETPORTSHUTDOWNAIS	NUMBER(1)	—	—
PATHNUM	NUMBER(10)	—	—
B1BERTHRESHOLD	NUMBER(1)	—	—
SDBERTHRESHOLD	NUMBER(1)	—	—
SFBERTHRESHOLD	NUMBER(1)	—	—
DISABLEREPORTB1BER	NUMBER(1)	—	—
DISABLEREPORTSLOF	NUMBER(1)	—	—
DISABLEREPORTSLOS	NUMBER(1)	—	—
REPORTSDBER	NUMBER(1)	—	—
DISABLEREPORTSFBER	NUMBER(1)	—	—
B2BERTHRESHOLD	NUMBER(1)	—	—
REPORTLAIS	NUMBER(1)	—	—
DISABLEREPORTB2BER	NUMBER(1)	—	—
REPORTLRDI	NUMBER(1)	—	—

1.2.74  HFR_SONET_Interface_Path

The HFR_SONET_Interface_Path (Table 1-73) is a subtable of HFR_SONET_Interface_Config.

Primary key: HFR_SONET_INTF_PATHREC_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-73 HFR_SONET_Interface_Path 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBACCESSID	NUMBER(8)	NOT NULL	—
IFID	VARCHAR2(256)	NOT NULL	—
IFACTIVE	VARCHAR2(3)	NOT NULL	—
PATHNUM	NUMBER(10)	NOT NULL	Primary key and the path number associated with the SONET interface.
PATHCREATED	NUMBER(1)	—	—
PATHHOLDOFFDELAY	NUMBER(3)	—	—
SONETPATHSCRAMBLING	VARCHAR2(8)	—	—
TXC2	NUMBER(4)	—	—
TXJ1	VARCHAR2(64)	—	—
SONETPATHSHUTDOWNAIS	NUMBER(1)	—	—
SONETPATHSHUTDOWNUNEQ	NUMBER(1)	—	—
B3BERTHRESHOLD	NUMBER(1)	—	—
REPORTPAIS	NUMBER(1)	—	—
DISABLEREPORTB3BER	NUMBER(1)	—	—
DISABLEREPORTPLOP	NUMBER(1)	—	—
REPORTPRDI	NUMBER(1)	—	—
REPORTPUNEQ	NUMBER(1)	—	—

1.2.75  HFR_Version_Info

The HFR_Version_Info (Table 1-74) is used to store various XML schema version information in the database.

Primary key: HFR_VERSION_INFO_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-74 HFR_Version_Info 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBAccessID	NUMBER(8)	NOT NULL	Unique NE identifier.
Space	NUMBER(8)	NOT NULL	Integer representing the corresponding sysdb space for the schema.
SUBSTRINDEX	NUMBER(8)	NOT NULL	Value used to index any required substring. It starts from 0 and increments by 1.
VersionXML	VARCHAR2(4000)	—	Actual XML string returned from the router (CRS-1).

1.2.76  IF_Cross_Connect

The IF_Cross_Connect table (Table 1-75) contains information about cross-connects between interfaces on the same network element. Point-to-point (p2p) and point-to-multipoint (p2mp) are supported.

Primary key: None

Tablespace: ONS155XX_DATA_TABLESPACE

Table 1-75 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.77  IF_DWDM_Channel_Group

The IF_DWDM_Channel_Group table (Table 1-76) contains information about interfaces representing groups of DWDM channels.

Primary key: IF_DWDM_CHAN_FREQ_PK

Tablespace:ONS155XX_DATA_TABLESPACE

Table 1-76 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	Indicates 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.78  IF_Optical_Phy_Config_Table

The IF_Optical_Phy_Config_Table (Table 1-77) describes extended physical properties for certain interfaces.

Primary key: IF_OPTICAL_PHY_PK

Tablespace: ONS155XX_DATA_TABLESPACE

Table 1-77 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.79  IFIndex_Rule_Table

The IFIndex_Rule_Table (Table 1-78) 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-78 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.80  Interface_APS_Info

The Interface_APS_Info table (Table 1-79) contains APS information for interfaces that are members of an APS group.

Primary key: IF_APS_INFO_PK

Tablespace:ONS155XX_DATA_TABLESPACE

Table 1-79 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.81  Interface_DWDM_Frequency

The Interface_DWDM_Frequency table (Table 1-80) contains wavelength information for certain optical interfaces carrying DWDM frequencies.

Primary key: IF_DWDM_FREQ_PK

Tablespace: ONS155XX_DATA_TABLESPACE

Table 1-80 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.82  Interface_Stack_Table

The Interface_Stack_Table (Table 1-81) provides information about underlying and overlaying layer relationships between interfaces.

Primary key: IFSTACK_PK

Tablespace: ONS155XX_DATA_TABLESPACE

Table 1-81 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.83  Interface_Table

The Interface_Table (Table 1-82) contains static interface indexes and names for an NE managed by CTM.

Primary key: INTERFACE_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-82 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.84  IOS_Parser_Static_Tree_Table

The IOS_Paerser_Static_Tree_Table (Table 1-83) contains information about the IOS parser static tree table.

Primary key: IOS_PARSER_STATIC_TREE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-83 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.85  L2_FrontPort_Table

The L2_FrontPort_Table (Table 1-84) contains information about the L2 front port table.

Primary key: L2_FRONTPORT_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-84 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. Valid values are: 0: PORT_STATE_DISABLED 1: PORT_STATE_ENABLED
PM_STATUS	NUMBER(1)	—	—

1.2.86  L2_Interface_QoSClass_Table

The L2_Interface_QoSClass_Table (Table 1-85) 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-85 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)	NOT NULL	Bridge group number.
Port_Number	NUMBER(2)	NOT NULL	Port number.
Port_Sub_Interface	NUMBER(4)	—	Subinterface number on the port.
MATCH_ANY	NUMBER(1)	—	Matches any traffic.
MATCH_DSCP	NUMBER(1)	—	Matches the DSCP. DSCP value needs to be specified.
MATCH_COS	NUMBER(1)	—	Matches the class of service.
MATCH_IP_PRECEDENCE	NUMBER(1)	—	Matches the IP precedence value.
MATCH_DSCP_VALUE	VARCHAR2(64)	—	DSCP value is used with Match_DSCP.
MATCH_COS_VALUE	VARCHAR2(32)	—	COS value is used with Match_COS.
MATCH_IP_PRECEDENCE_V ALUE	VARCHAR2(32)	—	IP precedence value is used with Match_IP_Precedence.
ANDOR	NUMBER(1)	—	And/or condition.
CLASS_NAME	VARCHAR2(60)	—	Name of class map.
CIR_TYPE	NUMBER(2)	—	CIR type. Values are: 0: Line rate CIR 1: Rate-limited CIR
MAX_RATE_KBPS	NUMBER(20)	—	Maximum allowed rate in kbps.
BURST_SIZE_BPS	NUMBER(20)	—	Size of the burst in bps.
CIR_COS_TYPE	NUMBER(2)	—	Committed CoS mark type. Values are: 0: Trust 1: Mark CoS
CIR_COS_VALUE	NUMBER(2)	—	If CIR_COS_TYPE is 1 then this is the CoS value.
EXCESS_ACTION	NUMBER(2)	—	Excess traffic action. Values are: 0: Discard 1: Allow
PIR_BURST_BPS	NUMBER(20)	—	Peak information rate burst value in bps.
PIR_KBPS	NUMBER(20)	—	Peak information rate in kbps.
PIR_COS_TYPE	NUMBER(2)	—	PIR CoS type. Values are: 0: Trust 1: Mark CoS
PIR_COS_VALUE	NUMBER(2)	—	PIR CoS marking value.
VIOLATE_ACTION	NUMBER(2)	—	Violate action. Values are: 0: Discard 1: Allow
VIOLATE_COS_VALUE	NUMBER(2)	—	CoS marking for violation traffic.
BEFF_TYPE	NUMBER(2)	—	Best effort type. Values are: 0: Line rate 1: Rate limited
BEFF_RATE_KBPS	NUMBER(20)	—	Best effort maximum rate in kbps.
BEFF_BURST_SIZE_BPS	NUMBER(20	—	Best effort burst size in bps.

1.2.87  L2_Interface_Table

The L2_Interface_Table (Table 1-86) contains information about the L2 interface table.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-86 L2_Interface_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)	NOT NULL	Bridge group number.
PORT_NUMBER	NUMBER(2)	NOT NULL	Port number.
PORT_SUB_INTERFACE	NUMBER(4)	—	Port subinterface.
COMMITED_RATE_KBPS	NUMBER(20)	—	Committed rate in kilobytes per second.
INTERFACE_NAME	VARCHAR2(30)	—	Interface name.
INTERFACE_TYPE	NUMBER(3)	—	Interface type: 1: POS 2: FASTETHERNET 3: GIGABITETHERNET
PORT_TYPE	NUMBER(2)	—	Port types: 1: UNI 2: NNI
CONNECTION_TYPE	NUMBER(2)	—	Connection types: 1: QinQ 2: Dot1Q 3: Untagged
PORT_STATE	NUMBER(2)	—	Port state. Valid values are: 0: PORT_STATE_DISABLED 1: PORT_STATE_ENABLED
CIR_BURST_BPS	NUMBER(20)	—	Committed information rate burst value.
PIR_BURST_PBS	NUMBER(20)	—	Peak information rate burst value.
QOS_POLICING	NUMBER(1)	—	QoS policy configured on the selected front port interface or subinterface. Valid values are: 0: Unknown 1: Best effort 2: CIR/PIR The default is 1.
PIR_KBPS	NUMBER(20)	—	Peak information rate.
CIR_KBPS	NUMBER(20)	—	Committed information rate.
BEFF_MAXVALUE	NUMBER(20)	—	Best effort maximum value.
BEFF_BURST	NUMBER(20)`	—	Maximum best effort burst value.

1.2.88  L2QoSTemplate_QoSClass_Table

The L2QoSTemplate_QoSClass_Table (Table 1-87) is used to store all the Quality of Service (QoS) parameters defined in a QoS profile. QoS profiles are used during Layer 2 services creation to specify the QoS parameters for the service drops.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-87 L2QoSTemplate_QoSClass_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
QoSTemplateID	NUMBER(6)	NOT NULL	QoS template ID.
MATCH_ANY	NUMBER(1)	—	Matches any traffic.
MATCH_DSCP	NUMBER(1)	—	Match DSCP. DSCP value needs to be specified.
MATCH_COS	NUMBER(1)	—	Match class of service.
MATCH_IP_PRECEDENCE	NUMBER(1)	—	Match IP precedence value.
MATCH_DSCP_VALUE	VARCHAR2(64)	—	DSCP value is used along with Match_DSCP.
MATCH_COS_VALUE	VARCHAR2(32)	—	COS value is used along with Match_COS.
MATCH_IP_PRECEDENCE_V ALUE	VARCHAR2(32)	—	IP precedence value is used along with Match_IP_Precedence.
ANDOR	NUMBER(1)	—	And/or condition.
CLASS_NAME	VARCHAR2(60)	—	Name of class map.
CIR_TYPE	NUMBER(2)	—	CIR type. Values are: 0: Line rate CIR 1: Rate-limited CIR
MAX_RATE_KBPS	NUMBER(20)	—	Maximum allowed rate in kbps.
BURST_SIZE_BPS	NUMBER(20)	—	Size of the burst in bps.
CIR_COS_TYPE	NUMBER(2)	—	Committed CoS mark type. Values are: 0: Trust 1: Mark CoS
CIR_COS_VALUE	NUMBER(2)	—	If CIR_COS_TYPE is 1 then this is the CoS value.
EXCESS_ACTION	NUMBER(2)	—	Excess traffic action. Values are: 0: Discard 1: Allow
PIR_BURST_BPS	NUMBER(20)	—	Peak information rate burst value in bps.
PIR_KBPS	NUMBER(20)	—	Peak information rate in kbps.
PIR_COS_TYPE	NUMBER(2)	—	PIR CoS types. Values are: 0: Trust 1: Mark CoS
PIR_COS_VALUE	NUMBER(2)	—	PIR CoS marking value.
VIOLATE_ACTION	NUMBER(2)	—	Violate action. Values are: 0: Discard 1: Allow
VIOLATE_COS_VALUE	NUMBER(2)	—	CoS marking for violation traffic.
BEFF_TYPE	NUMBER(2)