- Before
- Reconciles police, residence life, Title IX and authority reports in a spreadsheet, and hopes every number survives a program review.
- Now
- Opens any number in the report into its reports, settles the agents' findings with a reason, and certifies each row in place.
One number in the annual security report, from 14 reports to a certified row
Tuesday, September 15, 2026, 9:40 a.m. Marcus Tellford, Clery Compliance Officer at Halden State University, has 16 days to publish. Here is how one number in the report is checked, changed and certified, screen by screen, in the working solution.
- 019:40 a.m.
The morning brief, written by the agents
Marcus Tellford · Clery Compliance Officer17 of 21 rows of the 2025 column are certified, 2,614 reports have been read for 2025 and one timely warning waits for the Chief. The brief explains what changed since last week, every line cited. The next decision is the burglary number: 14 now, 12 with the agents' two changes.
- 02One click
The annual security report table, as it will be published
Marcus TellfordOffenses run down the side, from murder to the new hazing row, with arrests and disciplinary referrals; on campus, residential, noncampus and public property run across the top, with 2023, 2024 and 2025 in each. A dot marks the cells that changed since September 8. The hazing row reads "n/a" for 2023 and 2024.
- 03One click
Burglary in residence halls, 2025, opens into its 14 reports
Marcus TellfordThe number unfolds in place: 11 police reports, 2 from residence life and one campus security authority form, each with its date, place and source. Beside the list sit two findings from the agents, each with its confidence, its citations and the choice to accept it or keep the count with a reason.
- 04Finding 1
One Larkspur Hall break-in, reported twice
Duplicate agentPolice report HSUPD-25-03117 and residence life report RL-25-0882 both describe room 412 of Larkspur Hall on March 8, 2025, with a laptop and a wallet taken. Residence life logged it at 11:05 p.m. and called the police at 11:07. The agent proposes counting it once, under the police report, at 0.97.
A merge never deletes a report: RL-25-0882 stays on file, linked to the police report.
- 05Finding 2
A chapter house is noncampus, not a residence hall
Geography agentHSUPD-25-05902, a window entry at 1418 Alder Row on September 6, 2025, was counted as residential because residence life lists the house as affiliated housing. The Clery geography register lists it as property 7, the Delta Kappa Rho chapter house, leased to a recognized student organization: noncampus. The agent cites the register entry at 0.95.
- 06Certified
The number now reads 12, and the row is certified
Marcus TellfordMarcus accepts both findings. Burglary in residence halls reads 12 with the old 14 struck through; on campus moves from 31 to 29 and noncampus from 3 to 4. He certifies the burglary row with an attestation, 18 of 21 rows, and it goes to Associate General Counsel Simone Achterberg for second review.
You certify; counsel second-reviews the whole report. You cannot second-review your own certification.
- 07Meanwhile, 9:02 a.m.
A timely warning drafted 31 minutes after the report
Warning agentA student was robbed at knifepoint at the University Parkway transit stop at 7:55 a.m., reported at 8:31. It is the third knife robbery in 10 days with a matching description, and the suspect is not in custody. The agent drafted a warning at 9:02, removed four details that could identify the victim, and gave its reasons with the police reports cited.
The agent never sends. Chief Dana Whitcombe issued it at 9:51 a.m. to 38,000 students and 9,400 employees.
- 08Due by Sep 17
The daily crime log, current within two business days
Crime Log agent1,312 of 1,312 entries in 2026 were made within two business days. One dating violence entry needs Marcus: the agent generalized a room in a house of 12 residents to "Residence hall, main campus", because the room would identify the victim. He approves the change and the records lieutenant posts the entry.
- 09Before October 1
Sign-off in five steps, with duties kept apart
Simone Achterberg · Associate General CounselThe officer certifies the statistics, the Report agent checks 46 of 47 required policy statements, the fire safety report is certified, counsel's second review opens September 21, and publication and notice follow by October 1. Send to counsel opens only when every row is certified.
- 10Program review
A published number traced to its reports
Graham Okafor-Lind · Internal auditorThe audit trail follows burglary, residential, 2025 from the published 12 to Marcus's certification, the 12 reports behind it (police 10, residence life 1, authority form 1), the two accepted changes and the agent versions and rule that produced them. The export pack is ready for a program reviewer.