Product Management & Clinical Trials

The Products module provides lifecycle management for pharmaceutical products (drugs, biologics, devices) and their associated clinical trials. It supports pipeline visualization by lifecycle stage, product-project linking, regulatory stage transition validation, enrollment tracking, and Product Lifetime Cost (PLT) analysis with break-even modeling.

Overview

Pharmaceutical companies manage complex product portfolios where each product passes through well-defined lifecycle stages -- from early discovery through clinical trials to commercial launch and eventual patent expiry. Each stage involves multiple projects, significant capital investment, and regulatory constraints that dictate which transitions are valid.

ProBeya's Products module models this lifecycle with stage-based pipeline views, enforced transition rules, and deep integration with the PPM project portfolio. The clinical trials submodule tracks individual studies with protocol-level detail, enrollment metrics, and phase-based grouping for portfolio dashboards.

Product Lifetime Cost (PLT) analysis aggregates all linked project budgets and actual costs to compute total investment across the product lifecycle, with CAPEX/OPEX breakdowns, phase-level waterfall charts, cumulative cost curves, and break-even analysis against forecasted revenue.

Getting Started

1. Navigate to Portfolio > Products in the sidebar.
2. Click New Product and fill in the product details: name, internal code, therapeutic area, molecule, lifecycle stage.
3. Link existing PPM projects to the product using the Link Project action.
4. Add clinical trials under the product using the Clinical Trials tab.
5. View the Pipeline tab for a swim-lane visualization grouped by lifecycle stage.
6. Open the PLT Analysis tab to review Product Lifetime Cost metrics.

Key Concepts

Pharma Product Lifecycle

Products track through a regulated lifecycle sequence. The standard stages are:

1. Discovery -- Early research and target identification
2. Preclinical -- Laboratory and animal studies
3. Phase I -- First-in-human safety studies
4. Phase II -- Efficacy and dose-finding studies
5. Phase III -- Pivotal confirmatory trials
6. Regulatory Review -- NDA/MAA submission and agency review
7. Approved/Launch -- Commercial availability
8. Post-Market -- Phase IV surveillance and lifecycle management
9. Patent Expiry/Sunset -- End of exclusivity period

Stage transitions are validated to enforce the regulatory progression sequence. For example, a product cannot jump from Discovery directly to Phase III. The isValidLifecycleTransition validator ensures only adjacent stage progressions are accepted.

Product Attributes

Each product stores:

• Name and internal code (e.g., "ABC-1234")
• Therapeutic area (e.g., Oncology, Immunology, Neuroscience)
• Molecule name or compound identifier
• Indication description: the disease or condition being targeted
• Lifecycle stage: current position in the regulatory pipeline
• Patent expiry date and launch date
• Financial projections: peak sales (EUR), NPV, IRR, discount rate
• Forecasted revenue: array of period-revenue pairs for break-even modeling
• Tags for filtering and categorization

Clinical Trials

Clinical trials represent individual studies associated with a product. Each trial tracks:

• Title and protocol number (unique study identifier)
• Clinical trial registry ID (e.g., ClinicalTrials.gov NCT number)
• Trial phase: Phase I, Phase I/II, Phase II, Phase II/III, Phase III, Phase IV
• Status: planning, recruiting, active, completed, terminated, or suspended
• Enrollment target and enrollment actual: recruitment metrics
• Key dates: First Patient In (FPI), Last Patient Out (LPO), Database Lock
• Primary and secondary endpoints: study outcome measures
• Linked project: the PPM project managing this trial's execution

Trial statuses follow ICH GCP-aligned transition rules. Terminal statuses (completed, terminated) cannot be reverted. Suspended trials can return to recruiting or active if the hold is lifted.

Pipeline View

The pipeline view groups all products by lifecycle stage in a swim-lane layout. Each lane shows the products currently at that stage with key metrics (linked project count, trial count, NPV). This provides a single-page portfolio overview of the entire product pipeline.

Product Lifetime Cost (PLT)

PLT analysis aggregates financial data across all projects linked to a product:

• Total PLT: sum of all linked project budgets with CAPEX/OPEX breakdown
• Phase waterfall: cost breakdown by lifecycle phase showing incremental investment at each stage
• Cumulative cost curve: time-series of actual costs plotted against the budget baseline
• Break-even analysis: intersection of cumulative cost and forecasted revenue, identifying the point at which the product becomes profitable

How It Works

Creating Products

Product creation requires a name, internal code, and initial lifecycle stage. Financial projections (peak sales, NPV, IRR) are optional but recommended for PLT analysis. Numeric fields are stored as PostgreSQL NUMERIC to preserve decimal precision.

Linking Projects

Projects are linked to products with a relationship type (e.g., "primary", "supporting", "regulatory"). Both the product and project must belong to the same organization. Unlinking removes the association but does not affect either entity.

Lifecycle Transitions

When updating a product's lifecycle stage, the system validates the transition against the allowed progression sequence. Invalid transitions (e.g., skipping stages or moving backward) are rejected with an explanatory error message. This prevents accidental misrepresentation of a product's regulatory status.

Clinical Trial Management

Trials are created under a specific product. The system verifies that both the product and any linked project belong to the caller's organization before creating the trial. Status transitions follow the clinical trial state machine with explicit validation.

The Enrollment Tracker shows target vs. actual enrollment for each trial, enabling recruitment monitoring. The Trials by Product view groups all trials for a product by phase, providing a study-level dashboard.

Break-Even Computation

The break-even analysis combines:

1. Cumulative actual costs from all linked project cost entries
2. Forecasted revenue from the product's forecastedRevenue array

The intersection point where cumulative revenue exceeds cumulative cost is the break-even date. If the curves do not intersect within the forecast horizon, the analysis indicates that break-even has not been reached.

Configuration

Setting	Location	Description
Lifecycle stage	Product form	Current regulatory stage
Therapeutic area	Product form	Disease area classification
Financial projections	Product form	Peak sales, NPV, IRR, discount rate
Forecasted revenue	Product form	Period-revenue pairs for break-even modeling
Trial phase	Clinical trial form	Study phase classification
Enrollment target	Clinical trial form	Planned number of participants
Key dates	Clinical trial form	FPI, LPO, database lock dates

Permissions

• View products and trials: all organization members with PPM access
• Create/edit products: requires PPM admin or product manager role
• Delete products: requires PPM admin role (only if no linked projects remain)
• Link/unlink projects: requires PPM admin or product manager role
• Manage clinical trials: requires PPM admin or clinical operations role
• View PLT analysis: all organization members with PPM access

Tips & Best Practices

• Use internal codes consistently: Internal codes (e.g., "ABC-1234") should follow your organization's naming convention for easy cross-referencing with external systems.
• Link all relevant projects: PLT analysis is only as accurate as the project linkage. Ensure every project that contributes to a product's development is linked.
• Enter forecasted revenue early: Break-even analysis requires revenue forecasts. Enter these during the preclinical/Phase I stage and refine as clinical data matures.
• Track enrollment closely: Recruitment is the most common source of clinical trial delays. Use the enrollment tracker to identify shortfalls early.
• Validate stage transitions carefully: Stage changes are significant regulatory events. Ensure the product has genuinely met the criteria for the new stage before updating.
• Review the pipeline quarterly: The pipeline view during portfolio reviews helps identify stage bottlenecks and resource allocation needs.

Troubleshooting

Issue	Cause	Resolution
Cannot delete product	Product has linked projects	Unlink all projects before deleting the product.
Lifecycle stage transition rejected	Invalid transition (non-adjacent stages)	Products must progress through stages sequentially. Check the current stage.
Clinical trial status transition rejected	Terminal status (completed/terminated)	Completed and terminated trials cannot be reactivated. Create a new trial if needed.
PLT analysis shows zero values	No linked projects with budget data	Ensure linked projects have budget lines and cost entries.
Break-even not computed	No forecasted revenue entered	Add forecasted revenue data to the product record.
Enrollment tracker shows no data	Trial has no enrollment target set	Set the enrollment target on the clinical trial record.

Related Features

• Projects -- PPM projects linked to products for lifecycle execution
• Budgets & Costs -- Project budgets feed PLT analysis
• Schedules -- Project schedules support clinical trial timeline tracking
• Risk Management -- Product-level risks map to clinical and regulatory categories
• Financial Reports -- Project financial reports complement PLT analysis