Decision owner
Student advisor
The named role remains accountable for the consequential decision.
Education
Designed for Student advisor
Give the student advisor a grounded view of a student's academic standing, degree progress, holds, financial aid deadlines and support referrals so intervention conversations start from verified policy and record rather than from memory.
Contract EDU-03 · primary aggregate StudentSupportCase · mode loading
Decision brief
This brief starts with the decision, evidence, and accountable owner. The guided workflow then shows how the recommendation was produced.
The evidence and control points that shape this recommendation.
Decision owner
Student advisor
The named role remains accountable for the consequential decision.
Governed evidence
5 record types
Structured records and cited text ground the recommendation.
Workflow
5 controlled stages
Each transition records its input, output, status, and audit context.
Human controls
1 approval gate
Approval gates prevent the copilot from making consequential decisions.
A third-year student on academic warning asks whether dropping an organic chemistry course will cost them their scholarship.
Give the student advisor a grounded view of a student's academic standing, degree progress, holds, financial aid deadlines and support referrals so intervention conversations start from verified policy and record rather than from memory.
confirmedReferral gives Student advisor the evidence needed to begin the final governed business outcome, with the decision trail retained for review.
Step 1 of 5
| Field | Value |
|---|
| Field | Value |
|---|
The output appears here immediately. More technical evidence remains available below.
The demonstration keeps deterministic controls, AI assistance, and approval separate.
Source systems enforce identity, workflow order, policy filters, and record updates.
Retrieval and generation assemble relevant evidence into a cited recommendation or draft.
Student advisor verifies material claims and approves the consequential action.
Run the stages in order before using the Copilot. Every stage explains what happens, why it matters, the evidence it uses, and the complete API request and response.
Automated stage
What happens: Early-alert aggregator performs risk signal aggregation using StudentRecord and produces riskProfile. The transition is deterministic and does not require autonomous model approval.
Why it matters: riskProfile gives Degree audit connector the evidence needed to begin Degree progress reconciliation, with the decision trail retained for review.
Loading relevant sample records.
Ready to run.
POST /api/domain/workflow/risk-signal-aggregation
Run this API to see its formatted outcome.
| Field | Value |
|---|
| Field | Value |
|---|
Automated stage
What happens: Degree audit connector performs degree progress reconciliation using DegreeRequirement and produces progressGapSet. The transition is deterministic and does not require autonomous model approval.
Why it matters: progressGapSet gives Student services navigator the evidence needed to begin Policy and deadline grounding, with the decision trail retained for review.
Loading relevant sample records.
Ready to run.
POST /api/domain/workflow/degree-progress-reconciliation
Run this API to see its formatted outcome.
| Field | Value |
|---|
| Field | Value |
|---|
Automated stage
What happens: Student services navigator performs policy and deadline grounding using progressGapSet and produces PolicyChunk. The transition is deterministic and does not require autonomous model approval.
Why it matters: PolicyChunk gives Student services navigator the evidence needed to begin Intervention plan drafting, with the decision trail retained for review.
Loading relevant sample records.
Ready to run.
POST /api/domain/workflow/policy-and-deadline-grounding
Run this API to see its formatted outcome.
| Field | Value |
|---|
| Field | Value |
|---|
Automated stage
What happens: Student services navigator performs intervention plan drafting using PolicyChunk and produces InterventionPlan. The transition is deterministic and does not require autonomous model approval.
Why it matters: InterventionPlan gives Student advisor the evidence needed to begin Advisor confirmation and referral release, with the decision trail retained for review.
Loading relevant sample records.
Ready to run.
POST /api/domain/workflow/intervention-plan-drafting
Run this API to see its formatted outcome.
| Field | Value |
|---|
| Field | Value |
|---|
Human approval required
What happens: Student advisor performs advisor confirmation and referral release using InterventionPlan and produces confirmedReferral. A named human approver must review the evidence before the transition completes.
Why it matters: confirmedReferral gives Student advisor the evidence needed to begin the final governed business outcome, with the decision trail retained for review.
Loading relevant sample records.
Ready to run.
POST /api/domain/workflow/advisor-confirmation-and-referral-release
Run this API to see its formatted outcome.
| Field | Value |
|---|
| Field | Value |
|---|
Run a stage to see its explanation, evidence, full request, and full response.
Ask a question and receive an answer grounded in retrieved StudentSupportCase evidence.
Select a starter question or enter your own.
Loaded live from /api/config, /api/domain/model, and
/api/domain/sample.
studentSupportCases/tenantId + /studentIdA third-year student on academic warning asks whether dropping an organic chemistry course will cost them their scholarship. The navigator reconciles the degree audit, shows that the course satisfies a required science sequence with no approved substitution in the 2024-2025 catalog, cites the satisfactory-academic-progress rule requiring 24 completed credits per year, and notes the late-withdrawal deadline is in nine days with an appeal path through the registrar. It drafts a plan pairing a tutoring referral with a reduced-load petition. The advisor confirms the tutoring referral, declines the petition for now, and the cited rationale is written to the advising record for the next advisor who opens the case.
| Container | Role | Hierarchical partition key | Document types |
|---|---|---|---|
studentSupportCases |
Primary | /tenantId + /studentId |
StudentRecord, DegreeRequirement, AdvisingInteraction, InterventionPlan |
academicCatalogLibrary |
Reference | /tenantId + /catalogYear |
PolicyChunk |
| Type | Container | Partition key | Identifier pattern | Embedding fields |
|---|---|---|---|---|
StudentRecord |
studentSupportCases |
/tenantId + /studentId |
student::{studentId} |
None |
DegreeRequirement |
studentSupportCases |
/tenantId + /studentId |
student::{studentId}::requirement::{requirementGroupCode}::{requirementCode} |
None |
PolicyChunk |
academicCatalogLibrary |
/tenantId + /catalogYear |
catalog::{catalogYear}::policy::{policyDocId}::{chunkOrdinal} |
chunkVector |
AdvisingInteraction |
studentSupportCases |
/tenantId + /studentId |
student::{studentId}::interaction::{interactionTimestampUtc}::{interactionId} |
None |
InterventionPlan |
studentSupportCases |
/tenantId + /studentId |
student::{studentId}::plan::{planId} |
rationaleVector |
List students on the advisor's caseload whose standing or holds indicate immediate outreach. Application-side partition-key fan-out advisor worklist: bounded by the tenantId prefix, one advisor's assignment and the at-risk academic standings.
studentSupportCases
partition-key-fan-out
SELECT * FROM c WHERE c.tenantId = @tenantId AND c.type = 'StudentRecord' AND c.assignedAdvisorUpn = @advisorUpn AND c.academicStanding IN ('probation','warning') AND c.enrollmentStatus = 'enrolled' ORDER BY c.cumulativeGpa ASC
Show which requirement groups still block graduation for the student's catalog year.
studentSupportCases
single-partition
SELECT * FROM c WHERE c.tenantId = @tenantId AND c.studentId = @studentId AND c.type = 'DegreeRequirement' AND c.satisfactionState IN ('unsatisfied','partial') ORDER BY c.requirementGroupCode ASC
Retrieve only the policy text governing this student's catalog year and question.
academicCatalogLibrary
single-partition
SELECT * FROM c WHERE c.tenantId = @tenantId AND c.catalogYear = @catalogYear AND c.type = 'PolicyChunk' AND c.policyCategory = @policyCategory ORDER BY RANK RRF(VectorDistance(c.chunkVector, @queryVector), FullTextScore(c.chunkText, @queryTerms))
Return the cited advising history when a case transfers to another advisor or an appeal is filed.
studentSupportCases
single-partition
SELECT * FROM c WHERE c.tenantId = @tenantId AND c.studentId = @studentId AND c.type = 'AdvisingInteraction' AND c.interactionTimestampUtc >= @termStartUtc ORDER BY c.interactionTimestampUtc DESC