SRCESCTV table
Used to import existing sewer main inspections that have been updated. The updated records are imported to the SMNSERVICEINSP table (
Hansen.AssetManagement.Sewer.SMNServiceInspection object).
This table shows the property of the SMNServiceInspection object that each column in the SRCESCTV table maps to.
| Access DB column | IPS property |
|---|---|
| ActKey | Not mapped |
| ADDLOC | Not mapped |
| AREA | Not mapped |
| CATEGORY | Not mapped |
| CLEANED | Not mapped |
| CLNOUTLOC | Not mapped |
| Comments | Not mapped |
| COMPDATE | CompletedDateTime |
| COMPKEY | Not mapped |
| COMPLETED | Not mapped |
| Condition | Not mapped |
| CREW | Not mapped |
| CREWLEAD | Not mapped |
| CUSTOMER | Not mapped |
| DIRECTION | Not mapped |
| DISTRICT | Not mapped |
| DNASSETYPE | Not mapped |
| DNDEPTH | Not mapped |
| DNDEPTHUOM | Not mapped |
| DNGRADETOINVERT | Not mapped |
| DNHOUSENO | Not mapped |
| DNID | Asset.Detail.ID2 |
| DNRIMTOGRADE | Not mapped |
| DNSTREET | Not mapped |
| DNSUFFIX | Not mapped |
| ErrorLevel | Not mapped |
| FLOWCONTROL | Not mapped |
| FLOWDEPTH | Not mapped |
| GRPKEY | Not mapped |
| HistKey | Not mapped |
| HOUSENO | Not mapped |
| HT | SurveyedHeight |
| HTUOM | Not mapped |
| Import | Not mapped |
| Imported | Not mapped |
| INSPKEY (required) | InspectionNumber
This is the primary key of the inspection that will be updated. |
| INSTDATE | Not mapped |
| JOINTSPACE | Not mapped |
| JOINTTYPE | Not mapped |
| JTLENUOM | Not mapped |
| LENGTH | AssetLength |
| LENGTHUOM | Not mapped |
| LININGMETHOD | Not mapped |
| LOCATION | Not mapped |
| MATERIAL | Not mapped |
| MEDIAFORM | Not mapped |
| MEDIANO | MediaNumber |
| MEDIASTART | Not mapped |
| MEDIASTOP | Not mapped |
| NOTAPS | Not mapped |
| NOTES | Comments |
| OWNER | Not mapped |
| PIPEDET | Not mapped |
| PIPESIZE | SurveyedDiameter |
| PIPESIZEUOM | Not mapped |
| PLLNO | Asset.Detail.ParallelLineNumber |
| PRECLEAN | PreCleaning.Code |
| PRESSURE | Not mapped |
| Project | Project.Code |
| PROPLINEDEPTH | Not mapped |
| PROPLINEDEPTHUOM | Not mapped |
| PURPOSE | Responsibility.Code |
| REHABYEAR | Not mapped |
| Result | Not mapped |
| REVERSE | Not mapped |
| SERVTYPE | Not mapped |
| SHAPE | Not mapped |
| SHEETNO | Not mapped |
| STARTDATE | StartDateTime |
| STREET | Not mapped |
| SUBAREA | Not mapped |
| SUFFIX | Not mapped |
| SURFACE | Not mapped |
| TAPDIST | Not mapped |
| TAPDISTUOM | Not mapped |
| TAPFROM | Not mapped |
| TAPHOUSENO | Not mapped |
| TAPSTREET | Not mapped |
| TAPSUFFIX | Not mapped |
| UPASSETYPE | Not mapped |
| UPDEPTH | Not mapped |
| UPDEPTHUOM | Not mapped |
| UPGRADETOINVERT | Not mapped |
| UPHOUSENO | Not mapped |
| UPID | Asset.Detail.ID |
| UPRIMTOGRADE | Not mapped |
| UPSTREET | Not mapped |
| UPSUFFIX | Not mapped |
| USE | Not mapped |
| VIDOP | CompletedBy.EmployeeID |
| WEATHER | Weather.Code |
| WIDTH | AssetWidth |
| WIDTHUOM | Not mapped |
| XCOORD | Not mapped |
| YCOORD | Not mapped |
| ZCOORD | Not mapped |