Signal — Employees

Route guard: none. /employees is mounted in src/App.tsx with no wrapper (<Route path="/employees" element={<EmployeeView />} />), so any authenticated Signal user can load it. Authentication itself is Google OAuth restricted to authorized Power Digital and Cardinal email domains (the three-domain ALLOWED_DOMAINS allowlist in src/context/AuthContext.tsx: powerdigitalmarketinginc.com, external.powerdigitalmarketinginc.com, cardinaldigitalmarketing.com — see the Access Model page).

Role tiers (resolved in src/context/AuthContext.tsx from the Supabase app_users table columns is_team_lead, is_admin, is_gandalf; "Sauron" is a hardcoded super-admin list in code): Member (no elevated role) → Team Lead → Admin → Gandalf → Sauron. Roles are granted by editing app_users via Signal's General Access screen (/users, Gandalf-only). is_team_lead is also auto-granted at login when the user is an Executive Sponsor (Account Director) or Group Director on any active Nova client (the ensureUserProvisioned step provisions/upgrades the app_users row).

Member experience: the Employees view itself checks isMember and strips the page down to a table titled "Your Record" containing only the member's own row, matched by login email against the Nova roster (an unfiltered roster call, so the default hide-unassigned / hide-Unknown-org gates cannot drop the member's own record). Filters, averages, leaderboards, tabs, and the KPI Rollup are all hidden. The sidebar for Members keeps exactly two links: Summary and Employees. Global Search and the Iris assistant are also hidden for Members.

Nav flag: the "Employees" link sits in the "People" accordion section of the sidebar with no per-link flag (visible to everyone). Sibling links in the same section carry flags: Manage Leads (teamLeadOnly), Employee Pulse and KPI Targets (adminOnly, which also passes for Gandalf).

Admin-and-above extras inside the view: the "FT" confirmed-full-time badge on names (canSeeFtTag = isAdmin || isGandalf), the "Mark On Leave / Remove Leave" toggle in the drawer (isAdmin), the "Adjust Allocation" button in the drawer (isAdmin), and the data behind the hidden-by-default "Avg Client Hrs/Wk" column (its endpoint /api/pulse-coverage is requireAuth + requireAdmin; non-admins silently see em-dashes because the fetch failure is swallowed).

RPE (Revenue Per Employee) — the employee's allocated share of gross profit from their ACTIVE accounts, divided by the number of selected months, PLUS their monthly-averaged VABO allocation. Allocation merges blueprint slices per (client, department), applies Signal's saved team and any revenue_split_overrides percentages, and uses consulting-role weighting for Consulting accounts. Computed by the shared computeEmployeeRpe helper (also used by the Staffing view's simulator, so the two views cannot drift). Origin: Vena revenue × Nova/Signal staffing.

Total Gross Profit (attributedRevenue) — same allocated share summed across all selected months (not averaged). With a single month selected this equals RPE, so the column is labeled "RPE" and the separate Avg RPE column is hidden.

MRR (Book Value) — total monthly client value of the employee's active clients, counted once per client (full client revenue across departments, not just their line), averaged per selected month. This is the primary KPI for titles containing "account director" or "account manager". Origin: Vena revenue.

Retention — percentage of the employee's assigned clients that are retained. A client is retained in a month if its Nova churn_date is empty or falls after that month's end (src/services/transform.ts); a client counts as retained for the employee if ANY of its accounts are retained. An employee with zero assigned clients shows 100%. Cell color: green ≥ 90%, yellow ≥ 80%, red below (code constants as of Jul 2026). Origin: Nova client churn dates.

Seats — number of unique active (client, department) pairs the employee is on (blueprint slices collapsed so a Retainer + Project split is one seat).

Active Clients — distinct client names among the employee's active accounts (active = the account has revenue > 0).

VABO — the employee's allocated share of VABO revenue (performance-based revenue tracked by Finance in Vena; the acronym's expansion is unconfirmed — see the Glossary entry), lead-based: only people set as VABO leads in Manage Leads → People get credit. Shown as a "+VABO" pill and included in RPE.

Performance status / target chips — actual vs target for the employee's primary KPI (MRR for AD/AM titles, RPE otherwise; when a role has only one target set, that one is primary). Targets come from the Google Sheets → signal_roles sync; default retention target is 90% when the sheet doesn't set one (code constant as of Jul 2026, data-team-tunable via the sheet).

Hit Rate (KPI Rollup) — percentage of classified employees in a group at or above their primary KPI target. Badge: green ≥ 75%, amber ≥ 50%, red below (code constants as of Jul 2026).

KPI Rollup grouping — "By Department & Role" uses the same single-role classification (getCapacityRole) as the Role Capacity view; "By Division" pulls avg RPE / MRR from the centralized getGroupedSummary so numbers match the Summary view.

Avg Client Hrs/Wk — total client hours from Pulse submissions divided by distinct weeks submitted, per employee (admin-only data).

Hours benchmark badge (drawer) — the person's weekly hours as % of the company benchmark (average weekly hours of all Pulse reporters, last 13 weeks). Badge: green ≥ 90%, amber ≥ 70%, red below (code constants as of Jul 2026).

Averages strip — Total Employees, Total Gross Profit (identical to Summary view when no account-level filters are set), Avg Gross Profit / Employee, Avg Clients / Employee, Avg Seats / Employee, all over the currently filtered roster.

Mark On Leave / Remove Leave (admin-only, in the employee drawer): writes the on_leave flag to Signal's own records (Supabase employee_flags, direct from the browser with optimistic update/rollback). Side effect: the person is excluded from all aggregate metrics across every Signal view (a global, not month-scoped, flag).

Adjust Allocation (admin-only, in the drawer) writes nothing on this view — it navigates to Manage Leads (/leads?employee=<name>), where team changes and % splits land in Signal's own records (Supabase team_assignments, revenue_split_overrides) and, since the 2026-07-01 cutover, AD/Sr-AD changes are pushed to Nova itself. Those changes then feed back into every RPE/share number on the Employees view.

Request Title / Dept / Division Change opens an external Asana intake form — org-data corrections happen in Nova via Asana, not in Signal.

Column show/hide preferences and CSV exports (employees.csv, kpi_rollup.csv) are local to the user's browser; no shared state changes.

Avg Client Hrs/Wk is effectively admin-only: the column is offered to all users in the column picker but its endpoint (/api/pulse-coverage) requires admin; non-admins get silent em-dashes. Whether that gate is intentional for this column is not defined in the app repo.

Column labels change with month selection: single month → the Gross Profit column is labeled "RPE", the Avg RPE column and the "Avg Monthly" leaderboard tab disappear (they'd duplicate the gross-profit numbers).

Unassigned people are hidden by default: the roster only shows people leading at least one account with revenue activity (VABO counts). The "Show unassigned" checkbox reveals everyone; searching a person by name always surfaces them even when unassigned.

People with Unknown org are dropped: anyone whose Nova department OR division resolves to "Unknown" is excluded from the Employees view roster (hideUnknownOrgUnit in DataContext.getEmployeeMetrics).

Employment type is best-effort ADP name matching — expect blanks when names differ between Nova and ADP or ADP is unreachable.

JD links are curated, not automatic: a title links to its job description only if the person/title is in the manually maintained Excel/Google Sheet (re-synced at server startup or by a Gandalf user). Unlinked titles show a dashed-underline fallback.

KPI targets depend on a manual sheet + title match: targets sync from a Google Sheet into Supabase signal_roles on server startup and on manual sync; there is no scheduled re-sync in the repo. Employees whose Nova job title doesn't match a sheet row are "unclassified" (no chips, excluded from Hit Rate).

Caching: roster and org lookups are cached 1 hour server-side (plus warehouse replica lag from Nova); Nova live assignments cache 5 minutes. A just-made Nova org change can take up to ~1 hour (or ?refresh=1 on the API) to appear.

Code constants (as of Jul 2026, changeable without notice): retention colors 90/80, hit-rate badges 75/50, hours badge 90/70, default retention target 90%, Pulse question id 1006, 250h per-entry hours cap, 13-week benchmark window, the Asana form URL, and the Nova profile URL pattern.

On Leave is global: the flag applies to all historical months, not just the current selection.

Nova cutover transition (2026-07-01): team-assignment history for dates on/after 2026-07-01 reads Nova's own assignment history; earlier dates read Signal's Supabase records. During this transition, discrepancies between Manage Leads saves and Nova's state resolve in Nova's favor for AD/Sr-AD on non-consulting single-division clients.

Precise business definition of "Retained": in code, a client is retained for a month when its Nova churn_date is empty or after that month-end. Whether this matches finance's external retention definition is not defined in the app repo.

Whether "Seats" matches finance/ops vocabulary outside Signal is not defined in the app repo.

Summary (/summary): the Employees averages strip reuses the Summary view's revenue computation so totals match; Division/Department filters are shared state between the two views (a filter set on Employees follows you to Summary).

Manage Leads (/leads, Team Lead+): the biggest upstream dependency — saved teams (Supabase team_assignments), % overrides (revenue_split_overrides), VABO leads, and (post-cutover) Nova-direct AD/Sr-AD writes directly change every RPE, "Your Share", and VABO number on the Employees view. The drawer's "Adjust Allocation" deep-links there pre-filtered to the employee.

Staffing (/staffing, non-members): uses the same canonical computeEmployeeRpe helper, so simulated RPE matches this view.

KPI Targets (/kpi-targets, Admin+): where the Google Sheet → signal_roles target sync is run and managed; the Employees view consumes the resulting title→target map for chips, KPI cards, and Hit Rate.

Employee Pulse (/pulse-coverage, Admin+): audits who submitted Pulse hours; the Employees view consumes the same submissions for hours per person.

Role Capacity (/capacity, Admin+): shares the single-role classification (getCapacityRole) used by the KPI Rollup's role grouping.

Nova (external, app.novapower.io): origin of the roster, org structure, titles, managers, hire dates, staffing history, and Pulse hours; drawer links out to Nova profiles.