Data Primitives

interface DemandSignal {
  source: 'pipeline' | 'project' | 'strategic';
  confidence: number; // 0-1
  fteEquivalent: number;
  timeHorizon: '0-3m' | '3-6m' | '6-12m';
  businessUnit: string;
}

function weightByRisk(signal: DemandSignal): number {
  const horizonWeight = {
    '0-3m': 0.95,
    '3-6m': 0.75,
    '6-12m': 0.50,
  };
  return signal.fteEquivalent * signal.confidence * horizonWeight[signal.timeHorizon];
}

SELECT
    bu.name                         AS business_unit,
    SUM(d.fte_equivalent)           AS raw_demand,
    SUM(d.fte_equivalent * d.confidence * h.weight) AS risk_weighted_demand,
    COUNT(DISTINCT d.role_id)       AS unique_roles
FROM demand_signals d
JOIN business_units bu ON bu.id = d.business_unit_id
JOIN horizon_weights h ON h.horizon = d.time_horizon
WHERE d.active = true
GROUP BY bu.name
ORDER BY risk_weighted_demand DESC;