Red Rover Manager Skill

Overview

Red Rover is an absence management system used by PSD to track staff absences and substitute coverage. This skill provides access to absence data for reporting and analysis.

Configuration

Base URL:
```
https://connect.redroverk12.com/
```
Org ID: 1305 (Peninsula School District)
Authentication: HTTP Basic Auth + API Key header
Credentials: Stored in 1Password as "RedRover"
Rate Limit: 100 requests/minute

Authentication

All requests require both:

Authorization: Basic [base64(username:password)]

header

```
apiKey: [key]
```
header (obtained from organization endpoint)

The organization endpoint returns a dynamic API key that should be used for subsequent requests.

Scripts

All scripts are in

skills/redrover-manager/scripts/

. Run with

bun

get_organization.js

Fetch organization info and validate credentials.

bash

bun get_organization.js

Returns: Organization ID, name, and API key.

get_absences.js

Fetch raw absence/vacancy data for a date range.

bash

bun get_absences.js <start_date> <end_date> [filled|unfilled|all]

Examples:

bash

bun get_absences.js 2026-01-20 2026-01-27
bun get_absences.js 2026-01-27 2026-01-27 unfilled

Note: Max date range is 31 days.

get_daily_summary.js

Get daily absence summary (all staff) with counts by school, reason, and fill status.

bash

bun get_daily_summary.js [date]

Date options:

```
today
```
(default)
```
yesterday
```
Day names:
```
monday
```
,
```
tuesday
```
, etc.
```
last wednesday
```
,
```
last friday
```
Specific date:
```
2026-01-27
```

get_certificated_summary.js

Get daily absence summary for certificated staff only (Teachers, ESA, CTE).

bash

bun get_certificated_summary.js [date]

Same date options as above. This is the most commonly requested report - focuses on classroom coverage.

get_weekly_summary.js

Get weekly trends and patterns.

bash

bun get_weekly_summary.js [weeks_ago]

Options:

```
0
```
= this week (default)
```
1
```
= last week
```
2
```
= two weeks ago

API Endpoints Used

Organization

GET /api/v1/organization
Security: Basic Auth
Returns: Array with org info including dynamic apiKey

Vacancy Details (Primary data endpoint)

GET /api/v1/{orgId}/Vacancy/details
Security: Basic Auth + apiKey header
Query Params:
  - fromDate: datetime (required)
  - toDate: datetime (required)
  - filled: boolean (optional - filter filled/unfilled)
  - pageSize: int (default 10, max 100)
  - page: int (default 1)
Returns: Paginated vacancy/absence data

Common Workflows

"How many absences yesterday?"

bash

bun get_daily_summary.js yesterday

"Show unfilled positions for today"

bash

bun get_daily_summary.js today
# Look at unfilled_positions array in output

"Weekly absence trends"

bash

bun get_weekly_summary.js

"Last week's summary"

bash

bun get_weekly_summary.js 1

Output Format

Daily Summary

json

{
  "date": "yesterday",
  "date_iso": "2026-01-26",
  "total_absences": 110,
  "filled": 75,
  "unfilled": 35,
  "fill_rate": 68,
  "by_school": {
    "PENINSULA HIGH SCHOOL": 13,
    "GIG HARBOR HIGH SCHOOL": 10
  },
  "by_reason": {
    "SICK LV > 1 SICK": 54,
    "OTH PAID LV > PERSONAL": 15
  },
  "by_position_type": {
    "Teacher": 55,
    "Paraprofessional": 36
  },
  "unfilled_positions": [
    {
      "school": "PENINSULA HIGH SCHOOL",
      "position": "MATH",
      "employee": "JANE DOE",
      "start": "2026-01-26T07:00:00",
      "end": "2026-01-26T14:30:00"
    }
  ]
}

Weekly Summary

json

{
  "week": "Jan 20-24, 2026",
  "week_label": "this week",
  "total_absences": 450,
  "daily_average": 90,
  "filled": 380,
  "unfilled": 70,
  "fill_rate": 84,
  "peak_day": { "day": "Monday", "count": 120 },
  "slow_day": { "day": "Friday", "count": 65 },
  "by_day": {
    "Monday": 120,
    "Tuesday": 95,
    "Wednesday": 90,
    "Thursday": 80,
    "Friday": 65
  },
  "trends": [
    { "type": "info", "message": "Monday had 120 absences (50%+ above average)" }
  ]
}

Data Fields

Key fields in vacancy data:

```
absenceDetail.employee
```
- Employee who is absent
```
absenceDetail.reasons[0].name
```
- Reason category (SICK, PERSONAL, etc.)
```
location.name
```
- School name
```
position.title
```
- Position title
```
position.positionType.name
```
- Position category (Teacher, Paraprofessional, etc.)
```
substitute
```
- If present, position is filled
```
start
```
/
```
end
```
- Absence time range
```
needsReplacement
```
- Whether sub is required

Schools in PSD

Common school names in data:

PENINSULA HIGH SCHOOL
GIG HARBOR HIGH SCHOOL
HENDERSON BAY HIGH SCHOOL
GOODMAN MIDDLE SCHOOL
HARBOR RIDGE MIDDLE SCHOOL
KEY PENINSULA MIDDLE SCHOOL
KOPACHUCK MIDDLE SCHOOL
ARTONDALE ELEMENTARY SCHOOL
DISCOVERY ELEMENTARY SCHOOL
EVERGREEN ELEMENTARY SCHOOL
HARBOR HEIGHTS ELEMENTARY SCHOOL
MINTER CREEK ELEMENTARY SCHOOL
PIONEER ELEMENTARY SCHOOL
PURDY ELEMENTARY SCHOOL
SWIFT WATER ELEMENTARY SCHOOL
VAUGHN ELEMENTARY SCHOOL
VOYAGER ELEMENTARY SCHOOL

redrover-manager

NPX Install

Tags

SKILL.md Content

Red Rover Manager Skill

Overview

Configuration

Authentication

Scripts

get_organization.js

get_absences.js

get_daily_summary.js

get_certificated_summary.js

get_weekly_summary.js

API Endpoints Used

Organization

Vacancy Details (Primary data endpoint)

Common Workflows

"How many absences yesterday?"

"Show unfilled positions for today"

"Weekly absence trends"

"Last week's summary"

Output Format

Daily Summary

Weekly Summary

Data Fields

Schools in PSD