SRCINSP_NEW_ASSET table
Used to import new sidewalks inspections that have been added outside of Infor Operations and Regulations. 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 Operations and Regulations 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 |