VERIFIED SOLUTION i

How to find the schema that matches up with the Designations field of the Location tab in Confirm Street Works

Product Feature: Street Works


 
In Confirm - which field on the schema matches up with the Designations field of the Location tab in street works?

The table is 

sw_notice_design 

Below query will help them to understand the mapping: 

select * from sw_notice_design where work_header_no = (select work_header_no from sw_header where works_ref = <works_ref>) 

Designation_code column is a foreign key to Designation table. 

 
UPDATED:  October 3, 2017