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 |