Back to ER Diagram
Legal & Compliance

Legal & Compliance Logic

Regulatory permits, government approvals, licenses, right-of-way, legal cases, and compliance tracking for construction projects.

PostgreSQL
6 Tables
Schema: legal
Regulatory Compliance

Overview

Legal & Compliance manages all regulatory approvals, permits, licenses, and legal proceedings for construction projects. Building permits, environmental clearances, right-of-way acquisitions, and statutory licenses are tracked with application-to-approval lifecycle. Government approvals from multiple authorities coordinated. Legal cases and disputes managed with hearing schedules and outcome tracking.


Apply

Track

Obtain Approval

Monitor Compliance

Renew
6
Legal Tables
Multi
Authority Tracking
Auto
Renewal Alerts
Compliance
Dashboard

Status States

StatusDescriptionAllowed ActionsNext States
AppliedApplication submitted to authorityTrack, Follow UpUnder Review
Under ReviewAuthority processing applicationRespond to QueriesApproved, Rejected
ApprovedPermit/license obtainedMonitor Conditions, RenewExpiring
ExpiringWithin 60 days of expiryRenew, ExtendActive, Expired
ExpiredValidity period endedApply FreshApplied
RejectedApplication deniedAppeal, ReapplyApplied

Database Schema

legal.regulatory_permit

  • permit_id — PK
  • project_id — FK → project.project
  • permit_type — building | environmental | fire | occupation
  • authority, reference_number — Issuing authority and permit number
  • applied_date, approved_date, expiry_date — Lifecycle dates
  • conditions_json — Permit conditions to comply with
  • status — Applied → Under Review → Approved → Expired

legal.government_approval

  • approval_id — PK
  • project_id — FK → project.project
  • department — municipal | environment | fire | labour | highway
  • approval_type, description — Type and details
  • status, remarks — Current state and notes

legal.license

  • license_id — PK
  • entity_id — FK → organization.company_entity
  • license_type — contractor | labour | blasting | crane
  • license_number, issued_by — Details
  • valid_from, valid_to — Validity period
  • renewal_reminder_days — Days before expiry to alert

legal.legal_case

  • case_id — PK
  • project_id — FK → project.project
  • case_type — arbitration | litigation | mediation | regulatory
  • case_number, court_forum — Case identification
  • filed_date, next_hearing_date — Key dates
  • claim_amount, status — Financial exposure and progress

Legal Process

1

Permit Application

Prepare and submit permit applications with required documents. Track submission receipts and reference numbers. Monitor processing timelines.

2

Authority Coordination

Respond to authority queries. Arrange site inspections. Coordinate between multiple departments for concurrent approvals.

3

Compliance Monitoring

Once permits obtained, monitor compliance with conditions. Record inspections, reports, and submissions required by permit conditions.

4

License Renewal

System alerts before license expiry. Renewal applications submitted with updated documents. Track continuity — construction stops if critical licenses lapse.

5

Legal Case Management

Track arbitration and litigation proceedings. Schedule hearing dates, manage documents, and monitor outcomes. Provision for potential liabilities in finance.

Legal Queries

Permit Expiry Dashboard

SELECT rp.permit_type, rp.authority, rp.reference_number,
       rp.expiry_date,
       rp.expiry_date - CURRENT_DATE AS days_remaining,
       CASE
         WHEN rp.expiry_date < CURRENT_DATE THEN 'EXPIRED'
         WHEN rp.expiry_date < CURRENT_DATE + 60 THEN 'EXPIRING'
         ELSE 'VALID'
       END AS alert_status
FROM legal.regulatory_permit rp
WHERE rp.project_id = :project_id
ORDER BY rp.expiry_date;

Validation Rules

Business Rules

  • Construction Start: Building permit must be valid before construction activities commence
  • Environmental Clearance: Environmental permit conditions must be met for monthly compliance report
  • Labour License: Labour license must cover actual headcount deployed
  • Case Provision: Legal cases above ₹1 Cr must have financial provision in accounts

Integration Points

Connected Modules

  • Project: Permits linked to project milestones and activities
  • HSE: Environmental permit conditions linked to HSE monitoring
  • Finance: Legal case provisions tracked as contingent liabilities
  • Document: All permit documents stored in document management

Best Practices

Recommended

  • Maintain permit tracker dashboard visible to project team
  • Start permit applications 3-6 months before needed
  • Track all authority interactions with formal correspondence
  • Review legal case portfolio quarterly with external counsel