VERIFIED SOLUTION i
X

How to locate Confirm table name query

UPDATED: March 24, 2017


There is a field on a Street Works notice on the site tab, called "position". We would like to include it in a report but cannot locate it on the schema, can you tell me what it is called? 



Position is referred as Surface type in the database. 

Main table where all the types of Surface are stored is: 

surface_type 

In the notice, "surface_type_code" column can be found out in sw_notice_site table.

 

Environment Details

Product Feature: Street Works


 

Downloads

  • No Downloads