PPM API

ProBeya includes a comprehensive Project Portfolio Management (PPM) module designed as a “Planisware Lite” for pharmaceutical organizations. The PPM system covers the full project lifecycle from demand intake through portfolio optimization, budgeting, earned value management, and resource planning. All PPM procedures are available through tRPC.

Module Overview

The PPM module spans multiple routers, each handling a specific domain:

PPM Architecture
  |-- Portfolios       Strategic portfolio management
  |-- Demand           Intake portal and approval workflows
  |-- Programs         Program grouping and governance
  |-- Projects         PPM project lifecycle
  |-- Budgets          CAPEX/OPEX financial planning
  |-- Cost Entries     Actual cost tracking
  |-- Cost Rates       Resource cost rate tables
  |-- EVM              Earned Value Management (CPI, SPI, EAC, ETC)
  |-- WBS              Work Breakdown Structure
  |-- Stage Gates      Phase-gate governance
  |-- Risks            Risk register with scoring
  |-- Benefits         Benefits realization tracking
  |-- Baselines        Schedule and cost baselines
  |-- Resources        Capacity planning and allocation
  |-- Skills           Skills taxonomy and proficiency
  |-- Timesheets       Time tracking and approval
  |-- Scoring          Multi-criteria project scoring
  |-- Scenarios        What-if portfolio scenarios
  |-- Calendars        Working calendars and holidays
  |-- Templates        Project and WBS templates
  |-- Reports          Financial, schedule, and portfolio reports

Portfolios

Strategic portfolio management with project categorization, strategic objectives, and optimization.

Router: ppmPortfolios

ProcedureTypeDescription
ppmPortfolios.createMutationCreate a new portfolio
ppmPortfolios.listQueryList portfolios in the organization
ppmPortfolios.getByIdQueryGet portfolio with project details
ppmPortfolios.updateMutationUpdate portfolio properties
ppmPortfolios.archiveMutationArchive a portfolio
ppmPortfolios.addProjectMutationAdd a project to the portfolio
ppmPortfolios.removeProjectMutationRemove a project from the portfolio
ppmPortfolios.reorderProjectsMutationReorder projects within the portfolio
ppmPortfolios.createObjectiveMutationCreate a strategic objective
ppmPortfolios.updateObjectiveMutationUpdate a strategic objective
ppmPortfolios.deleteObjectiveMutationDelete a strategic objective
ppmPortfolios.listObjectivesQueryList strategic objectives
ppmPortfolios.getPortfolioSummaryQueryAggregate budget, EVM, and scoring data

The portfolio optimizer supports:

  • Optimal mix calculation with budget and resource constraints
  • Efficient frontier generation for value vs. cost trade-off analysis
  • NPV computation for financial evaluation
  • Weighted scoring with configurable criteria

Demand Management

Intake portal for project demand requests with full lifecycle: submission, review, scoring, approval/rejection, and project conversion.

Router: ppmDemand

ProcedureTypeDescription
ppmDemand.createMutationCreate a demand request
ppmDemand.updateMutationUpdate request details
ppmDemand.submitMutationSubmit for review
ppmDemand.reviewMutationReview and approve/reject
ppmDemand.withdrawMutationWithdraw a request
ppmDemand.quickScoreMutationQuick scoring for triage
ppmDemand.batchActionMutationBatch approve/reject multiple requests
ppmDemand.convertToProjectMutationConvert approved request to PPM project
ppmDemand.listQueryList requests with filters
ppmDemand.getByIdQueryGet request with full details
ppmDemand.getAnalyticsQueryDemand pipeline analytics

Status lifecycle: draft > submitted > under_review > approved / rejected / deferred

Business case templates can be configured for standardized request submissions.


Financial Management

Budgets (ppmBudgets)

CAPEX/OPEX budget planning with period-based allocation.

Key proceduresDescription
create, update, deleteBudget CRUD
getByProjectGet budget breakdown for a project
allocateAllocate budget to a period

Cost Tracking (ppmCostEntries, ppmCostRates)

Actual cost recording and resource rate management for EVM calculations.

EVM (ppmEvmV2)

Earned Value Management with industry-standard metrics:

MetricDescription
PVPlanned Value
EVEarned Value
ACActual Cost
CPICost Performance Index (EV / AC)
SPISchedule Performance Index (EV / PV)
EACEstimate At Completion
ETCEstimate To Complete
VACVariance At Completion

Project Execution

WBS (ppmWbs)

Work Breakdown Structure with hierarchical task management.

Key proceduresDescription
create, update, deleteWBS element CRUD
getTreeFetch WBS as nested tree
reorderReorder elements
getByProjectGet full WBS for a project

Stage Gates (ppmGates)

Phase-gate governance with formal gate reviews.

Key proceduresDescription
listGatesList gates for a project
createReviewCreate a gate review
submitReviewSubmit gate review decision

Risks (ppmRisks)

Risk register with probability/impact scoring.

Key proceduresDescription
create, update, deleteRisk CRUD
listList risks with filters
getMatrixGet probability-impact risk matrix

Resource Management

Capacity Planning (ppmCapacityPlans)

Resource allocation and capacity forecasting.

Skills (ppmSkills)

Skills taxonomy with proficiency levels for resource matching.

Timesheets (ppmTimesheets)

Time tracking with approval workflows.

Hiring Plans (ppmHiringPlans)

Workforce planning aligned with project demand.


Analytics and Reporting

RouterDescription
ppmDashboardPortfolio-level dashboard with aggregated metrics
ppmFinancialReportsBudget vs. actual, cost forecasts, LRFP
ppmScheduleReportsTimeline, milestone, and critical path reports
ppmResourceReportsUtilization, allocation, and availability reports
ppmPortfolioReportsPortfolio health, scoring distribution, what-if analysis

Scenario Planning

The ppmScenarios and ppmScheduleScenarios routers support what-if analysis:

  • Create alternative portfolio compositions
  • Compare scenarios on budget, resource, and timeline impact
  • Simulate schedule changes and their downstream effects
  • Export comparison reports

Integration Notes

The PPM module is designed for pharma organizations managing complex project portfolios. It integrates with ProBeya’s core modules:

  • Actions link to WBS elements for task execution
  • KPIs track project health metrics
  • Forms power demand intake workflows
  • Notifications alert on gate reviews, budget overruns, and milestone deadlines