Project Atlas AetherDev project hub
Atlas project production

BOUSD-Enrollment-Worksheet-HR

Refresh the enrollment worksheet and HR-linked planning feed from Aeries into Google Sheets on a scheduled daytime cadence.

Internal-only entry. Do not publish externally without review.
Type
Field Tool
Lifecycle
Active
Last touched
2026-03-24
Visibility
Internal

Purpose

Keep the enrollment worksheet and HR-adjacent planning view refreshed from Aeries so staffing and enrollment planning use the same current feed.

Current state

The registry now identifies this as an active member of the reporting extract family with a 15-minute schedule. What remains missing is a clear Atlas note on who consumes the resulting worksheet and how the live sheet contract is governed.

Next step

Capture the destination sheet, business owner, and downstream planning surface that currently depend on this extract.

Interfaces

Inputs
  • SQL query files
  • TOML configuration
  • ODBC connection settings
  • Google service-account access
Outputs
  • enrollment worksheet tabs
  • local CSV artifacts
  • staffing-planning source data

Reality to Action trace

Reality Ingestion

Contributes in this stage.

Canonical Storage

Not in scope.

Automation Engines

Not in scope.

Human Interfaces

Contributes in this stage.

Operational Adoption

Contributes in this stage.

Core workflow

TBD. Document the 5-10 steps that define the core workflow.

Data integrity and contracts

Source of truth rules

  • Aeries is canonical for the extracted data.
  • Destination sheets are operational distribution surfaces and should not become the authoring system.

Safe handling

  • Restrict service-account keys and ODBC credentials to approved operators.
  • Treat CSV artifacts and destination tabs as restricted operational data.
  • Document host ownership and recovery steps in an internal runbook.

Operational notes

Reliability posture

Re-runs overwrite known sheet ranges and usually leave prior sheet data intact on failure, but host inventory and alerting are not yet centralized.

Observability

  • stdout/stderr from run.sh and bundled CLI tools
  • CSV artifacts in data/ and temp/
  • stale or missing downstream sheet tabs

Security and privacy

These jobs move restricted operational data from Aeries into Google Sheets. Keep service-account keys, credentials, logs, and CSV artifacts private.

Dependencies

Upstream
  • Aeries SQL access
  • ODBC driver stability
  • service-account sharing
  • scheduler ownership
Downstream
  • enrollment worksheet processes
  • staffing and planning reviews

Ownership

Owners

Technology Services, Josh Barton

Users

Technology Services, district reporting stakeholders

BOUSD-Enrollment-Worksheet-HR

Operational Notes

  • Implementation pattern: run.sh wrapper, conf.d/ configuration, SQL-over-ODBC extraction, local CSV artifacts, and controlled Google Sheets range overwrites.
  • Scheduled cadence: Every 15 minutes between 07:00 and 18:00 per registry-backed cron evidence.
  • Shared family risks include sheet header drift, secret sprawl, host ownership gaps, and weak centralized monitoring.

Registry Alignment

  • Registry context: this feed belongs to the Aeries-to-Google Sheets reporting extract family, which Atlas keeps as operational family context rather than as a standalone BOUSD integration.
  • Registry clarified: this job is a scheduled production feed, not just a one-off worksheet generator.
  • Validation gaps: destination tabs, business ownership, and host inventory still need explicit documentation.