Group Scholar Check-in Studio

Group Scholar Check-in Studio is a Perl CLI for logging scholar outreach check-ins, surfacing overdue follow-ups, and summarizing engagement signals. It stores records in PostgreSQL so the ops team can keep a consistent, shared history of outreach.

Features

• Log check-ins with channel, status, notes, and next follow-up date
• List recent check-ins with filtering
• Surface overdue follow-ups based on the latest check-in per scholar
• Summarize check-in status totals for a recent window
• Flag stale scholars with no recent check-ins
• Show upcoming check-ins based on the latest outreach plan
• Review history for a specific scholar

Tech Stack

• Perl 5.42
• PostgreSQL
• DBI + DBD::Pg

Setup

1. Install Perl dependencies:

cpanm --local-lib=~/perl5 local::lib
PERL5LIB=~/perl5/lib/perl5 PERL_MM_OPT="INSTALL_BASE=$HOME/perl5" cpanm DBI DBD::Pg

2. Configure the database connection (use the production connection for deployed environments):

export GROUPSCHOLAR_DB_URL="postgresql://USER:PASSWORD@HOST:PORT/DATABASE"

3. Run the migrations and seed data:

psql "$GROUPSCHOLAR_DB_URL" -f scripts/migrate.sql
psql "$GROUPSCHOLAR_DB_URL" -f scripts/seed.sql

Usage

bin/checkin-studio add-checkin \
  --scholar-id GS-1010 \
  --name "Taylor Chen" \
  --cohort 2027 \
  --region "Midwest" \
  --channel email \
  --status completed \
  --notes "Reviewed scholarship renewal plan" \
  --next-date 2026-03-12

bin/checkin-studio list-checkins --since 2026-01-01
bin/checkin-studio overdue
bin/checkin-studio summary --days 45
bin/checkin-studio stale --days 60 --limit 25
bin/checkin-studio upcoming --days 21 --limit 25
bin/checkin-studio history --scholar-id GS-1002 --limit 5

Testing

prove -l tests