GROUPINSPECTIONS tables
Sidewalk inspections are exported from the SWSERVICEINSP table
(
Hansen.AssetManagement.Street.SWServiceInspection object). All uncompleted
inspections that belong to the specified group inspection are exported.
This table shows the SWServiceInspection property of the object that each
column in the GROUPINSPECTIONS table maps to.
| Access DB column | IPS property |
|---|---|
| ADDLOC | Asset.Detail.AddressQualifier |
| AREA | Asset.Detail.Area.Code |
| ASSIGNED | AssignedTo.EmployeeID |
| BASEDEPTH | Not mapped |
| BASETYPE | Not mapped |
| BUSROUTE | Not mapped |
| CATID | Not mapped |
| CITY | Asset.Detail.Address.City |
| COMMENTS | Comments |
| COMPANY | Name of the company. Populated by the XSLT style sheet, but must have a temporary value. |
| COMPKEY | Asset.Detail.AssetKey |
| COMPTYPE | Asset.Detail.Asset.AssetType.AssetType |
| CREW | Responsibility.Code |
| CURBTYPE | Asset.Detail.CurbType.Code |
| DESCRIPTION | Asset.Detail.UnitDesc |
| DISTRICT | Asset.Detail.District.Code |
| DIVIDERTYPE | Not mapped |
| FILLER | Asset.Detail.FillerStripType.Code |
| FROMREF | Not mapped |
| GRADE | Not mapped |
| GRPKEY | GroupInspection.GroupInspectionKey |
| HIGHADDR | Not mapped |
| HOUSENO | Asset.Detail.Address.StreetNumber |
| ID | Asset.Detail.ID |
| INSPKEY | InspectionNumber |
| INSPNO | Not mapped |
| INSTDATE | Asset.Detail.InstalledDate |
| LENGTH | Asset.Detail.Length |
| LENGTHUOM | Asset.Detail.LengthUOM |
| LOCATION | Asset.Detail.Location.Code |
| LOWADDR | Not mapped |
| MAPNO | Asset.Detail.MapNumber |
| MATERIAL | Asset.Detail.Material.Code |
| NUOFLANES | Not mapped |
| ONEWAY | Not mapped |
| OWNER | Asset.Detail.Ownership.Code |
| PEDTRAFFIC | Asset.Detail.PedestrianTraffic |
| POSTDIR | Asset.Detail.Address.PostDirection |
| PREDIR | Asset.Detail.Address.PreDirection |
| PROJNO | Not mapped |
| SCHEDDATE | ScheduledDateTime |
| SPEEDLIMIT | Not mapped |
| STNAME | Asset.Detail.Address.StreetName |
| STNAMEFROM | Not mapped |
| STNAMETO | Not mapped |
| STREETID | Not mapped |
| STSIDE | Asset.Detail.SideOfStreet.Code |
| SUBAREA | Asset.Detail.SubArea.Code |
| SUFFIX | Asset.Detail.Address.Suffix.Code |
| SURFDEPTH | Asset.Detail.Thickness |
| SURFDEPTHUOM | Asset.Detail.ThicknessUOM |
| SURFTYPE | Asset.Detail.SurfaceType.Code |
| SURFWIDTH | Asset.Detail.Width |
| SURFWIDTHUOM | Asset.Detail.WidthUOM |
| TOREF | Not mapped |
| TRUCKROUTE | Not mapped |
| UNITTYPE | Asset.Detail.UnitType.Code |
| USESCOMPONENTS | InspectionType.UsesComponents |
| XCOORD | Asset.Detail.XCoordinate |
| YCOORD | Asset.Detail.YCoordinate |
| ZCOORD | Asset.Detail.ZCoordinate |