SRCEOBS table
Used to import new observations for existing inspections. The records are imported to
the SEGSERVINSPOB table
(
Hansen.AssetManagement.Street.SEGServiceInspectionObservation
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 SEGServiceInspectionObservation
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) | ObservationKeyThis is the primary key of the observation that will be updated. |
| OFFSET | Offset |
| OFFSETUOM | OffsetUOM |
| WIDTH | Width |
| WIDTHUOM | WidthUOM |