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 |