SRCINSP_NEW_ASSET table
Used to import new sidewalks inspections that have been added outside of Infor Public Sector. The new inspections are added to the SWSERVICEINSP table
(
Hansen.AssetManagement.Street.SWServiceInspection 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 SWServiceInspection object that each
column in the SRCINSP_NEW_ASSET table maps to.
| Access DB column | IPS property |
|---|---|
| AREA | Not mapped |
| ASSETLEN | AssetLength |
| ASSETLENUOM | AssetLengthUOM |
| ASSETWID | AssetWidth |
| ASSETWIDUOM | AssetWidthUOM |
| ASSIGNED | Not mapped |
| BASEDEPTH | Not mapped |
| BASETYPE | Not mapped |
| BUSROUTE | Not mapped |
| COMMENTS | Comments |
| COMPBY | CompletedBy.EmployeeID |
| COMPDATE | CompletedDateTime |
| COMPKEY | Asset.AssetKey |
| COMPLETED | Not mapped |
| CREW | Responsibility.Code |
| CREWLEAD | Not mapped |
| CURBTYPE | Not mapped |
| DISTRICT | Not mapped |
| DIVIDERTYPE | Not mapped |
| FILLER | Not mapped |
| GRADE | Not mapped |
| GRPKEY | Not mapped |
| HIGHADDR | Not mapped |
| ID | 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. |
| LOCATION | Not mapped |
| LOWADDR | Not mapped |
| NUOFLANES | Not mapped |
| ONEWAY | Not mapped |
| OWNER | Not mapped |
| PEDTRAFFIC | Not mapped |
| SPEEDLIMIT | Not mapped |
| STARTDATE | StartDateTime |
| SUBAREA | Not mapped |
| SURFDEPTH | Not mapped |
| SURFDEPTHUOM | Not mapped |
| SURFTYPE | Not mapped |
| SURFWIDTH | Not mapped |
| SURFWIDTHUOM | Not mapped |
| TOREF | Not mapped |
| TRUCKROUTE | Not mapped |
| XCOORD | Not mapped |
| YCOORD | Not mapped |
| ZCOORD | Not mapped |