NEWSCTV table
Used to import new inspections that have been added outside of Infor Operations and Regulations. The new inspections are added to the SMNSERVICEINSP table (
Hansen.AssetManagement.Sewer.SMNServiceInspection object).
The new inspections will use the inspection type of the group inspection, and will be linked to the group inspection when they are imported.
This table shows the property of the SMNServiceInspection object that each column in the NEWSCTV 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 | Asset.AssetKey |
| COMPLETED | Not mapped |
| Condition | Not mapped |
| CREW | Not mapped |
| CREWLEAD | Not mapped |
| CUSTOMER | Not mapped |
| DIRECTION | Not mapped |
| DISTRICT | Not mapped |
| DNASSETTYPE | 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 | GroupInspection.GroupInspectionKey |
| HistKey | Not mapped |
| HOUSENO | Not mapped |
| HT | SurveyedHeight |
| HTUOM | Not mapped |
| Import | Not mapped |
| Imported | Not mapped |
| INSPKEY | Specify a temporary key for the new inspection record. The value must be unique.
This key is used only to link observations and attachments to the inspection within the Access database. When inspections are imported, the links are established in the Infor Operations and Regulations database using the keys generated during the import process. |
| INSPNO | Not mapped |
| 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 |
| NEWINSPNO | Not mapped |
| NOTAPS | Not mapped |
| NOTES | Comments |
| OWNER | Not mapped |
| PIPEDET | Not mapped |
| PIPESIZE | SurveyedDiameter |
| PIPESIZEUON | Not mapped |
| PLLNO | Asset.Detail.ParallelLineNumber |
| PRECLEAN | PreCleaning.Code |
| PRESSURE | Not mapped |
| Project | Project.Code |
| PROPLNDEPTH | Not mapped |
| PROPLNDEPTHUOM | 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 |
| UPASSETTYPE | 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 |