SRCEOBS table

Used to import new observations for existing inspections. The records are imported to the SWSERVINSPOB table (Hansen.AssetManagement.Street.SWServiceInspectionObservation 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 SWServiceInspectionObservation object that each column in the SRCEOBS table maps to.


Access DB column	IPS property
COMMENTS	`Comments`
COMPONENT	`ComponentType.Code`
DISTFROM	`RelativeDistanceFrom`
DISTTO	`RelativeDistanceTo`
INSPKEY	Not mapped
MEAS	`Measurement`
MEASFROM	`MeasuredFrom`
OBCODE	`ObservationDefinition.ObservationDefinitionKey`
OBDEGREE	`ObservationSeverity.ObservationSeverityKey`
OBID (required)	`ObservationKey` This is the primary key of the observation that will be updated.
OFFSET	`Offset`
OFFSETUOM	`OffsetUOM`
WIDTH	`Width`
WIDTHUOM	`WidthUOM`