Roads for Everyone (RFE)

AI-Assisted Study Note

This page brings together public scenario links and AI-assisted research notes for study use. Start with the scenario brief, make your own attempt, and open the spoiler section only when you are ready to compare.

Scenario Snapshot

Field	Detail
Start here	Scenario page
Scenario source	Community scenario (Andrew Hart / CTA202)
Current status	Live (AH)
First public date	2021-06
Primary source	Open primary source
Coverage available	Scenario brief + Discussion or analysis

Why This Scenario Matters

• This entry is included because it appears in the public CTA scenario corpus and has enough public evidence to track for study use.

Only Open If You Have Attempted the Scenario

The section below contains public follow-up links, board-call material, and AI-assisted notes compiled from those public sources.

Open follow-up links, Q&A, and analysis

Follow-Up Links

• Scenario page
• CTAGOF list (item #17)

Board Insights & Common Pitfalls

Generalized Judge Questions

• 5 Million Record Migration: “You have 5 million records of highly variable quality from a custom CRM, Excel files, and office-based systems. What is your data cleansing and deduplication strategy before loading into Salesforce?”
• Canute Banking Integration Timing: “Canute only allows changes in the first week of each calendar quarter. How does your integration architecture handle this constraint? What happens to new donors created mid-quarter?”
• Offline Mobile for Build Teams: “Contractors in remote areas have no cellular coverage. How do you capture GPS-tagged photos and permit data offline, and how does it sync when connectivity returns?”
• Donor Privacy and Celebrity Protection: “How do you restrict access to celebrity and high-value donor records while still allowing global fundraising reporting?”
• Contractor Code of Conduct: “Walk me through the contractor onboarding flow — how does the Code of Conduct signing work, and how do you enforce the 3-year lookback for contractor history?”

Common Mistakes

• Ignoring the Canute Constraint: Treating the banking system integration as a standard real-time API when it has a hard quarterly change window. This is a critical scheduling constraint.
• Weak Data Migration Strategy: Underestimating the 5M-record migration from multiple disparate sources with variable quality. Not proposing a staging environment or data quality tooling.
• Over-Licensing Volunteers: Giving 5,000 street fundraisers full Salesforce licenses when they only need tablet-based field data capture — a massive cost error.
• Single Campaign Strategy: Not distinguishing between Scheduled and Reactive campaigns, and missing the regulatory cap of maximum 3 scheduled campaigns per donor per year.
• Ignoring Invoice Overrun Reporting: The scenario requires flagging contractors who exceed quotes by >10% more than 3 times in 12 months — this is a complex cross-object reporting requirement easily overlooked.

Strong Patterns

• Experience Cloud for Fundraisers: Using a lightweight Experience Cloud site or Salesforce Mobile Publisher app for the 5,000 street fundraisers to capture donor sign-ups on tablets.
• MuleSoft for ERP Orchestration: Using MuleSoft to manage the multi-cadence integration: real-time donor sync to Canute (within quarterly windows), marketing campaign data, and contractor payment flows.
• Briefcase Builder for Offline: Using Briefcase Builder (or Field Service offline capabilities) for build teams in areas with no connectivity, with GPS metadata capture on photo uploads.
• Shield for Donor Privacy: Using Shield Platform Encryption and restricted sharing rules for celebrity/high-value donor records.

Strategic Insights

• The “Green Roof Cousin”: Andrew Hart notes “some similarities to Green Roof Systems, but presents some slightly different challenges.” Judges familiar with Green Roof may probe the differences — be ready to articulate why your RFE solution diverges.
• Charity-Specific Patterns: Success requires demonstrating knowledge of NPSP-style patterns (or Nonprofit Cloud), multi-currency donation handling, and compliance with fundraising regulations across multiple countries.

Additional Notes

• Created by Andrew Hart, Salesforce CTA #202, VP Services at Own (formerly OwnBackup).
• Contact: andrew.hart@btinternet.com
• Similar in some ways to Green Roof Systems but with distinct charity/NGO challenges.
• Not listed on Apex Hours scenario page.