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 Operations and Regulations 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 |