CCTVFLEX table
Sewer main inspections are exported from the SMNSERVICEINSP table
(
Hansen.AssetManagement.Sewer.SMNServiceInspection object). All uncompleted
inspections that belong to the specified group inspection are exported.
This table shows the property of the SMNServiceInspection object that each
column in the CCTVFLEX table maps to.
| Access DB column | IPS property |
|---|---|
| ActKey | Value="1" |
| ADDLOC | Asset.Detail.AddressQualifier |
| AREA | Asset.Detail.Area.Code |
| CATEGORY | Not mapped |
| CATID | Not mapped |
| CITY | Asset.Detail.Address.City |
| CLEANED | Not mapped |
| CLNOUTLOC | Not mapped |
| 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 |
| CONTRACTOR | AssignedTo.EmployeeID |
| CREW | Responsibility.Code |
| CUSTOMER | Not mapped |
| DISTRICT | Asset.Detail.District.Code |
| DNDEPTH | Asset.Detail.DownstreamDepth |
| DNDEPTHUOM | Asset.Detail.DownstreamDepthUOM |
| DNGRADETOINVERT | Asset.Detail.DownstreamElevation |
| DNHOUSENO | Asset.Detail.UnitID2Asset.Detail.Address.StreetNumber |
| DNID | Asset.Detail.UnitID2Asset.ID |
| DNPOSTDIR | Asset.Detail.UnitID2Asset.Detail.Address.PostDirection |
| DNPREDIR | Asset.Detail.UnitID2Asset.Detail.Address.PreDirection |
| DNRIMTOGRADE | Not mapped |
| DNSTREET | Asset.Detail.UnitID2Asset.Detail.Address.StreetName |
| DNSUFFIX | Asset.Detail.UnitID2Asset.Detail.Address.Suffix.Code |
| DNTYPE | Asset.Detail.UnitID2Asset.AssetType.ComponentTypeCode |
| DRAWINGNO | Asset.Detail.MapNumber |
| GROUPPROJ | GroupInspection.GroupInspectionKey |
| GRPKEY | GroupInspection.GroupInspectionKey |
| HistKey | InspectionNumber |
| HOUSENO | Not mapped |
| HT | Asset.Detail.PipeHeight |
| HTUOM | Asset.Detail.PipeHeightUOM |
| INSPKEY | InspectionNumber |
| INSPNO | InspectionNumber |
| INSTDATE | Asset.Detail.InstalledDate |
| JOINTSPACE | Asset.Detail.JointLength |
| JOINTTYPE | Asset.Detail.JointType.Code |
| JTLENUOM | Asset.Detail.JointLengthUOM |
| LENGTH | Asset.Detail.PipeLength |
| LENGTHUOM | Asset.Detail.PipeLengthUOM |
| LININGMETHOD | Not mapped |
| LOCATION | Asset.Detail.Location |
| MATERIAL | Asset.Detail.PipeMaterial.Code |
| NOTAPS | Not mapped |
| OWNER | Asset.Detail.Ownership.Code |
| PIPESIZE | Asset.Detail.PipeDiameter |
| PIPESIZEUOM | Asset.Detail.PipeDiameterUOM |
| PLLNO | Asset.Detail.ParallelLineNumber |
| POSTDIR | Not mapped |
| PREDIR | Not mapped |
| Project | Project.Code |
| PROPLNDEPTH | Not mapped |
| PROPLNDEPTHUOM | Not mapped |
| PURPOSE | Not mapped |
| REHABYEAR | Not mapped |
| SCHEDDATE | ScheduledDateTime |
| SERVTYPE | Not mapped |
| SHAPE | Asset.Detail.PipeShape.Code |
| STREET | Asset.Detail.Address.StreetName |
| SUBAREA | Asset.Detail.SubArea.Code |
| SUFFIX | Asset.Detail.Address.Suffix.Code |
| SURFACE | Not mapped |
| TAPDIST | Not mapped |
| TAPDISTUOM | Not mapped |
| TAPFROM | Not mapped |
| UNITDESC | Not mapped |
| UNITID | Not mapped |
| UPDEPTH | Asset.Detail.UpstreamDepth |
| UPDEPTHUOM | Asset.Detail.UpstreamDepthUOM |
| UPGRADETOINVERT | Asset.Detail.UpstreamElevation |
| UPHOUSENO | Asset.Detail.UnitIDAsset.Detail.Address.StreetNumber |
| UPID | Asset.Detail.UnitIDAsset.ID |
| UPPOSTDIR | Asset.Detail.UnitIDAsset.Detail.Address.PostDirection |
| UPPREDIR | Asset.Detail.UnitIDAsset.Detail.Address.PreDirection |
| UPRIMTOGRADE | Not mapped |
| UPSTREET | Asset.Detail.UnitIDAsset.Detail.Address.StreetName |
| UPSUFFIX | Asset.Detail.UnitIDAsset.Detail.Address.Suffix.Code |
| UPTYPE | Asset.Detail.UnitIDAsset.AssetType.ComponentTypeCode |
| USE | Not mapped |
| USESCOMPONENTS | InspectionType.UsesComponents |
| WIDTH | Asset.Detail.PipeDiameter |
| WIDTHUOM | Asset.Detail.PipeDiameterUOM |
| WoComments | Not mapped |
| WoNo | InspectionNumber |
| XCOORD | Not mapped |
| YCOORD | Not mapped |
| ZCOORD | Not mapped |