Volunteer reports
Where the legacy Active, Assigned, New and Discharged Volunteers reports went
Each legacy report in the Active / Assigned / New / Discharged Volunteers, Training and Mileage/Expenses/Hours menu sections is now a view of one of the Optima volunteer reports. The tables below say which report to open and what to set.
- Date range is the report's date filter.
- Show is the switch above the results.
- Preset is a column layout in the View menu.
- Group is the grouping switcher.
- Filter is a column filter, set from the column header's menu.
- Every legacy report name is a link that opens the Optima report with those settings already applied.
The reports
| Optima report | What it lists | Replaces |
|---|---|---|
| Active Volunteers | volunteers on the books at some point in the date range (sworn by the end of it, not discharged before it started), one row each | Active Volunteers (all but Birthday / Anniversary) and the Assigned Volunteers demographics |
| New Volunteers | volunteers sworn in during the date range | New Volunteers |
| Discharged Volunteers | volunteers discharged during the date range | Discharged Volunteers |
| Volunteer Birthdays | active volunteers by birth month, as of today | Birthday by Month |
| Volunteer Anniversaries | active volunteers by sworn month, as of today | Anniversary by Month |
| Volunteer Assignments | volunteers' case assignments, one row per volunteer and case or per volunteer and child | Assigned Volunteers (Caseload, New Assignments, the supervisor's Roster) |
| Training | training activities completed in the date range, one row each | In-Service Training, by Supervisor, Un-Approved |
| Volunteer Hours | hours, mileage and expenses summed over the date range, one row per volunteer and case plus Training and Non-case rows | Volunteer Case Hours, Volunteer Total Hours |
| Non-Case Hours | non-case activities in the date range, one row each | Volunteer Non-Case Hours |
| Mileage and Expenses | activities with mileage or expenses in the date range, one row each | Volunteer Mileage/Expenses, Supervisor Hours/Mileage/Expenses |
| Volunteers - Data Checks | volunteers failing a data check, one row per check | the volunteer Exception Reports and No In-Service Training |
Three things apply everywhere:
- Reports that were "as of today". Legacy reports with no date parameters (Available, Contact Information, Background Check, Email) were snapshots as of today. Set the date range to end today (the start date can be any earlier date) and you get the same snapshot.
- By Supervisor. Every legacy "by Supervisor" volunteer report grouped on the volunteer's administrative supervisor, the staff member on the volunteer's record, not the supervisor of a case. That is the By Supervisor grouping; a volunteer with none shows under Not Assigned. By Case Supervisor groups on the supervisors of the cases the volunteer is assigned to instead.
- County and Jurisdiction variants of a legacy report are the same report with the County or Jurisdiction picker set (under Advanced filters).
Active Volunteers
| Legacy report | Opens with | Notes |
|---|---|---|
| All Alphabetical | Show: All · Preset: Roster · Group: By Supervisor | or no grouping for the plain list; Volunteer type: filter the Volunteer type column (Is any of), legacy's type picker |
| All Alphabetical by County | Show: All · Preset: Roster · Group: By County | or the County picker |
| All Alphabetical by Jurisdiction | Show: All · Preset: Roster · Group: By Jurisdiction | or the Jurisdiction picker |
| Volunteer Demographics - by Supervisor (Active) | Show: All · Preset: Demographics · Group: By Supervisor | Jurisdiction picker for the Jurisdiction variant |
| Volunteer Demographics (Assigned) | Show: Assigned in range · Preset: Demographics · Group: none | |
| Volunteer Demographics - by Supervisor (Assigned) | Show: Assigned in range · Preset: Demographics · Group: By Case Supervisor | legacy listed a volunteer once per case supervisor; here once, with the supervisors as a list |
| Available - Alphabetical | Date range: today · Show: Available · Preset: Availability · Group: none | |
| Available - Alphabetical - Unassigned | Date range: today · Show: Available, unassigned · Preset: Availability · Group: none | |
| Available - by Supervisor | Date range: today · Show: Available · Preset: Availability · Group: By Supervisor | Supervisor picker to pick some |
| Availability - Unavailable - Unassigned | Date range: today · Show: Unavailable, unassigned · Preset: Availability · Group: none | |
| Availability - Returning From Leave | Show: Returning from leave in range · Preset: Availability · Group: By Supervisor | the date range is when the leave ends |
| Contact Information | Date range: today · Show: All · Preset: Contact info · Group: none | Volunteer type filter for legacy's type picker |
| Contact Information - Best Email/Phone | Date range: today · Show: All · Preset: Best contact · Group: none | |
| Contact Information - Updates | Show: All · Preset: Contact info · Group: none | filter Contact info mod date: Is between the dates you want |
| Emergency Contact Info - Updates | Show: All · Preset: Screening · Group: none | filter Emergency contact mod date: Is between |
| Last Background Check | Date range: today · Show: All · Preset: Screening · Group: none | |
| Volunteer - Certifications | Show: All · Preset: Certifications · Group: none | filter Certifications: Is any of (legacy's certification picker); one row per volunteer with every certification listed |
| Volunteer Email | Date range: today · Show: All · Preset: Best contact · Group: none |
All Alphabetical printed four header totals (discharged, sworn, assigned and available in the range). Group By Supervisor for the volunteer subtotals; the assigned and available counts are the totals of the Assigned in range and Available Show options.
New Volunteers
| Legacy report | Opens with | Notes |
|---|---|---|
| First Assignments | Preset: First assignments · Group: By Supervisor | the date range is the sworn-in window; First assigned date and First case are the first assignment ever |
| Volunteer Demographics - by Supervisor (New) | Preset: Demographics · Group: By Supervisor | Jurisdiction picker for the Jurisdiction variant |
| Volunteer Preferences - by Sworn Date | Preset: Preferences · Group: none |
Discharged Volunteers
| Legacy report | Opens with | Notes |
|---|---|---|
| Contact Information (Discharged) | Preset: Contact info · Group: By Supervisor | the date range is the discharge window |
| Volunteer Demographics (Discharged) | Preset: Demographics · Group: By Discharge Reason | Jurisdiction picker for the Jurisdiction variant |
Volunteer Birthdays
| Legacy report | Opens with | Notes |
|---|---|---|
| Birthday by Month - by Supervisor | Preset: Birthday mailing · Group: By Supervisor | pick the Birth month, or leave it unset for the whole year |
Volunteer Anniversaries
| Legacy report | Opens with | Notes |
|---|---|---|
| Anniversary by Month - by Supervisor | Preset: Anniversary mailing · Group: By Supervisor | pick the Sworn month |
Volunteer Assignments
"Supervisor" on this report is the case supervisor, the supervisor assigned to the same case, which is what all three legacy reports used. The volunteer's administrative supervisor (the Supervisor column and By Supervisor grouping on the other volunteer reports) is not on this one. The Case supervisor picker narrows to one; By Case Supervisor groups by it.
| Legacy report | Opens with | Notes |
|---|---|---|
| Caseload - by Supervisor | Rows: One per case · Assignments: Open in range · Preset: Caseload · Group: By Case Supervisor | Case supervisor picker to pick some; Children on case is legacy's kid count |
| Volunteer New Assignments - by Date | Rows: One per child · Assignments: Started in range · Preset: New assignments · Group: none | the date range is when the assignment started |
| Contact Information - by Supervisor by Case | Rows: One per child · Assignments: Current · Preset: Roster · Group: By Case Supervisor | every open child with a current supervisor, with or without a volunteer, as in legacy |
| Assigned Volunteer - with No Assigned Child | Date range: today · Rows: One per case · Assignments: Current · Preset: Caseload · Group: By Case Supervisor · Filter children on case = 0 | an Exception Report: also going to the data review dashboard |
Training
One row per training activity completed in the date range. Legacy called these In-Service Training, but they listed every training activity whatever its type, and so does this. Status is the switch above the results: Approved (default), Pending (the Un-Approved queue, which lists every pending row whatever the date range) or All. By Supervisor groups on the volunteer's administrative supervisor with hours totals, as the legacy by-Supervisor report did.
| Legacy report | Opens with | Notes |
|---|---|---|
| In-Service Training | Status: Approved · Preset: Training · Group: By Volunteer | the County variant is the County picker (under Advanced) |
| In-Service Training - by Supervisor | Status: Approved · Preset: Training · Group: By Supervisor | legacy's supervisor pick list = the Supervisor picker; hours total per supervisor |
| Un-Approved In-Service Training | Status: Pending · Preset: Pending · Group: By Volunteer | the date range does not apply to Pending: every pending row lists, as in legacy |
Volunteer Hours
The roll-up: hours, mileage and expenses summed over the date range, one row per volunteer and case, plus one Training row and one Non-case row per volunteer. Source is the switch above the results: All activity (the legacy Total Hours) or Case activity (Case Hours). Volunteers only, not paid staff. Legacy's Case Hours printed supervisor and volunteer subtotals together; here By Supervisor gives the supervisor totals with each row carrying the volunteer's total for the range, and By Supervisor and Volunteer groups on both. Contact Logs has the log-by-log detail.
| Legacy report | Opens with | Notes |
|---|---|---|
| Volunteer Total Hours | Source: All activity · Preset: Hours · Group: By Volunteer | the By Volunteer subtotal is legacy's one figure per volunteer |
| Volunteer Case Hours | Source: Case activity · Preset: Hours · Group: By Supervisor | one row per volunteer and case, as legacy; the supervisor total is the group subtotal and each row carries the volunteer's total for the range (By Supervisor and Volunteer groups on both). The County and Jurisdiction variants are the County / Jurisdiction pickers (of the case, under Advanced) |
Non-Case Hours
One row per non-case activity (fundraising, board meetings, recruiting events, office help …) in the date range, with the notes.
| Legacy report | Opens with | Notes |
|---|---|---|
| Volunteer Non-Case Hours | Preset: Non-case hours · Group: By Volunteer | |
| Volunteer Non-Case Hours - by Volunteer Type | Preset: Non-case hours · Group: By Volunteer Type | legacy's volunteer-type pick list = filter Volunteer type: Is any of |
Mileage and Expenses
One row per activity in the date range that carries mileage or expenses, from approved case logs, approved training and non-case activity. Logged by is the switch above the results: Volunteers (default) or Supervisors, which lists paid-staff supervisors' own case logs and training with hours, under the legacy supervisor report's rules (any status, every log with a mileage figure).
| Legacy report | Opens with | Notes |
|---|---|---|
| Volunteer Mileage/Expenses - by Supervisor | Logged by: Volunteers · Preset: Mileage and expenses · Group: By Supervisor | legacy's supervisor pick list = the Supervisor picker |
| Volunteer Mileage/Expenses - by Volunteer | Logged by: Volunteers · Preset: Mileage and expenses · Group: By Volunteer | legacy's supervisor then volunteer pick lists = the Volunteer picker |
| Supervisor Hours/Mileage/Expenses | Logged by: Supervisors · Preset: Supervisor time · Group: By Volunteer |
Volunteers - Data Checks
One row per volunteer per failed check, opening grouped By Check; All checks lists every check the volunteer fails. Legacy ran each check as its own report; here each is the same report with a column filter on Data check. The checks legacy ran on active volunteers are the date range set to today; the Volunteers switch also offers Inactive, for the discharge-date check.
| Legacy report | Opens with | Notes |
|---|---|---|
| Active Volunteers - Missing Sworn Date - by Supervisor | Date range: today · Volunteers: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No sworn date | |
| Active Volunteers - Missing Birthdate - by Supervisor | Date range: today · Volunteers: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No birthdate | |
| Active Volunteers - Missing County | Volunteers: Active in range · Preset: Data checks · Group: none · Filter data check = No county | legacy kept paid staff in; here volunteers only |
| Active Volunteers - Missing Education | Date range: today · Volunteers: Active in range · Preset: Data checks · Group: none · Filter data check = No education | |
| Active Volunteers - Missing Emergency Contact - by Supervisor | Date range: today · Volunteers: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No emergency contact | |
| Active Volunteers - Missing Employment | Volunteers: Active in range · Preset: Data checks · Group: none · Filter data check = No employment | |
| Active Volunteers - Missing Jurisdiction | Date range: today · Volunteers: Active in range · Preset: Data checks · Group: none · Filter data check = No jurisdiction | |
| Active Volunteers - Missing Race - by Supervisor | Date range: today · Volunteers: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No race | |
| Active Volunteers/Applicants - Missing Background Check | Date range: today · Volunteers: Active in range · Preset: Data checks · Group: none · Filter data check = No completed background check | legacy picked a check type and included applicants; here any completed check, volunteers only |
| Discharged Volunteers - Missing Discharge Date - by Supervisor | Date range: today · Volunteers: Inactive · Preset: Data checks · Group: By Supervisor · Filter data check = No discharge date | |
| No In-Service Training | Date range: the training period · Volunteers: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No training in range, Active = Yes | legacy listed volunteers active today; drop the Active filter to include those discharged since. Add best_email, best_phone and assigned_in_range for legacy's other columns |
Not in these reports
| Legacy report | Where it is going |
|---|---|
| Available - by Supervisor by Note Subject | needs a note-subject picker; later |
| Missing Document; Missing Note Subject | the data review dashboard, not the reports |
Columns you might look for
All of these are on every volunteer report; most are hidden until you turn them on in the View menu or pick a preset: type, status, administrative supervisor, case supervisors, available and available date, on-leave dates, assigned now, first and last assignment, last release, days since last case, years in service, months of service, cases and children served in the range, hours in the range, address and every phone and email, best email and phone, emergency contact, application date, initial training date, last background check, certifications, abuse and disability preferences, jurisdictions, languages, gender, age, race, education, employment, discharge reason.