Compliance System

Levine Act (SB 1429) Compliance — City of Escondido

Role-based compliance dashboard for California's Levine Act and related government ethics requirements. Four user roles with distinct access levels, 22 routes, live MuniCode agenda integration, and evidence-based attorney investigation tools. Configured for Escondido City Council.

Total Routes

User Roles

DB Tables

45+

tRPC Procedures

AI Invocations

External Integrations

User Roles

Four distinct roles control what each user sees in the compliance dashboard. Access is enforced at both the route level (ComplianceRoleGuard) and the sidebar level (ComplianceDashboardLayout). Officers under investigation cannot see attorney tools.

Officer

12 pages

Mayor, Councilmembers & Commissioners

Elected officials and appointed commissioners who are subject to the Levine Act and other compliance requirements. Officers see a personal compliance experience focused on their own status, deadlines, and self-service tools.

Attorney

18 pages

City Attorney's Office

The City Attorney and designated legal staff who conduct compliance investigations, review contribution relationships, and provide legal guidance. Attorneys have the most powerful investigative tools, including evidence-based data exploration and AI-assisted legal research.

Clerk

12 pages

City Clerk's Office

The City Clerk and administrative staff who manage data ingestion, user onboarding, and system configuration. Clerks handle the operational side — importing Netfile contributions, managing data sources, and assigning compliance roles to new users.

Admin

20 pages

System Administrators

Full system access for ForaCity platform administrators. Admins see everything — all attorney investigative tools and all clerk administrative tools. The only role that bridges both the City Attorney and City Clerk tool sets.

Compliance Site Map

All 22 compliance routes organized by category. Each route shows which roles can access it and what data sources it reads from.

officerattorneyclerkadmin— access levels

Route	Page	Access	Data Source
`/compliance`	Dashboard Compliance overview with progress across all 8 modules	officerattorneyclerkadmin	compliance_scores, officers
`/compliance/overview`	Role Overview Interactive role reference — what each user type sees	officerattorneyclerkadmin	static metadata
`/compliance/tour`	Guided Tour Step-by-step onboarding walkthrough	officerattorneyclerkadmin	static

Route	Page	Access	Data Source
`/compliance/pay-to-play`	1. Pay-to-Play Levine Act (SB 1429) — $500 threshold, 12-month lookback, recusal rules	officerattorneyclerkadmin	contributions, officers, conflicts
`/compliance/form-700`	2. Form 700 Statement of Economic Interests filing requirements	officerattorneyclerkadmin	form700_filings, officers
`/compliance/conflicts`	3. Conflict of Interest Financial interest conflicts under Gov Code §87100	officerattorneyclerkadmin	conflicts, contributions
`/compliance/ethics-training`	4. Ethics Training AB 1234 — 2 hours every 2 years	officerattorneyclerkadmin	training_records
`/compliance/fiscal-training`	5. Fiscal Training Fiscal responsibilities for budget and expenditure oversight	officerattorneyclerkadmin	training_records
`/compliance/harassment`	6. Harassment Prevention AB 1825 — 2 hours every 2 years for supervisory roles	officerattorneyclerkadmin	training_records
`/compliance/open-meetings`	7. Open Meetings Brown Act — 72-hour agenda posting, public comment, closed session	officerattorneyclerkadmin	meetings, agendas
`/compliance/campaign-finance`	8. Campaign Finance Contribution limits, disclosure requirements, Netfile filing	officerattorneyclerkadmin	contributions, netfile_sync

Route	Page	Access	Data Source
`/compliance/my-dashboard`	My Compliance Personal compliance command center — status, flags, deadlines, self-service	officer	officers, compliance_scores, research_items

Route	Page	Access	Data Source
`/compliance/attorney-review`	Attorney Review Evidence-based contribution review with flag/annotate/compare tools	attorneyadmin	contributions, contribution_evidence_links, research_items
`/compliance/investigations`	Investigations Research dossier management — attorney-driven, not auto-generated	attorneyadmin	compliance_investigations, research_items
`/compliance/ai-assistant`	Legal AI Assistant AI research with CA Gov Code, FPPC opinions, Escondido municipal code	attorneyadmin	LLM, knowledge_base_docs
`/compliance/knowledge-base`	Knowledge Base Upload legal documents the AI assistant can cite	attorneyadmin	knowledge_base_docs, S3
`/compliance/audit`	Audit Trail Immutable log for FPPC audits and Public Records Act requests	attorneyadmin	audit_logs
`/compliance/netfile-explorer`	Netfile Explorer Live Netfile campaign finance data for Escondido filers	attorneyadmin	NetFile API
`/compliance/agenda-recusal`	Agenda Recusal MuniCode agenda scraping with Levine Act recusal flagging	attorneyadmin	council_meetings, agenda_items, recusal_flags, MuniCode

Route	Page	Access	Data Source
`/compliance/data-sources`	Data Sources Data ingestion hub — Netfile connections, CSV imports, sync status	clerkadmin	netfile_sync_status, import_history
`/compliance/onboarding`	Onboarding & Invites Invite officials with pre-assigned compliance roles	clerkadmin	users, invitations

Route	Page	Access	Data Source
`/compliance/setup`	Change City Switch jurisdiction context (multi-city support)	officerattorneyclerkadmin	jurisdictions

External Integrations

MuniCode Meetings

escondido-ca.municodemeetings.com

City Council agenda scraping

Weekly (Monday 7 AM)

California Netfile

netfile.com

Campaign finance contribution data

On-demand sync

Forge LLM

Built-in API

Legal AI assistant, agenda item classification

Per-request

Quick Links

Compliance Dashboard

Open the live compliance system

Role Overview (In-App)

Interactive role reference inside the dashboard

Database Schema

12 compliance tables in the schema docs

Architecture Notes

Compliance routes live under /compliance/* in the main App.tsx router
Role enforcement uses ComplianceRoleGuard at the route level and sidebar filtering in ComplianceDashboardLayout
Backend procedures are gated by complianceRole field on the user record, checked via tRPC middleware
MuniCode scraping runs server-side via node-cron every Monday at 7:00 AM Pacific
Evidence-based contribution links use contribution_evidence_links table with typed evidence categories
Attorney research dossiers are stored in research_items linked to compliance_investigations