VERIFIED SOLUTION i
X

Confirm - How to extract the street works Duration Days

UPDATED: April 10, 2017


This cannot be extracted direct from the Confirm database.

This field is calculated dynamically and not saved in the database, hence will not be retrieved by just selecting the "sw_notice_header.duration_days" field.

This is calculated by working out the difference between 'Work_start_date' and 'work_est_end_date'/'work_comp_date' to get this value. 

Environment Details

Product Feature: Street Works

 

Downloads

  • No Downloads