Table Of Contents

Database Schema Tables

1.1  CTM Sequence Numbers

1.2  CTM Tables (Non-MGX Voice Gateway)

1.2.1  Ack_Table

1.2.2  Active_Alarm_Table

1.2.3  Additional_Device_Info

1.2.4  Admin_Job_Table

1.2.5  Alarm_Ack_Config_Table

1.2.6  Alarm_Count_Table

1.2.7  Alarm_Event_Cause_Table

1.2.8  Alarm_Event_Table

1.2.9  Alarm_Event_Type_ENUM_Table

1.2.10  APC_Domain_Table

1.2.11  APS_Group_Table

1.2.12  Audit_Log_Mapping_Table

1.2.13  Audit_Log_Table

1.2.14  BLSR_Node

1.2.15  BLSR_Span

1.2.16  BLSR_Table

1.2.17  Bridge_Group_Table

1.2.18  C_MetaData

1.2.19  C_MetaData_Attr_Presentation

1.2.20  C_MetaData_Col

1.2.21  C_MetaData_Col_Custom

1.2.22  C_MetaData_Filter

1.2.23  C_MetaData_Grp_Presentation

1.2.24  C_MetaData_NETypes

1.2.25  C_Property_Sheet_Info_Table

1.2.26  C_Tab_Metadata_Info_Table

1.2.27  C_Tab_Metadata_Table

1.2.28  Chanfr_Conn_Data

1.2.29  Cerent_NE_Group_Table

1.2.30  Circuit_BS_Tbl

1.2.31  Circuit_Ctp_Tbl

1.2.32  Circuit_Dest_Tbl

1.2.33  Circuit_Size_Table

1.2.34  Circuit_Span_BS_Tbl

1.2.35  Circuit_Span_Tbl

1.2.36  Circuit_Tbl

1.2.37  Circuit_VCG_Tbl

1.2.38  Circuit_VLAN_Tbl

1.2.39  CLISession_Command_History_Tbl

1.2.40  CORBA_Functions_Table

1.2.41  CORBA_GW_Active_User_Table

1.2.42  CORBA_Interface_Table

1.2.43  CORBA_Permission_Table

1.2.44  CTC_Model_Const_Table

1.2.45  CTC_UserProfile_Table

1.2.46  CTM_Config_Table

1.2.47  CTM_Unique_ObjectType_Table

1.2.48  CTM_Unknown_User_Table

1.2.49  Custom_View_Table

1.2.50  DB_Pruning_Table

1.2.51  Debug_Module_Mapping_Table

1.2.52  Debug_Module_Table

1.2.53  Deleted_User_Table

1.2.54  Diskspace_Usage_Table

1.2.55  Domain_Table

1.2.56  Ems_Alarm_Table

1.2.57  Enum_Table

1.2.58  EQPT_Info_Table

1.2.59  Eqpt_Relationship_Table

1.2.60  Error_Log_Table

1.2.61  Forwarding_Table

1.2.62  GNE_Table

1.2.63  Group_Info_Table

1.2.64  GWCORBA_PM_Mapping_Table

1.2.65  IF_Cross_Connect

1.2.66  IF_DWDM_Channel_Group

1.2.67  IF_Optical_Phy_Config_Table

1.2.68  IFIndex_Rule_Table

1.2.69  Interface_APS_Info

1.2.70  Interface_DWDM_Frequency

1.2.71  Interface_Stack_Table

1.2.72  Interface_Table

1.2.73  IOS_Parser_Static_Tree_Table

1.2.74  L2_FrontPort_Table

1.2.75  L2_Interface_QoSClass_Table

1.2.76  L2_Interface_Table

1.2.77  L2_Ipsla_Attribute_Table

1.2.78  L2_Ipsla_Table

1.2.79  L2QoSTemplate_QoSClass_Table

1.2.80  L2QoSTemplate_Table

1.2.81  L2Topology_Circuits_Table

1.2.82  L2Topology_Table

1.2.83  L2_Vlan_Table

1.2.84  Link_Layer_Mapping_Table

1.2.85  Link_Table

1.2.86  Managed_Et_Table

1.2.87  Map_Coordinate_Table

1.2.88  Map_Cust_Table

1.2.89  Map_Image_Table

1.2.90  Map_Link_Table

1.2.91  MIB2_Interface_Table

1.2.92  MLPPP_Bundle_Data

1.2.93  MLPPP_Link_Data

1.2.94  MLPPP_Mux_Data

1.2.95  Model_Type_Table

1.2.96  Module155xx_Community_String

1.2.97  Module155xx_VTOID_Table

1.2.98  Module_Type_Mll_Info

1.2.99  Module_Type_Table

1.2.100  NE_Audit_Trail_Table

1.2.101  NE_Info_Table

1.2.102  NE_Inventory_Table

1.2.103  NE_Model_State_Table

1.2.104  NE_Model_Type_Table

1.2.105  NE_Module_Level_Debug

1.2.106  NE_Port_Status_Table

1.2.107  NE_Swimage_Table

1.2.108  Network_Partition_Table

1.2.109  Object_Relationship_Table

1.2.110  ObjectAttributeTable

1.2.111  ObjectTypeTable

1.2.112  ONS15216_Active_User_Table

1.2.113  ONS15216_NE_Inventory_Table

1.2.114  ONS15216_Privilege_Table

1.2.115  ONS15216_User_Table

1.2.116  ONS1530x_HO_PM_Table

1.2.117  ONS1530x_IP_PM_Table

1.2.118  ONS1530x_LO_PM_Table

1.2.119  ONS1530x_MS_PM_Table

1.2.120  ONS1530x_NE_Inventory_Table

1.2.121  ONS1530x_RS_PM_Table

1.2.122  ONS15454_327_NE_Table

1.2.123  ONS15454_8B10B_PM_Table

1.2.124  ONS15454_Active_User_Table

1.2.125  ONS15454_CBQoS_Info_Table

1.2.126  ONS15454_CLASSMAP_PM_Table

1.2.127  ONS15454_CMS_Storage_Table

1.2.128  ONS15454_COS_PM_Table

1.2.129  ONS15454_DS1_PM_Table

1.2.130  ONS15454_DS3_PM_Table

1.2.131  ONS15454_ENET_PM_Table

1.2.132  ONS15454_FC_PM_Table

1.2.133  ONS15454_GFP_PM_Table

1.2.134  ONS15454_IFX_PM_Table

1.2.135  ONS15454_IPSLA_PM_Table

1.2.136  ONS15454_Match_STMT_PM_Table

1.2.137  ONS15454_NE_Inventory_Table

1.2.138  ONS15454_OTN_Fec_PM_Table

1.2.139  ONS15454_OTN_Path_PM_Table

1.2.140  ONS15454_OTN_Sec_PM_Table

1.2.141  ONS15454_PHY_LAYER_PM_Table

1.2.142  ONS15454_Police_PM_Table

1.2.143  ONS15454_POS_PM_Table

1.2.144  ONS15454_Privilege_Table

1.2.145  ONS15454_RPR_PM_Table

1.2.146  ONS15454_SONET_Line_PM_Table

1.2.147  ONS15454_SONET_Path_PM_Table

1.2.148  ONS15454_SONET_Sec_PM_Table

1.2.149  ONS15454_SONET_VT_PM_Table

1.2.150  ONS15454_User_Table

1.2.151  ONS15454SDH_E1_PM_Table

1.2.152  ONS15454SDH_E3_PM_Table

1.2.153  ONS15454SDH_E4_PM_Table

1.2.154  ONS15454SDH_HO_PM_Table

1.2.155  ONS15454SDH_LO_PM_Table

1.2.156  ONS15454SDH_MS_PM_Table

1.2.157  ONS15454SDH_RS_PM_Table

1.2.158  ONS15501_NE_Explorer_Table

1.2.159  ONS15501_Opt_Power_PM_Table

1.2.160  ONS155xx_CDL_Flow_Config

1.2.161  ONS155xx_CDL_IF_Config

1.2.162  ONS155xx_CDL_PM_Table

1.2.163  ONS155xx_Circuit_CC_Tbl

1.2.164  ONS155xx_Circuit_Path_Tbl

1.2.165  ONS155xx_Circuit_Stack_Tbl

1.2.166  ONS155xx_Condtype_Map

1.2.167  ONS155xx_DCRP_Definition_Table

1.2.168  ONS155xx_DCRP_Table

1.2.169  ONS155xx_Discovery_Info_Table

1.2.170  ONS155xx_Ether_Hist_PM_Table

1.2.171  ONS155xx_FCM_PE_PM_Table

1.2.172  ONS155xx_Flash_Device_Table

1.2.173  ONS155xx_Flash_Partition_Table

1.2.174  ONS155xx_GRA_CC_To_CKT_CC_Tbl

1.2.175  ONS155xx_Granular_CC_Tbl

1.2.176  ONS155xx_IF_Circuit_Params_Tbl

1.2.177  ONS155xx_IF_Optical_Power

1.2.178  ONS155xx_IF_Phy_Info_Table

1.2.179  ONS155xx_NE_Info_Table

1.2.180  ONS155xx_NE_Type_Table

1.2.181  ONS155xx_Opt_Power_PM_Table

1.2.182  ONS155xx_Path_Hop_Tbl

1.2.183  ONS155xx_Path_Tbl

1.2.184  ONS155xx_Phy_PM_Table

1.2.185  ONS155xx_SONET_Sec_PM_Table

1.2.186  ONS15600_ENET_PM_Table

1.2.187  ONS15600_POS_PM_Table

1.2.188  ONS15600_Sonet_Line_PM_Table

1.2.189  ONS15600_Sonet_Path_PM_Table

1.2.190  ONS15600_Sonet_Sec_PM_Table

1.2.191  ONS15600SDH_HO_PM_Table

1.2.192  ONS15600SDH_MS_PM_Table

1.2.193  ONS15600SDH_RS_PM_Table

1.2.194  ONS158xx_Amplifier_PM_Table

1.2.195  ONS158xx_BCS_PM_Table

1.2.196  ONS158xx_CMP_PM_Table

1.2.197  ONS158xx_IOC_W_PM_Table

1.2.198  ONS158xx_LAC_Active_User_Table

1.2.199  ONS158xx_LAC_Log_Status_Table

1.2.200  ONS158xx_LAC_Log_Table

1.2.201  ONS158xx_LAC_Profile_Table

1.2.202  ONS158xx_LAC_User_Table

1.2.203  ONS158xx_LSM_PM_Table

1.2.204  ONS158xx_NE_IP_Table

1.2.205  ONS158xx_OAD_PM_Table

1.2.206  ONS158xx_OADM_PM_Table

1.2.207  ONS158xx_OSU_PM_Table

1.2.208  ONS158xx_OTS_PTP_Table

1.2.209  ONS158xx_PM_ACT_MOD_Table

1.2.210  ONS158xx_PTPType_Table

1.2.211  ONS158xx_SCF_PM_Table

1.2.212  ONS158xx_TimeStamp_PM_Table

1.2.213  ONS158xx_Transponder_PM_Table

1.2.214  ONS158xx_WD_PM_Table

1.2.215  ONS158xx_WD_RX_PM_Table

1.2.216  Operation_Permissions_Table

1.2.217  Operations_Table

1.2.218  OSS_Active_User_Table

1.2.219  OSS_AID_ENUM_Table

1.2.220  OSS_Alarm_Filter_Table

1.2.221  OSS_Alarm_Fltr_AID_Deny_Tbl

1.2.222  OSS_Alarm_Fltr_TID_Deny_Tbl

1.2.223  OSS_CORBA_User_Table

1.2.224  OSS_User_Table

1.2.225  Password_History_Table

1.2.226  PatchCord_Table

1.2.227  PM_ATTR_Value_Mapping_Table

1.2.228  PM_ATTRID_Mapping_Table

1.2.229  PM_Category_View_Table

1.2.230  PM_Cerent_Info_Table

1.2.231  PM_Historical_Appointments

1.2.232  PM_Metadata_Info_Table

1.2.233  PM_Metadata_Table

1.2.234  PMService_Associated_Tab_Table

1.2.235  Proxy_Server_Table

1.2.236  Purged_NE_Table

1.2.237  Roll_Table

1.2.238  Schedule_Info_Table

1.2.239  Server_Monitor_Table

1.2.240  Server_Parameter_Table

1.2.241  Subnetwork_Table

1.2.242  SVC_Config_Table

1.2.243  SVC_Info_Table

1.2.244  SVC_NEModel_Table

1.2.245  SVC_Package_Table

1.2.246  SVC_Property_Table

1.2.247  Sway_User_Port_Table

1.2.248  Table_Info

1.2.249  TCA_Event_Table

1.2.250  TCA_Event_Type_Table

1.2.251  Threshold_Table

1.2.252  TL1_Encoding_Table

1.2.253  TL1_Tunnel_Gateway_Table

1.2.254  TL1_Tunnel_Info_Table

1.2.255  Transaction_Log_Table

1.2.256  Unmanaged_NE_Inventory_Table

1.2.257  User_Map_Table

1.2.258  User_NE_Table

1.2.259  User_Preference_Table

1.2.260  User_Table

1.2.261  User_Type_Table

1.2.262  Version_Table

1.2.263  Version_Table_Enhanced

1.2.264  Wavelength_Table

1.2.265  Wavemux_NE

1.2.266  XML_Parser_Static_Tree_Table

1.3  CTM Tables (MGX Voice Gateway)

1.3.1  AAL1_CROSS_CONN

1.3.2  AAL1_DATA_PROFILE

1.3.3  AAL2_5_DATA_PROFILE

1.3.4  AAL2_CROSS_CONN

1.3.5  AAL5_CROSS_CONN

1.3.6  ADDR_CUG

1.3.7  APS

1.3.8  ATM_ADDR

1.3.9  ATM_CONNECTION

1.3.10  ATM_PHY

1.3.11  AU4TUG3

1.3.12  AUSM_PORT

1.3.13  AUSM_PORT_DATA

1.3.14  AXIST3_LINE_DATA

1.3.15  AXSM_CONN_DATA

1.3.16  AXSME_CONN_DATA

1.3.17  CALL_CONTROL_PROFILE

1.3.18  CARD_DESC

1.3.19  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  CONN_TEMPL_PARAM

1.3.27  CONN_TEMPLATE

1.3.28  CONN_ROUTE_STATISTICS

1.3.29  CONNECTION

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  DS0_CONNECT

1.3.41  DS1_AU3_PATH_DATA

1.3.42  DS1_AU4_PATH_DATA

1.3.43  DS1_DS3_AU3_PATH_DATA

1.3.44  DS1_DS3_AU3_PIF_DATA

1.3.45  DS1_DS3_STS1_IMA_LINK_DATA

1.3.46  DS1_DS3_STS1_PATH_DATA

1.3.47  DS1_DS3_STS1_PIF_DATA

1.3.48  DS1_DS3LINE_IMA_LINK_DATA

1.3.49  DS1_DS3LINE_PATH_DATA

1.3.50  DS1_DS3LINE_PIF_DATA

1.3.51  DS1_T3LINE_PATH_DATA

1.3.52  DS1_TU11_AU3_PATH_DATA

1.3.53  DS1_TU11_AU3_PIF_DATA

1.3.54  DS1_TU11_AU4_PATH_DATA

1.3.55  DS1_TU11_AU4_PIF_DATA

1.3.56  DS1_VT_STS1_PATH_DATA

1.3.57  DS1_VT_STS1_PIF_DATA

1.3.58  DS1_TU11_AU3_IMA_LINK_DATA

1.3.59  DS1_TU11_AU4_IMA_LINK_DATA

1.3.60  DS1_VT_STS1_IMA_LINK_DATA

1.3.61  DS1LINE_PIF_DATA

1.3.62  DS3_AU3_PATH_DATA

1.3.63  DS3_AU3_PIF_DATA

1.3.64  DS3_AU4_PATH_DATA

1.3.65  DS3_AU4_PIF_DATA

1.3.66  DS3_STS1_PATH_DATA

1.3.67  DS3_STS1_PF_DATA

1.3.68  DS3LINE_PIF_DATA

1.3.69  DSP_STATUS

1.3.70  E1_AU3_PATH_DATA

1.3.71  E1_AU4_PATH_DATA

1.3.72  E1_TU12_AU3_PIF_DATA

1.3.73  E1_TU12_AU3_PATH_DATA

1.3.74  E1_TU12_AU4_PATH_DATA

1.3.75  E1_TU12_AU4_PIF_DATA

1.3.76  E1_TU12_AU3_IMA_LINK_DATA

1.3.77  E1_TU12_AU4_IMA_LINK_DATA

1.3.78  E1_VT_STS1_IMA_LINK_DATA

1.3.79  E1_VT_STS1_PATH_DATA

1.3.80  E1_VT_STS1_PIF_DATA

1.3.81  E1LINE_PIF_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_TEMPL_PARAM

1.3.89  ELEMENT_TEMPLATE

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  IMAGROUP_PIF_DATA

1.3.102  LAPD_DS1_AU3_DATA

1.3.103  LAPD_DS1_AU4_DATA

1.3.104  LAPD_DS1_DS3_DATA

1.3.105  LAPD_DS1_VT_DATA

1.3.106  LAPD_E1_AU3_DATA

1.3.107  LAPD_E1_AU4_DATA

1.3.108  LAPD_E1_VT_STS1_Data

1.3.109  LAPD_T1E1_DATA

1.3.110  LAPD_T3E3_DATA

1.3.111  LAPD_TRUNK

1.3.112  LICENSE_IN_USE

1.3.113  LICENSE_POOL

1.3.114  LIF

1.3.115  LINE_DESC

1.3.116  LINEDISTRIBUTION

1.3.117  LINEDISTRIBUTION_DESC

1.3.118  LOOKUP_FIELD

1.3.119  LOOKUP_TABLE

1.3.120  MAINTLOG

1.3.121  MCARD_Table

1.3.122  MEGACO_CONFIG

1.3.123  MEGACO_DATA

1.3.124  MEGACO_EPH_TERM_DATA

1.3.125  MEGACO_PHY_TERM_DATA

1.3.126  MEGACO_PROFILE

1.3.127  MEGACO_TERM

1.3.128  MG_DNAME

1.3.129  MG_SUP_PRTCL

1.3.130  MGC_GRP

1.3.131  MGC_IP

1.3.132  MGC_RES

1.3.133  MGCG_PARAM

1.3.134  MGCG_PROTOCOL

1.3.135  MGX8880_NE_INFO_TABLE

1.3.136  MGX8880_SNMPV3_USERS_TABLE

1.3.137  MPBUNDLE

1.3.138  NETWORK

1.3.139  NETWORK_DESC

1.3.140  NHM_MANAGEABILITY

1.3.141  NHM_STATS

1.3.142  NODE_DESC

1.3.143  NODE_GROOM

1.3.144  NODE_PARENT

1.3.145  NODE_THRESH

1.3.146  PATH_DESC

1.3.147  PEND_FILE_LIST

1.3.148  PLCP

1.3.149  PNNI_IF

1.3.150  PNNI_NODAL_DATA

1.3.151  PNNI_PORT_DATA

1.3.152  PORT_DESC

1.3.153  PORT_QUEST

1.3.154  PPP_LINK

1.3.155  PROGRAM_TONE

1.3.156  PXM1E_CONN_DATA

1.3.157  PXM1E_LINE_DATA

1.3.158  PXM1E_PORT_DATA

1.3.159  PXM1ET1E1_PL_DATA

1.3.160  PXM1EE3_PL_DATA

1.3.161  PXM1ESONET_PL_DATA

1.3.162  PXM1ET3_PL_DATA

1.3.163  REDUNDANTCARD

1.3.164  RPM_CONNECTION

1.3.165  RPM_PORT

1.3.166  RSC_PART

1.3.167  RSC_POLICY

1.3.168  RTP_CONN

1.3.169  RUDP_SESSION

1.3.170  SCMCARDCOLLSTATUS

1.3.171  SCMDB_NODE_INFO

1.3.172  SCMNODECOLLSTATUS

1.3.173  SCTP_ADDR

1.3.174  SCTP_ASSOC

1.3.175  SCTP_ASSOCIATION_DATA

1.3.176  SCTP_GATEWAY_DATA

1.3.177  SENSOR_THRHD

1.3.178  SESSION_DATA

1.3.179  SESSION_GROUP

1.3.180  SESSION_SET

1.3.181  SHELF

1.3.182  SONET_LINE_DATA

1.3.183  SRCP_PARAM

1.3.184  SRCP_PEER

1.3.185  SRTFILTERLIST

1.3.186  SRTREPORTKEY

1.3.187  STAT_ENABLE

1.3.188  STATSDB_INFO

1.3.189  STATSDB_SCMCOLLSVR

1.3.190  STM1_PATH_DATA

1.3.191  STM1_PIF_DATA

1.3.192  STS1_PATH_DATA

1.3.193  STS1_PIF_DATA

1.3.194  STSDS3DS1PATH_DATA

1.3.195  STSVTGDS1PATH_DATA

1.3.196  SVC_CAC

1.3.197  SVC_OPERATION

1.3.198  SVC_PORT

1.3.199  SYNC_INFO

1.3.200  SYNC_LIST

1.3.201  TONE_DETECT

1.3.202  TONE_ID

1.3.203  TONE_PLAN

1.3.204  TRAP_FILTER

1.3.205  TU3_AU4_PATH_DATA

1.3.206  TU11_AU3_PATH_DATA

1.3.207  TU11_AU4_PATH_DATA

1.3.208  USER_CONNECTION

1.3.209  USER_CONN_DESC

1.3.210  USER_INFO

1.3.211  VIRTUAL_PORT

1.3.212  VISM_ANNOUNCE

1.3.213  VISM_CARD

1.3.214  VISM_CAS_BIT

1.3.215  VISM_CID

1.3.216  VISM_CID_DATA

1.3.217  VISM_CODEC

1.3.218  VISM_CONN_DATA

1.3.219  VISM_DS0

1.3.220  VISM_E1_LINE_DATA

1.3.221  VISM_ENDPT

1.3.222  VISM_HDLC

1.3.223  VISM_LAPD

1.3.224  VISM_LINE

1.3.225  VISM_MGC

1.3.226  VISM_MGCP

1.3.227  VISM_PROFILE

1.3.228  VISM_T1_LINE_DATA

1.3.229  VISM_TEMPLATE

1.3.230  VOICE_CONN

1.3.231  VT_STS1_PATH_DATA

1.3.232  VXSM_AS

1.3.233  VXSM_ASP

1.3.234  VXSM_ASP_IP

1.3.235  VXSM_BPVC_BW_DATA

1.3.236  VXSM_CARD

1.3.237  VXSM_CAS_PROFILE

1.3.238  VXSM_CAS_VARIANT

1.3.239  VXSM_CCD_PROFILE

1.3.240  VXSM_CODEC_DATA

1.3.241  VXSM_DPNSS

1.3.242  VXSM_DPNSS_DLC

1.3.243  VXSM_DPNSS_DLC_E1_AU3_DATA

1.3.244  VXSM_DPNSS_DLC_E1_AU4_DATA

1.3.245  VXSM_DPNSS_DLC_E1_LINE_DATA

1.3.246  VXSM_DPNSS_DLC_E1_STS_DATA

1.3.247  VXSM_DPNSS_E1_AU3_DATA

1.3.248  VXSM_DPNSS_E1_AU4_DATA

1.3.249  VXSM_DPNSS_E1_LINE_DATA

1.3.250  VXSM_DPNSS_E1_STS_DATA

1.3.251  VXSM_DS0_UTIL_GW_DATA

1.3.252  VXSM_DS0_UTIL_VGW_DATA

1.3.253  VXSM_DS0_UTIL_DS1_LN_DATA

1.3.254  VXSM_DS0_UTIL_E1_LN_DATA

1.3.255  VXSM_DS0_UTIL_T3_LN_DATA

1.3.256  VXSM_DS0_UTIL_OC3_LN_DATA

1.3.257  VXSM_DS0_UTIL_STM1_LN_DATA

1.3.258  VXSM_DS0_UTIL_DS1_T3_DATA

1.3.259  VXSM_DS0_UTIL_DS1_STS_DATA

1.3.260  VXSM_DS0_UTIL_DS1_DS3_STS_DATA

1.3.261  VXSM_DS0_UTIL_DS1_AU3_DATA

1.3.262  VXSM_DS0_UTIL_DS1_AU4_DATA

1.3.263  VXSM_DS0_UTIL_E1_STS_DATA

1.3.264  VXSM_DS0_UTIL_E1_AU3_DATA

1.3.265  VXSM_DS0_UTIL_E1_AU4_DATA

1.3.266  VXSM_EPH_TERM_GW_DATA

1.3.267  VXSM_EPH_TERM_VGW_DATA

1.3.268  VXSM_EPH_TERM_BPVC_DATA

1.3.269  VXSM_EVENT_MAP

1.3.270  VXSM_FAX_RELAY

1.3.271  VXSM_GENERAL_CONFIG

1.3.272  VXSM_GSP_INST

1.3.273  VXSM_GSP_LINK

1.3.274  VXSM_GSP_LINK_SET

1.3.275  VXSM_GSP_LINK_TIMER

1.3.276  VXSM_GSP_POINT_CODE

1.3.277  VXSM_GSP_PROF_TIMER

1.3.278  VXSM_GSP_ROUTE

1.3.279  VXSM_GRT_ROUTE

1.3.280  VXSM_GTT_APP_GROUP

1.3.281  VXSM_GTT_GTA

1.3.282  VXSM_GTT_MAP

1.3.283  VXSM_GTT_PREF

1.3.284  VXSM_GTT_SEL

1.3.285  VXSM_IKE_PEER_AUTH

1.3.286  VXSM_IKE_TUNNEL

1.3.287  VXSM_IN_LINE_SIGNAL

1.3.288  VXSM_IPSEC_TUNNEL

1.3.289  VXSM_L3UA_ASP_DATA

1.3.290  VXSM_LINE_SIGNAL_TIMER

1.3.291  VXSM_MTP_LINKSLC_DATA

1.3.292  VXSM_NETWORK_INTERFACE

1.3.293  VXSM_OUT_LINE_SIGNAL

1.3.294  VXSM_OVER_LOAD_RSR_DATA

1.3.295  VXSM_PH1_PTRF_ASSOC

1.3.296  VXSM_PH2_PTRF_ASSOC

1.3.297  VXSM_PHASE1_PROPOSAL

1.3.298  VXSM_PHASE1_TRANSFORM

1.3.299  VXSM_PHASE2_PROPOSAL

1.3.300  VXSM_PHASE2_TRANSFORM

1.3.301  VXSM_PHY_GW_DATA

1.3.302  VXSM_PLFM_SYS_DATA

1.3.303  VXSM_PLFM_SCALAR_DATA

1.3.304  VXSM_PLFM_GW_RSC_DATA

1.3.305  VXSM_PVC_IP

1.3.306  VXSM_RTCP_ALERT_TRIGGER

1.3.307  VXSM_RTCP_CIPHERSUITE

1.3.308  VXSM_RTCP_PROFILE

1.3.309  VXSM_RTCP_PROFILE_CODEC

1.3.310  VXSM_RTP_CIPHERSUITE

1.3.311  VXSM_SCCP_DATA

1.3.312  VXSM_SCTP_CONFIG

1.3.313  VXSM_SECURITY_POLICY

1.3.314  VXSM_SPD_KEY_MGR_ASSOC

1.3.315  VXSM_TTY_PROFILE

1.3.316  VXSM_VBD_CALL_DATA

1.3.317  VXSM_VDB_PROFILE

1.3.318  VXSM_VIF

1.3.319  VXSM_VQM_GW_DATA

1.3.320  VXSM_VQM_VGW_DATA

1.3.321  VXSM_VQM_BPVC_DATA

1.3.322  VXSM_VQM_DS1_LN_DATA

1.3.323  VXSM_VQM_E1_LN_DATA

1.3.324  VXSM_VQM_T3_LN_DATA

1.3.325  VXSM_VQM_OC3_LN_DATA

1.3.326  VXSM_VQM_STM1_LN_DATA

1.3.327  VXSM_VQM_STS_DATA

1.3.328  VXSM_VQM_AU3_DATA

1.3.329  VXSM_VQM_AU4_DATA

1.3.330  VXSM_VQM_DS1_T3_DATA

1.3.331  VXSM_VQM_DS1_STS_DATA

1.3.332  VXSM_VQM_DS1_DS3_STS_DATA

1.3.333  VXSM_VQM_DS1_AU3_DATA

1.3.334  VXSM_VQM_DS1_AU4_DATA

1.3.335  VXSM_VQM_E1_STS_DATA

1.3.336  VXSM_VQM_E1_AU3_DATA

1.3.337  VXSM_VQM_E1_AU4_DATA

1.3.338  VXSM_XUA_AS

1.3.339  VXSM_XUA_AS_ROUTE

1.3.340  VXSM_XUA_AS_ROUTE_AS

1.3.341  VXSM_XUA_ASP

1.3.342  VXSM_XUA_ASP_AS

1.3.343  VXSM_XUA_INST

1.3.344  VXSM_XUA_LOCAL_IP

1.3.345  VXSM_XUA_QOS

1.3.346  VXSM_XUA_REMOTE_IP

1.3.347  XG_CONN_DATA

1.3.348  XG_DS3PATH_DATA

1.3.349  XG_LINE_DATA

1.3.350  XG_LINE_DS3_DATA

1.3.351  XG_PATH_DATA

1.3.352  XG_PL_DATA

1.3.353  XG_PORT_DATA

1.3.354  XGCP_DATA

1.3.355  XGCP_GW

1.3.356  XGCP_MGC

1.3.357  XGCP_PEER

1.4  NE Statistics-Related Tables

1.4.1  AXSM_CARD_DATA

1.4.2  AXSM_CONN_DATA

1.4.3  AXSM_LINE_DATA

1.4.4  AXSM_PORT_DATA

1.4.5  AXSME_CONN_DATA

1.4.6  AXSME_LINE_DATA

1.4.7  AXSME_PORT_DATA

1.4.8  AXSMESONET_PL_DATA

1.4.9  AXSMET1E1_PL_DATA

1.4.10  AXSMET3E3_PL_DATA

1.4.11  IMA_GROUP_DATA

1.4.12  IMA_LINK_DATA

1.4.13  LAPD_IN_DS1INDS3_DATA

1.4.14  LAPD_IN_DS1INVT_DATA

1.4.15  LAPDIN_T1E1_DATA

1.4.16  LAPD_IN_T3E3_DATA

1.4.17  MEGACO_DATA

1.4.18  MEGACO_EPH_TERM_DATA

1.4.19  MEGACO_PHY_TERM_DATA

1.4.20  SCMCARD

1.4.21  SCMCARDCOLL

1.4.22  SCMCARDCOLLHOST

1.4.23  SCMCARDENABLE

1.4.24  SCMCARDFAMILY

1.4.25  SCMCARDFAMILYDEF

1.4.26  SCMCARDFAMILYSTAT

1.4.27  SCMCARDTEMPLATE

1.4.28  SCMCOLLSVR

1.4.29  SCMCOLPAR

1.4.30  SCMCOLPARSTAT

1.4.31  SCMCOLPARSUBOBJ

1.4.32  SCMENABLETYPE

1.4.33  SCMIDMAP

1.4.34  SCMNODECOLL

1.4.35  SCMNODECOLLHOST

1.4.36  SCMNODEENABLE

1.4.37  SCMNODESTAT

1.4.38  SCMNODETEMPLATE

1.4.39  SCMOBJ

1.4.40  SCMSTAT

1.4.41  SCMSTATSKEY

1.4.42  SCMSUBOBJ

1.4.43  SCMDB_SCMCOLLSVR

1.4.44  SCMENABLELIST

1.4.45  SCMENABLESUBTYPE

1.4.46  SCMFRAGDATATABLES

1.4.47  SCMIDMAPDEF

1.4.48  SCMNODESTAT

1.4.49  SCMNODE

1.4.50  SCMOLDSTATKEY

1.4.51  SCMSTATKEY

1.4.52  SCMTABLEKEY

1.4.53  SCTP_ASSOCIATION_DATA

1.4.54  SCTP_GATEWAY_DATA

1.4.55  SESSION_DATA

1.4.56  SONET_LINE_DATA

1.4.57  SRTPERFKEY

1.4.58  SRTRPORTKEY

1.4.59  STATSDB_CONFIG

1.4.60  STS_DS3_DS1_PATH_DATA

1.4.61  STS_VTGROUP_DS1_PATH_DATA

1.4.62  XG_CONN_DATA

1.4.63  XGCP_DATA

1.4.64  XG_DS3PATH_DATA

1.4.65  XG_PATH_DATA

1.4.66  XG_PL_DATA

1.4.67  XG_PORT_DATA

Database Schema Tables

---

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

•CTM Sequence Numbers

•CTM Tables (Non-MGX Voice Gateway)

•CTM Tables (MGX Voice Gateway)

•NE Statistics-Related Tables

1.1  CTM Sequence Numbers

Sequence numbers are Oracle integers of up to 38 digits that are defined in the database. A sequence generates a serial list of unique numbers for numeric columns in a database's tables. Sequences simplify application programming by automatically generating unique numerical values for the rows in one or in multiple tables. The sequence numbers used in the CTM schema are listed in the following table.

Table 1-1 Sequence Numbers used in the CTM Schema 

Sequence Number	Description
ACKINDEX_SEQ	Used when an alarm acknowledgement is added to Ack_Table.
ACTIVEALARMINDEX_SEQ	Used when an alarm is added to the Active_Alarm_Table.
ALARMFILTERID_SEQ	Used when adding a filter profile name to the OSS_Alarm_Filter_Table.
BLSRID_SEQ	Used to generate ID number when adding a new BLS ring to the BLSR_Table.
COORDINDEX_SEQ	Used when adding a map coordinate to the Map_Coordinate_Table.
CKTSPANID_SEQ	Used when adding a circuit span to the Circuit_Span_Tbl.
CUSTOMIZATIONID_SEQ	Used when adding a map customization to the Map_Cust_Table.
DCRPDBID_SEQ	Used when discrepancies are added to the ONS155xx_Dcrp_Table.
DEVICEID_SEQ	Used when adding a device to Additional_Device_Info.
DT_TREENODEID_SEQ	Used when group or NE nodes are added to the Domain_Table.
EVENTINDEX_SEQ	Used while inserting alarms and events in the Alarm_Event_Table.
FILTER_ID_SEQ	Used when a filter is added to the Syslog_Filter_Table.
FLASHDEVDBID_SEQ	Used for the Flash devices in the ONS155xx_Flash_Device_Table.
FLASHPARTDBID_SEQ	Used for Flash devices in the ONS155xx_Flash_Partition_Table.
GNEID_SEQ	Used when a GNE is added to the GNE_Table.
GROUPID_SEQ	Used when groups are added to the Group_Info_Table.
IF_XC_SEQ	Used when adding cross-connects to the IF_Cross_Connect.
IFDACCESSID_SEQ	Used for parameters in the MIB2_Interface_Table.
IFSTACK_SEQ	Used for underlying/overlaying layer relationships in the Interface_Stack_Table.
JARID_SEQ	Used for the ONS15454_CMS_Storage_Table.
JOBID_SEQ	Used when a job is added to the Admin_Job_Table.
LINKID_SEQ	Used when adding a link to the Link_Table.
MAPIMAGEID_SEQ	Used when adding a map image to the Map_Image_Table.
MAPLINKID_SEQ	Used when adding a map link to the Map_Link_Table.
MGX8880_SNMP_INDEX_SEQ	Used when user connections are added to the User_Connection_Table.
NEDBACCESSID_SEQ	Used when NEs are added to the NE_Info_Table.
NPID_SEQ	Used when adding a new network partition to Network_Partition_Table.
ONS155XX_CIRCUIT_CC_DBID_SEQ	Used for circuit-specific cross-connects in the ONS155xx_Circuit_CC_Tbl.
ONS155XX_GRANULAR_CC_DBID_SEQ	Used for NE-specific cross-connects in the ONS155xx_Granular_CC_Tbl.
ONS155XX_PATH_DBID_SEQ	Used for the ONS155xx_Path_Tbl.
QOSTEMPLATEID_SEQ	Used to generate a QoS template ID when a new QoS template is added.
SERVER_PARAMETER_SEQ	Used as parameter index in Server_Parameter_Table.
SID_SEQ	Used to generate a service ID when a service is added.
SUBNETID_SEQ	Used when adding a subnetwork to the Subnetwork_Table.
SYSLOG_MESSAGE_ID_SEQ	Used when a syslog message is added to Syslog_Message_Table.
TASKID_SEQ	Used when a task is added to the Admin_Job_Table.
TEMPLATE_DATA_ID_SEQ	Generates a sequential Primary Key ID (PKID) for each variable value added to the Template_Job_Data_Table.
TEMPLATE_JOB_DATA_ID_SEQ	Generates a sequential PKID for each variable added to the Template_Data_Table.
TEMPLATE_JOB_ID_SEQ	Used when a job is added to the Template_Job_Table.
TEMPLATE_ID_SEQ	Used when a template is added to the Template_Table.
TRANSID_SEQ	Used when adding a transaction to the NE_SWIMAGE_Table.
USERID_SEQ	Used when CTM users are added to the User_Table.
USERTYPEID_SEQ	Used when a new usertype is added to the User_Type_Table.

1.2  CTM Tables (Non-MGX Voice Gateway)

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

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

---

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

•ONS 1530x PM tables

•ONS 15454 PM tables

•ONS 155xx PM tables

•ONS 15600 PM tables

•ONS 158xx PM tables

---

1.2.1  Ack_Table

The Ack_Table provides information about the user who acknowledged an alarm and the time that the alarm was acknowledged.

Primary key: ALARM_ACK_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-2 Ack_Table  

Column Name	Oracle Data Type	Integrity Constraints	Description
AckIndex	NUMBER(10)	—	Index of the alarm acknowledgement. A unique sequence number whose value is saved in the database and incremented in memory. There is a single value of 0 for all unacknowledged alarms. Acknowledged alarms have an entry in this table and the AckIndex is stored in the AckIndex of the Active_Alarm_Table. Values are: 0: Unacknowledged Any other number: Acknowledged -1: Automatic Acknowledge
AckUserName	VARCHAR2(64)	—	Name of the user.
AckTimeStamp	DATE	—	Date and time of the acknowledgement.
IsAutoAck	NUMBER(1)	—	Whether acknowledgment is manual or automatic: 0: Manual 1: Automatic

1.2.2  Active_Alarm_Table

The Active_Alarm_Table contains information about all standing conditions on NEs.

---

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

---

Primary key: ACTIVE_ALARM_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-3 Active_Alarm_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBAccessID	NUMBER(10)	NOT NULL	ID to access this table for an NE; same as NEDBAccessID in the NE_Info_Table.
AlarmSeqNum	NUMBER(20)	NOT NULL	Unique sequence number of the alarm as referenced by the NE.
ModuleOrIfIndex	NUMBER(20)	NOT NULL	Unique long data type that identifies an interface in the NE; same as ifStaticIndex in the Interface_Table.
ActiveAlarmTimeStamp	DATE	NOT NULL	Date and time when the active alarm was generated.
ActiveAlarmType	NUMBER(5)	NOT NULL	Alarm event type. Values are rows of the Alarm_Event_Type_Enum_Table.
ActiveAlarmSeverity	NUMBER(1)	NOT NULL	Severity level of the alarm. Values are: 3: Not alarmed 4: Warning 5: Minor 6: Major 7: Critical
ActiveAlarmServEff	NUMBER(1)	NOT NULL	Values are: 0: Alarm does not affect service 1: Alarm affects service 2: Unknown
ActiveAlarmAdditionalInfo	VARCHAR2(512)	—	Additional information about the current alarm.
AckIndex	NUMBER(10)	NOT NULL	Index of the alarm acknowledgement.
ActiveAlarmFlag	NUMBER(1)	DEFAULT 0	Active alarm flag, which the server uses to synchronize the database to the NE information.
ActiveAlarmComment	VARCHAR2(2014)	—	Alarm comments.
ClearAlarmTimeStamp	DATE	DEFAULT NULL	Date and time when the alarm was cleared.
NEAlarmTimeStamp	DATE	NOT NULL	Date and time when the alarm was generated as viewed by the NE.
ActiveAlarmIndex	NUMBER(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	Indiactes whether an alarm is active or clear. Values are: 0: Active 1: Clear
NEAlarmClearTimeStamp	DATE	—	When the NE alarm was cleared.
ExternalCondition	VARCHAR2(1024)	—	External environment condition for the NEs.
ModelType	NUMBER(10)	DEFAULT 0	Model type.
ObjectType	NUMBER(10)	DEFAULT 0	Object type.
StrObjectInstance	VARCHAR2(256)	—	StrObjInstance name.
Direction	VARCHAR2(8)	DEFAULT NULL	TL1 direction.
Location	VARCHAR2(4)	DEFAULT NULL	TL1 location.

1.2.3  Additional_Device_Info

The Additional_Device_Info contains information on additional devices.

Primary key: ADDITIONAL_DEVICE_INFO

Tablespace: BASE_DATA_TABLESPACE

Table 1-4 Additional_Device_Info 

Column Name	Oracle Data Type	Integrity Constraints	Description
DeviceID	NUMBER(10)	NOT NULL	Unique ID generated by the database.
NEDBAccessID	NUMBER(10)	NOT NULL	ID to access the Additional_Device_Info table; same as NEDBAccessID in the NE_Info_Table.
PhyLoc	NUMBER(20)	NOT NULL	Physical location of the card.
ModuleType	NUMBER(8)	NOT NULL	Module type of the additional device.
IpAddress	NUMBER(10)	—	IP address of the additional device.
State	NUMBER(1)	NOT NULL	State of the additional device. Values are: 1: Device In Service 2: Device Out of Service 3: Device Preprovisioned 4: Device Under Maintenance
isConnected	NUMBER(1)	NOT NULL	Values are: 0: Unreachable 1: Device is reachable from CTM server
DiscoveryState	NUMBER(1)	—	Device discovery state. Values are: 1: Device undiscovered 2: Device Initializing 3: Device synchronization configuration 4: Device discovered

1.2.4  Admin_Job_Table

The Admin_Job_Table contains information about all administrative tasks and their status.

Primary key: ADMIN_JOB_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-5 Admin_Job_Table 

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

1.2.5  Alarm_Ack_Config_Table

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

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-6 Alarm_Ack_Config_Table 

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

1.2.6  Alarm_Count_Table

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

Primary key: ALARM_COUNT_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-7 Alarm_Count_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBAccessID	NUMBER(10)	NOT NULL	ID to access this table for an NE; same as NEDBAccessID in the NE_Info_Table.
AlarmCountType	NUMBER(1)	NOT NULL	Alarm count type. Values are: 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 are: 0: Alarm does not affect service 1: Alarm affects service 2: Unknown
OtherInfo	VARCHAR2(512)	DEFAULT Not applicable	Display string of alarm or event.
ModuleType	NUMBER(8)	DEFAULT 0	Module type.
PhysicalLoc	NUMBER(20)	DEFAULT 0	Physical location.
NEEventTimeStamp	DATE	NOT NULL	Time stamp of the NE event.
ModelType	NUMBER(10)	DEFAULT 0	Model type.
ObjectType	NUMBER(10)	DEFAULT 0	Model type.
StrObjInstance	VARCHAR2(256)	—	StrObjInstance name.
Direction	VARCHAR2(8)	DEFAULT NULL	TL1 direction.
Location	VARCHAR2(4)	DEFAULT NULL	TL1 location.

1.2.9  Alarm_Event_Type_ENUM_Table

The Alarm_Event_Type_ENUM_Table statically maps alarm and event type indexes to strings.

Primary key: ALARM_EVENT_TYPE_ENUM_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-10 Alarm_Event_Type_ENUM_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
EnumIndex	NUMBER(5)	—	Index of alarm or event type.
EnumString	VARCHAR2(128)	—	Alarm or event type string for the EnumIndex.
TL1String	VARCHAR2(64)	—	Transaction language 1 (TL1) string for the alarm.
TMFString	VARCHAR2(64)	DEFAULT UNIDENTIFIED	TMF mapping string for the alarm
EventType	NUMBER(1)	DEFAULT 1	Type of event. Values are: 1: NE_ALARM 2: NE_EVENT 3: EMS_EVENT 4: EMS_ALARM

1.2.10  APC_Domain_Table

The APC_Domain_Table contains information about the adjacent point code (APC) domains.

Primary Key: APC_DOMAIN_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-11 APC_Domain_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBAccessID	NUMBER(10)	NOT NULL	NEDBAccessID in NE_INFO_TABLE.
SideOut	NUMBER(10)	DEFAULT 0	ID of the outgoing side.
ApcState	NUMBER(10)	DEFAULT 0	APC state.
ApcAdminState	NUMBER(10)	DEFAULT 0	APC admin state.
Sides	VARCHAR2(1000)	—	All sides of the domain. This is a string of separated sides. Each side is defined by NEDBAccessID, SideIn, SideOut. SideOut is not defined for the last side of a domain. NEDBAccessID and SideOut of the first side are not stored in this column; so this column may contain nothing for a domain which does not have any sides; for example, "2 2 3,4 3 2,3 4."

1.2.11  APS_Group_Table

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

Primary key: APS_GROUP_PK

Tablespace: ONS155XX_DATA_TABLESPACE

Table 1-12 APS_Group_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBAccessID	NUMBER(10)	NOT NULL	Specific NE instance; same as NEDBAccessID in the NE_Info_Table.
GroupName	VARCHAR2(64)	NOT NULL	Group name for APS.
ConfigMode	NUMBER(2)	DEFAULT 1	APS group architecture. Values are: 1: 1+1 2: 1:N 3: 1+1 compatible 4: 1+1 optimized
ConfigRevert	NUMBER(2)	DEFAULT 1	Revertive mode. Values are: 1: Nonrevertive 2: Revertive
ConfigDirection	NUMBER(2)	DEFAULT 1	Direction. Values are: 1: Unidirectional 2: Bidirectional
ConfigCreationTime	DATE	—	Time when this group was created.
ConfigSpan	NUMBER(2)	DEFAULT 1	Type of span. Values are: 1: Hop-by-hop 2: End-to-end
ProtectionType	NUMBER(2)	DEFAULT 1	Type of protection. Values are: 1: None 2: Splitter 3: Y-cable 4: Trunk
YCableConfig	NUMBER(2)	DEFAULT 1	Y-cable configuration if y-cable protection is used. Values are: 1: Not y-cable 2: Y-cable 3: Y-cable cross-connect common
SwitchedChannelStatus	NUMBER(2)	DEFAULT 0	Protection channel number.

1.2.12  Audit_Log_Mapping_Table

The Audit_Log_Mapping_Table contains information about audit log mapping.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-13 Audit_Log_Mapping_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
UserType	NUMBER(10)	—	Defines whether user type is Service or User.
ActualName	VARCHAR(256)	—	Name agreed upon by client and server.
CurrentName	VARCHAR(256)	—	Name currently used by the server.

1.2.13  Audit_Log_Table

The Audit_Log_Table is obsolete.

1.2.14  BLSR_Node

The BLSR_Node contains information about the BLSR node.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-14 BLSR_Node 

Column Name	Oracle Data Type	Integrity Constraints	Description
BLSRID	NUMBER(8)	NOT NULL	BLSR ID.
RINGID	VARCHAR(8)	NOT NULL	Ring ID.
NODEID	NUMBER(8)	NOT NULL	Node ID.
RINGNODEID	NUMBER(8)	NOT NULL	Ring node ID.

1.2.15  BLSR_Span

The BLSR_Span contains information about the BLSR span.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-15 BLSR_Span 

Column Name	Oracle Data Type	Integrity Constraints	Description
BLSRID	NUMBER(8)	NOT NULL	BLSR ID.
RINGID	VARCHAR(8)	NOT NULL	Ring ID.
LINKID	NUMBER(8)	NOT NULL	Link ID.
WORKINGSPAN	NUMBER(1)	NOT NULL	Working span.
WESTNODEID	NUMBER(10)	NOT NULL	Node ID of the BLSR (west line).
EASTNODEID	NUMBER(10)	NOT NULL	Node ID of the BLSR (east line).

1.2.16  BLSR_Table

The BLSR_Table contains information about BLSRs.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-16 BLSR_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
BLSRID	NUMBER(8)	NOT NULL	BLSR ID.
RINGID	VARCHAR(8)	NOT NULL	Ring ID.
RINGTYPE	NUMBER(2)	NOT NULL	Ring type.
LINERATE	NUMBER(2)	NOT NULL	Line rate.
STATUS	VARCHAR2(12)	NOT NULL	Ring status.
RINGREVERSION	NUMBER(8, 2)	NOT NULL	Ring reversion time.
SPANREVERSION	NUMBER(8, 2)	NOT NULL	Span reversion time.
NODES	VARCHAR2(512)	NOT NULL	Nodes associated with the ring.

1.2.17  Bridge_Group_Table

The Bridge_Group_Table contains information about the bridge group table.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-17 Bridge_Group_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
TopoNodeID	NUMBER(10)	NOT NULL	Node ID of the source node of the circuit.
TopoUniqueId	NUMBER(10)	NOT NULL	Unique number within the node.
Vlan_Number	NUMBER(10)	NOT NULL	Unique number to identify the VLAN.
NEID	NUMBER(10)	NOT NULL	NE ID.
Slot_Number	NUMBER(3)	NOT NULL	Slot number.
Bridge_Group_Number	NUMBER(3)	NOT NULL	Bridge group number.
BRIDGE_PROTOCOL	VARCHAR2(30)	—	—

1.2.18  C_MetaData

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

---

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

---

Primary key: C_METADATA_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-18 C_MetaData 

Column Name	Oracle Data Type	Integrity Constraints	Description
TableID	NUMBER(4)	NOT NULL	Unique ID for each GUI table metadata.
TableName	VARCHAR2(30)	NOT NULL	Name of the table.
TableJDAQName	VARCHAR2(128)	—	JDAQ name.
TableType	NUMBER(1)	—	Title of table frame. Values are FM (fault management), PM (performance management), CM (configuration management), and other.
Title	VARCHAR2(132)	—	Title of the table.
Report	VARCHAR2(132)	—	String used as the name of the HTML report.
ReportFile	VARCHAR2(132)	—	String used as a filename when the HTML report is generated.
TitleIconStr	VARCHAR2(132)	—	Filename of the .gif file that appears in the upper-left corner of the table frame.
Help	VARCHAR2(132)	—	Help button on the table frame.
HelpStrFilterDlg	VARCHAR2(132)	—	Help button on the filter dialog box.
DbColCount	NUMBER(3)	—	Count of the number of columns in the database table or view.
TCAColIndex	NUMBER(3)	—	Index number of the threshold crossing alert (TCA). Number is usually -1, except for the PM tables where it is the index of the TCAColumn used to color the background of the cells in red.
DefSortCol	NUMBER(3)	—	Index of the default column. The table is presorted when it is launched the first time.
FilterMask	NUMBER(10)	—	Bit mask that contains bits for each tab in the filter dialog box.
AutoRef	NUMBER(1)	—	AutoRefresh = true if the table is updated automatically when an event occurs. AutoRefresh = false if the table is not updated automatically when an event occurs.
DispRowCount	NUMBER(3)	—	Total number of rows in the main table.
ColDispRow	NUMBER(3)	—	Total number of rows in the vertical table.
ColCount	NUMBER(3)	—	Total number of columns in the table.
BtnMask	NUMBER(20)	—	Bit mask that contains bits for each GUI table toolbar and for menu bar buttons.
NeDbaccessidcolindb	NUMBER(3)	DEFAULT -1	Database column index of the NEDBAccessId column in the respective view or table.

1.2.19  C_MetaData_Attr_Presentation

The C_MetaData_Attr_Presentation table stores information about ONS 15327 and ONS 15454 attributes. This information is used to lay out the property sheets in the NE Explorer.

Primary key: C_METADATA_ATTR_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-19 C_MetaData_Attr_Presentation 

Column Name	Oracle Data Type	Integrity Constraints	Description
METADATAINDEX	NUMBER(5)	NOT NULL	Metadata index of the event.
ATTRINDEX	NUMBER(5)	NOT NULL	Index of attribute.
WIDGET_ID	NUMBER(2)	NOT NULL	Values taken by widget IDs are: 0: Default value 1: Text field 2: Password field 3: Subnet mask 4: IP address 5: Timing Communications and Control Card (TCC) Common Object Request Broker Architecture (CORBA) port 6: List
WIDGET_ID (continued)	NUMBER(2)	NOT NULL	7: Check box 8: Combo box 9: Buttons 10: Combo text field 11: Button group 12: Dynamic combo box 13: ENUM check box 14: Number field 15: Time field 16: Dynamic ENUM combo box 17: Time zone combo box 18: Soak time 19: Pattern text field 20: Spin editor 21: Fixed length string 22: Editor pane 23: Text area 24: Double spin editor 25: Slider 26: Letter or digit text field 27: Area ID text field 28: ENUM text field 29: Dynamic generic combo box 30: Hexadecimal field 99: Adjacent text fields

1.2.20  C_MetaData_Col

The C_MetaData_Col table stores overall information about all of the columns in the CTM GUI.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-20 C_MetaData_Col 

Column Name	Oracle Data Type	Integrity Constraints	Description
TableID	NUMBER(4)	NOT NULL	ID in the parent table (C_MetaData).
ColName	VARCHAR2(50)	—	String used for the table header.
ColHeaderTip	VARCHAR2(350)	—	String used when you point your mouse over a column header.
ColWidth	NUMBER(4)	—	Width (in pixels) of the table column.
DisplayOrder	NUMBER(3)	—	Order in which the columns are displayed.
Sortable	NUMBER(1)	—	Specifies whether the table column is sortable.
Editable	NUMBER(1)	—	Specifies whether the cells in the column are editable.
DbColIndex	NUMBER(3)	—	Actual database column index for this GUI table column.
ClassName	VARCHAR2(128)	—	Renderer class used for the column.
FilterCol	NUMBER(3)	—	Specifies which columns are filterable.
SortColInDB	NUMBER(3)	—	Actual database column index used for sorting this GUI table column.
Renderer	VARCHAR2(128)	—	Used to display an icon instead of a value.
ColEnumBases	NUMBER(3)	—	Used to interpret the values from the database.
ColTCABitIndex	NUMBER(3)	—	Used for PM tables that have a TCA value.
ColSortOrder	NUMBER(1)	—	True if ascending; false if descending.
IsPhysicallocCol	NUMBER(1)	DEFAULT 0	Identifies a column as a physical location column.
IsInterfaceCol	NUMBER(1)	DEFAULT 0	Identifies a column as a logical interface location column.
IsTimestampCol	NUMBER(1)	DEFAULT 0	Identifies a column as a time stamp column.
IDENTIFIER	VARCHAR2(1000)	—	Identifies whether or not a particular column is graphable.

1.2.21  C_MetaData_Col_Custom

The C_MetaData_Col_Custom table contains the customized columns that users have selected for display in the CTM GUI.

Primary key: C_METADATA_COL_CUSTOM_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-21 C_MetaData_Col_Custom 

Column Name	Oracle Data Type	Integrity Constraints	Description
ViewID	NUMBER(4)	NOT NULL	Identifier of the customized view.
ColName	VARCHAR(50)	NOT NULL	Column name.
ColWidth	NUMBER(4)	NOT NULL	Column width.
DisplayOrder	NUMBER(3)	NOT NULL	Display order.
IsHidden	NUMBER(1)	NOT NULL	Values when column has to be displayed. Values are: 0: Hidden 1: Visible

1.2.22  C_MetaData_Filter

The C_MetaData_Filter table stores overall information about all the filters in the CTM GUI.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-22 C_MetaData_Filter 

Column Name	Oracle Data Type	Integrity Constraints	Description
TableID	NUMBER(4)	NOT NULL	ID in the parent table (C_MetaData).
FilterCols	NUMBER(3)	—	Index of a filterable column.
InitialFilterCols	NUMBER(3)	—	Index of a filterable column if this column is used in the initial filter. The value is -1 if it is not used in the initial filter.
DisplayOrder	NUMBER(3)	—	Order in which the columns are displayed.

1.2.23  C_MetaData_Grp_Presentation

The C_MetaData_Grp_Presentation table stores group information about ONS 15327 and ONS 15454. This information is used to lay out group attributes in NE Explorer property sheets.

Primary key: C_METADATA_GRP_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-23 C_MetaData_Grp_Presentation 

Column Name	Oracle Data Type	Integrity Constraints	Description
METADATAINDEX	NUMBER(5)	NOT NULL	Foreign key from ObjectAttributeTable.
GROUPINDEX	NUMBER(5)	NOT NULL	Attribute group.
PARENTINDEX	NUMBER(5)	NOT NULL	Parent group index.
NAME	VARCHAR2(32)	—	Group name.
DISPLAYTEXT	VARCHAR2(256)	—	User interface (UI) display text used as border text in a panel.
ATTRCLASS	NUMBER(4)	—	Not used (reserved for future use).
ATTRTYPE	NUMBER(4)	—	Not used (reserved for future use).
ENUMVAL	VARCHAR2(1024)	—	List of AATRIDs from ObjectAttributeTable that are children of this group. The IDs are separated by vertical bars (|).
ATTRGROUP	NUMBER(3)	—	User interface panel type.

1.2.24  C_MetaData_NETypes

The C_MetaData_NETypes table stores information about the supported NE types for the table identified in the C_MetaData table.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-24 C_MetaData_NETypes 

Column Name	Oracle Data Type	Integrity Constraints	Description
TableID	NUMBER(4)	NOT NULL	ID in the parent table (C_MetaData).
NETypes	VARCHAR2(15)	—	Models supported by this table.
DisplayOrder	NUMBER(3)	—	Order in which the columns are displayed.

1.2.25  C_Property_Sheet_Info_Table

The C_Property_Sheet_Info_Table stores metadata information about the various CTM property sheets.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-25 C_Property_Sheet_Info_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
ModelIndex	NUMBER(4)	—	NE model index. Number in this column corresponds to a number in the Version_Table.
PropSheetIndex	NUMBER(4)	—	Number to identify a specific property sheet in the NE specified by the ModelIndex.
TabIndex	NUMBER(5)	—	Number to identify a tab in the property sheet. This number refers to TabIndex in the C_Tab_Metadata_Table.
TabPosition	NUMBER(2)	—	Number to identify the position of the tab in the property sheet.

1.2.26  C_Tab_Metadata_Info_Table

The C_Tab_Metadata_Info_Table stores information about the relationship between the tabs and subtabs in the CTM property sheets.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-26 C_Tab_Metadata_Info_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
TabIndex	NUMBER(5)	—	Number to identify a tab on the property sheet.
SubtabIndex	NUMBER(5)	—	Number to identify a subtab in the tab corresponding to the TabIndex.
SubtabPosition	NUMBER(2)	—	Number to identify the subtab position.

1.2.27  C_Tab_Metadata_Table

The C_Tab_Metadata_Table stores information about the tabs in the CTM property sheets.

Primary key: C_TAB_METADATA_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-27 C_Tab_Metadata_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
TabIndex	NUMBER(5)	UNIQUE	Number to identify the tab on a property sheet.
TabName	VARCHAR2(200)	—	Name of the tab.
TabDataObjects	VARCHAR2(512)	—	Stores a list of data objects represented on the tab. The data objects in the list are separated by vertical bars (|). Each data object contains the following values, separated by a colon: ObjectIndex:MetaDataGroupIndex:GroupName:editable
Description	VARCHAR2(512)	—	Comment field.
OperationId	VARCHAR2(128)	—	Key that is cross-referenced in the user's security profile, which stores the user's access for this tab.

1.2.28  Chanfr_Conn_Data

Primary Key: None

Tablespace: MGX8880_DATA_TABLESPACE

Table 1-28 Chanfr_Conn_Data 

Column Name	Oracle Data Type
timestamp	NUMBER(10)
l_node_id	NUMBER(10)
l_slot	NUMBER(5)
l_dlci	NUMBER(5)
l_channel	NUMBER(5)
subobject_type	NUMBER(5)
stat_type	NUMBER(5)
bucket_type	NUMBER(5)
totald	NUMBER(22,2)
peak	NUMBER(22,2)

1.2.29  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-29 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.30  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-30 Circuit_BS_Tbl 

Column Name	Oracle Data Type	Integrity Constraints	Description
CktNodeId	NUMBER(10)	NOT NULL	Node ID of the source node of the circuit.
CktUniqueId	NUMBER(10)	NOT NULL	Unique number within each source node. The CktNodeId and CktUniqueId combine to form a circuit ID that is unique in the network. Note that these are internal fields and should not be displayed.
CktName	VARCHAR2(64)	—	Name of the circuit.
CktDescription	VARCHAR2(256)	—	Description of the circuit.
CustomerId	VARCHAR2(256)	—	Customer ID.
ServiceId	VARCHAR2(256)	—	Service ID.
CktType	NUMBER(2)	—	Type of circuit. Values are: 0: ETHERNET 1: STS_CIRCUIT 2: VT_CIRCUIT 3: VT_TUNNEL 4: VT_AGGREGATION 5: STS_VCAT_CIRCUIT 6: VT_VCAT_CIRCUIT 7: GIGABIT_ETHERNET 8: TENGIGABIT_ETHERNET 9: FIBERCHANNEL 10: FICON 11: ESCON 12: SDH_CIRCUIT 13: ISC_COMPATIBLE 14: ISC_PEER 15: SYSPLEX 16: DWDM_TRANSPARENT_ANY
CktType (continued)	NUMBER(2)	—	17: VC_HO_PATH_CIRCUIT 18: VC_LO_PATH_CIRCUIT 19: VC_LO_PATH_TUNNEL 20: VC_LO_PATH_AGGREGATION 21: VC_HO_VCAT_CIRCUIT 22: VC_LO_VCAT_CIRCUIT 23: DWDM_WAVELENGTH 24: FAST_ETHERNET 25: FDDI 26: SYSPLEX_TIMER_ETR 27: SYSPLEX_TIMER_CLO 28: TENGIGABIT_ETHERNET_WAVELENGTH 29: POINT5GIGABIT_ETHERNET_WAVELENGTH 30: TENGIGABIT_ETHERNET_TRUNK 31: SONET_CIRCUIT 32: OCHNC_CIRCUIT 33: TWO_GIGABIT_ETHERNET 34: E1_CIRCUIT 35: T1 CIRCUIT 36: DVB_CIRCUIT 37: SDI_CIRCUIT 38: OCHCC_CIRCUIT 39: OCHTRAIL_TUNNEL_CIRCUIT
CktSize	NUMBER(2)	—	Size of circuit. Values are: 0: VT1_5 1: 1 = STS1 2: STS3C 3: STS6C 4: STS9C 5: STS12C 6: STS24C 7: STS48C 8: STS192C 9: TS768C 10: DWDM_2POINT5G 11: DWDM_10G 12: VC_11 13: VC_12 14: VC_3 15: VC_4 16: VC_4_2C 17: VC_4_3C 18: VC_4_4C 19: VC_4_8C 20: VC_4_16C 21: VC_4_64C 22: FIBERCHANNEL1 23: FIBERCHANNEL2 24: FICON 25: ESCON 26: SYSPLEX 27: FAST_ETHERNET 28: GIGABIT_ETHERNET 29: TENGIGABIT_ETHERNET 30: VT_2
CktSize (continued)	NUMBER(2)	—	31: FDDI 32: OCHNC_NOTEQUIPPED 33: OCHNC_MULTIRATE 34: OCHNC_2_5G_FEC 35: OCHNC_2_5G_NOFEC 36: OCHNC_10G_FEC 37: OCHNC_10G_NOFEC 38: STS36C 39: VC_4_12C 40: STS18C 41: VC_4_6C 42: STM1C 43: STM4C 44: STM16C 45: STM64C 46: ISC_COMPATIBLE 47: ISC_PEER 48: SYSPLEX_TIMER_ETR 49: SYSPLEX_TIMER_CLO 50: TWO_GIGABIT_ETHERNET 51: E1 52: T1 53: DVB 54: SDI 55: OCHCC_OC_192 56: OCHCC_OC_48 57: OCHCC_OC_12 58: OCHCC_OC_3 59: OCHCC_10_GE 60: OCHCC_1_GE 61: OCHCC_10_GFC 62: OCHCC_4_GFC 63: OCHCC_2_GFC
CktSize (continued)	NUMBER(2)	—	64: OCHCC_1_GFC 65: OCHCC_4_GFICON 66: OCHCC_2_GFICON 67: OCHCC_1_GFICON 68: OCHCC_ESCON 69: OCHCC_ETR_CLO 70: OCHCC_ISC_PEER 71: OCHCC_ISC3_PEER_1G 72: OCHCC_ISC3_PEER2G 73: OCHCC_ISC_COMPAT 74: OCHCC_HVDT 75: OCHCC_SD1_D1 76: OCHCC_DV_6000 77: OCHCC_PASS_THROUGH 78: OCHCC_OC_768 79: STS96C 80: VC_4_32C 81: OCHCC_STM_256
CktDirection	NUMBER(1)	—	Type of traffic that the circuit carries. Values are: 0: Unidirectional 1: Bidirectional
CktIsMonitor	NUMBER(1)	—	Whether the circuit is a monitor circuit. Values are: 0: False 1: True
CktState	NUMBER(2)	—	State of the circuit. Values are: 0: CREATING 1: ACTIVE 2: DELETING 3: DROP_PENDING 4: INCOMPLETE 5: UPGRADABLE 6: INCOMPLETE_UPGRADABLE 7: ERRORED 8: NOT_UPGRADABLE 9: INCOMPLETE_NOT_UPGRADABLE 10: ROLL_PENDING 11: NOT_ACTIVATED 12: NOT ACTIVE. A circuit assumes this temporary state during an NE service restart, or after a circuit removal on an entry that will be removed later. This state also applies to circuits that no longer exist.
CktEnhancedState	NUMBER(2)	—	Administrative state of the circuit.
CktProtectionType	NUMBER(2)	—	Circuit protection type.
CktAdditionalInfo	VARCHAR2(64)	—	Additional information about the circuits.
cktComment	VARCHAR2(2014)	—	—
CktUseLap	NUMBER(1)	—	Whether the circuit uses LAP. Values are: 0: False 1: True
CktOchncChannel	NUMBER(3)	—	Values are: 0: NOT_APPLICABLE 1: OCHNC_30_33 2: OCHNC_31_12 3: OCHNC_31_90 4: OCHNC_32_68 5: OCHNC_34_25 6: OCHNC_35_04 7: OCHNC_35_82 8: OCHNC_36_61 9: OCHNC_38_19 10: OCHNC_38_98 11: OCHNC_39_77 12: OCHNC_40_56 13: OCHNC_42_14 14: OCHNC_42_94 15: OCHNC_43_73 16: OCHNC_44_53 17: OCHNC_46_12 18: OCHNC_46_92 19: OCHNC_47_72 20: FALSE OCHNC_48_51 21: FALSE OCHNC_50_12 22: OCHNC_50_92 23: OCHNC_51_72 24: MANUAL OCHNC_52_52 25: OCHNC_54_13 26: OCHNC_54_94 27: OCHNC_55_75 28: OCHNC_56_55 29: OCHNC_58_17 30: CHNC_58_98 31: OCHNC_59_79 32: OCHNC_60_61
CktOchncChannel (continued)	NUMBER(3)	—	33: OCHCC_77_44 34: OCHCC_77_86 35: OCHCC_78_27 36: OCHCC_78_69 37: OCHCC_79_10 38: OCHCC_79_52 39: OCHCC_79_93 40: OCHCC_80_35 41: OCHCC_80_77 42: OCHCC_81_18 43: OCHCC_81_60 44: OCHCC_82_02 45: OCHCC_82_44 46: OCHCC_82_85 47: OCHCC_83_27 48: OCHCC_83_69 49: OCHCC_84_11 50: OCHCC_84_53 51: OCHCC_84_95 52: OCHCC_85_36 53: OCHCC_85_78 54: OCHCC_86_20 55: OCHCC_86_62 56: OCHCC_87_04 57: OCHCC_87_46 58: OCHCC_87_88 59: OCHCC_88_30 60: OCHCC_88_73 61: OCHCC_89_15 62: OCHCC_89_57 63: OCHCC_89_99 64: OCHCC_90_41 65: OCHCC_90_83
CktOchncChannel (continued)	NUMBER(3)	—	66: OCHCC_91_26 67: OCHCC_91_68 68: OCHCC_92_10 69: OCHCC_92_52 70: OCHCC_92_95 71: OCHCC_93_37 72: OCHCC_93_79 73: WV_1310 74: WV_1550 75: WV_1470 76: WV_1490 77: WV_1510 78: WV_1530 79: WV_1570 80: WV_1590 81: WV_1610 82: OCHCC_29_55 83: OCHCC_29_94 84: OCHCC_30_73 85: OCHCC_31_51 86: OCHCC_32_29 87: OCHCC_33_07 88: OCHCC_33_47 89: OCHCC_33_86 90: OCHCC_34_64 91: OCHCC_35_43 92: OCHCC_36_22 93: OCHCC_37_00 94: OCHCC_37_40 95: OCHCC_37_79 96: OCHCC_38_58 97: OCHCC_39_37 98: OCHCC_40_16 99: OCHCC_40_95
CktOchncChannel (continued)	NUMBER(3)	—	100: OCHCC_41_35 101: OCHCC_41_75 102: OCHCC_42_54 103: OCHCC_43_33 104: OCHCC_44_13 105: OCHCC_44_92 106: OCHCC_45_32 107: OCHCC_45_72 108: OCHCC_46_52 109: OCHCC_47_32 110: OCHCC_48_12 111: OCHCC_48_92 112: OCHCC_49_32 113: OCHCC_49_71 114: OCHCC_50_52 115: OCHCC_51_32 116: OCHCC_52_12 117: OCHCC_52_93 118: OCHCC_53_33 119: OCHCC_53_73 120: OCHCC_54_54 121: OCHCC_55_34 122: OCHCC_56_15 123: OCHCC_56_96 124: OCHCC_57_36 125: OCHCC_57_77 126: OCHCC_58_58 127: OCHCC_59_39 128: OCHCC_60_20 129: OCHCC_61_01 130: OCHCC_70_83 131: OCHCC_71_24 132: OCHCC_71_65 133: OCHCC_72_06
CktOchncChannel (continued)	NUMBER(3)	—	134: OCHCC_72_48 135: OCHCC_72_89 136: OCHCC_73_30 137: OCHCC_73_71 138: OCHCC_74_13 139: OCHCC_74_54 140: OCHCC_74_95 141: OCHCC_75_37 142: OCHCC_75_78 143: OCHCC_76_20 144: OCHCC_76_61 145: OCHCC_77_03 146: OCHCC_94_22 147: OCHCC_94_64 148: OCHCC_95_06 149: OCHCC_95_49 150: OCHCC_95_91 151: OCHCC_96_34 152: OCHCC_96_76 153: OCHCC_97_19 154: OCHCC_97_62 155: OCHCC_98_04 156: OCHCC_98_47 157: OCHCC_98_89 158: OCHCC_99_32 159: OCHCC_99_75 160: OCHCC_00_17 161: OCHCC_00_60 162: OCHCC_01_03 163: OCHCC_01_46 164: OCHCC_01_88 165: OCHCC_02_31 166: OCHCC_02_74 167: OCHCC_03_17
CktOchncChannel (continued)	NUMBER(3)	—	168: OCHCC_03_60 169: OCHCC_04_03 170: OCHCC_61_42 171: OCHCC_61_83 172: WV_850_00
CktOchncDir	NUMBER(1)	—	Direction of the OCHNC circuit. Values are: 0: East-to-west 1: West-to-east 2: Not applicable
isDuplicateName	NUMBER(1)	DEFAULT 1	Whether or not the circuit has a duplicate name. Values are: 0: Duplicate 1: Not duplicate
NPID	NUMBER(10)	—	Network partition ID to which the subnetwork belongs.
CktAliasName	VARCHAR2(64)	—	Circuit alias name.

1.2.31  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-31 Circuit_Ctp_Tbl 

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

1.2.32  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-32 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.33  Circuit_Size_Table

The Circuit_Size_Table contains information about the circuit sizes.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-33 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.34  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-34 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.35  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-35 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.36  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-36 Circuit_Tbl 

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

1.2.37  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-37 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.38  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-38 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.39  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-39 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.40  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-40 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.41  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-41 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.42  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-42 CORBA_Interface_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
InterfaceIndex	NUMBER(10)	NOT NULL	Index used for mapping of operations.
InterfaceName	VARCHAR(32)	NOT NULL	Name of the interface.
AdditionalPermissions	NUMBER(1)	NOT NULL	Type of interface. Values are: 0: No permissions 1: All read 2: All write
HelperClass	VARCHAR(128)	NOT NULL	Helper class name used to get the repository ID.
BaseInterface	NUMBER(10	NOT NULL	Base interface.

1.2.43  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-43 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.44  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-44 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.45  CTC_UserProfile_Table

The CTC_UserProfile_Table contains information about CTC user profiles.

Primary key: CTC_USR_PROF_TABLE_PK

Tablespace: None

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

The CTM_Config_Table stores CTM configuration information. For detailed definitions of the parameters in this table, see Appendix B, "Ctm_Config_Table Parameters."

Primary key: ctm_config_table_pk

Tablespace: BASE_DATA_TABLESPACE

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

The CTM_Unknown_User_Table contains information about login attempts by unknown CTM users.

Primary key: CTM_Unknown_USER_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-48 CTM_Unknown_User_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
IPAddress	NUMBER(10)	NOT NULL	IP address of the unknown user.
FailedAttempts	NUMBER(2)	DEFAULT 0	Number of login attempts from the unknown user associated with a specific IP address.
LastLoginFailTime	DATE	—	Most recent time when the unknown user attempted to log into the CTM client.
LockedState	NUMBER(1)	DEFAULT 0	Status of the unknown user's account (locked or unlocked). Values are: 0: Not locked 1: Locked

1.2.49  Custom_View_Table

The Custom_View_Table contains the customized views that users have selected for display in the CTM GUI.

Primary key: CUSTOM_VIEW_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-49 Custom_View_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
ViewID	NUMBER(10)	NOT NULL	Unique number created by the database.
UserID	NUMBER(4)	NOT NULL	User identifier.
TableID	NUMBER(4)	NOT NULL	Table identifier.

1.2.50  DB_Pruning_Table

The DB_Pruning_Table contains information about the database pruning table.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-50 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.51  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-51 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.52  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-52 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.53  Deleted_User_Table

The Deleted_User_Table contains information about CTM users that were deleted.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-53 Deleted_User_Table 

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

1.2.54  Diskspace_Usage_Table

The Diskspace_Usage_Table stores information about database disk space usage.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-54 Diskspace_Usage_Table 

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

1.2.55  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-55 Domain_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
TreeNodeID	NUMBER(10)	NOT NULL	Unique sequence number generated by the database. Each node in the Domain Explorer tree is assigned a unique number that is used as an index to access group information in other tables.
ParentType	NUMBER(2)	NOT NULL	Indicates that the parent is a group.
ParentId	NUMBER(10)	NOT NULL	ID of the group.
ChildType	NUMBER(2)	NOT NULL	Type of tree node. Values are: 1: Root node 2: Group node 3: NE node
ChildId	NUMBER(10)	NOT NULL	ID of the group or NE.

1.2.56  Ems_Alarm_Table

The Ems_Alarm_Table shows information about EMS alarms.

Primary key: EMS_ALARM_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-56 Ems_Alarm_Table 

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

1.2.57  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-57 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.58  EQPT_Info_Table

The EQPT_Info_Table stores equipment provisioning information.

Primary key: EQPT_INFO_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-58 EQPT_Info_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEDBACCESSID	NUMBER(10)	NOT NULL	Database access ID; same as NEDBAccessID in the NE_Info_Table.
PHYSICALLOC	NUMBER(20)	NOT NULL	Physical location.
IFINDEX	NUMBER(20)	NOT NULL	Interface index.
MODULETYPE	NUMBER(8)	—	Module type.
OBJECTINDEX	NUMBER(10)	NOT NULL	Metadata object index.
MODELTYPE	NUMBER(4)	NOT NULL	Model type.
COL1	VARCHAR2(256)	—	Columns 1 to 250 store attribute values as defined by the metadata.
COL2	VARCHAR2(256)	—	Columns 1 to 250 store attribute values as defined by the metadata.
COL3	VARCHAR2(256)	—	Columns 1 to 250 store attribute values as defined by the metadata.
COL4	VARCHAR2(256)	—	Columns 1 to 250 store attribute values as defined by the metadata.
COL5	VARCHAR2(256)	—	Columns 1 to 250 store attribute values as defined by the metadata.
...
COL248	VARCHAR2(4000)	—	Columns 1 to 250 store attribute values as defined by the metadata.
COL249	VARCHAR2(4000)	—	Columns 1 to 250 store attribute values as defined by the metadata.
COL250	VARCHAR2(4000)	—	Columns 1 to 250 store attribute values as defined by the metadata.

1.2.59  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-59 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.60  Error_Log_Table

The Error_Log_Table contains information about all errors reported by CTM.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-60 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.61  Forwarding_Table

The Forwarding_Table is obsolete.

1.2.62  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-61 GNE_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
GNEID	NUMBER(8)	NOT NULL	GNE identifier. Unique sequence number generated by the database. This is the link between this table and GNEID in the NE_Info_Table.
GNEType	NUMBER(4)	DEFAULT 1	Values are: 1: Unknown 2: Self 3: ISR_as_GNE 4: Foreign_GNE_TL1 5: Foreign_GNE_CLNP 6: Foreign_GNE_IP
RINGID	NUMBER(8)	—	Identifies the ring to which the NE is connected. NEs with similar RING_IDs are in the same ring.
GNESysId	VARCHAR2(128)	NOT NULL	Name of the GNE.
NextHopIPAddr	NUMBER(10)	NOT NULL	IP address of the next hop used to reach the GNE.
GNEComment	VARCHAR2(512)	—	Comment for the GNE.
GroupOption	NUMBER(1)	DEFAULT 0	Values are: 0: Default grouping 1: Group by GNE 2: Group by Subnet
GroupPrefix	VARCHAR2(12)	—	Group prefix that may be used for group names.
UserID	NUMBER(4)	DEFAULT 0	Value of 0 means no owner.

1.2.63  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-62 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.64  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-63 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.65  IF_Cross_Connect

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

Primary key: None

Tablespace: ONS155XX_DATA_TABLESPACE

Table 1-64 IF_Cross_Connect 

Column Name	Oracle Data Type	Integrity Constraints	Description
XCDBAccessID	NUMBER(10)	NOT NULL	Unique sequence number (can be a foreign key).
NEDBAccessId	NUMBER(10)	NOT NULL	ID to access this table for an NE; same as NEDBAccessID in the NE_Info_Table.
SrcIFDBAccessID	NUMBER(10)	NOT NULL	Source interface endpoint.
DestIFDBAccessID	NUMBER(10)	NOT NULL	Destination interface endpoint.
XCType	NUMBER(2)	DEFAULT 4	Type of switching element used: 1: Unknown 2: Electrical cross-connect 3: Optical cross-connect 4: Autoselect
XCKind	NUMBER(2)	DEFAULT 5	Type of call control to establish cross-connect: 1: Provisioned 2: Automatic 3: Dynamic 4: Protection 5: Other
CreationTime	DATE	—	Time when this cross-connect was created.
Src2DestOperStatus	NUMBER(2)	NOT NULL	Operational state from source to destination: 1: Up 2: Down 3: Dormant 4: Unknown
Dest2SrcOperStatus	NUMBER(2)	NOT NULL	Operational state from destination to source: 1: Up 2: Down 3: Dormant 4: Unknown
Src2DestLastChange	DATE	—	Sysuptime value when the cross-connect in this direction changed its operational state.
Dest2SrcLastChange	DATE	—	Sysuptime value when the cross-connect in this direction changed its operational state.

1.2.66  IF_DWDM_Channel_Group

The IF_DWDM_Channel_Group table contains information about interfaces representing groups of DWDM channels.

Primary key: IF_DWDM_CHAN_FREQ_PK

Tablespace: ONS155XX_DATA_TABLESPACE

Table 1-65 IF_DWDM_Channel_Group 

Column Name	Oracle Data Type	Integrity Constraints	Description
IFDBAccessID	NUMBER(10)	NOT NULL	Reference to IFDBAccessID in the MIB2_Interface_Table.
NEDBAccessID	NUMBER(10)	NOT NULL	ID to access this table for an NE; same as NEDBAccessID in the NE_Info_Table.
MinFrequency	NUMBER(10)	NOT NULL	Lowest frequency in the bitmap for bit 0.
Spacing	NUMBER(4)	NOT NULL	Frequency spacing between successive bits.
BitmapLogic	NUMBER(2)	DEFAULT 1	Whether frequencies in the bitmap are carried or blocked. Values are: 1: Carried 2: Blocked
Bitmap	VARCHAR2(64)	NOT NULL	List of frequencies as a bitmap.

1.2.67  IF_Optical_Phy_Config_Table

The IF_Optical_Phy_Config_Table describes extended physical properties for certain interfaces.

Primary key: IF_OPTICAL_PHY_PK

Tablespace: ONS155XX_DATA_TABLESPACE

Table 1-66 IF_Optical_Phy_Config_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
IFDBAccessID	NUMBER(10)	NOT NULL	Reference to IFDBAccessID in the MIB2_Interface_Table.
NEDBAccessID	NUMBER(10)	NOT NULL	ID to access this table for an NE; same as NEDBAccessID in the NE_Info_Table.
IfMode	NUMBER(2)	DEFAULT 1	Mode of operation. Values are: 1: mode2R 2: mode3R
IfProtocol	NUMBER(2)	DEFAULT 1	Client-side protocol to be monitored. Values are: 1: Other 2: Unknown 3: Gigabit Ethernet 4: 10-Gigabit Ethernet 5: Fiber channel 6: FICON 7: ESCON 8: SONET
IfClockRate	NUMBER(4)	—	Clock rate for client interface.
IfMonitorState	NUMBER(1)	—	Monitor state. Values are: 1: Enabled 2: Disabled
IfLoopback	NUMBER(2)	DEFAULT 1	Loopback status. Values are: 1: No loop 2: Diagnostic loop 3: Line loop 4: Other loop
IfOFC	NUMBER(1)	—	OFC state. Values are: 1: Enabled 2: Disabled
IfLaserSafteyControl	NUMBER(1)	—	Trunk-side laser safety control (LSC) state. Values are: 1: Enabled 2: Disabled
IfFLC	NUMBER(1)	—	State of forward laser control (FLC). Values are: 1: Enabled 2: Disabled

1.2.68  IFIndex_Rule_Table

The IFIndex_Rule_Table contains information on the rules to construct the IfIndex for each object type of an NE model.

Primary key: IFINDEX_RULE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-67 IFIndex_Rule_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
ModelType	NUMBER(10)	NOT NULL	Model type.
ObjectType	NUMBER(10)	NOT NULL	Object type.
AttributeNameConst	NUMBER(10)	NOT NULL	Integer constant of the attribute.
AttrOrder	NUMBER(10)	NOT NULL	Sequential number.
AttrSize	NUMBER(10)	NOT NULL	Size of the attribute in bytes.
AttrType	NUMBER(10)	NOT NULL	Type of the attribute.

1.2.69  Interface_APS_Info

The Interface_APS_Info table contains APS information about interfaces that are members of an APS group.

Primary key: IF_APS_INFO_PK

Tablespace: ONS155XX_DATA_TABLESPACE

Table 1-68 Interface_APS_Info 

Column Name	Oracle Data Type	Integrity Constraints	Description
IFDBAccessID	NUMBER(10)	NOT NULL	Reference to IFDBAccessID in the MIB2_Interface_Table.
NEDBAccessID	NUMBER(10)	NOT NULL	ID to access this table for an NE; same as NEDBAccessID in the NE_Info_Table.
ApsGroupName	VARCHAR2(64)	—	APS group name.
ApsChanNumber	NUMBER(2)	DEFAULT -1	Working or protected channel.
ApsChanStatusCurrent	NUMBER(2)	DEFAULT -1	Current state of interface in the group: 1: Locked out 2: Signal degrade 3: Signal failure 4: Switched
ApsChanLastSwitchover	DATE	—	Time since switch to protection channel.
ApsInterfaceState	NUMBER(2)	DEFAULT -1	Active or standby: -1: Unknown 1: Active 2: Standby

1.2.70  Interface_DWDM_Frequency

The Interface_DWDM_Frequency table contains wavelength information about certain optical interfaces carrying DWDM frequencies.

Primary key: IF_DWDM_FREQ_PK

Tablespace: ONS155XX_DATA_TABLESPACE

Table 1-69 Interface_DWDM_Frequency 

Column Name	Oracle Data Type	Integrity Constraints	Description
IFDBAccessID	NUMBER(10)	NOT NULL	Reference to IFDBAccessID in the MIB2_Interface_Table.
NEDBAccessID	NUMBER(10)	NOT NULL	ID to access this table for an NE; same as NEDBAccessID in the NE_Info_Table.
Frequency	NUMBER(10)	NOT NULL	DWDM frequency.

1.2.71  Interface_Stack_Table

The Interface_Stack_Table provides information about underlying and overlaying layer relationships between interfaces.

Primary key: IFSTACK_PK

Tablespace: ONS155XX_DATA_TABLESPACE

Table 1-70 Interface_Stack_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
UniqueID	NUMBER(10)	NOT NULL	Unique sequence number. Acts as foreign key.
NEDBAccessID	NUMBER(10)	NOT NULL	ID to access this table for an NE; same as NEDBAccessID in the NE_Info_Table.
HighIfDBAccessID	NUMBER(10)	NOT NULL	IFDBAccessID at the higher layer in the stack.
LowIfDBAccessID	NUMBER(10)	NOT NULL	IFDBAccessID at the lower layer in the stack.
Status	NUMBER(2)	NOT NULL	Operational state of lower layer. Values are: 1: Up 2: Down 3: Testing 4: Unknown 5: Dormant 6: Not present 7: Lower layer down

1.2.72  Interface_Table

The Interface_Table contains static interface indexes and names for an NE managed by CTM.

Primary key: INTERFACE_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-71 Interface_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEType	NUMBER(1)	NOT NULL	Type of NE. Values are: -1: Common ifNames Any-other-number: NEModelIndex of the NE_Info_Table
ifStaticIndex	NUMBER(4)	NOT NULL	Interface table static index; unique value for each interface on the NE.
ifName	VARCHAR2(64)	NOT NULL	Name of the interface.

1.2.73  IOS_Parser_Static_Tree_Table

The IOS_Paerser_Static_Tree_Table contains information about the IOS parser static tree table.

Primary key: IOS_PARSER_STATIC_TREE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-72 IOS_Parser_Static_Tree_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
ModelIndex	NUMBER(8)	NOT NULL	Model index for the static tree.
IOSModelName	VARCHAR(128)	NOT NULL	Index of the static tree.
NodeIndex	NUMBER(8)	NOT NULL	Index of the node.
ParentIndex	NUMBER(8)	NOT NULL	Parent node index: -1 for the root node.
NodeName	VARCHAR(128)	NOT NULL	Name of the IOS node.
NodeValue	VARCHAR(128)	—	Value of the nodes.
CTMAttributeName	VARCHAR(128)	—	Corresponding CTM attribute name.
AttributeLocation	NUMBER(8)	NOT NULL	Position of the attribute in the object index.

1.2.74  L2_FrontPort_Table

The L2_FrontPort_Table contains information about the L2 front port table.

Primary key: L2_FRONTPORT_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-73 L2_FrontPort_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEID	NUMBER(10)	NOT NULL	NE ID.
SLOT_NUMBER	NUMBER(2)	NOT NULL	Slot number.
PORT_NUMBER	NUMBER(2)	NOT NULL	Port number.
NNI	NUMBER(1)	—	Port type.
UNI	NUMBER(1)	—	Port type.
DOT1Q	NUMBER(1)	—	Connection type.
QINQ	NUMBER(1)	—	Connection type.
UNTAGGED	NUMBER(1)	—	Connection type.
BG_COUNT	NUMBER(3)	—	—
SUB_IF_COUNT	NUMBER(3)	—	—
PORT_STATE	NUMBER(1)	—	Port state. Values are: 0: PORT_STATE_DISABLED 1: PORT_STATE_ENABLED
PM_STATUS	NUMBER(1)	—	—
MTU_SIZE	VARCHAR(6)	—	—
SPEED	VARCHAR(6)	—	—
DUPLEX	VARCHAR(6)	—	—
FLOWCONTROL_SEND	VARCHAR(30)	—	—
FLOWCONTROL_RECEIVE	VARCHAR(30)	—	—
CDP	VARCHAR(30)	—	Cisco Discovery Protocol.

1.2.75  L2_Interface_QoSClass_Table

The L2_Interface_QoSClass_Table stores all the QoS parameters that are configured on a Layer 2 service drop. The Layer 2 services are configured on a Layer 2 topology. The table is populated when a new Layer 2 service is created or discovered in CTM.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-74 L2_Interface_QoSClass_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEID	NUMBER(10)	NOT NULL	NE ID.
Slot_Number	NUMBER(3)	NOT NULL	Slot number.
Bridge_Group_Number	NUMBER(3)	NOT NULL	Bridge group number.
Port_Number	NUMBER(2)	NOT NULL	Port number.
Port_Sub_Interface	NUMBER(4)	—	Subinterface number on the port.
MATCH_ANY	NUMBER(1)	—	Matches any traffic.
MATCH_DSCP	NUMBER(1)	—	Matches the Differentiated Services Code Point (DSCP). The DSCP value needs to be specified.
MATCH_COS	NUMBER(1)	—	Matches the class of service.
MATCH_IP_PRECEDENCE	NUMBER(1)	—	Matches the IP precedence value.
MATCH_DSCP_VALUE	VARCHAR2(64)	—	DSCP value is used with Match_DSCP.
MATCH_COS_VALUE	VARCHAR2(32)	—	COS value is used with Match_COS.
MATCH_IP_PRECEDENCE_V ALUE	VARCHAR2(32)	—	IP precedence value is used with Match_IP_Precedence.
ANDOR	NUMBER(1)	—	And/or condition.
CLASS_NAME	VARCHAR2(60)	—	Name of class map.
CIR_TYPE	NUMBER(2)	—	CIR type. Values are: 0: Line rate CIR 1: Rate-limited CIR
MAX_RATE_KBPS	NUMBER(20)	—	Maximum allowed rate in kbps.
BURST_SIZE_BPS	NUMBER(20)	—	Size of the burst in bps.
CIR_COS_TYPE	NUMBER(2)	—	Committed Class of Service (CoS) mark type. Values are: 0: Trust 1: Mark CoS
CIR_COS_VALUE	NUMBER(2)	—	If CIR_COS_TYPE is 1, this is the CoS value.
EXCESS_ACTION	NUMBER(2)	—	Excess traffic action. Values are: 0: Discard 1: Allow
PIR_BURST_BPS	NUMBER(20)	—	Peak information rate burst value in bps.
PIR_KBPS	NUMBER(20)	—	Peak information rate in kbps.
PIR_COS_TYPE	NUMBER(2)	—	PIR CoS type. Values are: 0: Trust 1: Mark CoS
PIR_COS_VALUE	NUMBER(2)	—	PIR CoS marking value.
VIOLATE_ACTION	NUMBER(2)	—	Violate action. Values are: 0: Discard 1: Allow
VIOLATE_COS_VALUE	NUMBER(2)	—	CoS marking for violation traffic.
BEFF_TYPE	NUMBER(2)	—	Best effort type. Values are: 0: Line rate 1: Rate limited
BEFF_RATE_KBPS	NUMBER(20)	—	Best effort maximum rate in kbps.
BEFF_BURST_SIZE_BPS	NUMBER(20	—	Best effort burst size in bps.

1.2.76  L2_Interface_Table

The L2_Interface_Table contains information about L2 interfaces.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-75 L2_Interface_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
NEID	NUMBER(10)	NOT NULL	NE ID.
SLOT_NUMBER	NUMBER(3)	NOT NULL	Slot number.
BRIDGE_GROUP_NUMBE R	NUMBER(3)	NOT NULL	Bridge group number.
PORT_NUMBER	NUMBER(2)	NOT NULL	Port number.
PORT_SUB_INTERFACE	NUMBER(4)	—	Port subinterface.
INTERFACE_NAME	VARCHAR2(30)	—	Interface name.
INTERFACE_TYPE	NUMBER(3)	—	Interface type: 1: POS 2: FAST ETHERNET 3: GIGABIT ETHERNET
PORT_TYPE	NUMBER(2)	—	Port types: 1: UNI 2: NNI
CONNECTION_TYPE	NUMBER(2)	—	Connection types: 1: QinQ 2: Dot1Q 3: Untagged
PORT_STATE	NUMBER(2)	—	Port state. Values are: 0: PORT_STATE_DISABLED 1: PORT_STATE_ENABLED
POLICING_TYPE	NUMBER(2)	—	Policing type.
QOSTEMPLATE_NAME	VARCHAR2(30	—	Name of the QoS template.
MTU_SIZE	VARCHAR2(30)	—	Maximum transmission unit (MTU) size.
SPEED	VARCHAR2(30)	—	Speed: 10: MIN_SPEED 100: MAX_SPEED auto: AUTO_SPEED
DUPLEX	VARCHAR2(30)	—	Duplex value: full: FULL_DUPLEX half: HALF_DUPLEX auto: AUTO_DUPLEX
FLOWCONTROL_SEND	VARCHAR2(30)	—	Flow Control (send) value.
FLOWCONTROL_RECEIV E	VARCHAR2(30)	—	Flow Control (receive) value.
RSTP_STATUS	NUMBER(2)	—	RSTP_STATUS has the following values: 0: DISABLE 1: ENABLE
CDP	VARCHAR2(30)	—	Cisco Discovery Protocol.
IP_ADDRESS	VARCHAR2(50)	—	IP address.
SUBNET_MASK	VARCHAR2(50)	—	Subnet mask.

1.2.77  L2_Ipsla_Attribute_Table

The L2_Ipsla_Attribute_Table contains information about the attributes of IP service-level agreements (SLAs) that were created for a specific Layer 2 service.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-76 L2_Ipsla_Attribute_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
Source_NeId	NUMBER(10)	NOT NULL	Node ID of the source node of the circuit.
Source_PhyLoc	NUMBER(20)	NOT NULL	Source physical location.
Ipsla_Number	NUMBER(10)	NOT NULL	Unique number to identify the IP SLA.
AttributeName	VARCHAR2(50)	NOT NULL	Name of the IP SLA attribute.
AttributeValue	VARCHAR2(50)	—	Value of the IP SLA attribute.

1.2.78  L2_Ipsla_Table

The L2_Ipsla_Table contains information about the IP SLAs that were created for a specific Layer 2 service.

Primary key: IPSLA_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-77 L2_Ipsla_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.
Ipsla_Number	NUMBER(10)	NOT NULL	Unique number to identify the IP SLA.
Destination_NeId	NUMBER(10)	—	ID of the destination NE.
Destination_PhyLoc	NUMBER(20)	—	Destination physical location.
Destination_Addr	VARCHAR2(50)	—	Destination IP address.
Source_NeId	NUMBER(10)	—	Source NE ID.
Source_PhyLoc	NUMBER(20)	—	Source physical location.
Source_Addr	VARCHAR2(50)	—	Source IP address.
Operation_Type	VARCHAR2(50)	—	Operation type. The possible values are: jitter: JITTER echo: ECHO
Operation_status	NUMBER(10)	—	Operation status. The possible values are: 0: NOT_SCHEDULED 1: SCHEDULED_RUNNING 2: SCHEDULED_NOT_RUNNING

1.2.79  L2QoSTemplate_QoSClass_Table

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

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-78 L2QoSTemplate_QoSClass_Table 

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

1.2.80  L2QoSTemplate_Table

The L2QoSTemplate_Table contains information about the L2 QoS template.

Primary key: L2QOSTEMPLATE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-79 L2QoSTemplate_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
QoSTemplateID	NUMBER(6)	NOT NULL	QoS template ID.
QoSTemplateName	VARCHAR2(50)	NOT NULL	Unique name of the QoS template.
QoSTemplateType	NUMBER(2)	—	QoS template types: 1: BEST_EFFORT 2: CIR_PIR 3: ADVANCED
QoSTemplateDescription	VARCHAR2(257)	—	QoS template description.
ClassOrder	NUMBER(20)	—	Position of the class policy within the QoS template.

1.2.81  L2Topology_Circuits_Table

The L2Topology_Circuits_Table contains information about the L2 topology.

Primary key: None

Tablespace: BASE_DATA_TABLESPACE

Table 1-80 L2Topology_Circuits_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
TopoNodeID	NUMBER(10)	NOT NULL	Node ID of the source node of the circuit where Point-to-Point topology is used. Where Shared Packet Ring (SPR) is used, it is the node ID of the node that is equal to the maximum of all node IDs in the SPR.
TopoUniqueId	NUMBER(10)	NOT NULL	Unique number within the node.
NodeID	NUMBER(10)	NOT NULL	Node ID of the source node of the circuit.
UniqueId	NUMBER(10)	NOT NULL	Unique number within the node.
LinkId	NUMBER(10)	NOT NULL	Unique number within the link.

1.2.82  L2Topology_Table

The L2Topology_Table contains information about L2 topologies.

Primary key: L2TOPOLOGY_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-81 L2Topology_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.
TopoType	NUMBER(2)	—	Topology types. Values are: 1: Point to point 2: SPR 3: Hub and spoke
Topology_Name	VARCHAR2(50)	—	CTM name for the topology.
TopoDescription	VARCHAR2(256)	—	Description of topology.
AlarmSeverity	NUMBER(2)	—	Alarm severity.
TopoStatus	NUMBER(2)	—	Status of the topology.
TopoSize	NUMBER(10)	—	Size of the topology.
TopoProtection	NUMBER(2)	—	Topology protection.
TopoResyncStatus	NUMBER(2)	—	Topology resynchronization states. Values are: 0: TOPO_SYNC_NEEDED 1: TOPO_SYNC_IN_PROGRESS 2: TOPO_SYNC_COMPLETED
TopoOperStatus	NUMBER(2)	—	Operational status of the topology.
BW_SP_Management	NUMBER(3)	—	Displays the bandwidth percentage used for the service provider (SP) management traffic class.
BW_Committed	NUMBER(3)	—	Displays the bandwidth percentage used for the committed information rate (CIR) traffic class.
BW_Best_Effort	NUMBER(3)	—	Displays the bandwidth percentage used for the best-effort traffic class.
TOPOCONSTATE	NUMBER(2)	—	Displays CTM status after trying to synchronize the configuration of all the multilayer cards in the topology.
COS_COMMIT	NUMBER(3)	—	Committed CoS value.
BW_Utilized	NUMBER(20)	—	Percentage of utilized bandwidth.
BW_Available	NUMBER(20)	—	Percentage of available bandwidth.
BW_AVVID_CONTROL	NUMBER(3)	—	Percentage of bandwidth for AVVID call control.
COS_SP_MANAGEMENT	VARCHAR2(128)	—	CoS for SP management.
COS_COMMITTED	VARCHAR2(128)	—	CoS for the committed rate.
COS_AVVID_VOICEVIDEO	VARCHAR2(128)	—	CoS for AVVID voice video.
COS_AVVID_CONTROL	VARCHAR2(128)	—	CoS for AVVID control.
BW_Group1	NUMBER(3)	—	First bandwidth group.
BW_Group2	NUMBER(3)	—	Second bandwidth group.
COS_GROUP1	VARCHAR2(128)	—	First CoS group.
COS_GROUP2	VARCHAR2(128)	—	Second CoS group.
TopoAliasName	VARCHAR2(64)	—	Circuit alias name.
BW_A0	NUMBER(4)	—	Absolute bandwidth value in megabits per second (Mbps) for Class A0, which conforms to the reserved rate on the ring. The range is from 0 to 48 Mbps.
BW_A1	NUMBER(4)	—	Absolute bandwidth value in Mbps for Class A1. The range is from 1 to 48 Mbps.
BW_B_CIR	NUMBER(4)	—	Absolute bandwidth value in Mbps for Class B-CIR. The range is from 1 to 48 Mbps.
CLASS_SP_MGMT	VARCHAR2(128)	—	Specifies that the user-defined class SP_MANAGEMENT is mapped to a specific service class a, b, or c as defined by the 802.17 RPR standard.
CLASS_CIR	VARCHAR2(128)	—	Specifies that the user-defined class CLASS_CIR is mapped to a specific service class a, b, or c as defined by the 802.17 RPR standard.
CLASS_BEST_EFFORT	VARCHAR2(128)	—	Specifies that the user-defined class BEST_EFFORT is mapped to a specific service class a, b, or c as defined by the 802.17 RPR standard.
CLASS_AVVID_CTRL	VARCHAR2(128)	—	Specifies that the user-defined class AVVID_CTRL is mapped to a specific service class a, b, or c as defined by the 802.17 RPR standard.
CLASS_AVVID_VOICEVIDEO	VARCHAR2(128)	—	Specifies that the user-defined class AVVIDVOICEVIDEO is mapped to a specific service class a, b, or c as defined by the 802.17 RPR standard.

1.2.83  L2_Vlan_Table

The L2_Vlan_Table contains information about the VLANs in an L2 topology.

Primary key: VLAN_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-82 L2_Vlan_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
TopoNodeID	NUMBER(10)	NOT NULL	Node ID of the source node of the circuit where Point-to-Point topology is used. Where SPR is used, it is the node ID of the node that is equal to the maximum of all node IDs in the SPR.
TopoUniqueId	NUMBER(10)	NOT NULL	Unique number within the node.
Vlan_Number	NUMBER(10)	NOT NULL	Unique number to identify the VLAN.
Service_Id	VARCHAR2(50)	—	CTM service ID.
Customer_Id	VARCHAR2(50)	—	CTM customer ID.
VlanStatus	NUMBER(2)	—	VLAN status.
ManagedVlan	NUMBER(1)	—	VLAN in the L2 topology.

1.2.84  Link_Layer_Mapping_Table

The Link_Layer_Mapping_Table maps information between link layer integer values and strings. Integer values are stored in the database and are converted to string values for user display. The Link_Layer_Mapping_Table is used to convert the integer values to string values.

Primary key: LINK_LAYER_MAPPING_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-83 Link_Layer_Mapping_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
LinkLayerId	NUMBER(2)	—	Integer representing the layer ENUM.
LinkLayerString	VARCHAR2(30)	—	Corresponding string value of LinkLayerId.

1.2.85  Link_Table

The Link_Table contains information about the links on the CTM Network Map.

Primary key: LINK_TABLE_PK

Tablespace: BASE_DATA_TABLESPACE

Table 1-84 Link_Table 

Column Name	Oracle Data Type	Integrity Constraints	Description
LinkID	NUMBER(8)	NOT NULL	Unique number created by the database.
LinkSrcNode	NUMBER(10)	NOT NULL	Source node.
LinkSrcModuleType	NUMBER(8)	NOT NULL	Module type at the source.
LinkSrcPhysicalLoc