VERIFIED SOLUTION i
X

Confirm - Report to Identify a Job Having a Linked Permit

UPDATED: March 24, 2017


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).

Environment Details

Product Feature: Ad-hoc Reporting \ Streetworks
 

Downloads

  • No Downloads