Workforce Intelligence™ Data Architecture

Platform Data ArchitectureMaster Entity Relationship Diagram

Complete data architecture for the Business Impact Platform™ — 8 platform domains, 25+ entity models, 150+ field definitions, cross-module data flows, and 4 core engine specifications. Designed to support 10,000+ customers and millions of benchmark data points.

Data Domains

25+

Entities

150+

Fields Defined

Engine Specs

Master Entity Relationship Diagram

Platform Data Model

Five architectural layers spanning 8 platform domains. Each layer feeds the next — assessment results power scores, scores power benchmarks, benchmarks power recommendations, recommendations drive workforce configurations, and configurations produce measurable business impact.

Assessment & Intelligence Layer

Layer 1 of 5

BusinessDNAAssessment

BusinessDNAReport

AssessmentHistory

OrganizationProfile

WorkforceIntelligenceScore

Data flows toProof

Proof & Benchmark Layer

Layer 2 of 5

ProofCenterEntry

RevenueRecoveryAudit

PeerGroupIndex

PeerGroup

IndustryBenchmark

Data flows toWorkforce

Workforce & Configuration Layer

Layer 3 of 5

DigitalWorkforceConfiguration

DigitalTeamMember

WorkforceExpansionHistory

Data flows toImpact

Impact & Reporting Layer

Layer 4 of 5

BusinessImpactDashboard

DashboardWidget

QuarterlyBusinessImpactReport

Data flows toExpansion

Expansion & Forecasting Layer

Layer 5 of 5

ExpansionTrigger

ExpansionForecast

Cross-Domain Relationship Matrix

From Entity	Relationship	To Entity	Foreign Key	Description
OrganizationProfile	1:1	WorkforceIntelligenceScore	organizationId	Each organization has one current intelligence score record
OrganizationProfile	1:N	DigitalWorkforceConfiguration	organizationId	Organization can have multiple workforce configurations over time
OrganizationProfile	1:N	AssessmentHistory	organizationId	Full history of all assessments and score recomputations
WorkforceIntelligenceScore	N:1	OrganizationProfile	organizationId	Scores belong to one organization
WorkforceIntelligenceScore	1:N	WorkforceGap	scoreId	Each score computation produces gap records
WorkforceIntelligenceScore	1:N	RecommendationMatch	scoreId	Each score computation produces matched recommendations
BusinessDNAAssessment	N:1	OrganizationProfile	organizationId	Assessment belongs to one organization
BusinessDNAAssessment	1:1	BusinessDNAReport	assessmentId	Each assessment can generate one executive report
BusinessDNAAssessment	1:N	AssessmentHistory	assessmentId	Assessment archived in history for trend analysis
BusinessDNAReport	N:1	BusinessDNAAssessment	assessmentId	Report generated from one assessment
BusinessDNAReport	N:1	OrganizationProfile	organizationId	Report belongs to one organization
BusinessDNAReport	1:1	BusinessesLikeYours	organizationId	Benchmark position derived from DNA profile
AssessmentHistory	N:1	OrganizationProfile	organizationId	History belongs to one organization
AssessmentHistory	N:1	BusinessDNAAssessment	assessmentId	Snapshot references original assessment
ProofCenterEntry	N:1	OrganizationProfile	organizationId	Proof point optionally linked to source organization
ProofCenterEntry	1:N	BusinessImpactDashboard	proofId	Proof points feed impact dashboard widgets
RevenueRecoveryAudit	N:1	OrganizationProfile	organizationId	Audit belongs to one organization
RevenueRecoveryAudit	1:N	ProofCenterEntry	organizationId	Audit results can generate proof points
PeerGroupIndex	N:1	OrganizationProfile	organizationId	Index entry for one organization
PeerGroupIndex	N:1	PeerGroup	peerGroupId	Index entry belongs to a peer group cluster
PeerGroup	1:N	PeerGroupIndex	peerGroupId	Peer group contains many organization indices
PeerGroup	1:1	IndustryBenchmark	peerGroupId	Peer group maps to industry benchmark record
IndustryBenchmark	N:1	PeerGroup	peerGroupId	Benchmark derived from a peer group or industry aggregate
DigitalWorkforceConfiguration	N:1	OrganizationProfile	organizationId	Configuration belongs to one organization
DigitalWorkforceConfiguration	1:N	DigitalTeamMember	configId	Configuration contains many team members
DigitalWorkforceConfiguration	1:1	BusinessImpactDashboard	configId	Each configuration feeds one dashboard instance
DigitalTeamMember	N:1	DigitalWorkforceConfiguration	configId	Member belongs to one configuration
DigitalTeamMember	N:1	WorkforceIntelligenceScore	organizationId	Member performance tracked against workforce scores
WorkforceExpansionHistory	N:1	OrganizationProfile	organizationId	Expansion belongs to one organization
WorkforceExpansionHistory	N:1	ExpansionTrigger	triggerType	Expansion linked to triggering signal
BusinessImpactDashboard	N:1	OrganizationProfile	organizationId	Dashboard for one organization
BusinessImpactDashboard	N:1	DigitalWorkforceConfiguration	configId	Dashboard driven by active configuration
BusinessImpactDashboard	1:N	DashboardWidget	dashboardId	Dashboard contains many widgets
DashboardWidget	N:1	BusinessImpactDashboard	dashboardId	Widget belongs to one dashboard
QuarterlyBusinessImpactReport	N:1	OrganizationProfile	organizationId	QBIR for one organization
QuarterlyBusinessImpactReport	1:N	AssessmentHistory	organizationId	QBIR references historical assessment data for trend analysis
QuarterlyBusinessImpactReport	1:N	WorkforceExpansionHistory	organizationId	QBIR summarizes quarterly expansion activity
ExpansionTrigger	N:1	OrganizationProfile	organizationId	Trigger belongs to one organization
ExpansionTrigger	1:1	WorkforceExpansionHistory	triggerId	Executed trigger produces one expansion history record
ExpansionForecast	N:1	OrganizationProfile	organizationId	Forecast for one organization
ExpansionForecast	N:1	WorkforceIntelligenceScore	organizationId	Forecast driven by current intelligence scores

Data Dictionary

Complete Field-Level Data Dictionary

Every field across all 25+ entities, with type, required status, source system, and description. Organized by domain for easy reference.

Workforce Intelligence Core

Storage: Primary: PostgreSQL (scores, profiles). Cache: Redis (dashboard queries). Archive: S3 (historical reports).confidential

OrganizationProfile— Core organization record linking Business DNA™, workforce config, and intelligence scores

Field	Type	Req	Source	Description
organizationId	UUID	R	assessment	Primary key
businessDNAProfile	JSONB	R	assessment	Full Business DNA™ profile with 5 archetypes, confidence scores, alternative types
industry	VARCHAR(100)	R	assessment	Primary industry classification from 50-industry taxonomy
revenueRange	VARCHAR(20)	R	assessment	Annual revenue bracket for peer grouping
employeeCount	INTEGER	R	assessment	Total employee count for capacity calculations
locationCount	INTEGER	R	assessment	Active locations for multi-location scenarios
assessmentCompletedAt	TIMESTAMP	R	assessment	When the last Business DNA™ assessment was completed

Relationships:→ WorkforceIntelligenceScore [1:1] via organizationId→ DigitalWorkforceConfiguration [1:N] via organizationId→ AssessmentHistory [1:N] via organizationId

WorkforceIntelligenceScore— Current workforce intelligence scores with full dimension breakdown

Field	Type	Req	Source	Description
scoreId	UUID	R	computed	Primary key
organizationId	UUID (FK)	R	assessment	Foreign key to OrganizationProfile
workforceIntelligenceScore	INTEGER (0-100)	R	computed	Composite WIS™
workforceReadinessScore	INTEGER (0-100)	R	computed	WRS™
workforceCapacityScore	INTEGER (0-100)	R	computed	WCS™
workforceOptimizationScore	INTEGER (0-100)	R	computed	WOS™
workforceExpansionReadiness	INTEGER (0-100)	R	computed	WERS™
maturityLevel	VARCHAR(20)	R	computed	Nascent / Developing / Established / Advanced / Optimized
dimensions	JSONB	R	computed	Array of 5 dimension objects with current, target, gap, readiness, capacity, optimization, expansionReadiness
industryPercentile	INTEGER (1-99)	O	computed	Percentile ranking within industry peer group
computedAt	TIMESTAMP	R	computed	When these scores were computed

Relationships:→ OrganizationProfile [N:1] via organizationId→ WorkforceGap [1:N] via scoreId→ RecommendationMatch [1:N] via scoreId

Business DNA™ Assessment & Profile

Storage: PostgreSQL (assessments, reports). Redis (active session cache). S3 (report PDFs, historical archives).confidential

BusinessDNAAssessment— Complete assessment response record — raw answers mapped to 5 archetype dimensions before computation

Field	Type	Req	Source	Description
assessmentId	UUID	R	assessment	Primary key
organizationId	UUID (FK)	R	assessment	Foreign key to OrganizationProfile
answers	JSONB	R	assessment	Raw assessment answers keyed by question code (B1-B4, G1-G4, W1-W4, C1-C4, O1-O4, X1-X3)
dimensionScores	JSONB	R	computed	Computed per-dimension scores before archetype resolution: { business: {...}, growth: {...}, workforce: {...}, communication: {...}, operational: {...} }
archetypeResults	JSONB	R	computed	Resolved archetypes: { businessArchetype, growthArchetype, workforceArchetype, communicationArchetype, operationalArchetype } with confidence scores
businessImpactPotential	INTEGER (0-100)	R	computed	Composite potential score derived from archetype combination
uniqueCombinationId	VARCHAR(20)	R	computed	Canonical identifier from 10,080 possible combinations (e.g., BA-GA-WA-CA-OA)
completedAt	TIMESTAMP	R	assessment	When the assessment was submitted
assessmentVersion	VARCHAR(10)	R	assessment	Version of assessment logic used (for backwards compatibility)

Relationships:→ OrganizationProfile [N:1] via organizationId→ BusinessDNAReport [1:1] via assessmentId→ AssessmentHistory [1:N] via assessmentId

BusinessDNAReport— Generated Business DNA™ Executive Report — complete organizational diagnostic with benchmarks, projections, and workforce recommendations

Field	Type	Req	Source	Description
reportId	UUID	R	computed	Primary key
assessmentId	UUID (FK)	R	assessment	Foreign key to BusinessDNAAssessment
organizationId	UUID (FK)	R	assessment	Denormalized for query convenience
dnaProfile	JSONB	R	computed	Full DNA profile: 5 archetypes, confidence scores, business impact potential, alternative types
archetypes	JSONB	R	computed	Resolved archetype profiles with descriptions, confidence scores, and alternative possibilities
scorecards	JSONB	R	computed	Array of scorecard objects with metric, value, trend, and description
industryBenchmarks	JSONB	R	computed	Your Business vs Industry Avg vs Top 10% comparison across metrics
customerExperienceBenchmarks	JSONB	R	computed	CX benchmark dimensions with gap analysis and recommendations
impactProjections	JSONB	R	computed	7-dimension business impact projections with conservative/expected/optimistic scenarios
workforceRecommendation	JSONB	R	computed	Recommended Digital Workforce™ configuration with members, phases, and ROI
day90Plan	JSONB	R	computed	Phased 90-day implementation plan with milestones and KPIs
year1Roadmap	JSONB	R	computed	1-year growth roadmap with quarter-by-quarter milestones
executiveSummary	JSONB	R	computed	Executive summary: headline, opportunity size, recommended action, projected impact, confidence
generatedAt	TIMESTAMP	R	computed	Report generation timestamp

Relationships:→ BusinessDNAAssessment [N:1] via assessmentId→ OrganizationProfile [N:1] via organizationId→ BusinessesLikeYours [1:1] via organizationId

AssessmentHistory— Immutable archive of all assessment records for trend analysis and longitudinal studies

Field	Type	Req	Source	Description
historyId	UUID	R	computed	Primary key
organizationId	UUID (FK)	R	assessment	Foreign key to OrganizationProfile
assessmentId	UUID	R	assessment	Reference to original assessment
snapshot	JSONB	R	computed	Full frozen snapshot of assessment + scores + recommendations at time of computation
archivedAt	TIMESTAMP	R	computed	When this snapshot was archived
isBaseline	BOOLEAN	R	computed	Whether this is the baseline (first) assessment for the organization

Relationships:→ OrganizationProfile [N:1] via organizationId→ BusinessDNAAssessment [N:1] via assessmentId

Proof Center™ & Revenue Recovery Intelligence

Storage: PostgreSQL (audits, proof points). Redis (Proof Center™ cache — pre-computed industry aggregations).confidential

ProofCenterEntry— Case study, benchmark proof point, or performance evidence record — fuels the Proof Center™ display and competitive intelligence

Field	Type	Req	Source	Description
proofId	UUID	R	computed	Primary key
organizationId	UUID (FK)	O	assessment	Optional link to source organization (anonymized for public display)
category	VARCHAR(50)	R	derived	revenue-recovery \| capacity-created \| response-time \| conversion-improvement \| cost-reduction \| expansion
industry	VARCHAR(100)	R	derived	Industry of the proof point (for filtering)
metricName	VARCHAR(100)	R	derived	Name of the measured metric
beforeValue	NUMERIC	R	derived	Baseline measurement before TelegentAI deployment
afterValue	NUMERIC	R	derived	Measurement after Digital Workforce™ deployment
improvementPercent	NUMERIC	R	computed	Computed improvement percentage
annualizedDollarImpact	NUMERIC	R	computed	Annualized financial impact in dollars
timeframe	VARCHAR(20)	R	derived	30-day \| 90-day \| 180-day \| 365-day
workforceMembersDeployed	JSONB	R	derived	List of Digital Team Members™ contributing to this outcome
isPublic	BOOLEAN	R	manual	Whether this proof point can be displayed publicly
anonymizationLevel	VARCHAR(20)	R	manual	full \| industry-only \| size-range-only \| fully-anonymous
recordedAt	TIMESTAMP	R	computed	When this proof point was recorded

Relationships:→ OrganizationProfile [N:1] via organizationId→ BusinessImpactDashboard [1:N] via proofId

RevenueRecoveryAudit— Revenue Recovery Audit™ record — measures missed revenue opportunities and recovery potential

Field	Type	Req	Source	Description
auditId	UUID	R	computed	Primary key
organizationId	UUID (FK)	R	assessment	Foreign key to OrganizationProfile
totalLeadVolume	INTEGER	R	assessment	Monthly lead volume across all channels
estimatedLossPct	NUMERIC (0-100)	R	computed	Estimated percentage of leads lost to slow/no response
estimatedLeadsLost	INTEGER	R	computed	Computed number of leads lost per month
avgDealValue	NUMERIC	R	assessment	Average deal/transaction value
monthlyRevenueAtRisk	NUMERIC	R	computed	Monthly revenue at risk from missed interactions
annualRevenueAtRisk	NUMERIC	R	computed	Annualized revenue at risk
recoveryOpportunityPct	NUMERIC (0-100)	R	computed	Estimated recoverable percentage with Digital Workforce™
recoverableAnnualRevenue	NUMERIC	R	computed	Annual revenue that can be recovered (revenueAtRisk × recoveryPct)
responseTimeMinutes	INTEGER	R	assessment	Current average response time in minutes
targetResponseTimeMinutes	INTEGER	R	computed	Target response time with digital workforce
auditCompletedAt	TIMESTAMP	R	computed	When the audit was computed

Relationships:→ OrganizationProfile [N:1] via organizationId→ ProofCenterEntry [1:N] via organizationId

Businesses Like Yours™ Benchmark Engine

Storage: PostgreSQL (indices, peer groups). Redis (pre-computed comparison matrices for top 20 peer groups). ClickHouse (benchmark analytics at scale).confidential

PeerGroupIndex— Pre-computed peer group assignment for every organization — enables fast similarity lookups for Businesses Like Yours™

Field	Type	Req	Source	Description
indexId	UUID	R	computed	Primary key
organizationId	UUID (FK)	R	derived	Foreign key to OrganizationProfile
peerGroupId	UUID	R	computed	Assigned peer group cluster
industry	VARCHAR(100)	R	derived	Primary industry
revenueBracket	VARCHAR(20)	R	derived	Revenue range for peer grouping
employeeBracket	VARCHAR(20)	R	derived	Employee count bracket
businessArchetype	VARCHAR(30)	R	derived	Business archetype from DNA assessment
growthArchetype	VARCHAR(30)	R	derived	Growth archetype
maturityLevel	VARCHAR(20)	R	derived	Workforce maturity level
similarityScore	NUMERIC (0-1)	R	computed	Cosine similarity to peer group centroid
percentileRank	INTEGER (1-99)	R	computed	Workforce Intelligence percentile within peer group
indexedAt	TIMESTAMP	R	computed	When this index entry was computed

Relationships:→ OrganizationProfile [N:1] via organizationId→ PeerGroup [N:1] via peerGroupId

PeerGroup— Cluster definition for a peer group — centroid values, member count, score distributions

Field	Type	Req	Source	Description
peerGroupId	UUID	R	computed	Primary key
groupLabel	VARCHAR(100)	R	computed	Human-readable label (e.g., 'Mid-Market Professional Services — Established')
memberCount	INTEGER	R	computed	Number of organizations in this peer group
centroidWIS	NUMERIC	R	computed	Centroid Workforce Intelligence Score
centroidReadiness	NUMERIC	R	computed	Centroid readiness score
centroidCapacity	NUMERIC	R	computed	Centroid capacity score
centroidOptimization	NUMERIC	R	computed	Centroid optimization score
centroidExpansion	NUMERIC	R	computed	Centroid expansion readiness
scoreDistribution	JSONB	R	computed	Full score distribution: p5, p25, p50, p75, p95 for each of 5 scores
topPerformers	JSONB	R	computed	Anonymized top 10% performer stats: avg scores, avg workforce size, avg ROI
lastRebalancedAt	TIMESTAMP	R	computed	When the peer group was last recomputed (k-means reclustering)

Relationships:→ PeerGroupIndex [1:N] via peerGroupId→ IndustryBenchmark [1:1] via peerGroupId

IndustryBenchmark— Industry-level benchmark aggregations — updated from all organizations in an industry

Field	Type	Req	Source	Description
benchmarkId	UUID	R	computed	Primary key
industry	VARCHAR(100)	R	derived	Industry name
organizationCount	INTEGER	R	computed	Number of contributing organizations
avgWorkforceIntelligenceScore	NUMERIC	R	computed	Industry-average WIS™
avgReadinessScore	NUMERIC	R	computed	Industry-average readiness
avgCapacityScore	NUMERIC	R	computed	Industry-average capacity
avgOptimizationScore	NUMERIC	R	computed	Industry-average optimization
avgExpansionReadiness	NUMERIC	R	computed	Industry-average expansion readiness
avgDigitalWorkforceSize	NUMERIC	R	computed	Average number of deployed digital team members
maturityDistribution	JSONB	R	computed	Percentage distribution across 5 maturity levels
topQuartileThreshold	JSONB	R	computed	Score thresholds to reach top quartile for each of 5 scores
sampleSize	INTEGER	R	computed	Number of organizations in benchmark sample (for statistical significance)
updatedAt	TIMESTAMP	R	computed	Last update timestamp

Relationships:→ PeerGroup [N:1] via peerGroupId

Digital Workforce™ Configuration & Deployment

Storage: PostgreSQL (configurations, members, expansions). TimescaleDB (member utilization time-series). Redis (live member status).confidential

DigitalWorkforceConfiguration— A specific Digital Workforce™ configuration — bundle of Digital Team Members™ deployed for an organization, with phase, pricing, and ROI tracking

Field	Type	Req	Source	Description
configId	UUID	R	computed	Primary key
organizationId	UUID (FK)	R	assessment	Foreign key to OrganizationProfile
configVersion	INTEGER	R	computed	Version number for this configuration (increments on changes)
phase	VARCHAR(20)	R	derived	immediate (0-30d) \| short-term (30-90d) \| expansion (90-180d) \| strategic (180-365d)
members	JSONB	R	derived	Array of deployed Digital Team Members™: { memberId, roleName, startedAt, status, utilizationPct, costPerMonth, hoursRecoveredPerMonth, monthlyROI }
totalMonthlyInvestment	NUMERIC	R	computed	Total monthly cost of all deployed members
totalHoursRecoveredPerMonth	NUMERIC	R	computed	Total FTE-equivalent hours recovered monthly
annualizedROIPct	NUMERIC	R	computed	Annualized return on investment percentage
paybackPeriodMonths	NUMERIC	R	computed	Months until investment is recovered
bundleType	VARCHAR(15)	R	derived	Starter \| Professional \| Enterprise — recommended bundle
activeSince	TIMESTAMP	R	derived	When this configuration went live
isCurrent	BOOLEAN	R	derived	Whether this is the active (current) configuration

Relationships:→ OrganizationProfile [N:1] via organizationId→ DigitalTeamMember [1:N] via configId→ BusinessImpactDashboard [1:1] via configId

DigitalTeamMember— Individual Digital Team Member™ deployment record — performance, utilization, and impact tracking

Field	Type	Req	Source	Description
memberDeploymentId	UUID	R	computed	Primary key
configId	UUID (FK)	R	derived	Foreign key to DigitalWorkforceConfiguration
memberRoleId	VARCHAR(30)	R	derived	Canonical role ID (e.g., 'digital-receptionist', 'digital-bookkeeper', 'lead-router')
roleName	VARCHAR(100)	R	derived	Human-readable role name with trademark
status	VARCHAR(20)	R	derived	active \| provisioning \| paused \| retired
utilizationPct	NUMERIC (0-100)	R	computed	Current utilization percentage
hoursAutomatedPerMonth	NUMERIC	R	computed	Actual hours automated/recovered per month
monthlyCost	NUMERIC	R	derived	Monthly cost for this member
monthlyRevenueImpact	NUMERIC	R	computed	Measured monthly revenue impact
memberROI	NUMERIC	R	computed	Individual member ROI percentage
integrationHealth	VARCHAR(10)	R	computed	healthy \| degraded \| error \| not-connected
deployedAt	TIMESTAMP	R	derived	When this member was deployed
lastActiveAt	TIMESTAMP	R	computed	Last recorded activity

Relationships:→ DigitalWorkforceConfiguration [N:1] via configId→ WorkforceIntelligenceScore [N:1] via organizationId

WorkforceExpansionHistory— Chronological record of workforce expansions — what was added, when, and the measured impact

Field	Type	Req	Source	Description
expansionId	UUID	R	computed	Primary key
organizationId	UUID (FK)	R	derived	Foreign key to OrganizationProfile
triggerType	VARCHAR(30)	R	derived	What triggered this expansion (e.g., 'volume-increase', 'new-location', 'seasonal-peak')
membersAdded	JSONB	R	derived	List of member role IDs added in this expansion
investmentIncrease	NUMERIC	R	computed	Additional monthly investment from this expansion
projectedImpact	NUMERIC	R	computed	Projected annual impact at time of expansion
actualImpact90d	NUMERIC	O	computed	Measured impact after 90 days (null if not yet reached)
actualImpact180d	NUMERIC	O	computed	Measured impact after 180 days
forecastAccuracy	NUMERIC	O	computed	Actual vs projected accuracy ratio (improves model over time)
expandedAt	TIMESTAMP	R	derived	When the expansion was executed

Relationships:→ OrganizationProfile [N:1] via organizationId→ ExpansionTrigger [N:1] via triggerType

Business Impact Dashboard™

Storage: PostgreSQL (dashboard config, widget states). Redis (live widget data — 60-second TTL for real-time widgets). S3 (dashboard snapshots for historical comparison).confidential

BusinessImpactDashboard— Live dashboard instance for an organization — aggregates all workforce intelligence, financial impact, and operational metrics into real-time widgets

Field	Type	Req	Source	Description
dashboardId	UUID	R	computed	Primary key
organizationId	UUID (FK)	R	assessment	Foreign key to OrganizationProfile
configId	UUID (FK)	R	derived	Active workforce configuration driving the dashboard
revenueRecoveredYTD	NUMERIC	R	computed	Year-to-date revenue recovered via workforce automation
revenueRecoveredAnnualized	NUMERIC	R	computed	Annualized revenue recovery projection
capacityCreatedFTE	NUMERIC	R	computed	FTE equivalent capacity created through automation
hoursRecoveredYTD	NUMERIC	R	computed	Total hours recovered year-to-date
responseTimeImprovementPct	NUMERIC	R	computed	Percentage improvement in response time vs baseline
conversionRateImprovementPct	NUMERIC	R	computed	Percentage improvement in conversion rate
totalInvestmentYTD	NUMERIC	R	computed	Total investment in Digital Workforce™ YTD
overallROIPct	NUMERIC	R	computed	Overall return on investment percentage
widgetStates	JSONB	R	manual	Per-widget configuration: visibility, position, refresh rate, thresholds
lastRefreshedAt	TIMESTAMP	R	computed	Last full dashboard refresh

Relationships:→ OrganizationProfile [N:1] via organizationId→ DigitalWorkforceConfiguration [N:1] via configId→ DashboardWidget [1:N] via dashboardId

DashboardWidget— Individual widget on the Business Impact Dashboard™ — self-contained visualization of a specific metric or dimension

Field	Type	Req	Source	Description
widgetId	UUID	R	computed	Primary key
dashboardId	UUID (FK)	R	derived	Foreign key to BusinessImpactDashboard
widgetType	VARCHAR(30)	R	manual	scorecard \| bar-chart \| radar-chart \| trend-line \| gauge \| comparison-matrix \| heatmap \| funnel
metric	VARCHAR(50)	R	manual	Metric this widget displays (e.g., 'workforceIntelligenceScore', 'revenueRecoveredYTD')
title	VARCHAR(100)	R	manual	Display title for the widget
position	JSONB	R	manual	{ row, col, width, height } — grid positioning
refreshIntervalSeconds	INTEGER	R	manual	Auto-refresh interval (0 = manual only)
thresholds	JSONB	R	manual	Alert thresholds: { warning, critical } values with colors
dataSource	VARCHAR(50)	R	manual	Which entity/query feeds this widget
isVisible	BOOLEAN	R	manual	Whether this widget is currently displayed

Relationships:→ BusinessImpactDashboard [N:1] via dashboardId

QBIR™ — Quarterly Business Impact Report

Storage: PostgreSQL (QBIR records). S3 (rendered PDFs + archived reports). Read-replica for historical querying.restricted

QuarterlyBusinessImpactReport— QBIR™ — Quarterly Business Impact Report. Frozen quarterly snapshot of all workforce intelligence scores, financial impact, and benchmark position for executive review.

Field	Type	Req	Source	Description
qbirId	UUID	R	computed	Primary key
organizationId	UUID (FK)	R	assessment	Foreign key to OrganizationProfile
quarter	VARCHAR(7)	R	computed	Quarter identifier (e.g., '2026-Q2')
periodStart	DATE	R	computed	Quarter start date
periodEnd	DATE	R	computed	Quarter end date
scoresSnapshot	JSONB	R	computed	Frozen copy of all 5 Workforce Intelligence scores at quarter-end
maturityLevel	VARCHAR(20)	R	computed	Workforce maturity as of quarter-end
maturityChange	VARCHAR(20)	R	computed	improved \| stable \| declined — quarter-over-quarter maturity movement
quarterlyRevenueImpact	NUMERIC	R	computed	Revenue impact recorded this quarter
cumulativeRevenueImpact	NUMERIC	R	computed	Cumulative revenue impact since deployment began
quarterlyInvestment	NUMERIC	R	computed	Total workforce investment this quarter
quarterlyROI	NUMERIC	R	computed	ROI for this quarter
benchmarkPosition	JSONB	R	computed	Percentile rank vs industry, vs peer group, vs all organizations
expansionActivity	JSONB	R	derived	Expansions executed this quarter with member details
topRecommendations	JSONB	R	computed	Top 5 recommendations for next quarter
executiveSummary	TEXT	R	computed	Quarterly executive narrative generated from data
reportStatus	VARCHAR(20)	R	manual	draft \| reviewed \| approved \| shared
generatedAt	TIMESTAMP	R	computed	When the QBIR was generated

Relationships:→ OrganizationProfile [N:1] via organizationId→ AssessmentHistory [1:N] via organizationId→ WorkforceExpansionHistory [1:N] via organizationId

Expansion Engine™

Storage: PostgreSQL (triggers, forecasts). TimescaleDB (trigger history time-series for trend analysis). Redis (active trigger cache — 5min TTL).confidential

ExpansionTrigger— Live expansion signal — detects when an organization is ready for workforce expansion based on score thresholds, volume changes, and environmental signals

Field	Type	Req	Source	Description
triggerId	UUID	R	computed	Primary key
organizationId	UUID (FK)	R	derived	Foreign key to OrganizationProfile
triggerCategory	VARCHAR(30)	R	computed	volume-increase \| new-location \| score-threshold \| seasonal-peak \| maturity-progression \| budget-increase \| integration-ready \| gap-threshold
condition	VARCHAR(200)	R	computed	Human-readable condition that triggered this signal
currentValue	NUMERIC	R	computed	Current value of the triggering metric
thresholdValue	NUMERIC	R	derived	Threshold that was crossed
isTriggered	BOOLEAN	R	computed	Whether this trigger is currently active
urgency	VARCHAR(15)	R	computed	immediate \| soon \| planned \| future
recommendedMembers	JSONB	R	computed	List of recommended Digital Team Members™ to deploy: { roleId, priority, projectedImpact, estimatedCost }
projectedImpactAnnual	NUMERIC	R	computed	Projected annual impact if expansion is executed
triggeredAt	TIMESTAMP	R	computed	When this trigger first fired
resolvedAt	TIMESTAMP	O	computed	When this trigger was resolved (expansion executed or condition dismissed)
status	VARCHAR(20)	R	derived	active \| acknowledged \| executed \| dismissed \| expired

Relationships:→ OrganizationProfile [N:1] via organizationId→ WorkforceExpansionHistory [1:1] via triggerId

ExpansionForecast— Projected expansion path for an organization — models when each workforce phase should activate based on current trajectory

Field	Type	Req	Source	Description
forecastId	UUID	R	computed	Primary key
organizationId	UUID (FK)	R	derived	Foreign key to OrganizationProfile
forecastDate	DATE	R	computed	Date this forecast was generated
forecastHorizonDays	INTEGER	R	derived	How many days this forecast projects (30/90/180/365)
phaseProjections	JSONB	R	computed	Array of projected phases: { phaseName, projectedStartDate, memberAdditions, investmentRequired, confidenceScore }
optimisticPath	JSONB	R	computed	Optimistic scenario: accelerated deployment timeline and higher impact
expectedPath	JSONB	R	computed	Expected scenario: baseline deployment timeline and impact
conservativePath	JSONB	R	computed	Conservative scenario: slower deployment, lower initial impact
confidenceIntervalPct	INTEGER	R	computed	Confidence interval width (e.g., 80 means 80% confidence range)
keyAssumptions	JSONB	R	computed	List of key assumptions driving the forecast
generatedAt	TIMESTAMP	R	computed	Forecast generation timestamp

Relationships:→ OrganizationProfile [N:1] via organizationId→ WorkforceIntelligenceScore [N:1] via organizationId

Platform Data Flows

Cross-Module Data Flow Architecture

Complete data lineage from initial Business DNA™ assessment through scoring, benchmarking, recommendation, workforce configuration, impact measurement, and quarterly reporting — with CRM synchronization at every stage.

Business DNA AssessmentOrganizationProfile

real-timeTrigger: Assessment completed~1KB per assessment

Map assessment answers to profile fields + compute archetypes

OrganizationProfileWorkforceIntelligenceScore

real-timeTrigger: Profile created/updated~2KB per computation

computeWorkforceIntelligence() — run all 5 scoring engines

WorkforceIntelligenceScoreRecommendationMatch

real-timeTrigger: Score computed~5KB per match

matchRecommendations() — filter 350+ scenarios against profile

Industry Benchmark DBWorkforceIntelligenceScore

batch-dailyTrigger: Score computation~500KB per industry refresh

Pull latest benchmark data for percentile calculation

CRMSyncPayload™CRM System

real-timeTrigger: All computations complete~3KB per sync

Map all scores, gaps, recommendations to CRM fields

Assessment UIBusinessDNAAssessment

real-timeTrigger: User submits assessment~3KB per assessment

Validate answers, compute dimension scores, resolve archetypes, assign combinationId

BusinessDNAAssessmentOrganizationProfile

real-timeTrigger: Assessment completed + archetypes resolved~2KB per update

Update organization profile with DNA profile, archetypes, confidence scores

BusinessDNAAssessmentBusinessDNAReport

real-timeTrigger: All computations complete~15KB per report

generateBusinessDNAReport() — full report with benchmarks, projections, workforce, plans

BusinessDNAAssessmentAssessmentHistory

real-timeTrigger: Assessment + report complete~10KB per archive

Freeze and archive full snapshot for longitudinal comparison

BusinessDNAReportBusinessesLikeYours

real-timeTrigger: Report generated~1KB per index

Index organization into peer group for similarity scoring and benchmarking

Revenue Recovery Calculator UIRevenueRecoveryAudit

real-timeTrigger: Calculator form submitted~2KB per calculation

Compute lead loss, revenue at risk, recovery potential from calculator inputs

Digital Workforce MonitoringProofCenterEntry

batch-dailyTrigger: Performance thresholds met~1KB per proof point

Detect significant improvements, verify against baseline, anonymize per settings, record proof point

ProofCenterEntryBusinessesLikeYours

batch-dailyTrigger: New proof point recorded~500KB per daily batch

Aggregate industry-level proof data for benchmark enrichment

OrganizationProfilePeerGroupIndex

batch-dailyTrigger: New assessment or score recomputation~2KB per organization per day

Compute similarity scores, assign to nearest peer group centroid via k-means, calculate percentile

PeerGroupIndex (all orgs)PeerGroup

batch-dailyTrigger: Daily batch recomputation~5MB per daily batch (10K orgs)

Recompute centroids, distributions, top-performer stats from all member indices

PeerGroupIndustryBenchmark

batch-dailyTrigger: Peer group rebalanced~100KB per industry

Roll up peer group stats to industry level, compute averages and distributions

BusinessesLikeYours UIPeerGroupIndex + PeerGroup + IndustryBenchmark

real-timeTrigger: User requests comparison~3KB per request

Fetch org index → fetch peer group stats + top performers → compute gap analysis → render comparison

WorkforceRecommendationDigitalWorkforceConfiguration

real-timeTrigger: Organization accepts recommendation~5KB per configuration

Convert recommendation to active configuration, provision members, start tracking

Digital Workforce MonitoringDigitalTeamMember

batch-hourlyTrigger: Continuous monitoring (hourly)~500B per member per hour

Collect utilization, hours automated, revenue impact, integration health per member

DigitalTeamMember (aggregated)DigitalWorkforceConfiguration

batch-dailyTrigger: Member metrics updated~2KB per config per day

Roll up member metrics to configuration-level totals, ROI, payback

ExpansionTriggerWorkforceExpansionHistory

real-timeTrigger: Expansion executed~1KB per expansion

Record expansion event with projected impact for forecast-vs-actual tracking

WorkforceIntelligenceScoreBusinessImpactDashboard

real-timeTrigger: Scores updated~2KB per score update

Push latest scores to dashboard — update scorecard and radar widgets

DigitalTeamMemberBusinessImpactDashboard

batch-hourlyTrigger: Member metrics updated~3KB per hour

Aggregate all member revenue impact, hours, utilization for dashboard financial widgets

ProofCenterEntryDashboardWidget

batch-dailyTrigger: New proof point recorded~1KB per update

Update competitive position and benchmark comparison widgets

WorkforceIntelligenceScore + BusinessImpactDashboard + WorkforceExpansionHistoryQuarterlyBusinessImpactReport

batch-dailyTrigger: End of quarter (auto) or manual generate~20KB per QBIR

Aggregate quarter data, freeze scores, compute quarterly ROI, generate executive narrative, rank vs benchmarks

QuarterlyBusinessImpactReportExecutiveReportFormat

real-timeTrigger: QBIR generated/approved~50KB per render

Render QBIR into board-ready PDF and interactive dashboard formats

WorkforceIntelligenceScore + OrganizationProfileExpansionTrigger

real-timeTrigger: Scores updated or threshold crossed~2KB per evaluation

Evaluate all trigger conditions, set urgency, match recommended members from scenario catalog

Active ExpansionTriggers (aggregated)CRM System

real-timeTrigger: New trigger fires (critical/soon urgency)~1KB per CRM sync

Push expansion opportunity to CRM: create task, update lead enrichment fields

WorkforceIntelligenceScore + ExpansionTrigger + DigitalWorkforceConfigurationExpansionForecast

batch-weeklyTrigger: Weekly recomputation or on-demand~10KB per forecast

Run 5-model forecast with 3-path scenarios, phase projections, confidence intervals

ExpansionForecastQuarterlyBusinessImpactReport

batch-dailyTrigger: QBIR generation~5KB per QBIR inclusion

Include latest expansion forecast in QBIR for forward-looking strategy

SE-001

Workforce Intelligence Scoring Engine™

Central scoring engine powering the Workforce Intelligence™ platform. Computes 5 composite scores from 25+ input dimensions, benchmarks against industry peers, and feeds all downstream engines.

Latency Target

<500ms for full computation pipeline (steps 1-7). <50ms for score-only refresh.

Throughput Target

100 computations/second at peak (supporting 10K+ organizations with burst traffic)

Caching Strategy

Redis: active scores (TTL 5min). PostgreSQL: historical scores. CDN: pre-computed public benchmarks.

Inputs (10)

businessDNAProfile

Type: JSONB

Source: BusinessDNAAssessment.archetypeResults

on-assessment

callResponseRate

Type: NUMERIC (0-100)

Source: Phone System Integration / CRM

hourly

leadResponseTimeMinutes

Type: INTEGER

Source: CRM / Communication Platform

hourly

schedulingAutomationPercent

Type: NUMERIC (0-100)

Source: Calendar Integration

daily

revenueRecoveryActive

Type: BOOLEAN

Source: DigitalWorkforceConfiguration

on-change

analyticsDashboardLive

Type: BOOLEAN

Source: BusinessImpactDashboard

on-change

multiLocationCount

Type: INTEGER

Source: OrganizationProfile

on-change

currentFTECapacity

Type: NUMERIC

Source: OrganizationProfile + HR Integration

monthly

digitalMembersActive

Type: INTEGER

Source: DigitalTeamMember (status=active)

hourly

industryBenchmark

Type: JSONB

Source: IndustryBenchmark

daily

Computation Pipeline

Step 1

Dimension Scoring

Compute raw scores for each of 5 workforce dimensions (Front Office, Revenue Growth, Operations, Executive Intelligence, Customer Experience) using weighted input formulas.

Step 2

Composite Score Calculation

Weight the 5 dimension scores into composite WIS™, WRS™, WCS™, WOS™, and WERS™.

Step 3

Maturity Level Classification

Map composite WIS™ to maturity level using defined ranges: Nascent [0-20), Developing [20-40), Established [40-60), Advanced [60-80), Optimized [80-100].

Step 4

Gap Detection

Compare each dimension's current vs target, compute delta, classify severity (critical >30 gap, high 20-30, moderate 10-20, low <10), estimate dollar impact and time-to-close.

Step 5

Industry Percentile Ranking

Query industry benchmark DB for peer distribution, compute percentile rank of organization's WIS™ within industry.

Step 6

Expansion Trigger Evaluation

Evaluate 8 trigger categories against current state, compute urgency, match recommended workforce members.

Step 7

Alert Generation

Generate executive alerts for critical gaps, triggered expansions, and score degradations. Categorize by severity and category.

Outputs (7)

Output	Type	Consumer
workforceIntelligenceScore	INTEGER (0-100)	WorkforceIntelligenceScore entity, BusinessImpactDashboard, QBIR, CRM
dimensions[]	JSONB array of 5 WorkforceDimension objects	DashboardWidget (radar chart), ExecutiveReportFormat, CRM enrichment
gaps[]	JSONB array of WorkforceGap objects	ExecutiveAlert system, Recommendation Engine, Dashboard
expansionTriggers[]	JSONB array of ExpansionTrigger objects	Expansion Engine, CRM (opportunity creation), Email notifications
alerts[]	JSONB array of ExecutiveAlert objects	Dashboard, Email, Slack/Teams, CRM tasks
maturityLevel	VARCHAR(20)	OrganizationProfile, Dashboard, QBIR, Benchmark Engine
industryPercentile	INTEGER (1-99)	BusinessesLikeYours, Dashboard, QBIR, Proof Center

Scaling Considerations

Dimension scoring is embarrassingly parallel — each dimension computed independently before composite step

Industry benchmark lookup uses pre-computed distribution tables (O(log n) via B-tree index on percentile)

Expansion trigger evaluation is read-heavy; Redis cache reduces DB load by 95% for active triggers

Historical score computation for trend analysis is batch-processed via PostgreSQL materialized views refreshed hourly

For 10K+ organizations, score recomputation on each profile change would be ~50M dimension computations/day — partition by organization last-updated to batch process

Multi-tenant isolation: each organization's scores are computed independently; no cross-org data leakage in computation

BE-001

Businesses Like Yours™ Benchmarking Engine

Clustering and benchmarking engine that groups organizations into peer cohorts using multi-dimensional similarity scoring, computes industry and peer-group benchmarks, and powers the Businesses Like Yours™ comparison experience.

Peer Grouping Strategy

Multi-dimensional k-means clustering with cosine similarity scoring. Organizations are clustered on 9 dimensions: industry, revenue bracket, employee bracket, business archetype, growth archetype, workforce archetype, maturity level, location count, and digital workforce size.

Clustering Algorithm

k-means++ initialization with silhouette score optimization for k selection (k=15-50 clusters per industry depending on sample size). Clusters rebalanced daily as new organizations join or existing profiles change.

Similarity Dimensions (9)

Industry classification (hierarchical: sector → industry → sub-industry)

Revenue bracket (7 brackets: <$1M, $1-5M, $5-10M, $10-25M, $25-50M, $50-100M, $100M+)

Employee count bracket (6 brackets: 1-10, 11-50, 51-200, 201-500, 501-2000, 2000+)

Business Archetype (8 types from Business DNA™)

Growth Archetype (6 types)

Workforce Archetype (8 types)

Workforce Maturity Level (5 levels)

Location count (single vs multi-location vs enterprise)

Digital Workforce size (number of active Digital Team Members™)

Computation Steps

Feature Vector Construction

Build normalized 9-dimensional feature vector for each organization. One-hot encode categoricals (archetypes, maturity). Min-max normalize continuous values (scores, counts).

k-means Clustering

Run k-means++ with k=15-50 (silhouette-optimized) per industry sector. Assign each organization to nearest centroid via cosine similarity.

Within-Cluster Percentile Calculation

For each organization, compute percentile rank within assigned cluster for each of 5 workforce intelligence scores.

Top Performer Identification

Identify top 10% within each cluster by WIS™. Extract anonymized stats: avg scores, avg workforce size, avg ROI, common archetype combinations.

Peer Group Statistics

Compute cluster-level statistics: centroid, p5/p25/p50/p75/p95 distributions, member count, maturity distribution, avg workforce size.

Industry Rollup

Roll up cluster-level stats to industry-level benchmarks. Weight clusters by member count. Compute industry averages, top quartile thresholds.

Similarity Scoring

For Businesses Like Yours™ display: compute cosine similarity matrix for top 10 most-similar organizations within peer group (anonymized).

Gap-to-Top-Performer Analysis

Compute gap vectors: organization vs peer group centroid, organization vs top 10% average. Highlight largest gaps with improvement opportunity sizing.

Benchmarks Produced

Industry Score BenchmarksDaily

Peer Group BenchmarksDaily

Top Performer ProfilesDaily

Maturity DistributionWeekly

Workforce Size BenchmarksWeekly

Businesses Like Yours™Real-time (cached, 15min TTL)

Statistical Methods

k-means++ clustering with silhouette score optimization for k selection

Cosine similarity for peer-to-peer comparisons within clusters

Percentile rank computation with linear interpolation between observed values

Confidence intervals: 95% CI using bootstrap resampling (n=1000 iterations) for cluster statistics

Minimum sample size enforcement: clusters with <20 members merged into nearest cluster

Anomaly detection: organizations scoring >2.5σ from cluster mean flagged for review

Longitudinal trend: linear regression on 4-quarter score history for maturity trajectory projection

Minimum Sample Size: 20 organizations per cluster

RE-001

Workforce Recommendation Engine™

Matches organizations to Digital Workforce™ configurations using a multi-factor scoring model across 350+ scenarios. Prioritizes recommendations by business impact, urgency, and organizational fit.

Scenario Catalog

350+

scenarios across 4 tiers

Matching Strategy

Multi-factor weighted scoring with constraint satisfaction. Each scenario is scored against the organization profile on 8 weighted factors. Top N scenarios are selected, deduplicated, and organized into phased deployment timelines.

Scoring Weights (8 factors, total 100%)

Workforce Intelligence Fit

How well the organization's current scores and maturity align with the scenario's target profile

Business Impact Potential

Projected revenue impact, capacity creation, and optimization improvement from this scenario

Urgency Alignment

How closely the scenario addresses active expansion triggers and critical gaps

Industry Relevance

How well the scenario applies to the organization's industry (industry-specific scenarios score higher)

Archetype Compatibility

How well the scenario's workforce design complements the organization's Business DNA™ archetypes

Implementation Feasibility

Realism of deployment timeline given current maturity, budget, and integration readiness

Expansion Pathway

How well this scenario positions the organization for future expansion (builds toward higher maturity)

Matching Pipeline

Scenario Pool Filtering

Filter 350+ scenario catalog to applicable scenarios: match industry, location count, maturity range, and revenue bracket. Typically reduces pool to 80-120 candidate scenarios.

Multi-Factor Scoring

Score each candidate against the 8 weighted factors using the organization's full profile. Produce a 0-100 composite score per scenario.

Deduplication & Diversity

Remove near-duplicate scenarios (cosine similarity >0.85). Ensure diversity: at least 2 scenarios from each priority tier (P0-P3) in final selection.

Phased Assignment

Assign top scenarios to deployment phases: Immediate (P0, 0-30d), Short-Term (P1, 30-90d), Expansion (P2, 90-180d), Strategic (P3, 180-365d).

Workforce Configuration Assembly

For top-ranked scenario in each phase, assemble full Digital Workforce™ configuration: member roles, pricing, timeline, projected impact, KPIs.

Expansion Path Generation

Generate complete expansion path: phase 1 configuration → phase 1 triggers → phase 2 configuration → ... → optimized state. Include gates between phases.

ROI & Payback Calculation

Compute total investment, projected annual impact, ROI percentage, and payback period for each phase and the cumulative path.

Output Prioritization

P0 (Deploy immediately): top 3 immediate-phase recommendations ordered by business impact potential. P1 (Optimize): top 3 short-term recommendations. P2 (Expand): top 2 expansion recommendations. P3 (Strategic): top 2 strategic recommendations. Output includes full justification with factor breakdown for each recommendation.

Feedback Loop

Recommendation accuracy measured at 90d and 180d post-deployment: forecasted vs actual impact. Feedback fed back into scoring weights via periodic weight recalibration (quarterly). Organizations that deviate significantly from forecast trigger model review.

BIE-001

Business Impact Engine™

Measures, projects, and reports business impact across all dimensions of the Business Impact Platform™. Aggregates financial, operational, and strategic metrics into real-time dashboards, quarterly reports, and executive summaries.

Impact Dimensions (8)

Revenue RecoveryHourly

Leads captured × avg deal value × conversion rate improvement vs baseline. Tracked per Digital Team Member™.

Source: CRM + DigitalTeamMember metrics

Capacity CreatedDaily

Hours automated per member × loaded labor rate / 2080 annual hours = FTE equivalent. Summed across active members.

Source: DigitalTeamMember.hoursAutomatedPerMonth

Response Time ImprovementHourly

Current avg response time / baseline avg response time. Tracked per channel (phone, web, email, messaging).

Source: Phone System + CRM + Messaging Platform

Conversion Rate ImprovementDaily

(Current conversion rate − baseline conversion rate) / baseline conversion rate. Tracked per lead source.

Source: CRM pipeline analytics

Cost ReductionMonthly

Cost of manual processes replaced − cost of digital workforce for same function. Includes labor, overtime, error correction.

Source: HR cost data + DigitalWorkforceConfiguration

Workforce OptimizationMonthly

WOS™ progression over time. Measured as improvement in optimization score with each new deployment or optimization action.

Source: WorkforceIntelligenceScore (historical)

Maturity ProgressionQuarterly

Time in each maturity level. Progression velocity: levels progressed / quarters deployed. Target: advance 1 level per 2 quarters.

Source: AssessmentHistory + QBIR records

Competitive PositionMonthly

Industry percentile rank in WIS™. Movement in percentile quarter-over-quarter.

Source: IndustryBenchmark + PeerGroup

Projection Models (5)

Revenue Impact ForecastCI: 80%

Monte Carlo simulation (10K iterations) with input distributions: deployment velocity, market response lag, seasonal adjustment. 3-path output.

current revenue recovery ratedeployment scheduleavg deal valuelead volume growth rate

Capacity ForecastCI: 85%

Linear cumulative model with learning-curve adjustment (90% learning curve on member efficiency). Hours scale linearly with member count; efficiency improves logarithmically.

hours automated todaymember deployment planlearning curve rate

Optimization Maturity ForecastCI: 75%

S-curve adoption model. Early maturity gains are slow (learning), middle accelerates (compounding improvements), later tapers (diminishing returns). Calibrated per organization archetype.

current maturity leveloptimization actions activearchetype-specific progression velocity

Benchmark Position ForecastCI: 70%

Relative forecasting: own projected trajectory vs industry trend line (linear regression on industry avg over past 4 quarters). Gap-to-leader modeled with mean-reversion assumption.

current percentile rankindustry trend slopecompetitive velocity

Expansion Path ForecastCI: 75%

Trigger-probability model. Each expansion trigger has a monthly probability of activation based on urgency and historical patterns. Expansion path is the expected sequence of activations.

active triggers (count + urgency)budget availabilityhistorical expansion rate

Financial Calculations

Calculation	Formula
Monthly Revenue Recovery Total monthly revenue recovered/created across all deployed Digital Team Members™	Σ(member.monthlyRevenueImpact) for all active members
Annualized Revenue Impact Annualized projection accounting for compounding improvement as members optimize	Monthly Revenue Recovery × 12 × (1 + compoundingGrowthRate)
Total Monthly Investment Total monthly cost of the active Digital Workforce™ configuration	Σ(member.monthlyCost) for all active members
Monthly ROI Return on investment for current month	((Monthly Revenue Recovery − Total Monthly Investment) / Total Monthly Investment) × 100
Annualized ROI Annualized return on investment	((Annualized Revenue Impact − Annualized Investment) / Annualized Investment) × 100
Payback Period (months) Months until cumulative revenue recovered exceeds cumulative investment	Cumulative Investment / Monthly Revenue Recovery — solved for month where cumulative revenue exceeds cumulative cost
FTE Capacity Created Full-time equivalent capacity created through automation	Σ(member.hoursAutomatedPerMonth × loadedLaborRate) / (2080 × avgFTESalary)
Revenue-at-Risk Recovered Percentage of identified revenue-at-risk that has been recovered	(RevenueRecoveryAudit.recoverableAnnualRevenue × revenueRecoveryRate)

Dashboard Widget Mappings

scorecard

workforceIntelligenceScore

5min

gauge

revenueRecoveredYTD

15min

trend-line

revenueRecoveryTrend

15min

bar-chart

memberROIComparison

1hr

radar-chart

dimensionScores

5min

comparison-matrix

benchmarkComparison

24hr

funnel

capacityCreatedBreakdown

1hr

heatmap

expansionReadinessHeatmap

15min

Scaling Architecture

10,000+ Customer Architecture

The Workforce Intelligence™ data architecture is designed to scale from 10 to 10,000+ organizations while maintaining sub-second scoring latency and supporting millions of benchmark data points.

Storage Tier

PostgreSQL

Primary OLTP — profiles, scores, configurations, assessments. Multi-tenant with org-level partitioning.

Up to 50K organizations with read replicas

TimescaleDB

Time-series — member utilization, score history, trigger logs. Automatic partitioning by time + org.

Handles 10M+ data points/day at 10K orgs

Redis

Caching layer — active scores (5min TTL), dashboard data (60s TTL), peer group matrices (15min TTL).

95% cache hit rate target; reduces DB load 20x

ClickHouse

Analytics — benchmark aggregations, industry rollups, cross-org analytics. Columnar for fast aggregations.

Sub-second aggregation across millions of rows

Archive — historical reports (QBIR™ PDFs), dashboard snapshots, assessment archives. Lifecycle policy for cost.

Petabyte-scale, cost-optimized with lifecycle policies

Compute & Integration Tier

Scoring Workers

Stateless compute — run dimension scoring, composite calculation, gap detection. Horizontally scalable.

100 req/s per worker; auto-scale to 50 workers

Benchmark Workers

Batch compute — daily k-means reclustering, industry rollups, percentile calculations.

Handles 10K orgs × 9 dimensions in <30 seconds

Forecast Workers

On-demand — Monte Carlo simulations, S-curve projections, expansion path generation.

10K iterations per forecast, <3s per model

CRM Sync Workers

Event-driven — CRMSyncPayload™ construction, webhook delivery, retry logic (3 attempts, exponential backoff).

100 syncs/sec; queued via Redis streams

Report Generators

Scheduled — QBIR™ generation, executive briefing PDFs, benchmark report rendering.

Queue-based; 50 concurrent renders

Notification Dispatcher

Fan-out — email, Slack/Teams, dashboard alerts. Templated from engine outputs.

1K notifications/sec; deduplicated within 5min window

Scaling Principles & Guarantees

Multi-Tenant Isolation

Every computation is scoped to a single organization ID. No cross-org data leakage in scoring, benchmarking, or recommendation engines. Database-level row security enforces tenant isolation.

Idempotent Computation

All scoring, benchmarking, and recommendation functions are deterministic and idempotent for the same inputs. Repeat computations produce identical results. Safe for retries and replays.

Eventual Consistency

Scores update within 500ms of input change (real-time). Peer group benchmarks converge within 24 hours (daily rebalance). Industry benchmarks converge within 1 week. All reads are eventually consistent.

Graceful Degradation

If the benchmark engine is unavailable, scoring continues with last-known benchmarks. If CRM sync fails, payloads are queued for retry. No downstream dependency blocks upstream computation.

Observability First

Every engine exposes: latency histograms, error rates, throughput metrics, cache hit rates. Per-organization computation traces available for debugging. Alert on any score pipeline step exceeding p99 latency.

Cost-Aware Archiving

Hot data (active scores, current configs): Redis + PostgreSQL. Warm data (90-day history): PostgreSQL read replicas. Cold data (1yr+): S3 with Parquet columnar format. Reports auto-archive after 4 quarters.

Platform Capacity at 10,000 Organizations

~50M

/day

Score Computations

5 engines × daily recomputation per org

~25M

active

Benchmark Data Points

9D vectors × 10K orgs × daily snapshots

~100K

/day

CRM Sync Operations

Score updates, trigger fires, opportunity creation

~40K

/quarter

Report Generations

QBIR™, executive briefings, benchmark reports