SRCEINSP_NEW_ASSET table
Used to import new inspections that have been added outside of Infor Public Sector. The new inspections are added to the SEGSERVICEINSP table
(
Hansen.AssetManagement.Street.SEGServiceInspection 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 SEGServiceInspection object that each
column in the SRCEINSP_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 (required) | 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 | Enter any unique string value as an identifier. |
| 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. |
| 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 |