GROUPINSPECTIONS table
Street segment inspections are exported from the SEGSERVICEINSP table (
Hansen.AssetManagement.Street.SEGServiceInspection object). All uncompleted inspections that belong to the specified group inspection are exported.
This table shows the property of the SEGServiceInspection 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 | Asset.Detail.BaseDepth |
| BASETYPE | Asset.Detail.BaseType.Code |
| BUSROUTE | Asset.Detail.IsBusRoute |
| 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 | Not mapped |
| DESCRIPTION | Asset.Detail.UnitDesc |
| DISTRICT | Asset.Detail.District.Code |
| DIVIDERTYPE | Asset.Detail.DividerType.Code |
| FILLER | Not mapped |
| FROMREF | Asset.Detail.ReferenceFrom |
| GRADE | Asset.Detail.Grade |
| GRPKEY | GroupInspection.GroupInspectionKey |
| HIGHADDR | Asset.Detail.HighAddressNumber |
| HOUSENO | Asset.Detail.Address.StreetNumber |
| ID | Asset.Detail.ID2 |
| INSPKEY | InspectionNumber |
| INSPNO | Not mapped |
| INSTDATE | Asset.Detail.InstalledDate |
| LENGTH | Asset.Detail.Length |
| LENGTHUOM | Asset.Detail.LengthUOM |
| LOCATION | Asset.Detail.Location.Code |
| LOWADDR | Asset.Detail.LowAddressNumber |
| MAPNO | Asset.Detail.MapNumber |
| MATERIAL | Not mapped |
| NUOFLANES | Asset.Detail.NumberOfLanes |
| ONEWAY | Asset.Detail.IsOneWay |
| OWNER | Asset.Detail.Ownership.Code |
| PEDTRAFFIC | Not mapped |
| POSTDIR | Asset.Detail.Address.PostDirection |
| PREDIR | Asset.Detail.Address.PreDirection |
| PROJNO | Not mapped |
| SCHEDDATE | ScheduledDateTime |
| SPEEDLIMIT | Asset.Detail.SpeedLimit |
| STNAME | Asset.Detail.Address.StreetName |
| STNAMEFROM | Asset.Detail.BeginCrossStreet.ID |
| STNAMETO | Asset.Detail.EndCrossStreet.ID |
| STREETID | Asset.Detail.ID |
| STSIDE | Not mapped |
| SUBAREA | Asset.Detail.SubArea.Code |
| SUFFIX | Asset.Detail.Address.Suffix.Code |
| SURFDEPTH | Asset.Detail.SurfaceDepth |
| SURFDEPTHUOM | Asset.Detail.SurfaceDepthUOM |
| SURFTYPE | Asset.Detail.SurfaceType.Code |
| SURFWIDTH | Asset.Detail.SurfaceWidth |
| SURFWIDTHUOM | Asset.Detail.SurfaceWidthUOM |
| TOREF | Asset.Detail.ReferenceTo |
| TRUCKROUTE | Asset.Detail.IsTruckRoute |
| UNITDESC | Not mapped |
| UNITTYPE | Not mapped |
| USESCOMPONENTS | InspectionType.UsesComponents |
| XCOORD | Asset.Detail.XCoordinate |
| YCOORD | Asset.Detail.YCoordinate |
| ZCOORD | Asset.Detail.ZCoordinate |