Network Devices (netdev) to Equipment (eq)

Source Table and Field	Target Table and Field	Notes
netdev bl_id	eq bl_id
netdev cross_connect_level		not migrated
netdev description	eq description
netdev detail_dwg		not migrated
netdev dwgname	eq dwgname	XDATA is not adjusted
netdev ehandle	eq ehandle
netdev fl_id	eq fl_id
netdev hardware_address	eq hardware_address
netdev is_multiplexing	eq is_multiplexing
netdev net_address	eq net_address
netdev net_address_ip	eq net_address_ip
netdev net_card_type	eq net_card_type
netdev net_id	eq net_id
netdev net_sub_mask	eq net_sub_mask
netdev netdev_id	eq eq_id
netdev netdev_std	eq eq_std
netdev netdev_type		not migrated
netdev num_serial	eq num_serial
netdev rack_id	eq rack_id
netdev rm_id	eq rm_id
netdev tc_level	eq tc_level

Network Device Standards (netdevstd) to Equipment Standards (eqstd)

Source Table and Field	Target Table and Field
netdevstd cost_purchase	eqstd price
netdevstd description	eqstd description
netdevstd image_file	eqstd image_file
netdevstd is_multiplexing	eqstd is_multiplexing
etdevstd netdev_std	eqstd eq_std
netdevstd netdev_type	eqstd category
netdevstd symbol	eqstd symbol
netdevstd tc_contained_tbls	eqstd tc_contained_tbls
netdevstd tc_level	eqstd tc_level
netdevstd tc_npositions	eqstd tc_npositions

Network Device Ports (ndports) to Equipment Ports (eqports)

Source Table and Field	Target Table and Field
ndport description	eqport description
ndport hardware_address	eqport hardware_address
ndport net_address	eqport net_address
ndport netdev_id	eqport eq_id
ndport port_id	eqport port_id
ndport port_std	eqport port_std
ndport segment	eqport segment
ndport tc_level	eqport tc_level
ndport tc_use_status	eqport tc_use_status

Punch Blocks (pb) to Patch Panels (pn)

Source Table and Field	TargetTable and Field	Notes
pb bl_id	pn bl_id
pb cross_connect_level	pn cross_connect_level
pb description	pn description
pb detail_dwg	pn detail_dwg	XDATA is not adjusted
pb dwgname	pn dwgname
pb ehandle	pn ehandle
pb fl_id	pn fl_id
pb mount_id		not migrated
pb pb_id	pn pn_id
pb pb_std	pn pn_std
pb rack_id	pn rack_id
pb rm_id	pn rm_id
pb shelf_id	pn shelf_id
pb tc_level	pn tc_level
pb tc_service	pn tc_service

Punch Block Standards (pbstd) to Patch Panel Standards (pnstd)

Source Table and Field	Target Table and Field
pbstd description	pnstd description
pbstd doc_image	pnstd doc_image
pbstd image_file	pnstd image_file
pbstd pb_std	pnstd pn_std
pbstd symbol	pnstd symbol
pbstd tc_contained_tbls	pnstd tc_contained_tbls
pbstd tc_level	pnstd tc_level
pbstd tc_npositions	pnstd tc_npositions
pbstd vn_id	pnstd vn_id

Punch Block Contained Positions to Patch Panel Ports

There is no source table for punch block contained positions. Rather each punch block has the number of connections specified in the Number of Contained Positions field (tc_npositions) in the Punch Block Standards (pbstd) table.

The Number of Contained Positions migrates to the corresponding field with the same name in the Panel Standards (pnstd) table.

Punch Block positions are specified in the Down Position and Up Position fields of the Connections table (afm_tccn). The migration process creates a single port in the Panel Ports table for each unique position entry in the Down Position and Up Position fields for each punch block.

For each Punch Block, the workflow rule runs the following SQL query statement to generate the corresponding ports for the Panel Ports table:

INSERT INTO pnport (pn_id,port_id) SELECT DISTINCT 'PB19H',position FROM
((SELECT DISTINCT downhill_position AS position FROM afm_tccn WHERE downhill_key='PB19H') UNION (SELECT DISTINCT uphill_position AS position FROM afm_tccn WHERE uphill_key='PB19H')) AS pnport order by position

Source Table and Field	Target Table and Field	Notes
pb_id pnport	pn_id	SQL statement to process all punch block connections and create patch panel ports
afm_tccn downhill_position afm_tccn uphill_position	pnport port_id

Cards (card) to Equipment (eq)

Source Table and Field	Target Table and Field	Notes
card card_id	eq eq_id	Cards use 16 characters
card card_std	eq eq_std
card description	eq description
card eq_id		not migrated
card hardware_address	eq hardware_address
card is_multiplexing	eq is_multiplexing
card net_address	eq net_address
card net_id	eq net_id
card netdev_id		not migrated
card slot_id		not migrated
card tc_level	eq tc_level

Card Standards (cardstd) to Equipment Standards (eqstd)

Source Table and Field	Target Table and Field
cardstd card_std	eqstd eq_std
cardstd description	eqstd description
cardstd is_multiplexing	eqstd is_multiplexing
cardstd netdev_type	eqstd category
pbstd symbol	pnstd symbol
cardstd tc_contained_tbls	eqstd tc_contained_tbls
cardstd tc_level	peqstd tc_level
cardstd tc_npositions	eqstd tc_npositions

Card Ports (cdport ) to Equipment Ports (eqport)

Source Table and Field	Target Table and Field	Notes
cdport card_id	eqport eq_id	card_id is 16 characters
cdport description	eqport description
cdport hardware_address	eeqport hardware_address
cdport net_address	eqport net_address
cdport port_id	eqport port_id
cdport port_std	eqport port_std
cdport tc_level	eqport tc_level
cdport tc_use_status	eqport tc_use_status

Connections Table (afm_tccn) to Key Element Uphill Keys (eq, eqport, pn, pnport, jk tables)

The migration from the Connections table (afm_tccn) uses a series of SQL statements to process the Connection records and fill in the corresponding uphill fields (To fields) in the Jacks, Equipment, Equipment Ports, and Panel Ports tables.

Source Table and Field	Target Table	Target Field	Notes
afm_tccn auto_number			not migrated
afm_tccn ca_std			not migrated
afm_tccn comments			not migrated
afm_tccn uphill_key			not migrated
afm_tccn uphill_position			not migrated
afm_tccn uphill_position_end			not migrated
afm_tccn upnhill_table			not migrated
afm_tccn transfer_status			not migrated
afm_tccn downhill_key	eq eqport jk tc_eqport_id pn pnport	tc_eq_id tc_eqport_id tc_eqport_id tc_pn_id tcpnport_id
afm_tccn downhill_position			not migrated
afm_tccn downhill_position_end			not migrated
afm_tccn downhill_table			not migrated