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_BUNDLE_MEMBER

1.2.63  HFR_BGP_PEER_PM_Table

1.2.64  HFR_Common_Interface_Config

1.2.65  HFR_ETHER_Interface_Config

1.2.66  HFR_Interface_BUNDLE

1.2.67  HFR_Interface_DRC_PM_Table

1.2.68  HFR_Interface_GC_PM_Table

1.2.69  HFR_Interface_Helper_Address

1.2.70  HFR_Interface_MTU_Layer2

1.2.71  HFR_Interface_Secondary_Addr

1.2.72  HFR_LACP

1.2.73  HFR_MPLS_Interface_PM_Table

1.2.74  HFR_MPLS_LDP_PM_Table

1.2.75  HFR_MPLS_TE_Link_PM_Table

1.2.76  HFR_MPLS_TE_Tunnel_PM_Table

1.2.77  HFR_Node_CPU_PM_Table

1.2.78  HFR_Node_Memory_PM_Table

1.2.79  HFR_Node_Process_PM_Table

1.2.80  HFR_OSPF_V2_PM_Table

1.2.81  HFR_OSPF_V3_PM_Table

1.2.82  HFR_POS_Interface_Config

1.2.83  HFR_SONET_Interface_Config

1.2.84  HFR_SONET_Interface_Path

1.2.85  HFR_Version_Info

1.2.86  HFR_VRF

1.2.87  HFR_VRF_AF

1.2.88  HFR_VRF_EXPORT_AF

1.2.89  HFR_VRF_IMPORT_AF

1.2.90  IF_Cross_Connect

1.2.91  IF_DWDM_Channel_Group

1.2.92  IF_Optical_Phy_Config_Table

1.2.93  IFIndex_Rule_Table

1.2.94  Interface_APS_Info

1.2.95  Interface_DWDM_Frequency

1.2.96  Interface_Stack_Table

1.2.97  Interface_Table

1.2.98  IOS_Parser_Static_Tree_Table

1.2.99  IOX_CONFIG_SYNC_TABLE (Incremental Configuration Discovery Feature)

1.2.100  L2_FrontPort_Table

1.2.101  L2_Interface_QoSClass_Table

1.2.102  L2_Interface_Table

1.2.103  L2_Ipsla_Table

1.2.104  L2QoSTemplate_QoSClass_Table

1.2.105  L2QoSTemplate_Table

1.2.106  L2Topology_Circuits_Table

1.2.107  L2Topology_Table

1.2.108  L2_Vlan_Table

1.2.109  Link_Table

1.2.110  Managed_Et_Table

1.2.111  Map_Coordinate_Table

1.2.112  Map_Cust_Table

1.2.113  Map_Image_Table

1.2.114  Map_Link_Table

1.2.115  MIB2_Interface_Table

1.2.116  Model_Type_Table

1.2.117  Module155xx_Community_String

1.2.118  Module155xx_VTOID_Table

1.2.119  Module_Type_Mll_Info

1.2.120  Module_Type_Table

1.2.121  NE_Audit_Trail_Table

1.2.122  NE_Info_Table

1.2.123  NE_Inventory_Table

1.2.124  NE_Model_State_Table

1.2.125  NE_Model_Type_Table

1.2.126  NE_Module_Level_Debug

1.2.127  NE_Port_Status_Table

1.2.128  NE_Swimage_Table

1.2.129  Network_Partition_Table

1.2.130  ObjectAttributeTable

1.2.131  Object_Relationship_Table

1.2.132  ObjectTypeTable

1.2.133  ONS15216_Active_User_Table

1.2.134  ONS15216_NE_Inventory_Table

1.2.135  ONS15216_Privilege_Table

1.2.136  ONS15216_User_Table

1.2.137  ONS1530x_HO_PM_Table

1.2.138  ONS1530x_IP_PM_Table

1.2.139  ONS1530x_LO_PM_Table

1.2.140  ONS1530x_MS_PM_Table

1.2.141  ONS1530x_NE_Inventory_Table

1.2.142  ONS1530x_RS_PM_Table

1.2.143  ONS15454_327_NE_Table

1.2.144  ONS15454_8B10B_PM_Table

1.2.145  ONS15454_Active_User_Table

1.2.146  ONS15454_CBQoS_Info_Table

1.2.147  ONS15454_CLASSMAP_PM_Table

1.2.148  ONS15454_CMS_Storage_Table

1.2.149  ONS15454_COS_PM_Table

1.2.150  ONS15454_DS1_PM_Table

1.2.151  ONS15454_DS3_PM_Table

1.2.152  ONS15454_ENET_PM_Table

1.2.153  ONS15454_FC_PM_Table

1.2.154  ONS15454_GFP_PM_Table

1.2.155  ONS15454_IFX_PM_Table

1.2.156  ONS15454_Match_STMT_PM_Table

1.2.157  ONS15454_NE_Inventory_Table

1.2.158  ONS15454_OTN_Fec_PM_Table

1.2.159  ONS15454_OTN_Path_PM_Table

1.2.160  ONS15454_OTN_Sec_PM_Table

1.2.161  ONS15454_PHY_LAYER_PM_Table

1.2.162  ONS15454_Police_PM_Table

1.2.163  ONS15454_POS_PM_Table

1.2.164  ONS15454_Privilege_Table

1.2.165  ONS15454_SONET_Line_PM_Table

1.2.166  ONS15454_SONET_Path_PM_Table

1.2.167  ONS15454_SONET_Sec_PM_Table

1.2.168  ONS15454_SONET_VT_PM_Table

1.2.169  ONS15454_User_Table

1.2.170  ONS15454SDH_E1_PM_Table

1.2.171  ONS15454SDH_E3_PM_Table

1.2.172  ONS15454SDH_E4_PM_Table

1.2.173  ONS15454SDH_HO_PM_Table

1.2.174  ONS15454SDH_LO_PM_Table

1.2.175  ONS15454SDH_MS_PM_Table

1.2.176  ONS15454SDH_RS_PM_Table

1.2.177  ONS15501_NE_Explorer_Table

1.2.178  ONS15501_Opt_Power_PM_Table

1.2.179  ONS155xx_CDL_Flow_Config

1.2.180  ONS155xx_CDL_IF_Config

1.2.181  ONS155xx_CDL_PM_Table

1.2.182  ONS155xx_Circuit_CC_Tbl

1.2.183  ONS155xx_Circuit_Path_Tbl

1.2.184  ONS155xx_Circuit_Stack_Tbl

1.2.185  ONS155xx_Condtype_Map

1.2.186  ONS155xx_DCRP_Definition_Table

1.2.187  ONS155xx_DCRP_Table

1.2.188  ONS155xx_Discovery_Info_Table

1.2.189  ONS155xx_Ether_Hist_PM_Table

1.2.190  ONS155xx_FCM_PE_PM_Table

1.2.191  ONS155xx_Flash_Device_Table

1.2.192  ONS155xx_Flash_Partition_Table

1.2.193  ONS155xx_GRA_CC_TO_CKT_CC_Tbl

1.2.194  ONS155xx_Granular_CC_Tbl

1.2.195  ONS155xx_IF_Circuit_Params_Tbl

1.2.196  ONS155xx_IF_Optical_Power

1.2.197  ONS155xx_IF_Phy_Info_Table

1.2.198  ONS155xx_NE_Info_Table

1.2.199  ONS155xx_NE_Type_Table

1.2.200  ONS155xx_Opt_Power_PM_Table

1.2.201  ONS155xx_Path_Hop_Tbl

1.2.202  ONS155xx_Path_Tbl

1.2.203  ONS155xx_Phy_PM_Table

1.2.204  ONS155xx_SONET_Sec_PM_Table

1.2.205  ONS15600_ENET_PM_Table

1.2.206  ONS15600_POS_PM_Table

1.2.207  ONS15600_Sonet_Line_PM_Table

1.2.208  ONS15600_Sonet_Path_PM_Table

1.2.209  ONS15600_Sonet_Sec_PM_Table

1.2.210  ONS15600SDH_HO_PM_Table

1.2.211  ONS15600SDH_MS_PM_Table

1.2.212  ONS15600SDH_RS_PM_Table

1.2.213  ONS158xx_Amplifier_PM_Table

1.2.214  ONS158xx_BCS_PM_Table

1.2.215  ONS158xx_CMP_PM_Table

1.2.216  ONS158xx_IOC_W_PM_Table

1.2.217  ONS158xx_LAC_Active_User_Table

1.2.218  ONS158xx_LAC_Log_Status_Table

1.2.219  ONS158xx_LAC_Log_Table

1.2.220  ONS158xx_LAC_Profile_Table

1.2.221  ONS158xx_LAC_User_Table

1.2.222  ONS158xx_LSM_PM_Table

1.2.223  ONS158xx_NE_IP_Table

1.2.224  ONS158xx_OAD_PM_Table

1.2.225  ONS158xx_OADM_PM_Table

1.2.226  ONS158xx_OSU_PM_Table

1.2.227  ONS158xx_OTS_PTP_Table

1.2.228  ONS158xx_PM_ACT_MOD_Table

1.2.229  ONS158xx_PTPType_Table

1.2.230  ONS158xx_SCF_PM_Table

1.2.231  ONS158xx_TimeStamp_PM_Table

1.2.232  ONS158xx_Transponder_PM_Table

1.2.233  ONS158xx_WD_PM_Table

1.2.234  ONS158xx_WD_RX_PM_Table

1.2.235  Operation_Permissions_Table

1.2.236  Operations_Table

1.2.237  OSS_Active_User_Table

1.2.238  OSS_AID_ENUM_Table

1.2.239  OSS_Alarm_Filter_Table

1.2.240  OSS_Alarm_Fltr_AID_Deny_Tbl

1.2.241  OSS_Alarm_Fltr_TID_Deny_Tbl

1.2.242  OSS_CORBA_User_Table

1.2.243  OSS_User_Table

1.2.244  Password_History_Table

1.2.245  PatchCord_Table

1.2.246  PM_ATTR_Value_Mapping_Table

1.2.247  PM_ATTRID_Mapping_Table

1.2.248  PM_Cerent_Info_Table

1.2.249  PM_Historical_Appointments

1.2.250  PM_Metadata_Info_Table

1.2.251  PM_Metadata_Table

1.2.252  Proxy_Server_Table

1.2.253  Purged_NE_Table

1.2.254  QOS_CLASS_MAP

1.2.255  QOS_MATCH_ACCESS_GROUP

1.2.256  QOS_MATCH_PROTOCOL

1.2.257  QOS_POLICY_MAP

1.2.258  QOS_RANDOM_DETECT_DISCARD

1.2.259  QOS_RANDOM_DETECT_DSCP

1.2.260  QOS_RANDOM_DETECT_MPLS_EXP

1.2.261  QOS_RANDOM_DETECT_PRECEDENCE

1.2.262  QOS_SERVICE_POLICY

1.2.263  Roll_Table

1.2.264  ROUTER_AS_PATH_ACCESS_LIST

1.2.265  ROUTER_EXT_COMMUNITY_LIST

1.2.266  ROUTER_IEP

1.2.267  ROUTER_IEP_PATH_DETAIL

1.2.268  Router_Link_Table

1.2.269  ROUTER_PACKETFILTER

1.2.270  ROUTER_PREFIX_LIST

1.2.271  ROUTER_STD_COMMUNITY_LIST

1.2.272  ROUTER_USER_SETTINGS

1.2.273  Schedule_Info_Table

1.2.274  Server_Monitor_Table

1.2.275  Server_Parameter_Table

1.2.276  Subnetwork_Table

1.2.277  SVC_Config_Table

1.2.278  SVC_Info_Table

1.2.279  SVC_NEModel_Table

1.2.280  SVC_Package_Table

1.2.281  SVC_Property_Table

1.2.282  Sway_User_Port_Table

1.2.283  Table_Info

1.2.284  TCA_Event_Table

1.2.285  TCA_Event_Type_Table

1.2.286  Threshold_Table

1.2.287  Transaction_Log_Table

1.2.288  Unmanaged_NE_Inventory_Table

1.2.289  User_Map_Table

1.2.290  User_NE_Table

1.2.291  User_Preference_Table

1.2.292  CTM_Unknown_User_Table

1.2.293  User_Table

1.2.294  User_Type_Table

1.2.295  Version_Table

1.2.296  Wavemux_NE

1.2.297  XML_Parser_Static_Tree_Table

1.3  CTM Tables (MGX Voice Gateway)

1.3.1  AAL1_CROSS_CONN

1.3.2  AAL1_DATA_PROFILE

1.3.3  AAL2_CROSS_CONN

1.3.4  AAL2_5_DATA_PROFILE

1.3.5  AAL5_CROSS_CONN

1.3.6  ADDR_CUG

1.3.7  APS

1.3.8  ATM_ADDR

1.3.9  ATM_CONNECTION

1.3.10  ATM_PHY

1.3.11  AUSM_PORT

1.3.12  AUSM_PORT_DATA

1.3.13  AU4TUG3

1.3.14  AXIST3_LINE_DATA

1.3.15  AXSM_CONN_DATA

1.3.16  AXSME_CONN_DATA

1.3.17  CALL_CONTROL_PROFILE

1.3.18  CARD_DESC

1.3.19  COLL_ERR_LOG

1.3.20  COLL_INFO

1.3.21  COLL_SUMM_LIST

1.3.22  COLLSVR_ERR_LOG

1.3.23  COLLSVR_INFO

1.3.24  COLLSVR_ROLE

1.3.25  COMP_FILE_LIST

1.3.26  Connection

1.3.27  CONN_TEMPL_PARAM

1.3.28  CONN_TEMPLATE

1.3.29  CONN_ROUTE_STATISTICS

1.3.30  CONTROLLER

1.3.31  CORBA_DISCONNECT

1.3.32  CUG

1.3.33  CURRENT_ROUTE_ELEM

1.3.34  CWM_ROLE_INFO

1.3.35  DBKR_TEMP

1.3.36  DC_Lookup_Field

1.3.37  DC_Lookup_Table

1.3.38  DC_VXSM_RSCUTIL

1.3.39  DESTROYNODE

1.3.40  DS1_AU4_PATH_DATA

1.3.41  DS1_AU3_PATH_DATA

1.3.42  DS1_DS3_AU3_PATH_DATA

1.3.43  DS1_DS3_AU3_PIF_DATA

1.3.44  DS1_DS3_STS1_IMA_LINK_DATA

1.3.45  DS1_DS3_STS1_PATH_DATA

1.3.46  DS1_DS3_STS1_PIF_DATA

1.3.47  DS1_DS3LINE_IMA_LINK_DATA

1.3.48  DS1_DS3LINE_PATH_DATA

1.3.49  DS1_DS3LINE_PIF_DATA

1.3.50  DS1_T3LINE_PATH_DATA

1.3.51  DS1_TU11_AU3_PATH_DATA

1.3.52  DS1_TU11_AU3_PIF_DATA

1.3.53  DS1_TU11_AU4_PATH_DATA

1.3.54  DS1_TU11_AU4_PIF_DATA

1.3.55  DS1_VT_STS1_PATH_DATA

1.3.56  DS1_VT_STS1_PIF_DATA

1.3.57  DS1_TU11_AU4_IMA_LINK_DATA

1.3.58  DS1_TU11_AU3_IMA_LINK_DATA

1.3.59  DS1_VT_STS1_IMA_LINK_DATA

1.3.60  DS1LINE_PIF_DATA

1.3.61  DS3_AU3_PATH_DATA

1.3.62  DS3_AU3_PIF_DATA

1.3.63  DS3_AU4_PATH_DATA

1.3.64  DS3_AU4_PIF_DATA

1.3.65  DS3_STS1_PATH_DATA

1.3.66  DS3_STS1_PF_DATA

1.3.67  DS3LINE_PIF_DATA

1.3.68  DS0_CONNECT

1.3.69  DSP_STATUS

1.3.70  E1_AU4_PATH_DATA

1.3.71  E1_AU3_PATH_DATA

1.3.72  E1_TU12_AU3_PIF_DATA

1.3.73  E1_TU12_AU4_PATH_DATA

1.3.74  E1_TU12_AU4_PIF_DATA

1.3.75  E1_TU12_AU4_IMA_LINK_DATA

1.3.76  E1_TU12_AU3_IMA_LINK_DATA

1.3.77  E1_TU12_AU3_PATH_DATA

1.3.78  E1_VT_STS1_IMA_LINK_DATA

1.3.79  E1LINE_PIF_DATA

1.3.80  E1_VT_STS1_PIF_DATA

1.3.81  E1_VT_STS1_PATH_DATA

1.3.82  E3_AU3_PATH_DATA

1.3.83  E3_AU3_PIF_DATA

1.3.84  E3_AU4_PATH_DATA

1.3.85  E3_AU4_PIF_DATA

1.3.86  E3_STS1_PATH_DATA

1.3.87  E3_STS1_PIF_DATA

1.3.88  ELEMENT_TEMPLATE

1.3.89  ELEMENT_TEMPL_PARAM

1.3.90  Fax_Relay

1.3.91  FILE_ERR_LOG

1.3.92  FILE_INFO

1.3.93  FILE_QUEUE_LOG

1.3.94  FILE_TRANSFER_LOG

1.3.95  FRP

1.3.96  IF_SHUTDOWN

1.3.97  IMA_GROUP

1.3.98  IMA_GROUP_DESC

1.3.99  IMA_LINK

1.3.100  IMA_LINK_DESC

1.3.101  LAPD_DS1_AU4_DATA

1.3.102  LAPD_E1_AU4_DATA

1.3.103  LAPD_DS1_AU3_DATA

1.3.104  LAPD_E1_AU3_DATA

1.3.105  LAPD_DS1_VT_DATA

1.3.106  LAPD_DS1_DS3_DATA

1.3.107  LAPD_T1E1_DATA

1.3.108  LAPD_T3E3_DATA

1.3.109  LAPD_TRUNK

1.3.110  LICENSE_IN_USE

1.3.111  LICENSE_POOL

1.3.112  LIF

1.3.113  LINE_DESC

1.3.114  LINEDISTRIBUTION

1.3.115  LINEDISTRIBUTION_DESC

1.3.116  LOOKUP_FIELD

1.3.117  Lookup_Table

1.3.118  MaintLog

1.3.119  MEGACO_CONFIG

1.3.120  MEGACO_DATA

1.3.121  MEGACO_EPH_TERM_DATA

1.3.122  MEGACO_PHY_TERM_DATA

1.3.123  MEGACO_PROFILE

1.3.124  MEGACO_TERM

1.3.125  MG_DNAME

1.3.126  MGC_GRP

1.3.127  MGC_IP

1.3.128  MGC_RES

1.3.129  MGCG_PARAM

1.3.130  MGCG_PROTOCOL

1.3.131  MG_SUP_PRTCL

1.3.132  MPBUNDLE

1.3.133  MGX8880_NE_INFO_TABLE

1.3.134  NETWORK

1.3.135  NETWORK_DESC

1.3.136  NHM_MANAGEABILITY

1.3.137  NHM_STATS

1.3.138  IMAGROUP_PIF_DATA

1.3.139  NODE_DESC

1.3.140  Node_Parent

1.3.141  NODE_THRESH

1.3.142  NODE_GROOM

1.3.143  PATH_DESC

1.3.144  PEND_FILE_LIST

1.3.145  PLCP

1.3.146  PNNI_IF

1.3.147  PNNI_NODAL_DATA

1.3.148  PNNI_PORT_DATA

1.3.149  PORT_DESC

1.3.150  PORT_QUEST

1.3.151  PPP_LINK

1.3.152  PROGRAM_TONE

1.3.153  PXM1E_CONN_DATA

1.3.154  PXM1E_LINE_DATA

1.3.155  PXM1E_PORT_DATA

1.3.156  PXM1ET1E1_PL_DATA

1.3.157  PXM1ET3_PL_DATA

1.3.158  PXM1EE3_PL_DATA

1.3.159  PXM1ESONET_PL_DATA

1.3.160  REDUNDANTCARD

1.3.161  RPM_CONNECTION

1.3.162  RPM_PORT

1.3.163  RSC_PART

1.3.164  RSC_POLICY

1.3.165  RTP_CONN

1.3.166  RUDP_SESSION

1.3.167  SCMCARDCOLLSTATUS

1.3.168  SCMDB_NODE_INFO

1.3.169  SCMNODECOLLSTATUS

1.3.170  SCTP_ADDR

1.3.171  SCTP_ASSOC

1.3.172  SCTP_ASSOCIATION_DATA

1.3.173  SCTP_GATEWAY_DATA

1.3.174  SENSOR_THRHD

1.3.175  SESSION_DATA

1.3.176  SESSION_GROUP

1.3.177  SESSION_SET

1.3.178  SHELF

1.3.179  SONET_LINE_DATA

1.3.180  SRCP_PARAM

1.3.181  SRCP_PEER

1.3.182  SRTFILTERLIST

1.3.183  SRTREPORTKEY

1.3.184  STAT_ENABLE

1.3.185  STATSDB_INFO

1.3.186  STATSDB_SCMCOLLSVR

1.3.187  STM1_PATH_DATA

1.3.188  STM1_PIF_DATA

1.3.189  STS1_PATH_DATA

1.3.190  STS1_PIF_DATA

1.3.191  STSDS3DS1PATH_DATA

1.3.192  STSVTGDS1PATH_DATA

1.3.193  SVC_CAC

1.3.194  SVC_OPERATION

1.3.195  SVC_PORT

1.3.196  SYNC_INFO

1.3.197  SYNC_LIST

1.3.198  TONE_DETECT

1.3.199  TONE_ID

1.3.200  TONE_PLAN

1.3.201  TRAP_FILTER

1.3.202  TU3_AU4_PATH_DATA

1.3.203  TU11_AU3_PATH_DATA

1.3.204  TU11_AU4_PATH_DATA

1.3.205  USER_CONNECTION

1.3.206  USER_CONN_DESC

1.3.207  User_info

1.3.208  VIRTUAL_PORT

1.3.209  VISM_ANNOUNCE

1.3.210  VISM_CARD

1.3.211  VISM_CAS_BIT

1.3.212  VISM_CID

1.3.213  VISM_CID_DATA

1.3.214  VISM_CODEC

1.3.215  VISM_CONN_DATA

1.3.216  VISM_DS0

1.3.217  VISM_E1_LINE_DATA

1.3.218  VISM_ENDPT

1.3.219  VISM_HDLC

1.3.220  VISM_LAPD

1.3.221  VISM_LINE

1.3.222  VISM_MGC

1.3.223  VISM_MGCP

1.3.224  VISM_PROFILE

1.3.225  VISM_T1_LINE_DATA

1.3.226  VISM_TEMPLATE

1.3.227  VOICE_CONN

1.3.228  VT_STS1_PATH_DATA

1.3.229  VXSM_AS

1.3.230  VXSM_ASP

1.3.231  VXSM_ASP_IP

1.3.232  VXSM_BPVC_BW_DATA

1.3.233  VXSM_CARD

1.3.234  VXSM_CAS_PROFILE

1.3.235  VXSM_CAS_VARIANT

1.3.236  VXSM_CODEC_DATA

1.3.237  VXSM_DPNSS

1.3.238  VXSM_DPNSS_DLC

1.3.239  VXSM_DPNSS_E1_LINE_DATA

1.3.240  VXSM_DPNSS_E1_STS_DATA

1.3.241  VXSM_DPNSS_E1_AU3_DATA

1.3.242  VXSM_DPNSS_E1_AU4_DATA

1.3.243  VXSM_DPNSS_DLC_E1_LINE_DATA

1.3.244  VXSM_DPNSS_DLC_E1_STS_DATA

1.3.245  VXSM_DPNSS_DLC_E1_AU3_DATA

1.3.246  VXSM_DPNSS_DLC_E1_AU4_DATA

1.3.247  VXSM_DS0_UTIL_GW_DATA

1.3.248  VXSM_DS0_UTIL_VGW_DATA

1.3.249  VXSM_DS0_UTIL_DS1_LN_DATA

1.3.250  VXSM_DS0_UTIL_E1_LN_DATA

1.3.251  VXSM_DS0_UTIL_T3_LN_DATA

1.3.252  VXSM_DS0_UTIL_OC3_LN_DATA

1.3.253  VXSM_DS0_UTIL_STM1_LN_DATA

1.3.254  VXSM_DS0_UTIL_DS1_T3_DATA

1.3.255  VXSM_DS0_UTIL_DS1_STS_DATA

1.3.256  VXSM_DS0_UTIL_DS1_DS3_STS_DATA

1.3.257  VXSM_DS0_UTIL_DS1_AU3_DATA

1.3.258  VXSM_DS0_UTIL_DS1_AU4_DATA

1.3.259  VXSM_DS0_UTIL_E1_STS_DATA

1.3.260  VXSM_DS0_UTIL_E1_AU3_DATA

1.3.261  VXSM_DS0_UTIL_E1_AU4_DATA

1.3.262  VXSM_EPH_TERM_GW_DATA

1.3.263  VXSM_EPH_TERM_VGW_DATA

1.3.264  VXSM_EPH_TERM_BPVC_DATA

1.3.265  VXSM_EVENT_MAP

1.3.266  VXSM_FAX_RELAY

1.3.267  VXSM_GENERAL_CONFIG

1.3.268  VXSM_GSP_INST

1.3.269  VXSM_GSP_LINK

1.3.270  VXSM_GSP_LINK_SET

1.3.271  VXSM_GSP_LINK_TIMER

1.3.272  VXSM_GSP_POINT_CODE

1.3.273  VXSM_GSP_PROF_TIMER

1.3.274  VXSM_GSP_ROUTE

1.3.275  VXSM_GRT_ROUTE

1.3.276  VXSM_GTT_APP_GROUP

1.3.277  VXSM_GTT_GTA

1.3.278  VXSM_GTT_MAP

1.3.279  VXSM_GTT_PREF

1.3.280  VXSM_GTT_SEL

1.3.281  VXSM_IKE_PEER_AUTH

1.3.282  VXSM_IKE_TUNNEL

1.3.283  VXSM_IN_LINE_SIGNAL

1.3.284  VXSM_IPSEC_TUNNEL

1.3.285  VXSM_L3UA_ASP_DATA

1.3.286  VXSM_LINE_SIGNAL_TIMER

1.3.287  VXSM_MTP_LINKSLC_DATA

1.3.288  VXSM_NETWORK_INTERFACE

1.3.289  VXSM_OUT_LINE_SIGNAL

1.3.290  VXSM_OVER_LOAD_RSR_DATA

1.3.291  VXSM_PH1_PTRF_ASSOC

1.3.292  VXSM_PH2_PTRF_ASSOC

1.3.293  VXSM_PHASE1_PROPOSAL

1.3.294  VXSM_PHASE1_TRANSFORM

1.3.295  VXSM_PHASE2_PROPOSAL

1.3.296  VXSM_PHASE2_TRANSFORM

1.3.297  VXSM_PHY_GW_DATA

1.3.298  VXSM_PLFM_SYS_DATA

1.3.299  VXSM_PLFM_SCALAR_DATA

1.3.300  VXSM_PLFM_GW_RSC_DATA

1.3.301  VXSM_PVC_IP

1.3.302  VXSM_RTCP_ALERT_TRIGGER

1.3.303  VXSM_RTCP_CIPHERSUITE

1.3.304  VXSM_RTCP_PROFILE

1.3.305  VXSM_RTP_CIPHERSUITE

1.3.306  VXSM_SCCP_DATA

1.3.307  VXSM_SCTP_CONFIG

1.3.308  VXSM_SECURITY_POLICY

1.3.309  VXSM_SPD_KEY_MGR_ASSOC

1.3.310  VXSM_TTY_PROFILE

1.3.311  VXSM_VBD_CALL_DATA

1.3.312  VXSM_VDB_PROFILE

1.3.313  VXSM_VIF

1.3.314  VXSM_VQM_GW_DATA

1.3.315  VXSM_VQM_VGW_DATA

1.3.316  VXSM_VQM_BPVC_DATA

1.3.317  VXSM_VQM_DS1_LN_DATA

1.3.318  VXSM_VQM_E1_LN_DATA

1.3.319  VXSM_VQM_T3_LN_DATA

1.3.320  VXSM_VQM_OC3_LN_DATA

1.3.321  VXSM_VQM_STM1_LN_DATA

1.3.322  VXSM_VQM_STS_DATA

1.3.323  VXSM_VQM_AU3_DATA

1.3.324  VXSM_VQM_AU4_DATA

1.3.325  VXSM_VQM_DS1_T3_DATA

1.3.326  VXSM_VQM_DS1_STS_DATA

1.3.327  VXSM_VQM_DS1_DS3_STS_DATA

1.3.328  VXSM_VQM_DS1_AU3_DATA

1.3.329  VXSM_VQM_DS1_AU4_DATA

1.3.330  VXSM_VQM_E1_STS_DATA

1.3.331  VXSM_VQM_E1_AU3_DATA

1.3.332  VXSM_VQM_E1_AU4_DATA

1.3.333  VXSM_XUA_AS

1.3.334  VXSM_XUA_AS_ROUTE

1.3.335  VXSM_XUA_AS_ROUTE_AS

1.3.336  VXSM_XUA_ASP

1.3.337  VXSM_XUA_ASP_AS

1.3.338  VXSM_XUA_INST

1.3.339  VXSM_XUA_LOCAL_IP

1.3.340  VXSM_XUA_QOS

1.3.341  VXSM_XUA_REMOTE_IP

1.3.342  XG_CONN_DATA

1.3.343  XG_DS3PATH_DATA

1.3.344  XG_PATH_DATA

1.3.345  XG_PL_DATA

1.3.346  XG_PORT_DATA

1.3.347  XGCP_DATA

1.3.348  XGCP_GW

1.3.349  XGCP_MGC

1.3.350  XGCP_PEER

1.4  NE Statistics-Related Tables

1.4.1  AXSM_CARD_DATA

1.4.2  AXSM_CONN_DATA

1.4.3  AXSM_LINE_DATA

1.4.4  AXSM_PORT_DATA

1.4.5  AXSME_CONN_DATA

1.4.6  AXSME_LINE_DATA

1.4.7  AXSME_PORT_DATA

1.4.8  AXSMESONET_PL_DATA

1.4.9  AXSMET1E1_PL_DATA

1.4.10  AXSMET3E3_PL_DATA

1.4.11  IMA_GROUP_DATA

1.4.12  IMA_LINK_DATA

1.4.13  LAPD_IN_DS1INDS3_DATA

1.4.14  LAPD_IN_DS1INVT_DATA

1.4.15  LAPDIN_T1E1_DATA

1.4.16  LAPD_IN_T3E3_DATA

1.4.17  MEGACO_DATA

1.4.18  MEGACO_EPH_TERM_DATA

1.4.19  MEGACO_PHY_TERM_DATA

1.4.20  SCMCARD

1.4.21  SCMCARDCOLL

1.4.22  SCMCARDCOLLHOST

1.4.23  SCMCARDENABLE

1.4.24  SCMCARDFAMILY

1.4.25  SCMCARDFAMILYDEF

1.4.26  SCMCARDFAMILYSTAT

1.4.27  SCMCARDTEMPLATE

1.4.28  SCMCOLLSVR

1.4.29  SCMCOLPAR

1.4.30  SCMCOLPARSTAT

1.4.31  SCMCOLPARSUBOBJ

1.4.32  SCMENABLETYPE

1.4.33  SCMIDMAP

1.4.34  SCMNODECOLL

1.4.35  SCMNODECOLLHOST

1.4.36  SCMNODEENABLE

1.4.37  SCMNODESTAT

1.4.38  SCMNODETEMPLATE

1.4.39  SCMOBJ

1.4.40  SCMSTAT

1.4.41  SCMSTATSKEY

1.4.42  SCMSUBOBJ

1.4.43  SCMDB_SCMCOLLSVR

1.4.44  SCMENABLELIST

1.4.45  SCMENABLESUBTYPE

1.4.46  SCMFRAGDATATABLES

1.4.47  SCMIDMAPDEF

1.4.48  SCMNODESTAT

1.4.49  SCMNODE

1.4.50  SCMOLDSTATKEY

1.4.51  SCMSTATKEY

1.4.52  SCMTABLEKEY

1.4.53  SCTP_ASSOCIATION_DATA

1.4.54  SCTP_GATEWAY_DATA

1.4.55  SESSION_DATA

1.4.56  SONET_LINE_DATA

1.4.57  SRTPERFKEY

1.4.58  SRTRPORTKEY

1.4.59  STATSDB_CONFIG

1.4.60  STS_DS3_DS1_PATH_DATA

1.4.61  STS_VTGROUP_DS1_PATH_DATA

1.4.62  XG_CONN_DATA

1.4.63  XGCP_DATA

1.4.64  XG_DS3PATH_DATA

1.4.65  XG_PATH_DATA

1.4.66  XG_PL_DATA

1.4.67  XG_PORT_DATA

Database Schema Tables

---

This chapter describes tables and table sequence numbers. It contains the following sections:

•CTM Sequence Numbers

•CTM Tables (Non-MGX Voice Gateway)

•CTM Tables (MGX Voice Gateway)

•NE Statistics-Related Tables

1.1  CTM Sequence Numbers

Sequence numbers are Oracle integers of up to 38 digits that are defined in the database. A sequence generates a serial list of unique numbers for numeric columns in a database's tables. Sequences simplify application programming by automatically generating unique numerical values for the rows in one or in multiple tables. The sequence numbers used in the CTM schema are listed in 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 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 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 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 Preprovisioned 4: Device Under Maintenance
isConnected	NUMBER(1)	NOT NULL	Values are: 0: Unreachable 1: Device is reachable from CTM server
DiscoveryState	NUMBER(1)	—	Device discovery state. 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 contains information about all administrative tasks and their status.

Primary key: ADMIN_JOB_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-5 Admin_Job_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
JobID	NUMBER(12)	NOT NULL	Unique job identifier.
TaskID	NUMBER(12)	NOT NULL	Unique identifier for the task within a job.
JobType	NUMBER(2)	NOT NULL	Type of job. Valid types are: 0: NE User Add 1: NE User Modify 2: NE User Delete 3: NE User Logout 4: NE User Conn Delete 5: NE User Enable Log 6: NE User Disable Log 7: NE User Delete Log 8: Image Activate 9: Image Revert 10: Image Download 11: Memory Auto Backup 12: Memory Backup 13: Memory Restore 14: Image Download and Activate 15: SNTP Setup Job 22: BLSR Exercise Ring Backup
JobOwner	VARCHAR2(64)	—	Owner of job.
NEDBAccessID	NUMBER(10)	—	NEDBAccessID of the NE for which the job was scheduled; same as NEDBAccessID in the NE_Info_Table.
JobStatus	NUMBER(1)	—	Status of the job. Values are: 0: Uninitialized 1: Queued 2: Running 3: Cancelled 4: Failed 5: Succeeded 6: Unknown 7: Waiting
CreationTime	DATE	—	Time stamp when the job was created.
ScheduledTime	DATE	—	Time stamp when the job was scheduled to run.
StartTime	DATE	—	Time stamp when the job was actually started.
EndTime	DATE	—	Time stamp when the job was completed.
AdditionalInfo	VARCHAR2(4000)	—	Any additional information.
UserComments	VARCHAR2(2048)	—	Any comments entered by the user.
operation_info	VARCHAR2(4000)	—	List of parameters specific to a job.
display_info	VARCHAR2(4000)	—	String that displays job-specific information according to specific criteria.

1.2.5  Alarm_Ack_Config_Table

The Alarm_Ack_Config_Table stores information about whether or not automatic alarm acknowledgement is enabled.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-6 Alarm_Ack_Config_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
ConfigAlarmAck	NUMBER(1)	NOT NULL	A global, C-style, Boolean variable that represents whether alarm acknowledgement is on for all alarms. Values are: 0: Off 1: On

1.2.6  Alarm_Count_Table

The Alarm_Count_Table stores the alarm count for each level of severity for every NE.

Primary key: ALARM_COUNT_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-7 Alarm_Count_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBAccessID	NUMBER(10)	NOT NULL	ID to access this table for an NE; same as NEDBAccessID in the NE_Info_Table.
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 statically maps alarm and event cause indexes to strings.

Primary key: ALARM_EVENT_CAUSE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-8 Alarm_Event_Cause_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
EnumIndex	NUMBER(4)	—	Index of alarm or event cause.
EnumString	VARCHAR2(64)	—	Alarm or event cause string for the EnumIndex.

1.2.8  Alarm_Event_Table

The Alarm_Event_Table contains information about all events reported by NEs.

Primary key: None

Tablespace: EVENT_DATA_TABLESPACE

Table 1-9 Alarm_Event_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBAccessID	NUMBER(10)	NOT NULL	ID to access this table for an NE; same as NEDBAccessID in the NE_Info_Table.
EventIndex	NUMBER(10)	NOT NULL	Index of alarm or event. Unique sequence number generated by the database.
ModuleOrIfIndex	NUMBER(20)	NOT NULL	Unique integer that identifies an interface in the NE; same as ifStaticIndex in the Interface_Table.
AlarmEventType	NUMBER(5)	NOT NULL	Type of alarm or event. The Alarm_Event_Type_ENUM_Table lists valid types. The range is from 1 to n.
AlarmEventTimeStamp	DATE	NOT NULL	Date and time when the alarm or event was generated.
AlarmEventCause	NUMBER(4)	NOT NULL	Cause of alarm or event. The Alarm_Event_Cause_Table lists valid types. The range is from 1 to n.
AlarmEventSeverity	NUMBER(1)	NOT NULL	Severity level of the alarm.
ServiceEffecting	NUMBER(1)	NOT NULL	Values: 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 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 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 contains information about audit log mapping.

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 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 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 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 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 within the node.
Vlan_Number	NUMBER(10)	NOT NULL	Unique number to identify the VLAN.
NEID	NUMBER(10)	NOT NULL	NE ID.
Slot_Number	NUMBER(3)	NOT NULL	Slot number.
Bridge_Group_Number	NUMBER(3)	NOT NULL	Bridge group number.
BRIDGE_PROTOCOL	VARCHAR2(30)	—	—

1.2.17  C_MetaData

The C_MetaData table defines overall graphical user interface (GUI) information about a given database table or view.

---

Note C_MetaData is the parent table; C_MetaData_Col, C_MetaData_Filter, and C_MetaData_NETypes are the children.

---

Primary key: C_METADATA_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-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 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 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 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 stores group information about ONS 15327 and ONS 15454. This information is used to lay out group attributes in NE Explorer property sheets.

Primary key: C_METADATA_GRP_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-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 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 stores metadata information about 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 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 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 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(4)	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 stores basic information about the circuit.

Primary key: CIRCUIT_BS_TBL_PK

Tablespace: BASE_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

Table 1-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 33: TWO_GIGABIT_ETHERNET 34: E1_CIRCUIT 35: T1 CIRCUIT 36: DVB_CIRCUIT 37: SDI_CIRCUIT 38: OCHCC_CIRCUIT 39: OCHTRAIL_TUNNEL_CIRCUIT
CktSize	NUMBER(2)	—	Size of circuit. 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.
CktAliasName	VARCHAR2(64)	—	Circuit alias name.

1.2.28  Circuit_Ctp_Tbl

The Circuit_Ctp_Tbl stores the circuit termination points.

Foreign key: FK_CIRCUIT_CTPNPID

Tablespace: BASE_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

Table 1-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 shows the end and drop points for network circuits.

Primary key: None

Foreign key: FK_CIRCUIT_DEST_NPID

Tablespace: BASE_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

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

1.2.30  Circuit_Size_Table

The Circuit_Size_Table 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 stores circuit span information. Each span consists of the span base information, span source circuit termination point, and span destination circuit termination point. The span base information is stored in the Circuit_Span_BS_Tbl. The span source circuit termination point is stored in the Circuit_CTP_Tbl and a reference to the CIRCUIT_CTP_TBL row (that is, database row ID) is stored in the Circuit_Span_BS_Tbl as CIRCUIT_SPAN_SRC_CTP_ACCESSID. Similarly, the span destination circuit termination point is stored in the Circuit_CTP_Tbl and a reference to the CIRCUIT_CTP_TBL row (database row ID) is stored in the Circuit_Span_BS_Tbl as CIRCUIT_SPAN_DEST_CTP_ACCESSID.

Foreign key: FK_CIRCUIT_SPAN_BS_NPID

Tablespace: BASE_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

Table 1-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 contains information about spans associated with circuits.

Primary key: None

Foreign key: FK_CIRCUIT_SPAN_NPID

Tablespace: BASE_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

Table 1-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 about the circuit span.
CktSpanCDLFlowID	NUMBER(3)	DEFAULT -1	Source converged data link (CDL) flow identifier; applies only to ONS 15501, ONS 15530, and ONS 15540 circuits. Valid range is 0 to 254.
CktSpanSrcPortName	VARCHAR2(64)	—	Span source port name of the circuit.
CktSpanDestPortName	VARCHAR2(64)	—	Span destination port name of the circuit.
NPID	NUMBER(10)	DEFAULT 0	Network partition ID.

1.2.33  Circuit_Tbl

The Circuit_Tbl shows circuit information about an entire network.

Primary key: CIRCUIT_TBL_PK

Foreign key: FK_CIRCUIT_NPID

Tablespace: BASE_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

Table 1-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 36: DVB_CIRCUIT 37: SDI_CIRCUIT 38: OCHCC_CIRCUIT 39: OCHTRAIL_TUNNEL_CIRCUIT
CktSize	NUMBER(2)	—	Size of the circuit. Values are: 0: VT 1.5 1: STS1 2: STS3C 3: STS6C 4: STS9C 5: STS12C 6: STS24C 7: STS48C 8: STS192C 9: STS768C 10: DWDM 2.5 G 11: DWDM 10 G 12: VC_11 13: VC_12 14: VC_3 15: VC_4
CktSize (continued)	NUMBER(2)	—	16: VC_4_2C 17: VC_4_3C 18: VC_4_4C 19: VC_4_8C 20: VC_4_16C 21: VC_4_64C 22: Fiber channel 1 23: Fiber channel 2 24: FICON 25: ESCON 26: SYSPLEX 27: Fast Ethernet 28: Gigabit Ethernet 29: 10-Gigabit Ethernet 30: VT_2 31: FDDI 32: Optical CHannel Network Connection (OCHNC) not equipped 33: OCHNC multirate 34: OCHNC 2.5G FEC 35: OCHNC 2.5G NOFEC 36: OCHNC 10G FEC 37: OCHNC 10G NOFEC 38: STM 1C 39: STM 4C 40: STM 16C 41: STM 64C 42: ISC compatible 43: ISC peer 44: SYSPLEX_TIMER_ETR 45: SYSPLEX_TIMER_CLO 46: TWO_GIGABIT_ETHERNET 47: E1 48: T1
CktDirection	NUMBER(1)	—	Type of traffic that the circuit carries. Values are: 0: Unidirectional 1: Bidirectional
CktIsMonitor	NUMBER(1)	—	Whether the circuit is a monitor circuit. Values are: 0: False 1: True
CktState	NUMBER(2)	—	State of the circuit. Values are: 0: Creating 1: Active 2: Deleting 3: Drop-pending 4: Incomplete 5: TL1 active 6: TL1 incomplete 7: Errored 8: Roll-pending 9. Sig-pending 10: Sig-failed 11: Conversion-pending 12: Not activated
CktEnhancedState	NUMBER(2)	—	Administrative state of the circuit. Values are: 0: IS 1: OOS 2: OOS_MT 3: OOS_AINS 4: CES_NOT_DEFINED 5: OOS_PARTIAL 6: OOS_MT_PARTIAL 7: OOS_AINS_PARTIAL 8: IS_PARTIAL 9: UNKNOWN_ADMIN_STATE
CktProtectiontype	NUMBER(2)	—	Circuit protection type. Values are: 0: BLSR2F 1: OnePlusOne 2: NotDefined 3: UnProt 4: BLSR4F 5: PCA2F 6: PCA4F 7: NotDefined1 8: Protected 9: BLSR 10: UPSR 11: PCA 12: Lost 13: Unknown 14: None 15: UPSRDRI
CktSrcNodeId	NUMBER(10)	—	Source node ID.
CktSrcModuleType	NUMBER(8)	—	Module type at source.
CktSrcIfIndex	NUMBER(20)	—	Static index of the interface at the source.
CktObjectType	NUMBER(10)	—	Source object type.
CktSrcPhysicalLoc	NUMBER(20)	—	Source node physical location.
CktModelType	NUMBER(4)	—	Source node model type.
CktSrcDropProt	NUMBER(1)	—	Whether the endpoint is protected. Values are: 0: False 1: True
CktSrcDropProtType	NUMBER(1)	—	Protection type for ONS 15540: 0: No protection 1: Unknown protection 2: Splitter protection 3: Y-cable or line-card protection 4: Trunk card protection
CktSecSrcNodeId	NUMBER(10)	—	Secondary source node ID.
CktSecSrcModuleType	NUMBER(8)	—	Module type at secondary source node.
CktSecSrcIfIndex	NUMBER(20)	—	Static index of the interface at the secondary source node.
CktSecSrcObjectType	NUMBER(10)	—	Secondary source object type.
CktSecSrcPhysicalLoc	NUMBER(20)	—	Secondary source node physical location.
CktSecSrcModelType	NUMBER(4)	—	Model type for the secondary source node.
CktSecSrcDropProt	NUMBER(1)	—	Whether the secondary endpoint is protected. Values are: 0: False 1: True
CktSecSrcDropProtType	NUMBER(1)	—	Protection type for ONS 15540: 0: No protection 1: Unknown protection 2: Splitter protection 3: Y-cable or line-card protection 4: Trunk card protection
CktAdditionalInfo	VARCHAR2(64)	—	Additional information about the circuits.
CktDesNodeName	VARCHAR2(4000)	—	Node name of the circuit destination.
CktDestModuleName	VARCHAR2(4000)	—	Module name of the circuit destination.
CktDestPhysicalLoc	VARCHAR2(4000)	—	Physical location of the circuit destination.
CktDestModelType	VARCHAR2(4000)	—	Model type of the circuit destination.
CktDestIfIndex	VARCHAR2(4000)	—	Circuit destination node ifindex.
CktDestObjectType	VARCHAR2(4000)	—	Object type.
CktComment	VARCHAR2(2014)	—	Circuit comment.
CktSrcPortName	VARCHAR2(64)	—	Port name of the circuit source.
CktSecSrcPortName	VARCHAR2(64)	—	Port name of the circuit secondary circuit source.
CktDestPortName	VARCHAR2(4000)	—	Port name of the circuit destination.
CktUseLap	NUMBER(1)	—	Indicates if the circuit uses a lap. Values are: 0: False 1: True
CktOchncChannel	NUMBER(2)	—	Circuit OCHNC channel number. Values are: 0: Not applicable 1: OCHNC_30_33 2: OCHNC_31_12 3: OCHNC_31_90 4: OCHNC_32_68 5: OCHNC_34_25 6: OCHNC_35_04 7: OCHNC_35_82 8: OCHNC_36_61 9: OCHNC_38_19 10: OCHNC_38_98 11: OCHNC_39_77 12: OCHNC_40_56 13: OCHNC_42_14 14: OCHNC_42_94 15: OCHNC_43_73 16: OCHNC_44_53 17: OCHNC_46_12 18: OCHNC_46_92 19: OCHNC_47_72 20: OCHNC_48_51 21: OCHNC_50_12 22: OCHNC_50_92 23: OCHNC_51_72 24: OCHNC_52_52 25: OCHNC_54_13 26: OCHNC_54_94 27: OCHNC_55_75 28: OCHNC_56_55 29: OCHNC_58_17 30: OCHNC_58_98 31: OCHNC_59_79 32: OCHNC_60_61
CktOchncDir	NUMBER(1)	—	Direction of the OCHNC circuit. Values are: 0: East to west 1: West to east 2: Not applicable
isDuplicateName	NUMBER(1)	DEFAULT 1	Valid values are: 0: DUPLICATE 1: NOT_DUPLICATE
NPID	NUMBER(10)	DEFAULT 0	Network partition ID.
CktAliasName	VARCHAR2(64)	—	Circuit alias name.

1.2.34  Circuit_VCG_Tbl

The Circuit_VCG_Tbl contains the inventory of virtual concatenation group circuits.

Primary key: none

Foreign key: FK_CIRCUIT_VCG_NPID

Tablespace: BASE_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

Table 1-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 contains information about VLANs associated with circuits.

Primary key: CIRCUIT_VLAN_PK

Foreign key: FK_CIRCUIT_VLAN_NPID

Tablespace: BASE_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

Table 1-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 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 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 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 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 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 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 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 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 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)	NOT NULL UNIQUE	Object type.
ObjectName	VARCHAR2(256)	NOT NULL	Object name of the object type.

1.2.45  DB_Pruning_Table

The DB_Pruning_Table 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 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 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 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 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 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 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 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 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 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 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 contains PM data mapping information about 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 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 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 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 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(20)	—	—
DSCP	VARCHAR2(8)	—	—
PRECEDENCE	VARCHAR2(15)	—	—
SOURCEOPERATOR	VARCHAR2(12)	—	—
SOURCESTARTPORT	VARCHAR2(15)	—	—
SOURCEENDPORT	VARCHAR2(15)	—	—
DESTINATIONOPERATOR	VARCHAR2(12)	—	—
DESTINATIONSTARTPORT	VARCHAR2(15)	—	—
DESTINATIONENDPORT	VARCHAR2(15)	—	—
TCPBITS	VARCHAR2(12)	—	—
ICMPMESSAGECODE	NUMBER(3)	—	—
ICMPMESSAGETYPE	NUMBER(3)	—	—
IGMPMESSAGETYPE	VARCHAR2(15)	—	—
CHECKFRAGMENTS	VARCHAR2(5)	—	—

1.2.62  HFR_BUNDLE_MEMBER

The HFR_BUNDLE_MEMBER shows information about bundle members.

Primary key: HFR_BUNDLE_MBR_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-61 HFR_BUNDLE_MEMBER 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBACCESSID	NUMBER(8)	NOT NULL	—
BUNDLEIFID	VARCHAR2(256)	NOT NULL	—
IFID	VARCHAR2(256)	NOT NULL	—
IFACTIVE	VARCHAR2(3)	NOT NULL	—
BUNDLEMODE	VARCHAR2(10)	—	—
LACPPRIORITY	NUMBER(16)	DEFAULT 32768	—
LACPPERIOD	NUMBER(10)	DEFAULT 30	—

1.2.63  HFR_BGP_PEER_PM_Table

Primary key: HFR_PM_BGP_PEER_PK

Tablespace: HFR_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

Table 1-62 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(20)	DEFAULT -1	—
OUTPUTMSGS	NUMBER(20)	DEFAULT -1	—
INPUTUPDATEMSGS	NUMBER(20)	DEFAULT -1	—
OUTPUTUPDATEMSGS	NUMBER(20)	DEFAULT -1	—
CONNESTABLISHED	NUMBER(20)	DEFAULT -1	—
CONNDROPPED	NUMBER(20)	DEFAULT -1	—
ERRORSRECEIVED	NUMBER(20)	DEFAULT -1	—
ERRORSSENT	NUMBER(20)	DEFAULT -1	—
ModelType	NUMBER(10)	DEFAULT 0	Model type.
ObjectType	NUMBER(10)	DEFAULT 0	Object type.
StrObjInstance	VARCHAR2(256)	—	StrObjInstance name.

1.2.64  HFR_Common_Interface_Config

The HRF_Common_Interface_Config table contains CRS-1 common interface configuration date, including Ethernet and POS.

Primary key: HFR_COM_INTF_CFG_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-63 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	VARCHAR2(20)	—	Supports the CDP state in the interface.
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)	—	—
OPER_STATUS	VARCHAR2(2)	—	Supports the operational state in cards.
VRFNAME	VARCHAR2(32)	—	Supports the interface association with VRF.
BUNDLEID	NUMBER(16)	—	—

1.2.65  HFR_ETHER_Interface_Config

The HFR_ETHER_Interface_Config table contains CRS-1 Ethernet interface configuration data. It is used to retain detailed information about Ethernet interfaces on an NE.

Primary key: HFR_ETHER_INTF_CFG_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-64 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	Foreign key referencing HFR_COMMON_INTERFACE_CONFIG (IFID).
IFACTIVE	VARCHAR2(3)	NOT NULL	Activity status of the interface.
FULLDUPLEX	NUMBER(1)	—	Full duplex setting.
HALFDUPLEX	NUMBER(1)	—	Half duplex setting.
ARPPROXY	NUMBER(1)	—	Address Resolution Protocol (ARP) proxy setting.
ARPTIMEOUT	NUMBER(8)	—	Address Resolution Protocol (ARP) timeout.
MACADDRESS	VARCHAR2(12)	—	MAC address.
MEDIATYPE	VARCHAR2(6)	—	Media type.
SPEED	VARCHAR2(4)	—	Interface speed.
BUNDLEID	NUMBER(16)	—	Reserved for possible future use with bundle feature.

1.2.66  HFR_Interface_BUNDLE

The HFR_INTERFACE_BUNDLE table shows information about interface bundles.

Primary key: HFR_INTF_BUNDLE_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-65 HFR_Interface_BUNDLE 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBACCESSID	NUMBER(8)	NOT NULL	—
BUNDLEIFID	VARCHAR2(256)	NOT NULL	—
BUNDLEIFACTIVE	VARCHAR2(3)	—	—
BUNDLEID	NUMBER(16)	NOT NULL	—
MINLINKS	NUMBER(6)	DEFAULT 1	—
MINBW	NUMBER(32)	DEFAULT 1	—

1.2.67  HFR_Interface_DRC_PM_Table

Primary key: HFR_PM_INTERFACE_DRC_PK

Tablespace: HFR_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

Table 1-66 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(20)	DEFAULT -1	—
INPUTPACKETRATE	NUMBER(20)	DEFAULT -1	—
OUTPUTDATARATE	NUMBER(20)	DEFAULT -1	—
OUTPUTPACKETRATE	NUMBER(20)	DEFAULT -1	—
INPUTPEAKRATE	NUMBER(20)	DEFAULT -1	—
INPUTPEAKPKTS	NUMBER(20)	DEFAULT -1	—
OUTPUTPEAKRATE	NUMBER(20)	DEFAULT -1	—
OUTPUTPEAKPKTS	NUMBER(20)	DEFAULT -1	—
BANDWIDTH	NUMBER(20)	DEFAULT -1	—
ModelType	NUMBER(10	DEFAULT 0	Model type.
ObjectType	NUMBER(10)	DEFAULT 0	Object type.
StrObjInstance	VARCHAR2(256)	—	StrObjInstance name.

1.2.68  HFR_Interface_GC_PM_Table

Primary key: HFR_PM_INTERFACE_GC_PK

Tablespace: HFR_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

Table 1-67 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(20)	DEFAULT -1	—
INOCTETS	NUMBER(20)	DEFAULT -1	—
OUTPACKETS	NUMBER(20)	DEFAULT -1	—
OUTOCTETS	NUMBER(20)	DEFAULT -1	—
INUCASTPACKETS	NUMBER(20)	DEFAULT -1	—
INMULTICASTPACKETS	NUMBER(20)	DEFAULT -1	—
INBROADCASTPACKETS	NUMBER(20)	DEFAULT -1	—
OUTUCASTPACKETS	NUMBER(20)	DEFAULT -1	—
OUTMULTICASTPACKETS	NUMBER(20)	DEFAULT -1	—
OUTBROADCASTPACKETS	NUMBER(20)	DEFAULT -1	—
OUTPUTTOTALDROPS	NUMBER(20)	DEFAULT -1	—
INPUTTOTALDROPS	NUMBER(20)	DEFAULT -1	—
INPUTQUEUEDDROPS	NUMBER(20)	DEFAULT -1	—
INPUTUNKNOWNPROTO	NUMBER(20)	DEFAULT -1	—
OUTPUTTOTALERRORS	NUMBER(20)	DEFAULT -1	—
OUTPUTUNDERRUN	NUMBER(20)	DEFAULT -1	—
INPUTTOTALERRORS	NUMBER(20)	DEFAULT -1	—
INPUTCRC	NUMBER(20)	DEFAULT -1	—
INPUTOVERRUN	NUMBER(20)	DEFAULT -1	—
INPUTFRAME	NUMBER(20)	DEFAULT -1	—
ModelType	NUMBER(10)	DEFAULT 0	Model type.
ObjectType	NUMBER(10)	DEFAULT 0	Object type.
StrObjInstance	VARCHAR2(256)	—	StrObjInstance name.

1.2.69  HFR_Interface_Helper_Address

The HFR_Interface_Helper_Address table is a subtable of HFR_Common_Interface_Config. It is used to handle the case where helper addresses are associated with a single physical interface on an NE. The NE Explorer > Configuration > Interfaces > Common tab online help describes the distinction between IP addresses, secondary addresses, and helper addresses.

Primary key: HFR_COM_INTF_HELPADDR_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-68 HFR_Interface_Helper_Address 

Column Name	Oracle Data Type	Integrity Constraints	Description
IPADDRESS	VARCHAR2(16)	NOT NULL	IP address of the interface. Note IPv4 only.
NEDBACCESS	NUMBER(8)	NOT NULL	The foreign key referencing the attribute NE_INFO_TABLE (NEDBAccessID).
ENABLED	NUMBER(1)	—	Boolean status for the helper IP address.
IFID	VARCHAR2(256)	NOT NULL	The foreign key referencing the attribute HFR_COMMON_INTERFACE_CONFIG (IFID).
IFACTIVE	VARCHAR2(3)	NOT NULL	Activity status of the interface.

1.2.70  HFR_Interface_MTU_Layer2

The HFR_INTERFACE_MTU_LAYER2 table is used to retain information about the maximum transmission unit (MTU) value associated with a specific interface. This is important because if an interface supports only a small MTU value, it can create a bottleneck for network traffic. An ideal network path supports large MTU values between source and destination IP addresses. The MTU value reflects the largest packet value supported by the interface.

Primary key: HFR_COM_INTF_MTULAYER2_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-69 HFR_Interface_MTU_Layer2 

Column Name	Oracle Data Type	Integrity Constraints	Description
OWNER	VARCHAR2(16)	NOT NULL	—
NEDBACCESSID	NUMBER(8)	NOT NULL	The foreign key referencing the attribute NE_INFO_TABLE (NEDBAccessID).
MTUVALUE	NUMBER(16)	—	The value for maximum transmission unit.
IFID	VARCHAR2(256)	NOT NULL	The foreign key referencing the attribute HFR_COMMON_INTERFACE_CONFIG (IFID).
IFACTIVE	VARCHAR2(3)	NOT NULL	Activity status of the interface.

1.2.71  HFR_Interface_Secondary_Addr

The HFR_Interface_Secondary_Addr table is a subtable of HFR_Common_Interface_Config. This table is used to retain secondary interface addresses, which are associated with a single physical interface on an NE. The NE Explorer > Configuration > Interfaces > Common tab online help describes the distinction between IP addresses, secondary addresses, and helper addresses.

Primary key: HFR_COM_INTF_SECONDADDR_PK

Tablespace: HFR_DATA_TABLESPACE

Table 1-70 HFR_Interface_Secondary_Addr 

Column Name	Oracle Data Type	Integrity Constraints	Description
IPADDRESS	VARCHAR2(16)	NOT NULL	IP address of the interface. Note IPv4 only.
NEDBACCESSID	NUMBER(8)	NOT NULL	The foreign key referencing the attribute NE_INFO_TABLE (NEDBAccessID).
IP MASK	VARCHAR2(16)	—	IP address representing the subnet mask. Note IPv4 only.
IFID	VARCHAR2(256)	NOT NULL	The foreign key referencing the attribute HFR_COMMON_INTERFACE_CONFIG (IFID).
IFACTIVE	VARCHAR2(3)	NOT NULL	Activity status of the interface.

1.2.72  HFR_LACP

Tablespace: HFR_DATA_TABLESPACE

Table 1-71 HFR_LACP 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBACCESSID	NUMBER(8)	NOT NULL	—
SYSTEMPRIORITY	NUMBER(16)	DEFAULT 32768	—

1.2.73  HFR_MPLS_Interface_PM_Table

Primary key: HFR_PM_MPLS_INTERFACE_PK

Tablespace: HFR_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

Table 1-72 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(20)	DEFAULT -1	—
FRAGMENTEDPKTS	NUMBER(20)	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_MPLS_LDP_PM_Table

Primary key: HFR_PM_MPLS_LDP_PK

Tablespace: HFR_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

Table 1-73 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(20)	DEFAULT -1	—
TOTALMSGSRCVD	NUMBER(20)	DEFAULT -1	—
INITMSGSSENT	NUMBER(20)	DEFAULT -1	—
INITMSGSRCVD	NUMBER(20)	DEFAULT -1	—
ADDRESSMSGSSENT	NUMBER(20)	DEFAULT -1	—
ADDRESSMSGSRCVD	NUMBER(20)	DEFAULT -1	—
ADDRESSWITHDRAWMSGSSENT	NUMBER(20)	DEFAULT -1	—
ADRESSWITHDRAWMSGSRCVD	NUMBER(20)	DEFAULT -1	—
LABELMAPPINGMSGSSENT	NUMBER(20)	DEFAULT -1	—
LABELWITHDRAWMSGSSENT	NUMBER(20)	DEFAULT -1	—
LABELWITHDRAWMSGSRCVD	NUMBER(20)	DEFAULT -1	—
LABELRELEASEMSGSSENT	NUMBER(20)	DEFAULT -1	—
LABELRELEASEMSGSRCVD	NUMBER(20)	DEFAULT -1	—
NOTIFICATIONMSGSSENT	NUMBER(20)	DEFAULT -1	—
NOTIFICATIONMSGSRCVD	NUMBER(20)	DEFAULT -1	—
KEEPALIVEMSGSSENT	NUMBER(20)	DEFAULT -1	—
KEEPALIVEMSGSRCVD	NUMBER(20)	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_MPLS_TE_Link_PM_Table

Primary key: HFR_PM_MPLS_TE_LINK_PK

Tablespace: HFR_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

Table 1-74 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(20)	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_MPLS_TE_Tunnel_PM_Table

Primary key: HFR_PM_MPLS_TE_TUNNEL_PK

Tablespace: HFR_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

Table 1-75 HFR_MPLS_TE_Tunnel_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(20)	DEFAULT -1	—
INPUTPACKETRATE	NUMBER(20)	DEFAULT -1	—
OUTPUTDATARATE	NUMBER(20)	DEFAULT -1	—
OUTPUTPACKETRATE	NUMBER(20)	DEFAULT -1	—
INPUTPEAKRATE	NUMBER(20)	DEFAULT -1	—
INPUTPEAKPKTS	NUMBER(20)	DEFAULT -1	—
OUTPUTPEAKRATE	NUMBER(20)	DEFAULT -1	—
OUTPUTPEAKPKTS	NUMBER(20)	DEFAULT -1	—
BANDWIDTH	NUMBER(20)	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_Node_CPU_PM_Table

Primary key: HFR_PM_NODE_CPU_PK

Tablespace: HFR_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

Table 1-76 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(20)	DEFAULT -1	—
AVERAGECPUUSED	NUMBER(20)	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_Node_Memory_PM_Table

Primary key: HFR_PM_NODE_MEMORY_PK

Tablespace: HFR_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

Table 1-77 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(20)	DEFAULT -1	—
PEAKMEMORY	NUMBER(20)	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_Node_Process_PM_Table

Primary key: HFR_PM_NODE_PROCESS_PK

Tablespace: HFR_DATA_TABLESPACE

---

Note For medium, large, and high-end configurations, this table is partitioned.

---

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