Confirm - Report to Identify a Job Having a Linked Permit

Product Feature: Ad-hoc Reporting \ Streetworks
It is possible to create this type of report. Here we advise of the table names and column names which link the Jobs with corresponding Street Works Notices. 

In the table named "job", there is a column named "work_header_no". This column can be cross-referenced in the sw_header and sw_notice_header Street Works tables. In doing so please consult the Confirm Help system (Reporting -> Schemas).
UPDATED:  March 24, 2017