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 |