SRCEINSP table
Used to import existing sidewalk inspections that have been updated. The updated records are imported to the SWSERVICEINSP table (
Hansen.AssetManagement.Street.SWServiceInspection object).
This table shows the property of the SWServiceInspection object that each column in the SRCEINSP table maps to.
| Access DB column | IPS property |
|---|---|
| ADDLOC | Not mapped |
| AREA | Not mapped |
| ASSETLEN | AssetLength |
| ASSETLENUOM | AssetLengthUOM |
| ASSETWID | AssetWidth |
| ASSETWIDUOM | AssetWidthUOM |
| ASSIGNED | Not mapped |
| BASEDEPTH | Not mapped |
| BASETYPE | Not mapped |
| BUSROUTE | Not mapped |
| COMMENTS | Comments |
| COMPBY | CompletedBy.EmployeeID |
| COMPDATE | CompletedDateTime |
| COMPKEY | Not mapped |
| COMPLETED | Not mapped |
| CREW | Responsibility.Code |
| CREWLEAD | Not mapped |
| CURBTYPE | Not mapped |
| DISTRICT | Not mapped |
| DIVIDERTYPE | Not mapped |
| FILLER | Not mapped |
| GRADE | Not mapped |
| GRPKEY | Not mapped |
| HIGHADDR | Not mapped |
| Import | Not mapped |
| Imported | Not mapped |
| INSPKEY (required) | InspectionNumber
This is the primary key of the inspection that will be updated. |
| LOCATION | Not mapped |
| LOWADDR | Not mapped |
| NUOFLANES | Not mapped |
| ONEWAY | Not mapped |
| OWNER | Not mapped |
| PEDTRAFFIC | Not mapped |
| SPEEDLIMIT | Not mapped |
| STARTDATE | StartDateTime |
| SUBAREA | Not mapped |
| SURFDEPTH | Not mapped |
| SURFDEPTHUOM | Not mapped |
| SURFTYPE | Not mapped |
| SURFWIDTH | Not mapped |
| SURFWIDTHUOM | Not mapped |
| TOREF | Not mapped |
| TRUCKROUTE | Not mapped |
| XCOORD | Not mapped |
| YCOORD | Not mapped |
| ZCOORD | Not mapped |