Back to ER Diagram
Contract Lifecycle Management

Contract Lifecycle Management (CLM)

End-to-end contract management from creation through negotiation, approval, execution, compliance monitoring, amendments, renewal management, dispute resolution, and termination with complete audit trail.

PostgreSQL
8 Tables
Schema: clm
Legal Review

Contract Lifecycle Overview

Contracts follow a structured lifecycle from draft through active execution with options for amendment, renewal, or termination. Each stage has specific approval requirements and compliance checkpoints.

DRAFT
NEGOTIATION
PENDING_APPROVAL
ACTIVE
RENEWED
EXPIRING
TERMINATED
8
CLM Processes
8
Database Tables
90
Day Renewal Notice
Multi
Party Negotiation

1. Contract Creation & Templates

1

Initiate New Contract

Create contract from template or blank, select contract type (Master Agreement, Service Contract, Purchase Contract, NDA, SLA), define parties and key terms.

clm.contracts

  • contract_number - Auto-generated unique identifier
  • contract_type - MSA, SERVICE, PURCHASE, NDA, SLA
  • vendor_id - Reference to vendor master
  • total_value, currency_code - Contract value
  • start_date, end_date - Contract period
  • auto_renew - Automatic renewal flag
  • renewal_notice_days - Days before expiry to notify
2

Version Control

Each contract modification creates a new version. Active version is tracked with complete history maintained for audit purposes.

clm.contract_versions

  • version_number - Sequential version (1.0, 2.0, etc.)
  • document_path - Storage path for contract document
  • document_hash - SHA-256 hash for integrity
  • is_active - Current active version flag
  • effective_from, effective_to - Version validity

2. Clause Library & Negotiation

1

Clause Management

Standard clause library with risk categorization. Clauses can be marked as negotiable or non-negotiable with legal review requirements.

clm.contract_clauses

  • clause_code - Standard clause identifier
  • clause_type - PAYMENT, LIABILITY, TERMINATION, IP, CONFIDENTIALITY
  • is_standard - From standard library flag
  • is_negotiable - Can be modified flag
  • risk_level - LOW, MEDIUM, HIGH, CRITICAL
  • legal_review_required - Needs legal approval
2

Negotiation & Redlining

Track all negotiation rounds with original text, proposed changes, and resolution status. Support multi-party negotiations.

clm.contract_negotiations

  • round_number - Negotiation round (1, 2, 3...)
  • party - BUYER, VENDOR, LEGAL
  • original_text - Before modification
  • proposed_text - Proposed change
  • change_type - ADD, MODIFY, DELETE, ACCEPT, REJECT
  • status - PROPOSED, COUNTER, ACCEPTED, REJECTED

Negotiation Rules

High-risk clause modifications automatically trigger legal review. Counter-proposals reset the round counter. All negotiations are immutable for audit trail.

3. Approval Workflow

1

Multi-Stage Approval

Contracts require approval based on value thresholds and risk level. Legal review is mandatory for contracts above threshold or with modified standard clauses.

clm.contract_approvals

  • approval_stage - LEGAL, FINANCE, DEPARTMENT, EXECUTIVE
  • approval_type - PARALLEL, SEQUENTIAL
  • approver_id - Designated approver
  • delegated_from - If approval was delegated
  • status - PENDING, APPROVED, REJECTED, ESCALATED
  • due_date - SLA for approval

Approval Matrix

Contract ValueApprovers
< $50KManager
$50K - $250KManager + Legal
$250K - $1MDirector + Legal + Finance
> $1MVP + Legal + Finance + CFO

SLA Timelines

StageSLA (Days)
Legal Review5
Finance Review3
Department Head2
Executive3

4. Contract Amendment

1

Amendment Management

Amendments modify active contracts without creating entirely new contracts. Types include value change, term extension, scope modification, and party changes.

clm.contract_amendments

  • amendment_number - Sequential amendment ID
  • amendment_type - VALUE, TERM, SCOPE, PARTY, OTHER
  • original_value / amended_value - Value changes
  • original_end_date / amended_end_date - Term changes
  • change_description - Detailed amendment summary
  • effective_date - When amendment takes effect

Amendment Rules

Amendments require the same approval chain as original contract if they increase value by more than 20% or extend term by more than 12 months. Minor amendments follow expedited approval.

5. Compliance Monitoring

1

Compliance Tracking

Monitor compliance obligations, track delivery against SLAs, and identify violations early with automated alerts.

clm.contract_compliance

  • compliance_type - SLA, DELIVERY, PAYMENT, REGULATORY
  • clause_reference - Related contract clause
  • requirement - Specific compliance requirement
  • status - COMPLIANT, NON_COMPLIANT, PENDING_REVIEW
  • finding - Details of compliance check
  • corrective_action - Required remediation
  • next_check_date - Scheduled next review

SLA Monitoring

Track delivery times, response SLAs, uptime commitments, and service levels against contracted thresholds.

Milestone Tracking

Monitor project milestones, deliverable deadlines, and payment schedules defined in contract.

Automated Alerts

Proactive notifications for upcoming deadlines, SLA breaches, and compliance due dates.

6. Dispute Resolution

1

Dispute Management

Track and resolve contractual disputes through escalation, negotiation, mediation, or arbitration as defined in contract terms.

clm.contract_disputes

  • dispute_number - Unique dispute identifier
  • dispute_type - PAYMENT, DELIVERY, QUALITY, SCOPE, OTHER
  • clause_reference - Contract clause in dispute
  • disputed_amount - Financial value in dispute
  • resolution_method - NEGOTIATION, MEDIATION, ARBITRATION, LEGAL
  • settlement_amount - Final resolved amount
RAISED
UNDER_REVIEW
NEGOTIATION
RESOLVED
Escalation Path: Internal Review → Vendor Negotiation → Mediation → Arbitration → Legal Action

7. Renewal & Expiry Management

1

Renewal Workflow

Automated tracking of contract expiry with configurable notice periods. Support for auto-renewal, manual renewal, renegotiation, or termination.

Notification Schedule

  • • 90 days before: Initial renewal notice
  • • 60 days before: Renewal decision required
  • • 30 days before: Final notice / auto-renew trigger
  • • 7 days before: Expiry warning

Renewal Options

  • AUTO_RENEW Same terms extend
  • RENEGOTIATE New terms needed
  • TENDER Open to competition
  • TERMINATE End contract

8. Contract Termination

1

Termination Handling

Manage contract termination including notice period, obligations settlement, final payments, and transition planning.

Termination Checklist

Before terminating: Verify notice period compliance, settle outstanding obligations, complete pending deliverables, reconcile payments, retrieve confidential materials, and document knowledge transfer.

For Cause

Material breach, fraud, insolvency, regulatory non-compliance

For Convenience

Business decision with contractual notice period

Mutual Agreement

Both parties agree to early termination terms

Database Schema Summary

Table Purpose Key Columns Relationships
clm.contracts Master contract records contract_number, type, value, dates vendors, users
clm.contract_versions Version history version_number, document_hash contracts
clm.contract_clauses Clause library clause_code, risk_level contracts, self-reference
clm.contract_negotiations Redlining tracking round_number, change_type contracts, clauses
clm.contract_approvals Approval workflow stage, status, due_date contracts, users
clm.contract_amendments Amendment tracking amendment_type, effective_date contracts, users
clm.contract_compliance Compliance monitoring compliance_type, status contracts
clm.contract_disputes Dispute resolution dispute_type, resolution_method contracts, users