Table Of Contents

Database Schema Tables

1.1  CTM Sequence Numbers

1.2  CTM Tables (Non-MGX Voice Gateway)

1.2.1  Ack_Table

1.2.2  Active_Alarm_Table

1.2.3  Additional_Device_Info

1.2.4  Admin_Job_Table

1.2.5  Alarm_Ack_Config_Table

1.2.6  Alarm_Count_Table

1.2.7  Alarm_Event_Cause_Table

1.2.8  Alarm_Event_Table

1.2.9  Alarm_Event_Type_ENUM_Table

1.2.10  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_BS_Tbl

1.2.28  Circuit_Ctp_Tbl

1.2.29  Circuit_Dest_Tbl

1.2.30  Circuit_Size_Table

1.2.31  Circuit_Span_BS_Tbl

1.2.32  Circuit_Span_Tbl

1.2.33  Circuit_Tbl

1.2.34  Circuit_VCG_Tbl

1.2.35  Circuit_VLAN_Tbl

1.2.36  CLISession_Command_History_Tbl

1.2.37  CORBA_Functions_Table

1.2.38  CORBA_GW_Active_User_Table

1.2.39  CORBA_Interface_Table

1.2.40  CORBA_Permission_Table

1.2.41  CTC_Model_Const_Table

1.2.42  CTC_UserProfile_Table

1.2.43  CTM_Config_Table

1.2.44  CTM_Unique_ObjectType_Table

1.2.45  DB_Pruning_Table

1.2.46  Debug_Module_Mapping_Table

1.2.47  Debug_Module_Table

1.2.48  Deleted_User_Table

1.2.49  Diskspace_Usage_Table

1.2.50  Domain_Table

1.2.51  Ems_Alarm_Table

1.2.52  Enum_Table

1.2.53  EQPT_Info_Table

1.2.54  Eqpt_Relationship_Table

1.2.55  Error_Log_Table

1.2.56  Forwarding_Table

1.2.57  GWCORBA_PM_Mapping_Table

1.2.58  GNE_Table

1.2.59  Group_Info_Table

1.2.60  HA_Table

1.2.61  HFR_ACL_Policy_Config

1.2.62  HFR_BGP_PEER_PM_Table

1.2.63  HFR_Common_Interface_Config

1.2.64  HFR_ETHER_Interface_Config

1.2.65  HFR_Interface_DRC_PM_Table

1.2.66  HFR_Interface_GC_PM_Table

1.2.67  HFR_Interface_Helper_Address

1.2.68  HFR_Interface_MTU_Layer2

1.2.69  HFR_Interface_Secondary_Addr

1.2.70  HFR_MPLS_Interface_PM_Table

1.2.71  HFR_MPLS_LDP_PM_Table

1.2.72  HFR_MPLS_TE_Link_PM_Table

1.2.73  HFR_MPLS_TE_Tunnel_PM_Table

1.2.74  HFR_Node_CPU_PM_Table

1.2.75  HFR_Node_Memory_PM_Table

1.2.76  HFR_Node_Process_PM_Table

1.2.77  HFR_OSPF_V2_PM_Table

1.2.78  HFR_OSPF_V3_PM_Table

1.2.79  HFR_POS_Interface_Config

1.2.80  HFR_SONET_Interface_Config

1.2.81  HFR_SONET_Interface_Path

1.2.82  HFR_Version_Info

1.2.83  IF_Cross_Connect

1.2.84  IF_DWDM_Channel_Group

1.2.85  IF_Optical_Phy_Config_Table

1.2.86  IFIndex_Rule_Table

1.2.87  Interface_APS_Info

1.2.88  Interface_DWDM_Frequency

1.2.89  Interface_Stack_Table

1.2.90  Interface_Table

1.2.91  IOS_Parser_Static_Tree_Table

1.2.92  L2_FrontPort_Table

1.2.93  L2_Interface_QoSClass_Table

1.2.94  L2_Interface_Table

1.2.95  L2QoSTemplate_QoSClass_Table

1.2.96  L2QoSTemplate_Table

1.2.97  L2Topology_Circuits_Table

1.2.98  L2Topology_Table

1.2.99  L2_Vlan_Table

1.2.100  Link_Table

1.2.101  Managed_Et_Table

1.2.102  Map_Coordinate_Table

1.2.103  Map_Cust_Table

1.2.104  Map_Image_Table

1.2.105  Map_Link_Table

1.2.106  MIB2_Interface_Table

1.2.107  Model_Type_Table

1.2.108  Module155xx_Community_String

1.2.109  Module155xx_VTOID_Table

1.2.110  Module_Type_Mll_Info

1.2.111  Module_Type_Table

1.2.112  NE_Audit_Trail_Table

1.2.113  NE_Info_Table

1.2.114  NE_Inventory_Table

1.2.115  NE_Model_State_Table

1.2.116  NE_Model_Type_Table

1.2.117  NE_Port_Status_Table

1.2.118  NE_Swimage_Table

1.2.119  Network_Partition_Table

1.2.120  ObjectAttributeTable

1.2.121  Object_Relationship_Table

1.2.122  ObjectTypeTable

1.2.123  ONS15216_Active_User_Table

1.2.124  ONS15216_NE_Inventory_Table

1.2.125  ONS15216_Privilege_Table

1.2.126  ONS15216_User_Table

1.2.127  ONS1530x_HO_PM_Table

1.2.128  ONS1530x_IP_PM_Table

1.2.129  ONS1530x_LO_PM_Table

1.2.130  ONS1530x_MS_PM_Table

1.2.131  ONS1530x_NE_Inventory_Table

1.2.132  ONS1530x_RS_PM_Table

1.2.133  ONS15454_327_NE_Table

1.2.134  ONS15454_8B10B_PM_Table

1.2.135  ONS15454_Active_User_Table

1.2.136  ONS15454_CBQoS_Info_Table

1.2.137  ONS15454_CLASSMAP_PM_Table

1.2.138  ONS15454_CMS_Storage_Table

1.2.139  ONS15454_COS_PM_Table

1.2.140  ONS15454_DS1_PM_Table

1.2.141  ONS15454_DS3_PM_Table

1.2.142  ONS15454_ENET_PM_Table

1.2.143  ONS15454_FC_PM_Table

1.2.144  ONS15454_GFP_PM_Table

1.2.145  ONS15454_IFX_PM_Table

1.2.146  ONS15454_Match_STMT_PM_Table

1.2.147  ONS15454_NE_Inventory_Table

1.2.148  ONS15454_OTN_Fec_PM_Table

1.2.149  ONS15454_OTN_Path_PM_Table

1.2.150  ONS15454_OTN_Sec_PM_Table

1.2.151  ONS15454_PHY_LAYER_PM_Table

1.2.152  ONS15454_Police_PM_Table

1.2.153  ONS15454_POS_PM_Table

1.2.154  ONS15454_Privilege_Table

1.2.155  ONS15454_SONET_Line_PM_Table

1.2.156  ONS15454_SONET_Path_PM_Table

1.2.157  ONS15454_SONET_Sec_PM_Table

1.2.158  ONS15454_SONET_VT_PM_Table

1.2.159  ONS15454_User_Table

1.2.160  ONS15454SDH_E1_PM_Table

1.2.161  ONS15454SDH_E3_PM_Table

1.2.162  ONS15454SDH_E4_PM_Table

1.2.163  ONS15454SDH_HO_PM_Table

1.2.164  ONS15454SDH_LO_PM_Table

1.2.165  ONS15454SDH_MS_PM_Table

1.2.166  ONS15454SDH_RS_PM_Table

1.2.167  ONS15501_NE_Explorer_Table

1.2.168  ONS15501_Opt_Power_PM_Table

1.2.169  ONS155xx_CDL_Flow_Config

1.2.170  ONS155xx_CDL_IF_Config

1.2.171  ONS155xx_CDL_PM_Table

1.2.172  ONS155xx_Circuit_CC_Tbl

1.2.173  ONS155xx_Circuit_Path_Tbl

1.2.174  ONS155xx_Circuit_Stack_Tbl

1.2.175  ONS155xx_Condtype_Map

1.2.176  ONS155xx_DCRP_Definition_Table

1.2.177  ONS155xx_DCRP_Table

1.2.178  ONS155xx_Discovery_Info_Table

1.2.179  ONS155xx_Ether_Hist_PM_Table

1.2.180  ONS155xx_FCM_PE_PM_Table

1.2.181  ONS155xx_Flash_Device_Table

1.2.182  ONS155xx_Flash_Partition_Table

1.2.183  ONS155xx_GRA_CC_TO_CKT_CC_Tbl

1.2.184  ONS155xx_Granular_CC_Tbl

1.2.185  ONS155xx_IF_Circuit_Params_Tbl

1.2.186  ONS155xx_IF_Optical_Power

1.2.187  ONS155xx_IF_Phy_Info_Table

1.2.188  ONS155xx_NE_Info_Table

1.2.189  ONS155xx_NE_Type_Table

1.2.190  ONS155xx_Opt_Power_PM_Table

1.2.191  ONS155xx_Path_Hop_Tbl

1.2.192  ONS155xx_Path_Tbl

1.2.193  ONS155xx_Phy_PM_Table

1.2.194  ONS155xx_SONET_Sec_PM_Table

1.2.195  ONS15600_ENET_PM_Table

1.2.196  ONS15600_POS_PM_Table

1.2.197  ONS15600_Sonet_Line_PM_Table

1.2.198  ONS15600_Sonet_Path_PM_Table

1.2.199  ONS15600_Sonet_Sec_PM_Table

1.2.200  ONS15600SDH_HO_PM_Table

1.2.201  ONS15600SDH_MS_PM_Table

1.2.202  ONS15600SDH_RS_PM_Table

1.2.203  ONS158xx_Amplifier_PM_Table

1.2.204  ONS158xx_BCS_PM_Table

1.2.205  ONS158xx_CMP_PM_Table

1.2.206  ONS158xx_IOC_W_PM_Table

1.2.207  ONS158xx_LAC_Active_User_Table

1.2.208  ONS158xx_LAC_Log_Status_Table

1.2.209  ONS158xx_LAC_Log_Table

1.2.210  ONS158xx_LAC_Profile_Table

1.2.211  ONS158xx_LAC_User_Table

1.2.212  ONS158xx_LSM_PM_Table

1.2.213  ONS158xx_NE_IP_Table

1.2.214  ONS158xx_OAD_PM_Table

1.2.215  ONS158xx_OADM_PM_Table

1.2.216  ONS158xx_OSU_PM_Table

1.2.217  ONS158xx_OTS_PTP_Table

1.2.218  ONS158xx_PM_ACT_MOD_Table

1.2.219  ONS158xx_PTPType_Table

1.2.220  ONS158xx_SCF_PM_Table

1.2.221  ONS158xx_TimeStamp_PM_Table

1.2.222  ONS158xx_Transponder_PM_Table

1.2.223  ONS158xx_WD_PM_Table

1.2.224  ONS158xx_WD_RX_PM_Table

1.2.225  Operation_Permissions_Table

1.2.226  Operations_Table

1.2.227  OSS_Active_User_Table

1.2.228  OSS_AID_ENUM_Table

1.2.229  OSS_Alarm_Filter_Table

1.2.230  OSS_Alarm_Fltr_AID_Deny_Tbl

1.2.231  OSS_Alarm_Fltr_TID_Deny_Tbl

1.2.232  OSS_CORBA_User_Table

1.2.233  OSS_User_Table

1.2.234  Password_History_Table

1.2.235  PatchCord_Table

1.2.236  PM_ATTR_Value_Mapping_Table

1.2.237  PM_ATTRID_Mapping_Table

1.2.238  PM_Cerent_Info_Table

1.2.239  PM_Historical_Appointments

1.2.240  PM_Metadata_Info_Table

1.2.241  PM_Metadata_Table

1.2.242  Proxy_Server_Table

1.2.243  Purged_NE_Table

1.2.244  Roll_Table

1.2.245  Router_Link_Table

1.2.246  Router_User_Settings_Table

1.2.247  Schedule_Info_Table

1.2.248  Server_Monitor_Table

1.2.249  Server_Parameter_Table

1.2.250  Subnetwork_Table

1.2.251  SVC_Config_Table

1.2.252  SVC_Info_Table

1.2.253  SVC_NEModel_Table

1.2.254  SVC_Package_Table

1.2.255  Sway_User_Port_Table

1.2.256  Table_Info

1.2.257  TCA_Event_Table

1.2.258  TCA_Event_Type_Table

1.2.259  Threshold_Table

1.2.260  Transaction_Log_Table

1.2.261  Unmanaged_NE_Inventory_Table

1.2.262  User_Map_Table

1.2.263  User_NE_Table

1.2.264  User_Preference_Table

1.2.265  User_Table

1.2.266  CTM_Unknown_User_Table

1.2.267  User_Type_Table

1.2.268  Version_Table

1.2.269  Wavemux_NE

1.2.270  XML_Parser_Static_Tree_Table

1.3  CTM Tables (MGX Voice Gateway)

1.3.1  AAL2_CROSS_CONN

1.3.2  AAL2_5_DATA_PROFILE

1.3.3  ADDR_CUG

1.3.4  APS

1.3.5  ATM_ADDR

1.3.6  ATM_CONNECTION

1.3.7  ATM_PHY

1.3.8  AUSM_PORT

1.3.9  AUSM_PORT_DATA

1.3.10  AU4TUG3

1.3.11  AXSM_CONN_DATA

1.3.12  AXSME_CONN_DATA

1.3.13  CALL_CONTROL_PROFILE

1.3.14  CARD_DESC

1.3.15  CONN_TEMPL_PARAM

1.3.16  CONN_TEMPLATE

1.3.17  CONTROLLER

1.3.18  CUG

1.3.19  DBKR_TEMP

1.3.20  DS0_CONNECT

1.3.21  DSP_STATUS

1.3.22  ELEMENT_TEMPLATE

1.3.23  ELEMENT_TEMPL_PARAM

1.3.24  IF_SHUTDOWN

1.3.25  IMA_GROUP

1.3.26  IMA_GROUP_DESC

1.3.27  IMA_LINK

1.3.28  IMA_LINK_DESC

1.3.29  LAPD_TRUNK

1.3.30  LICENSE_IN_USE

1.3.31  LICENSE_POOL

1.3.32  LIF

1.3.33  LINE_DESC

1.3.34  LINEDISTRIBUTION

1.3.35  LINEDISTRIBUTION_DESC

1.3.36  MG_DNAME

1.3.37  MEGACO_CONFIG

1.3.38  MEGACO_PROFILE

1.3.39  MEGACO_TERM

1.3.40  MG_SUP_PRTCL

1.3.41  MGC_GRP

1.3.42  MGC_IP

1.3.43  MGC_RES

1.3.44  MGCG_PARAM

1.3.45  MGCG_PROTOCOL

1.3.46  MGX8880_NE_INFO_TABLE

1.3.47  NETWORK

1.3.48  NETWORK_DESC

1.3.49  NHM_MANAGEABILITY

1.3.50  NHM_STATS

1.3.51  NODE_DESC

1.3.52  NODE_THRESH

1.3.53  NODE_GROOM

1.3.54  PATH_DESC

1.3.55  PNNI_IF

1.3.56  PORT_DESC

1.3.57  PROGRAM_TONE

1.3.58  REDUNDANTCARD

1.3.59  RPM_CONNECTION

1.3.60  RPM_PORT

1.3.61  RSC_PART

1.3.62  RSC_POLICY

1.3.63  RTP_CONN

1.3.64  RUDP_SESSION

1.3.65  SENSOR_THRHD

1.3.66  SESSION_GROUP

1.3.67  SESSION_SET

1.3.68  SHELF

1.3.69  SRCP_PARAM

1.3.70  SRCP_PEER

1.3.71  STAT_ENABLE

1.3.72  SVC_CAC

1.3.73  SVC_OPERATION

1.3.74  SVC_PORT

1.3.75  TONE_DETECT

1.3.76  TONE_ID

1.3.77  TONE_PLAN

1.3.78  USER_CONNECTION

1.3.79  USER_CONN_DESC

1.3.80  VIRTUAL_PORT

1.3.81  VISM_ANNOUNCE

1.3.82  VISM_CARD

1.3.83  VISM_CAS_BIT

1.3.84  VISM_CID

1.3.85  VISM_CODEC

1.3.86  VISM_DS0

1.3.87  VISM_ENDPT

1.3.88  VISM_HDLC

1.3.89  VISM_LAPD

1.3.90  VISM_LINE

1.3.91  VISM_MGC

1.3.92  VISM_MGCP

1.3.93  VISM_PROFILE

1.3.94  VISM_TEMPLATE

1.3.95  VOICE_CONN

1.3.96  VXSM_CARD

1.3.97  VXSM_CAS_PROFILE

1.3.98  VXSM_CAS_VARIANT

1.3.99  VXSM_EVENT_MAP

1.3.100  VXSM_FAX_RELAY

1.3.101  VXSM_GENERAL_CONFIG

1.3.102  VXSM_IKE_PEER_AUTH

1.3.103  VXSM_IKE_TUNNEL

1.3.104  VXSM_IN_LINE_SIGNAL

1.3.105  VXSM_IPSEC_TUNNEL

1.3.106  VXSM_LINE_SIGNAL_TIMER

1.3.107  VXSM_NETWORK_INTERFACE

1.3.108  VXSM_OUT_LINE_SIGNAL

1.3.109  VXSM_PH1_PTRF_ASSOC

1.3.110  VXSM_PH2_PTRF_ASSOC

1.3.111  VXSM_PHASE1_PROPOSAL

1.3.112  VXSM_PHASE1_TRANSFORM

1.3.113  VXSM_PHASE2_PROPOSAL

1.3.114  VXSM_PHASE2_TRANSFORM

1.3.115  VXSM_PVC_IP

1.3.116  VXSM_RTCP_CIPHERSUITE

1.3.117  VXSM_RTP_CIPHERSUITE

1.3.118  VXSM_SECURITY_POLICY

1.3.119  VXSM_SPD_KEY_MGR_ASSOC

1.3.120  VXSM_TTY_PROFILE

1.3.121  VXSM_VDB_PROFILE

1.3.122  VXSM_VIF

1.3.123  XGCP_GW

1.3.124  XGCP_MGC

1.3.125  XGCP_PEER

1.4  NE Statistics-Related Tables

1.4.1  AXSM_CARD_DATA

1.4.2  AXSM_CONN_DATA

1.4.3  AXSM_LINE_DATA

1.4.4  AXSM_PORT_DATA

1.4.5  AXSME_CONN_DATA

1.4.6  AXSME_LINE_DATA

1.4.7  AXSME_PORT_DATA

1.4.8  AXSMESONET_PL_DATA

1.4.9  AXSMET1E1_PL_DATA

1.4.10  AXSMET3E3_PL_DATA

1.4.11  IMA_GROUP_DATA

1.4.12  IMA_LINK_DATA

1.4.13  LAPD_IN_DS1INDS3_DATA

1.4.14  LAPD_IN_DS1INVT_DATA

1.4.15  LAPDIN_T1E1_DATA

1.4.16  LAPD_IN_T3E3_DATA

1.4.17  MEGACO_DATA

1.4.18  MEGACO_EPH_TERM_DATA

1.4.19  MEGACO_PHY_TERM_DATA

1.4.20  SCMCARD

1.4.21  SCMCARDCOLL

1.4.22  SCMCARDCOLLHOST

1.4.23  SCMCARDENABLE

1.4.24  SCMCARDFAMILY

1.4.25  SCMCARDFAMILYDEF

1.4.26  SCMCARDFAMILYSTAT

1.4.27  SCMCARDTEMPLATE

1.4.28  SCMCOLLSVR

1.4.29  SCMCOLPAR

1.4.30  SCMCOLPARSTAT

1.4.31  SCMCOLPARSUBOBJ

1.4.32  SCMENABLETYPE

1.4.33  SCMIDMAP

1.4.34  SCMNODECOLL

1.4.35  SCMNODECOLLHOST

1.4.36  SCMNODEENABLE

1.4.37  SCMNODESTAT

1.4.38  SCMNODETEMPLATE

1.4.39  SCMOBJ

1.4.40  SCMSTAT

1.4.41  SCMSTATSKEY

1.4.42  SCMSUBOBJ

1.4.43  SCMDB_SCMCOLLSVR

1.4.44  SCMENABLELIST

1.4.45  SCMENABLESUBTYPE

1.4.46  SCMFRAGDATATABLES

1.4.47  SCMIDMAPDEF

1.4.48  SCMNODESTAT

1.4.49  SCMNODE

1.4.50  SCMOLDSTATKEY

1.4.51  SCMSTATKEY

1.4.52  SCMTABLEKEY

1.4.53  SCTP_ASSOCIATION_DATA

1.4.54  SCTP_GATEWAY_DATA

1.4.55  SESSION_DATA

1.4.56  SONET_LINE_DATA

1.4.57  SRTPERFKEY

1.4.58  SRTRPORTKEY

1.4.59  STATSDB_CONFIG

1.4.60  STS_DS3_DS1_PATH_DATA

1.4.61  STS_VTGROUP_DS1_PATH_DATA

1.4.62  XG_CONN_DATA

1.4.63  XGCP_DATA

1.4.64  XG_DS3PATH_DATA

1.4.65  XG_PATH_DATA

1.4.66  XG_PL_DATA

1.4.67  XG_PORT_DATA

Database Schema Tables

---

This chapter describes tables and table sequence numbers.

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.
MGX8880_SNMP_INDEX_SEQ	Used when user connections are added to the User_Connection_Table.
NEDBACCESSID_SEQ	Used when NEs are added to the NE_Info_Table.
NPID_SEQ	Used when adding a new network partition to Network_Partition_Table.
ONS155XX_CIRCUIT_CC_DBID_SEQ	Used for circuit-specific cross-connects in the ONS155xx_Circuit_CC_Tbl.
ONS155XX_GRANULAR_CC_DBID_SEQ	Used for NE-specific cross-connects in the ONS155xx_Granular_CC_Tbl.
ONS155XX_PATH_DBID_SEQ	Used for the ONS155xx_Path_Tbl.
QOSTEMPLATEID_SEQ	Used to generate a QoS template ID when a new QoS template is added.
SERVER_PARAMETER_SEQ	Used as parameter index in Server_Parameter_Table.
SID_SEQ	Used to generate a service ID when a service is added.
SUBNETID_SEQ	Used when adding a subnetwork to the Subnetwork_Table.
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 (Non-MGX Voice Gateway)

This section describes the non-MGX Voice Gateway database tables created by CTM, listed in alphabetical order.

MGX Voice Gateway database tables are described in CTM Tables (MGX Voice Gateway).

---

Note The following tables are partitioned in medium, large, and high-end configurations:

•HFR (CRS-1) PM tables

•ONS 1530x PM tables

•ONS 15454 PM tables

•ONS 155xx PM tables

•ONS 15600 PM tables

•ONS 158xx PM tables

---

1.2.1  Ack_Table

The Ack_Table (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)	—	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	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(4000)	—	Any additional information.
UserComments	VARCHAR2(2048)	—	Any comments entered by the user.
operation_info	VARCHAR2(4000)	—	List of parameters specific to a job.
display_info	VARCHAR2(4000)	—	String that displays job-specific information according to specific criteria.

1.2.5  Alarm_Ack_Config_Table

The Alarm_Ack_Config_Table (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
WIDGET_ID (continued)	NUMBER(2)	NOT NULL	6: List 7: Check box 8: Combo box 9: Buttons 10: Combo text field 11: Button group 12: Dynamic combo box
WIDGET_ID (continued)	NUMBER(2)	NOT NULL	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
WIDGET_ID (continued)	NUMBER(2)	NOT NULL	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 99: Adjacent text fields

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_BS_Tbl

The Circuit_BS_Tbl (Table 1-27) stores basic information about the circuit.

Primary key: CIRCUIT_BS_TBL_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-27 Circuit_BS_Tbl 

Column Name	Oracle Data Type	Integrity Constraints	Description
CktNodeId	NUMBER(10)	NOT NULL	Node ID of the source node of the circuit.
CktUniqueId	NUMBER(10)	NOT NULL	Unique number within each source node. The CktNodeId and CktUniqueId combine to form a circuit ID that is unique in the network. Note that these are internal fields and should not be displayed.
CktName	VARCHAR2(64)	—	Name of the circuit.
CktDescription	VARCHAR2(256)	—	Description of the circuit.
CustomerId	VARCHAR2(256)	—	Customer ID.
ServiceId	VARCHAR2(256)	—	Service ID.
CktType	NUMBER(2)	—	Type of circuit. Valid values are: 0: ETHERNET 1: STS_CIRCUIT 2: VT_CIRCUIT 3: VT_TUNNEL 4: VT_AGGREGATION 5: STS_VCAT_CIRCUIT 6: VT_VCAT_CIRCUIT 7: GIGABIT_ETHERNET 8: TENGIGABIT_ETHERNET 9: FIBERCHANNEL 10: FICON 11: ESCON 12: SDH_CIRCUIT 13: ISC_COMPATIBLE 14: ISC_PEER 15: SYSPLEX 16: DWDM_TRANSPARENT_ANY
CktType (continued)	NUMBER(2)	—	17: VC_HO_PATH_CIRCUIT 18: VC_LO_PATH_CIRCUIT 19: VC_LO_PATH_TUNNEL 20: VC_LO_PATH_AGGREGATION 21: VC_HO_VCAT_CIRCUIT 22: VC_LO_VCAT_CIRCUIT 23: DWDM_WAVELENGTH 24: FAST_ETHERNET 25: FDDI 26: SYSPLEX_TIMER_ETR 27: SYSPLEX_TIMER_CLO 28: TENGIGABIT_ETHERNET_WAVELENGTH 29: POINT5GIGABIT_ETHERNET_WAVELENGTH 30: TENGIGABIT_ETHERNET_TRUNK 31: SONET_CIRCUIT 32: OCHNC_CIRCUIT
CktSize	NUMBER(2)	—	Size of circuit. Valid values are: 0: VT1_5 1: 1 = STS1 2: STS3C 3: STS6C 4: STS9C 5: STS12C 6: STS24C 7: STS48C 8: STS192C 9: TS768C 10: DWDM_2POINT5G 11: DWDM_10G 12: VC_11 13: VC_12 14: VC_3 15: VC_4 16: VC_4_2C 17: VC_4_3C 18: VC_4_4C 19: VC_4_8C 20: VC_4_16C
CktSize (continued)	NUMBER(2)	—	21: VC_4_64C 22: FIBERCHANNEL1 23: FIBERCHANNEL2 24: FICON 25: ESCON 26: SYSPLEX 27: FAST_ETHERNET 28: GIGABIT_ETHERNET 29: TENGIGABIT_ETHERNET 30: VT_2
CktSize (continued)	NUMBER(2)	—	31: FDDI 32: OCHNC_NOTEQUIPPED 33: OCHNC_MULTIRATE 34: OCHNC_2_5G_FEC 35: OCHNC_2_5G_NOFEC 36: OCHNC_10G_FEC 37: OCHNC_10G_NOFEC 38: STS36C 39: VC_4_12C 40: STS18C 41: VC_4_6C 42: STM1C 43: STM4C 44: STM16C 45: STM64C 46: ISC_COMPATIBLE 47: ISC_PEER 48: SYSPLEX_TIMER_ETR 49: SYSPLEX_TIMER_CLO 50: TWO_GIGABIT_ETHERNET 51: E1 52: T1 53: DVB 54: SDI
CktDirection	NUMBER(1)	—	Type of traffic that the circuit carries. Values are: 0: Unidirectional 1: Bidirectional
CktIsMonitor	NUMBER(1)	—	Whether the circuit is a monitor circuit. Values are: 0: False 1: True
CktState	NUMBER(2)	—	State of the circuit. Values are: 0: CREATING 1: ACTIVE 2: DELETING 3: DROP_PENDING 4: INCOMPLETE 5: UPGRADABLE 6: INCOMPLETE_UPGRADABLE 7: ERRORED 8: NOT_UPGRADABLE 9: INCOMPLETE_NOT_UPGRADABLE 10: ROLL_PENDING 11: NOT_ACTIVATED
CktEnhancedState	NUMBER(2)	—	Administrative state of the circuit.
CktProtectionType	NUMBER(2)	—	Circuit protection type.
CktAdditionalInfo	VARCHAR2(64)	—	Additional information about the circuits.
cktComment	VARCHAR2(2014)	—	—
CktUseLap	NUMBER(1)	—	Whether the circuit uses LAP. Values are: 0: False 1: True
CktOchncChannel	NUMBER(2)	—	Values are: 0: NOT_APPLICABLE 1: OCHNC_30_33 2: OCHNC_31_12 3: OCHNC_31_90 4: OCHNC_32_68 5: OCHNC_34_25 6: OCHNC_35_04 7: OCHNC_35_82 8: OCHNC_36_61 9: OCHNC_38_19 10: OCHNC_38_98 11: OCHNC_39_77 12: OCHNC_40_56 13: OCHNC_42_14 14: OCHNC_42_94 15: OCHNC_43_73 16: OCHNC_44_53 17: OCHNC_46_12 18: OCHNC_46_92 19: OCHNC_47_72 20: FALSE OCHNC_48_51 21: FALSE OCHNC_50_12 22: OCHNC_50_92 23: OCHNC_51_72 24: MANUAL OCHNC_52_52 25: OCHNC_54_13 26: OCHNC_54_94 27: OCHNC_55_75 28: OCHNC_56_55 29: OCHNC_58_17 30: CHNC_58_98 31: OCHNC_59_79 32: OCHNC_60_61
CktOchncDir	NUMBER(1)	—	Direction of the OCHNC circuit. Values are: 0: East-to-west 1: West-to-east 2: Not applicable
isDuplicateName	NUMBER(1)	DEFAULT 1	Whether or not the circuit has a duplicate name. Values are: 0: Duplicate 1: Not duplicate
NPID	NUMBER(10)	—	Network partition ID to which the subnetwork belongs.
SPAN_TYPE	NUMBER(1)	—	The type of span. Values are: 0: Regular span 1: VT tunnel span

1.2.28  Circuit_Ctp_Tbl

The Circuit_Ctp_Tbl (Table 1-28) stores the circuit termination points.

Foreign key: FK_CIRCUIT_CTPNPID

Tablespace: BASE_DATA_TABLESPACE

Table 1-28 Circuit_Ctp_Tbl 

Column Name	Oracle Data Type	Integrity Constraints	Description
CTPAccessID	NUMBER(10)	NOT NULL	Unique sequence number generated by the database. This is the link between the table and the Circuit_Span_BS_Tbl that contains CTPs. Values are: 1: Circuit termination point CTP 2: L2 VLAN
CTP_Type	NUMBER(5)	NOT NULL	CTP entity type. Values are: 0: SRC 1: SEC_SRC 2: DROP 3: SPAN_SRC 4: SPAN_DEST 5: SPAN_SRC_THRU_TUNNEL 6: SPAN_DEST_THRU_TUNNEL 7: SPAN_SRC_VTT_EXPANDED 8: SPAN_DEST_VTT_EXPANDED
CktNodeId	NUMBER(10)	NOT NULL	The node ID of the source node of the circuit.
CktUniqueId	NUMBER(10)	NOT NULL	Unique number within each source node. The CktNodeId and CktUniqueId combine to form a circuit ID that is unique in the network. Note that these are internal fields and should not be displayed.
CktCtpNodeId	NUMBER(10)	—	CTP circuit node ID.
CKTCTPNeDBAccessId	NUMBER(10)	NOT NULL	NE database ID.
CktCtpModuleType	NUMBER(8)		Module type of the CTP.
CktCtpIfIndex	NUMBER(20)	—	If_Static_Index at the destination.
CktCtpObjectType	NUMBER(10)	—	Object type at the destination.
CktCtpPhysicalLoc	NUMBER(20)	—	Physical location of the destination node.
CktCtpModelType	NUMBER(4)	—	Model type of the destination node.
CktCtpDropProt	NUMBER(1)	—	Whether the endpoint is protected. Values are: 0: False 1: True
CktCtpPathProt	NUMBER(1)	—	Path protection for this drop. Values are: 0: PATH FULLY PROTECTED 1: PATH PROTECTED 2: PATH UNPROTECTED 3: PATH FULLY UNPROTECTED
CktCtpDropProtType	NUMBER(1)	—	Protection type. Values are: 0: NO_PROTECTION 1: UNKNOWN_PROTECTION 2: SPLITTER_PROTECTION 3: Y_CABLE_OR_LINE_CARD_PROTECTION 4: TRUNK_CARD_PROTECTION
CktCtpPortName	VARCHAR2(64)	—	Destination port name of the circuit.
CktCtpAdditionalInfo	VARCHAR2(64)	DEFAULT NULL	Additional information about the circuit destination.
NPID	NUMBER(10)	DEFAULT 0	Network partition ID to which the subnetwork belongs.

1.2.29  Circuit_Dest_Tbl

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

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-29 Circuit_Dest_Tbl 

Column Name	Oracle Data Type	Integrity Constraints	Description
CktNodeId	NUMBER(10)	NOT NULL	Node ID of the source node of the circuit.
CktUniqueId	NUMBER(10)	NOT NULL	Unique number within each source node. The CktNodeId and CktUniqueId combine to form a circuit ID that is unique in the network. Note that these are internal fields and should not be displayed.
CktDestNodeId	NUMBER(10)	—	Destination node ID.
CktDestModuleType	NUMBER(8)	—	Module type at destination.
CktDestIfIndex	NUMBER(20)	—	Static index of the interface at the destination.
CktDestObjectType	NUMBER(10)	—	Object type at the destination.
CktDestPhysicalLoc	NUMBER(20)	—	Physical location of the destination node.
CktDestModelType	NUMBER(4)	—	Model type of the destination node.
CktDestDropProt	NUMBER(1)	—	Whether the endpoint is protected. Values are: 0: False 1: True
CktDestPathProt	NUMBER(1)	—	Path protection for this drop. Values are: 0: Path fully protected 1: Path protected 2: Path unprotected 3: Path fully unprotected
CktDestDropProtType	NUMBER(1)	—	Protection type for ONS 15540: 0: No protection 1: Unknown protection 2: Splitter protection 3: Y-cable or line-card protection 4: Trunk card protection
CktDestPortName	VARCHAR2(64)	—	Destination port name of the circuit.
CktDestAdditionalInfo	VARCHAR2(64)	DEFAULT NULL	Additional information for the circuit destination.
NPID	NUMBER(10)	DEFAULT 0	Network partition ID.

1.2.30  Circuit_Size_Table

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

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

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

The Circuit_Span_BS_Tbl (Table 1-31) stores circuit span information. Each span consists of the span base information, span source circuit termination point, and span destination circuit termination point. The span base information is stored in the Circuit_Span_BS_Tbl. The span source circuit termination point is stored in the Circuit_CTP_Tbl and a reference to the CIRCUIT_CTP_TBL row (that is, database row ID) is stored in the Circuit_Span_BS_Tbl as CIRCUIT_SPAN_SRC_CTP_ACCESSID. Similarly, the span destination circuit termination point is stored in the Circuit_CTP_Tbl and a reference to the CIRCUIT_CTP_TBL row (database row ID) is stored in the Circuit_Span_BS_Tbl as CIRCUIT_SPAN_DEST_CTP_ACCESSID.

Foreign key: FK_CIRCUIT_SPAN_BS_NPID

Tablespace: BASE_DATA_TABLESPACE

Table 1-31 Circuit_Span_BS_Tbl 

Column Name	Oracle Data Type	Integrity Constraints	Description
CktSpanBSId	NUMBER(10)	NOT NULL	Unique sequence number generated by the database.
CktNodeId	NUMBER(10)	—	Node ID of the source node of the circuit to which the span belongs.
CktUniqueId	NUMBER(10)	—	Unique number within each source node. The CktNodeId and CktUniqueId combine to form a circuit ID that is unique in the network. Note that these are internal fields and should not be displayed.
CktLinkId	NUMBER(10)	—	ID of the link to which this span belongs.
Span_Type	NUMBER(5)	NOT NULL	Type of span.
CktSpanSrcCtpAccessId	NUMBER(10)	—	CTP ID of the span source.
CktSpanDstCtpAccessId	NUMBER(10)	—	CTP ID of the span destination.
CktSpanSrcState	NUMBER(1)	—	State of the circuit span from the source circuit node's point of view. Values are: 0: INACTIVE 1: STRANDED 2: ROUTED 3: TENTATIVE 4: ACTIVE
CktSpanDestState	NUMBER(1)	—	State of the circuit span from the destination circuit node's point of view. Values are: 0: INACTIVE 1: STRANDED 2: ROUTED 3: TENTATIVE 4: ACTIVE
IsCktForwarding	NUMBER(1)	—	Whether the circuit span is forwarding; valid for Ethernet circuit spans only. Values are: 0: False 1: True
IsCktSpanInUPSR	NUMBER(1)	—	Whether the circuit span is part of a UPSR ring. Values are: 0: False 1: True
IsCktSpanWorking	NUMBER(1)	—	Whether the circuit span is a working span. Values are: 0: False 1: True
IsCktSpanActive	NUMBER(1)	—	Whether the circuit span carries active traffic. Values are: 0: False 1: True
CktSpanProtOp	NUMBER(1)	—	Last successful span protection operation performed on this span. Values are: 1: Manual 2: Force 3: Lockout
CktSpanCDLFlowID	NUMBER(3)	DEFAULT -1	(Applicable only to ONS 155xx circuits) Source CDL flow identifier. The valid range is from 0 to 254.
CktSpanSrcPortName	VARCHAR2(64)	—	Span source port name of the circuit.
CktSpanDestPortName	VARCHAR2(64)	—	Span destination name of the circuit.
NPID	NUMBER(10)	DEFAULT 0	Network partition ID to which the subnetwork belongs.

1.2.32  Circuit_Span_Tbl

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

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-32 Circuit_Span_Tbl 

Column Name	Oracle Data Type	Integrity Constraints	Description
CktSpanId	NUMBER(10)	NOT NULL	Unique sequence number generated by the database.
CktNodeId	NUMBER(10)	—	Node ID of the source node of the circuit to which the span belongs.
CktUniqueId	NUMBER(10)	—	Unique number within each source node. The CktNodeId and CktUniquieId combine to form a circuit ID that is unique in the network. Note that these are internal fields and should not be displayed.
CktLinkId	NUMBER(10)	—	ID of the link to which this span belongs.
CktSpanSrcNodeId	NUMBER(10)	—	Node ID of the span source.
CktSpanSrcModuleType	NUMBER(8)	—	Module type at the span source.
CktSpanSrcIfIndex	NUMBER(20)	—	Static index of the interface at the span source.
CktSpanSrcObjectType	NUMBER(10)	—	Object type at span source.
CktSpanSrcPhysicalLoc	NUMBER(20)	—	Physical location of the source node of the span.
CktSpanSrcModelType	NUMBER(4)	—	Model type for source node of span.
CktSpanDestNodeId	NUMBER(10)	—	Node ID of the span destination.
CktSpanDestModuleType	NUMBER(8)	—	Module type at the span destination.
CktSpanDestIfIndex	NUMBER(20)	—	Static index of the interface at the span destination.
CktSpanDestObjectType	NUMBER(10)	—	Object type at span destination.
CktSpanDestPhysicalLoc	NUMBER(20)	—	Physical location of the destination node of the span.
CktSpanDestModelType	NUMBER(4)	—	Model type for destination node of span.
CktSpanSrcState	NUMBER(1)	—	State of the circuit span from the source circuit node. Values are: 0: Inactive 1: Stranded 2: Routed 3: Tentative 4: Active
CktSpanDestState	NUMBER(1)	—	State of the circuit span from the destination circuit. Values are: 0: Inactive 1: Stranded 2: Routed 3: Tentative 4: Active
IsCktForwarding	NUMBER(1)	—	Whether the circuit span is forwarding (for Ethernet circuit spans only): 0: False 1: True
IsCktSpanInUPSR	NUMBER(1)	—	Whether the circuit span is part of a unidirectional path switched ring (UPSR) ring. Values are: 0: False 1: True
IsCktSpanWorking	NUMBER(1)	—	Whether the circuit span is a working span. Values are: 0: False 1: True
IsCktSpanActive	NUMBER(1)	—	Whether the circuit span carries active traffic. Values are: 0: False 1: True
CktSpanProtOp	NUMBER(1)	—	Last successful span protection operation performed on this span. Values are: 0: Clear 1: Manual 2: Force 3: Lockout
CktSpanAdditionalInfo	VARCHAR2(64)	DEFAULT NULL	Additional information 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.33  Circuit_Tbl

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

Primary key: CIRCUIT_TBL_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-33 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: VT_2 31: FDDI 32: Optical CHannel Network Connection (OCHNC) not equipped 33: OCHNC multirate 34: OCHNC 2.5G FEC 35: OCHNC 2.5G NOFEC 36: OCHNC 10G FEC 37: OCHNC 10G NOFEC 38: STM 1C 39: STM 4C 40: STM 16C 41: STM 64C 42: ISC compatible 43: ISC peer 44: SYSPLEX_TIMER_ETR 45: SYSPLEX_TIMER_CLO 46: TWO_GIGABIT_ETHERNET 47: E1 48: T1
CktDirection	NUMBER(1)	—	Type of traffic that the circuit carries. Values are: 0: Unidirectional 1: Bidirectional
CktIsMonitor	NUMBER(1)	—	Whether the circuit is a monitor circuit. Values are: 0: False 1: True
CktState	NUMBER(2)	—	State of the circuit. Values are: 0: Creating 1: Active 2: Deleting 3: Drop-pending 4: Incomplete 5: 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)	—	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)	—	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.34  Circuit_VCG_Tbl

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

Primary key: none

Tablespace: BASE_DATA_TABLESPACE

Table 1-34 Circuit_VCG_Tbl 

Column Name	Oracle Data Type	Integrity Constraints	Description
CktNodeId	NUMBER(10)	NOT NULL	Node ID of the source circuit node.
CktUniqueId	NUMBER(10)	NOT NULL	Unique number within each source node. The combination of the CktNodeId and CktUniqueId result in a unique circuit ID in the whole network. Note that these are internal fields and should not be displayed.
ParentCktNodeId	NUMBER(10)	NOT NULL	Node ID of the source node of the parent VCAT circuit.
ParentCktUniqueId	NUMBER(10)	NOT NULL	Unique number within each source node. The combination of ParentCktNodeId and ParentCktUniqueId result in a unique circuit ID in the whole network. Note that these are internal fields and should not be displayed.
VCGDirection	NUMBER(1)	—	VCG direction. Values are: 0: None 1: Forward 2: Backward 3: Bidirectional
NPID	NUMBER(10)	DEFAULT 0	Network partition ID.
VCATSTATE	NUMBER(1)	DEFAULT 0	VCAT member state.

1.2.35  Circuit_VLAN_Tbl

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

Primary key: CIRCUIT_VLAN_PK

Tablespace: BASE_DATA_TABLESPACE

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

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

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

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

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

The CORBA_GW_Active_User_Table (Table 1-38) contains information about the active CTM GateWay/CORBA users.

Primary key: CORBA_GW_ACTIVE_USER_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-38 CORBA_GW_Active_User_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
active_session_id	VARCHAR2(128)	NOT NULL	Session ID.
user_name	VARCHAR2(128)	NOT NULL	Username of the OSS user.
client_end_ip	NUMBER(10)	NOT NULL	IP address of the OSS user.
LastLoginTime	DATE	—	Most recent user login date and time.

1.2.39  CORBA_Interface_Table

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

Primary key: CORBA_INTERFACE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-39 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.40  CORBA_Permission_Table

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

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-40 CORBA_Permission_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
InterfaceIndex	NUMBER(10)	NOT NULL	Index of the CORBA interface.
OperationID	NUMBER(10)	NOT NULL	Operation ID from the Operations_Table.

1.2.41  CTC_Model_Const_Table

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

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

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

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

Primary key: CTC_USR_PROF_TABLE_PK

Tablespace: None

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

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

Primary key: ctm_config_table_pk

Tablespace: BASE_DATA_TABLESPACE

Table 1-43 CTM_Config_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
SectionName	VARCHAR2(40)	NOT NULL	Name of the section.
PropertyName	VARCHAR2(40)	NOT NULL	Name of the parameter.
ActiveValue	VARCHAR2(128)	—	Active value of the parameter.
IsPermanent	NUMBER(1)	NOT NULL	Whether or not the value can be changed. Values are: 0: False 1: True
PermanentValue	VARCHAR2(128)	—	Permanent value of the parameter.

1.2.44  CTM_Unique_ObjectType_Table

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

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-44 CTM_Unique_ObjectType_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
ObjectType	NUMBER(10)	UNIQUE, NOT NULL	Object type.
ObjectName	VARCHAR2(256)	NOT NULL	Object name of the object type.

1.2.45  DB_Pruning_Table

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

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-45 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.46  Debug_Module_Mapping_Table

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

Primary key: none

Tablespace: BASE_DATA_TABLESPACE

Table 1-46 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.47  Debug_Module_Table

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

Primary key: DEBUG_MODULE_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-47 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.48  Deleted_User_Table

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

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-48 Deleted_User_Table 

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

1.2.49  Diskspace_Usage_Table

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

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-49 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.50  Domain_Table

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

Primary key: DOMAIN_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

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

The Ems_Alarm_Table (Table 1-51) shows information about EMS alarms.

Primary key: EMS_ALARM_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-51 Ems_Alarm_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
Name	VARCHAR2(128)	—	Name of the alarm displayed to client.
alarmIndex	NUMBER(5)	—	EMS index of alarm or group.
isGroup	NUMBER(1)	—	Whether or not this alarm belongs to a group. Values are: 0: FALSE 1: TRUE
Severity	NUMBER(1)	DEFAULT 4	Alarm severity. Values are: -1: N/A 4: Warning 5: Minor 6: Major 7: Critical

1.2.52  Enum_Table

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

Primary key: ENUM_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-52 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.53  EQPT_Info_Table

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

Primary key: EQPT_INFO_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-53 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.54  Eqpt_Relationship_Table

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

Primary key: EQPT_RELATIONSHIP_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-54 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.55  Error_Log_Table

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

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-55 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.56  Forwarding_Table

The Forwarding_Table is obsolete.

1.2.57  GWCORBA_PM_Mapping_Table

The GWCORBA_PM_Mapping_Table (Table 1-56) contains PM data mapping information for CTM GateWay/CORBA.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-56 GWCORBA_PM_Mapping_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
MODELTYPE	NUMBER(4)	NOT NULL	Unique number associated with each NE model type.
LAYERRATE	NUMBER(10)	NOT NULL	Layer rate(s) associated with each PM type.
OBJECTINDEX	NUMBER(10)	NOT NULL	Unique object type associated with a specific PM type.
LOCATION	NUMBER(2)	NOT NULL	Whether the PM data is near-end or far-end data. Values are: 1: Near end 2: Far end
DIRECTION	NUMBER(2)	NOT NULL	Whether the PM data is receive or transmit. Values are: 1: Receive (Rx) 2: Transmit (Tx)
TERMINATIONPOINT	NUMBER(2)	NOT NULL	Whether the PM parameters are for noncircuit or circuit data. Values are: 0: Noncircuit 1: Circuit
PMVIEWNAME	VARCHAR2(64)	NOT NULL	Name of the PM view in the CTM database from which the PM data is retrieved.

1.2.58  GNE_Table

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

Primary key: GNE_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-57 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.59  Group_Info_Table

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

Primary key: GROUP_INFO_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-58 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.60  HA_Table

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

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-59 HA_Table 

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

1.2.61  HFR_ACL_Policy_Config

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

Primary key: HFR_ACL_POLICY_CFG_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-60 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.62  HFR_BGP_PEER_PM_Table

Primary key: HFR_PM_BGP_PEER_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-61 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)	—	Whether NE was under maintenance 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-minute intervals. 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.63  HFR_Common_Interface_Config

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

Primary key: HFR_COM_INTF_CFG_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-62 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.64  HFR_ETHER_Interface_Config

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

Primary key: HFR_ETHER_INTF_CFG_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-63 HFR_ETHER_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	—
FULLDUPLEX	NUMBER(1)	—	—
HALFDUPLEX	NUMBER(1)	—	—
ARPPROXY	NUMBER(1)	—	—
ARPTIMEOUT	NUMBER(8)	—	—
MACADDRESS	VARCHAR2(12)	—	—
MEDIATYPE	VARCHAR2(6)	—	—
SPEED	VARCHAR2(4)	—	—

1.2.65  HFR_Interface_DRC_PM_Table

Primary key: HFR_PM_INTERFACE_DRC_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-64 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)	—	Whether NE was under maintenance 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-minute intervals. 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.66  HFR_Interface_GC_PM_Table

Primary key: HFR_PM_INTERFACE_GC_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-65 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)	—	Whether the NE was under maintenance 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-minute intervals. 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.67  HFR_Interface_Helper_Address

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

Primary key: HFR_COM_INTF_HELPADDR_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-66 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.68  HFR_Interface_MTU_Layer2

Primary key: HFR_COM_INTF_MTULAYER2_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-67 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.69  HFR_Interface_Secondary_Addr

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

Primary key: HFR_COM_INTF_SECONDADDR_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-68 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.70  HFR_MPLS_Interface_PM_Table

Primary key: HFR_PM_MPLS_INTERFACE_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-69 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)	—	Whether the NE was under maintenance 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-minute intervals. 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.71  HFR_MPLS_LDP_PM_Table

Primary key: HFR_PM_MPLS_LDP_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-70 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	Status of the PM bucket. Valid values are: •0: Valid period •Other: Bit mask value (information about the PM statistics)
inMaintenance	NUMBER(1)	—	Whether NE was under maintenance 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 during the 24-hour interval.
IS24H	NUMBER(1)	NOT NULL	Whether the PM data is for 24-hour or 15-minute intervals. 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	—
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.72  HFR_MPLS_TE_Link_PM_Table

Primary key: HFR_PM_MPLS_TE_LINK_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-71 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)	—	Whether the NE was under maintenance 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-minute intervals. 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.73  HFR_MPLS_TE_Tunnel_PM_Table

Primary key: HFR_PM_MPLS_TE_TUNNEL_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-72 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)	—	Whether the NE was under maintenance 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-minute intervals. 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.74  HFR_Node_CPU_PM_Table

Primary key: HFR_PM_NODE_CPU_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-73 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)	—	Whether the NE was under maintenance 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-minute intervals. 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.75  HFR_Node_Memory_PM_Table

Primary key: HFR_PM_NODE_MEMORY_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-74 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)	—	Whether the NE was under maintenance 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-minute intervals. 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.76  HFR_Node_Process_PM_Table

Primary key: HFR_PM_NODE_PROCESS_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-75 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 data 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	Status of the PM interval. Valid values are: •0: Valid period •Other: Bit mask value (information about the PM statistics)
inMaintenance	NUMBER(1)	—	Whether NE was under maintenance 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 during the 24-hour interval.
IS24H	NUMBER(1)	NOT NULL	Whether the PM data is for 24-hour or 15-minute intervals. 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.77  HFR_OSPF_V2_PM_Table

Primary key: HFR_PM_OSPF_V2_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-76 HFR_OSPF_V2_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 data refers.
PhysicalLoc	NUMBER(20)	DEFAULT 0	Physical location.
NEIfIndex	NUMBER(20)	NOT NULL	Table index for the interface; same as IfStaticIndex in the Interface_Table.
OSPFV2TimeStamp	DATE	NOT NULL	Time stamp showing the interval for which the set of statistics is stored.
NEIfPMStatus	NUMBER(20)	NOT NULL	Status of the PM interval. Valid values are: •0: Valid period •Other: Bit mask value (information about the PM statistics)
inMaintenance	NUMBER(1)	—	Whether NE was under maintenance 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 during the 24-hour interval.
IS24H	NUMBER(1)	NOT NULL	Whether the PM data is for 24-hour or 15-minute intervals. Valid values are: •1: 24 hour •0: 15 minutes
INSTANCENAME	VARCHAR2(64)	NOT NULL	Instance name.
INPACKETS	NUMBER(10)	DEFAULT -1	—
OUTPACKETS	NUMBER(10)	DEFAULT -1	—
INHELLO	NUMBER(100	DEFAULT -1	—
OUTHELLO	NUMBER(10)	DEFAULT -1	—
INDBDS	NUMBER(10)	DEFAULT -1	—
INDBDSLSA	NUMBER(10)	DEFAULT -1	—
OUTDBDS	NUMBER(10)	DEFAULT -1	—
OUTDBDSLSA	NUMBER(10)	DEFAULT -1	—
INLSREQUESTS	NUMBER(10)	DEFAULT -1	—
INLSREQUESTSLSA	NUMBER(10)	DEFAULT -1	—
OUTLSREQUESTS	NUMBER(10)	DEFAULT -1	—
OUTLSREQUESTSLSA	NUMBER(10)	DEFAULT -1	—
INLSAUPDATES	NUMBER(10)	DEFAULT -1	—
INLSAUPDATESLSA	NUMBER(10)	DEFAULT -1	—
OUTLSAUPDATESLSA	NUMBER(10)	DEFAULT -1	—
INLSAACKS	NUMBER(10)	DEFAULT -1	—
INLSAACKSLSA	NUMBER(10)	DEFAULT -1	—
OUTLSAACKS	NUMBER(10)	DEFAULT -1	—
OUTLSAACKSLSA	NUMBER(10)	DEFAULT -1	—
CHECKSUMERRS	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.78  HFR_OSPF_V3_PM_Table

Primary key: HFR_PM_OSPF_V3_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-77 HFR_OSPF_V3_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 data refers.
PhysicalLoc	NUMBER(20)	DEFAULT 0	Physical location.
NEIfIndex	NUMBER(20)	NOT NULL	Table index for the interface; same as IfStaticIndex in the Interface_Table.
OSPFV3TimeStamp	DATE	NOT NULL	Time stamp showing the interval for which the set of statistics is stored.
NEIfPMStatus	NUMBER(20)	NOT NULL	Status of the PM interval. Valid values are: •0: Valid period •Other: Bit mask value (information about the PM statistics)
inMaintenance	NUMBER(1)	—	Whether NE was under maintenance 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 during the 24-hour interval.
IS24H	NUMBER(1)	NOT NULL	Whether the PM data is for 24-hour or 15-minute intervals. Valid values are: •1: 24 hours •0: 15 minutes
INSTANCENAME	VARCHAR2(64)	NOT NULL	Instance name.
INPACKETS	NUMBER(10)	DEFAULT -1	—
OUTPACKETS	NUMBER(10)	DEFAULT -1	—
INHELLO	NUMBER(100	DEFAULT -1	—
OUTHELLO	NUMBER(10)	DEFAULT -1	—
INDBDS	NUMBER(10)	DEFAULT -1	—
INDBDSLSA	NUMBER(10)	DEFAULT -1	—
OUTDBDS	NUMBER(10)	DEFAULT -1	—
OUTDBDSLSA	NUMBER(10)	DEFAULT -1	—
INLSREQUESTS	NUMBER(10)	DEFAULT -1	—
INLSREQUESTSLSA	NUMBER(10)	DEFAULT -1	—
OUTLSREQUESTS	NUMBER(10)	DEFAULT -1	—
OUTLSREQUESTSLSA	NUMBER(10)	DEFAULT -1	—
INLSAUPDATES	NUMBER(10)	DEFAULT -1	—
INLSAUPDATESLSA	NUMBER(10)	DEFAULT -1	—
OUTLSAUPDATES	NUMBER(10)	DEFAULT -1	—
OUTLSAUPDATESLSA	NUMBER(10)	DEFAULT -1	—
INLSAACKS	NUMBER(10)	DEFAULT -1	—
INLSAACKSLSA	NUMBER(10)	DEFAULT -1	—
OUTLSAACKS	NUMBER(10)	DEFAULT -1	—
OUTLSAACKSLSA	NUMBER(10)	DEFAULT -1	—
CHECKSUMERRS	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.79  HFR_POS_Interface_Config

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

Primary key: HFR_POS_INTF_CFG_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-78 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)	—