SRCESMFO table
Used to import new observations for existing inspections. The records are imported to the SMNSERVINSPOB table (
Hansen.AssetManagement.Sewer.SMNServiceInspectionObservation object).
Existing observations are not updated. Any existing observations in Infor Operations and Regulations are deleted when new ones are imported.
This table shows the property of the SMNServiceInspectionObservation object that each column in the SRCESMFO table maps to.
| Access DB column | IPS property |
|---|---|
| CDKey | Not mapped |
| COMMENTS | Comments |
| COMPONENT | Not mapped |
| DEFECTPERCENT | Not mapped |
| DistFrom | StartDistance |
| DistTo | DistanceTo |
| ErrorLevel | Not mapped |
| GROUTED | IsGrouted |
| Images | Not mapped |
| ImgId | Not mapped |
| INCH1 | Not mapped |
| INCH2 | Not mapped |
| INSPKEY | Not mapped |
| JOINT | Not mapped |
| MEAS | Measurement |
| MEASFROM | MeasuredFrom |
| MEDIALOC | VTRIndex |
| OBCODE | ObservationDefinition.ObservationDefinitionKey |
| OBDEGREE | ObservationSeverity.ObservationSeverityKey |
| ObKey | Not mapped |
| OBPOSFROM | PositionFrom.Code |
| OBPOSTO | PositionTo.Code |
| OBSID (required) | ObservationKey
This is the primary key of the observation that will be updated. |
| OFFSET | Offset |
| OFFSETUOM | Not mapped |
| RELDISTFR | RelativeDistanceFrom |
| RELDISTTO | RelativeDistanceTo |
| WIDTH | Width |
| WIDTHUOM | Not mapped |