===== ROW missing Cascade/ExteNet ID dropdown value =====
Author: Paddy Murphy

If a support request comes to investigate why a value is missing from the Cascade/ExteNet ID drop down list in the ROW(right of way) application check that the values listed below are assigned.

==== Customer configuration through loadsheet ====
Check the following:
  * Is the right_of_way_element value set to true in the network_element table for the child element?
  * Is there a value assigned for node_id in the network_element table for child element?


==== Operations Database configuration  ====
Check that there is an entry in the state_cluster table to join the network element cluster to the relevant state – an element will not appear Cascade/ExteNet ID drop down after a state is selected if this is missing.

Example - check for clusters assigned to Pennsylvania
  select * from state where abbreviation = 'PA';
  select * from state_cluster where state_clusters_id = 39;
  
If a new entry is required it has be added to the state_cluster join table via a database insert statement.
  * state_clusters_id – State ID
  * cluster_id – Cluster ID

Example Insert Query
  insert into state_cluster values(<State ID>,<cluster ID>);