Aeries Staff Extract SQL Generator
Provide the canonical staff extract logic feeding BOUSD refresh, reporting, and operational planning workflows.
Reality Ingestion
Canonical Storage
Open projectAtlas view
SIS Data
This domain groups systems that solve SIS Data problems - shared vocabulary, common interfaces, and repeatable operational constraints. Use this page to see which systems already exist, what they ingest and emit, and which patterns we repeatedly rely on in this problem space.
Domains are how we avoid reinventing the same solution in slightly different shapes. When a domain repeats, it’s a signal to standardize schemas, mapping layers, auth patterns, and operator workflows.
Domain guide
How to read this domain
Definition
This domain groups systems focused on sis data workflows, shared data models, and repeatable operational constraints.
What belongs
- Systems where sis data is the primary problem space.
- Integrations that move, validate, or enforce data in this domain.
- Operational tools that reduce risk and manual work for this domain.
What doesn't
- Generic tools where sis data is incidental metadata.
- One-off experiments without domain-specific constraints.
Typical integrations and constraints
- Source-of-truth feeds, vendor APIs, and scheduled extracts.
- Schema drift, credential scope, and compliance requirements.
- Role-based access and operational review cycles.
Common interfaces
- REST/JSON APIs and vendor export endpoints.
- CSV, SQL views, or Sheets-based boundary objects.
- Auth boundaries (service accounts, OAuth, SSO).
Common patterns and playbooks
Sql Extract
Secure File Transfer
Review Before Apply
Schedule Driven Sync
Config Driven Extract
Range Overwrite
No playbooks mapped yet.
Aeries Student Groups Maintenance Workflow
Maintains selected Aeries student-group memberships for operational cohorts such as SPED, GATE, district groups, and other configured populations.
Operational Adoption
Human Interfaces
Open projectAeries to Clever Rostering and SSO Hub
Publish Aeries roster and identity data into Clever as the central hub for instructional access, SSO, downstream application provisioning, and app-assignment …
Reality Ingestion
Human Interfaces
Operational Adoption
Open projectAeries-to-Google Sheets Reporting Extract Family
Coordinate the parent family of scheduled Aeries-to-Google Sheets extracts that feed attendance, class-size, enrollment, PADC, and related district reporting …
Reality Ingestion
Human Interfaces
Operational Adoption
Open projectAPEX Learning OneRoster Provisioning Workflow
Publish Aeries roster data to APEX Learning through the current OneRoster-style provisioning path used for instructional access.
Reality Ingestion
Human Interfaces
Operational Adoption
Open projectASB Works Student Export
Sends current 9-12 student data into ASB Works so student activity or account records stay aligned without manual nightly imports.
Reality Ingestion
Delivery
Open projectBOUSD-ClassSize-Extract
Refresh Aeries class-size outputs into Google Sheets for staffing, class-load, and planning workflows.
Reality Ingestion
Human Interfaces
Operational Adoption
Open projectBOUSD-DataConfDocs-Extract
Refresh data-confirmation support outputs from Aeries into Google Sheets for recurring district workflow use.
Reality Ingestion
Human Interfaces
Operational Adoption
Open projectBOUSD-Enrollment-Extract
Refresh enrollment source data from Aeries into Google Sheets for planning, dashboard, and report workflows.
Reality Ingestion
Human Interfaces
Operational Adoption
Open projectBOUSD-Enrollment-Worksheet-HR
Refresh the enrollment worksheet and HR-linked planning feed from Aeries into Google Sheets on a scheduled daytime cadence.
Reality Ingestion
Human Interfaces
Operational Adoption
Open projectBOUSD-MonthlyAttendance-Dashboard
Provide district and site leaders with a role-aware Google Workspace dashboard for attendance and chronic absenteeism visibility, with source freshness …
Reality Ingestion
Human Interfaces
Operational Adoption
Open projectBOUSD-MonthlyAttendance-Extract
Refresh attendance source tabs from Aeries into Google Sheets for the monthly attendance dashboard and related reporting views.
Reality Ingestion
Human Interfaces
Operational Adoption
Open projectBOUSD-PADC-Extract
Refresh principal apportionment attendance support data from Aeries into Google Sheets for certification, revision, and funding-sensitive review workflows.
Reality Ingestion
Human Interfaces
Operational Adoption
Open projectCALPADS Data Quality, Validation, and Notification Workflow
Maintains CALPADS data quality through Aeries validation rules, automated SQL validation workflows, weekly responsibility-based notifications, and manual review …
Reality Ingestion
Delivery
Open projectCCGI Data Integration and Validation Pipeline
Synchronizes district data with CCGI and supports transcript, graduation, and validation work needed for college and career readiness records.
Reality Ingestion
Delivery
Open projectCYBHI / Leader Services Billing Integration
Integrates student insurance billing information with Leader Services to support SPED billing workflows.
Reality Ingestion
Delivery
Open projectData Warehouse
Centralize canonical datasets in a durable storage layer so dashboards, reports, and data-driven systems can depend on consistent truth.
Reality Ingestion
Canonical Storage
Operational Adoption
Open projectDecisionInsite Student Demographics Export
Exports current student demographic and residence data from Aeries into DecisionInsite for planning and demographic-analysis workflows.
Reality Ingestion
Delivery
Open projectEdlio Website Directory and School Data Export
Historical Integr8r export that pushed district student and staff records from Aeries into Edlio-facing files before retirement.
Reality Ingestion
Delivery
Open projectFollett Destiny Patron Import
Generates and imports patron records into Follett Destiny so student library accounts stay aligned to current SIS data.
Reality Ingestion
Delivery
Open projectGoGuardian Classroom Management / Filtering Reference
Historical predecessor platform retained only to preserve lineage from GoGuardian to NetRef to Classwize.
Operational Adoption
Open projectHero K12 Roster Export
Exports BJHS student, faculty, and schedule data into Hero K12 so the platform stays aligned to current SIS roster state.
Reality Ingestion
Delivery
Open projectHMH DataManager Assessment Provisioning Export
Seasonal Integr8r-driven export that sends location and staff-user files to HMH DataManager for CogAT and related assessment account provisioning.
Reality Ingestion
Delivery
Open projectHMH MyHRW / ThinkCentral Instructional Rostering Workflow
Send Aeries roster data into HMH instructional platforms so digital curriculum access stays aligned to live class rosters.
Reality Ingestion
Human Interfaces
Operational Adoption
Open projecti-Ready Clever Rostering and SSO Configuration
Keep i-Ready access aligned through Aeries and Clever configuration so eligible students and teachers receive timely instructional access.
Reality Ingestion
Human Interfaces
Operational Adoption
Open projectIntegr8r
Legacy Windows production runner for BOUSD integration jobs, including SQL exports, file transfers, write-back workflows, and report mailers.
Reality Ingestion
Automation Engines
Delivery
Operational Adoption
Open projectNetRef Classroom Management Platform
Historical classroom management tool retained here because later district work explicitly references transition from NetRef to Classwize.
Operational Adoption
Open projectNSCH Student Tracker Graduate Submission
Submits prior-year graduate records to National Student Clearinghouse StudentTracker to support postsecondary tracking and related reporting workflows.
Reality Ingestion
Delivery
Open projectOCDE HR to Aeries Staff Sync (Rust Active; Legacy Bash Retired)
Keeps Aeries staff records aligned with OCDE HR data for identity, assignment, and compliance reporting, with `ocdehr_aeries_sync` as the active runtime and …
Reality Ingestion
Delivery
Open projectOCDE S1S Summer School Roster Export Automation
Automates generation of the OCDE ACCESS S1S bulk-import roster file from a governed Google Sheets `Data Entry` tab and Aeries demographics, with verification …
Reality Ingestion
Automation Engines
Human Interfaces
Operational Adoption
Open projectSavvas Realize Instructional Rostering Workflow
Deliver current Aeries roster data into Savvas Realize through the district's scheduled instructional access workflow.
Reality Ingestion
Human Interfaces
Operational Adoption
Open projectSchoolMessenger Communication Workflows
Historical SchoolMessenger export workflows retained for lineage because Integr8r still preserves disabled job definitions.
Operational Adoption
Open projectSIA A2A Manual Code Export
Generates tab-delimited code files for SIA configuration and Data Robot support on the district automation machine.
Reality Ingestion
Delivery
Open projectSQL
Centralize operational queries for reporting, audits, and data movement workflows. It ingests Database tables (Aeries and related systems) and produces Query …
Canonical Storage
Open projectTransTraks Student Export
Generates a student demographic and contact export for a TransTraks downstream workflow.
Reality Ingestion
Delivery
Open projectNo matching projects found. Try another keyword.