Assetram

Overview

• ▸Multi-tenant SaaS with company-scoped data isolation; a copy-on-write architecture lets global templates and reference data be forked per company without duplication
• ▸Full asset hierarchy (4-level equipment tree per ISO 14224) with drag-and-drop tree navigation, combined/equipment-class/hierarchy view modes, and inline editing
• ▸API 581 risk assessment engine: 224 seeded formulas, 77 lookup tables, 25 risk assessment templates covering all major failure mechanisms (thinning, SCC, HTHA, fatigue, COF, inspection planning)
• ▸PostGIS-backed geospatial features: Google Maps integration, pipeline/crossing detection against roads, water bodies, railways, and landslide susceptibility zones (AER data)
• ▸Public regulator data ingestion (AER, BCER, PMAA, Saskatchewan MER) via Celery Beat scheduled imports, with company operator alias matching to auto-link public records to internal assets
• ▸Inspection planning system: schedules → occurrences → inspection plans → report execution → TA packages → external inspector portal
• ▸SOC 2-aligned security: JWT in HttpOnly cookies, MFA (TOTP), audit logging, account lockout, rate limiting, security headers
• ▸Dynamic formula engine with per-field formula assignment, formula lookup tables with display labels, and reference lookup wiring for dropdown fields