- Before
- Finds unspent money only after the round, in funds whose application form never found the students the donor meant.
- Now
- Sees where donor money is sitting and who could receive it on one shelf, and records each award once the committee has voted.
One endowed scholarship fund, from gift agreement to donor report
The Ellery and June Harrow Endowed Scholarship at Halden State University, fund F-04172, on Wednesday, October 21, 2026, in the Spring 2027 round. Here is what happens to it, screen by screen, in the working solution.
- 01Morning
Every donor fund on one shelf
Constance Oyelaran · Director of ScholarshipsThe day opens on one number: $4,620,000 of restricted money left unspent in 311 of 1,480 funds in 2025–26, with $3,184,600 still to award this year in 214 funds. Each fund stands as a jar filled to what it still has to award, labeled with its restriction in plain words. The Harrow jar holds $84,300, labeled "rural county · nursing · first-generation preferred", with 46 eligible students against 7 last year.
$2.31 million of last year's unspent balance sat in 148 funds matched on form answers alone.
- 02One click
The gift agreement becomes the rule, cited
Restriction agentThe 2009 gift agreement opens with section 3(b) highlighted. The agent has read it into 7 criteria, each citing its clause (§3(a), §3(b), §3(c), §5) and the data source it is tested against, with confidence from 0.93 to 0.99. Nobody retypes the restriction into a form.
"Rural counties" is not defined, so the agent reuses interpretation IM-2024-07, signed by the Director and the associate general counsel: a home county with a USDA rural-urban continuum code of 4 to 9.
- 039:41 AM
46 eligible students, not 7
MatcherThe Matcher reads 1,284 nursing and pre-nursing students in the student information system: 1,106 are full-time undergraduates in good standing, 61 have a rural home county, and 46 are eligible. 29 are first-generation, 12 are pre-nursing, and 31 never ticked "rural" on last year's form. The 15 excluded each carry a reason: 6 have no FAFSA on file, 3 have no remaining need, 4 graduate in December and 2 are on leave for spring.
- 04Before the vote
Every match reason, cited to the clause and the record
MatcherMaren Kowalczyk ranks first: full-time in good standing, from Ostrand County (code 7), admitted to the BSN program, first-generation from FAFSA parent education, with $28,270 in need. Each line cites the gift agreement clause and the student or aid record. Her essay scores 4.6 of 5 on the nursing rubric, with the passage quoted.
"I want to be the nurse who stays."
- 05Oct 20, 3:41 PM
The committee votes in the open
School of Nursing scholarship committeeThe top 18 candidates went to the committee in one cited packet on Oct 16. The five members voted 12 awards totaling $83,650 of $84,300 spendable, 2 alternates and 4 not awarded, each with a reason. Prof. Walter Ng declared a conflict and recused himself from one candidate, and the Committee Clerk reconciled the tally to the fund's balance before the chair closed the vote.
- 069:52 AM
No award creates an overaward
Award Limit agentThe agent reads the 12 packages from the financial aid system. Talia Brennan's cost of attendance is $29,695 and her aid already totals $24,695, so the $6,150 the committee voted would put her $1,150 over. She has no loan or work-study to replace and Pell is never reduced, so the agent proposes trimming the award to $5,000. The other 11 awards fit.
Her Pell Grant is safe: non-federal grants of $21,700 stay below her cost of attendance.
- 0710:05 AM
Recorded by one person, confirmed by another
Constance Oyelaran · Director of ScholarshipsConstance accepts the trim and records the 12 awards, $82,500. She cannot confirm her own record: Darnell Fitch, the financial aid packaging counselor, confirms there is no overaward at 10:11 AM. Only then do the awards post to the financial aid system for spring 2027, and the 12 award letters go out.
- 08After posting
A donor report that respects consent
Stewardship agentThe agent drafts the mid-year report to Margaret Harrow Bell, the donors' designee: 12 nursing students from rural counties received $82,500. Ten signed a release and are named with their county and a line from their essay; two are described without a name. Luis Arrellano is the only recipient from Quillan County, so his county is replaced by "a rural county". Leah Marchetti, the advancement stewardship officer, signs it.
- 09Audit-ready
One export pack for the whole round
Beatrice Lund · Internal auditorThe pack for the Harrow fund's Spring 2027 round holds the 12 awards, 18 candidates and 90 votes, the 7 criteria with their clauses, the Award Limit checks, every recorder, confirmer and signer, the donor report versions and the consent records. Student IDs are masked and aid amounts are removed from donor sections.
- 10The result
The money reaches students
Constance OyelaranBack on the shelf, the Harrow jar holds $1,800 of $84,300, carried to the fall 2027 round, where $61,000 went unspent last year. The university's still-to-award total falls from $3,184,600 to $3,102,100.