Core Expiration Engine
Mathematical precision for deadline evaluation and notice period enforcement.
UTC Date Normalization
All expiration timestamps are strictly converted and normalized to UTC, preventing ambiguous day-boundary and midnight errors across distributed timezones.
Deterministic Urgency Statuses
Dynamic evaluation categorizes obligations into Active, Due Soon (within 30 days), or Expired automatically without manual status toggling.
Notice Period Window Calculator
Calculates the exact date by which cancellation or renegotiation notice must be submitted to prevent unwanted auto-renewals.
Automated Notification System
Proactive email alerts keeping assignees informed before critical milestones.
Multi-Tier Alert Schedules
Automated reminders trigger at standard intervals (90, 60, 30, 14, 7 days before deadline), ensuring continuous operational visibility.
Idempotent Cron Dispatcher
Background reminder engine uses claim-based locking and execution state tracking to guarantee zero duplicate emails.
Exponential Backoff Retry Engine
Transient email transmission failures are automatically retried up to 5 attempts before flagging delivery issues.
Document Vault & Audit History
Secure storage and permanent audit logging for executive compliance.
Magic-Byte & Checksum Validation
Uploaded contracts and certificates undergo binary magic-byte inspection and client/server SHA-256 integrity verification.
Short-Lived Signed URLs
Stored documents are never made public. Access is granted via cryptographically signed Supabase URLs with a strict 120-second TTL.
Immutable Renewal History
Every renewal execution creates a permanent audit record containing previous expiration dates, costs, notes, and the executing user ID.
Multi-Tenant Team Workspace
Enterprise isolation and role-based permissions.
PostgreSQL Row Level Security (RLS)
Data isolation is enforced at the database engine level via tenant policies, ensuring complete segregation between workspaces.
Role-Based Access Control (RBAC)
Granular roles (Owner, Admin, Member, Viewer) restrict billing management, document uploads, and item modifications.
Instant Multi-Filter & Search
Query across title, vendor, category, department, and identifier numbers with sanitized PostgREST search expressions.