NEWSCTV table
Used to import new inspections that have been added outside of Infor Public Sector. 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 Public Sector 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 |