Group Scholar Escalation Console

A Scala CLI for logging, tracking, and summarizing escalations across scholar support operations. Designed to keep high-stakes issues visible, accountable, and time-bound.

Features

• Log escalations with owner, reason, severity, and due date
• List open/closed escalations with filters
• Close escalations and capture resolution time
• Summary rollups by status and severity
• Seed production with realistic starter data

Tech Stack

• Scala 2.13
• Slick (PostgreSQL)
• sbt

Setup

Install dependencies:

sbt update

Set environment variables (do not hardcode credentials):

export PGHOST="db-acupinir.groupscholar.com"
export PGPORT="23947"
export PGDATABASE="postgres"
export PGUSER="ralph"
export PGPASSWORD="<password>"

Usage

sbt "run -- help"
sbt "run -- init"
sbt "run -- seed"
sbt "run -- log --case-id GS-1001 --owner 'Ava Park' --reason 'Missing documentation' --severity high --due-date 2026-02-15 --notes 'Waiting on residency proof'"
sbt "run -- list --status open"
sbt "run -- close --id 1"
sbt "run -- summary"

Database Notes

• Uses schema escalation_console with table escalations.
• Run seed in production to preload realistic data for dashboards and summaries.

Testing

sbt test