0029 Element Inspection

0029 Element Inspection

• PON_ENVT_DEFS -> Environment
• PON_ELEM_INSP -> ElementInspection
• ASSET_ELEM_INSP -> ElementInspection

Data Considerations

• Duplicates
• Null Data Replacement - See SQL

Other Notes

• This script contains custom logic for PON_ELEM_INSP tables that contain the column INSPECTED.
• The script migration element inspection for bridge and non-bridge assets.
• The following fields are required to be valid for element inspections to migrate:
  • STRUCTURE_UNIT_GD
  • PON_ENVT_DEFS_GD
  • PON_ELEM_DEFS_GD
  • INSPEVNT_GD
  • Asset Specific: ASSET_ELEM_DEFS_GD, BRIDGE_GD
• ConditionStateQuality fields may be rounded to (12,3) to match SNBI precision and scale.