INFO table
Information about the inspection exchange run is exported from the INSPECTIONEXCHANGERUN table (
Hansen.AssetManagement.InspectionExchangeRun object).
This table shows the property of the InspectionExchangeRun object that each column in the INFO table maps to.
| Access DB column | IPS property |
|---|---|
| ActCode | Not mapped |
| ActKey | InspectionExchangeRunKey |
| CATID | InspExchangeGlobalSetup.AttachmentCatalog.CatalogID |
| CATKEY | InspExchangeGlobalSetup.AttachmentCatalog.AttachmentsCatalogKey |
| CLIENT | InspExchangeGlobalSetup.OrganizationName |
| CLIENTID | {ClientIDValue} |
| COMMENTS | GroupInspection.Comments |
| COMPCODE | GroupInspection.AssetType.ComponentTypeCode |
| COMPDESC | GroupInspection.AssetType.Description |
| COMPTYPE | GroupInspection.AssetType.AssetType |
| COUNTRY | {CountryValue} |
| DBCATVER | Not mapped |
| DEST | ExternalDatabase |
| DTTM | InitiatedDateTime |
| ERRORCODE | Not mapped |
| ERRORDESC | Not mapped |
| H8USER | AddedBy |
| H8VERSION | {H8VersionValue} |
| INSPTYPE | GroupInspection.InspectionTypeDetail.InspectionType |
| INSPTYPEDESC | GroupInspection.InspectionTypeDetail.Description |
| INSPTYPEKEY | GroupInspection.InspectionTypeDetail.InspectionTypeKey |
| MODULES | Fixed value: 1 |
| NATIVE | Fixed value: 0 |
| PROGNAME | Fixed value: "Data Exchange Utility - Inspections" |
| PROJDESC | GroupInspection.Description |
| PROJECT | GroupInspection.GroupInspectionKey |
| PROJKEY | GroupInspection.GroupInspectionKey |
| PROJTYPE | Fixed value: "SMNFT" |
| PROVIDER | DBProvider |
| REGNAME | {RegNameValue} |
| REGNO | Not mapped |
| SERIALNO | Not mapped |
| VERSION | Fixed value: "4.8.3.012" |
| WEB_SERVICE | Not mapped |
| WINDOWS | Not mapped |
| WINVER | Not mapped |