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 Public Sector 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