SRCEOBS_NEW table

Used to import observations for new inspections. The new observations are added to the SEGSERVINSPOB table (Hansen.AssetManagement.Street.SEGServiceInspectionObservation object).

This table shows the property of the SEGServiceInspectionObservation object that each column in the SRCEOBS_NEW table maps to.

Access DB column IPS property
COMPONENT ComponentType.Code
DISTFROM RelativeDistanceFrom
DISTTO RelativeDistanceTo
ID Enter any unique string value as an identifier.
INSPKEY Primary key of the inspection that the observation is associated with. This must match the INSPKEY column for an inspection in the SRCEINSP or SRCEINSP_NEW_ASSET table.
MEAS Measurement
MEASFROM MeasuredFrom
OBCODE ObservationDefinition.ObservationDefinitionKey
OBDEGREE ObservationSeverity.ObservationSeverityKey
OBID Specify a temporary key for the new observation record. The value must be unique.

This key is used only to link attachments to the observation within the Access database. When observations are imported, the links are established in the Infor Public Sector database using the keys generated during the import process.

OFFSET Offset
OFFSETUOM OffsetUOM
WIDTH Width
WIDTHUOM WidthUOM