Optima

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 reportWhat it listsReplaces
Active Volunteersvolunteers on the books at some point in the date range (sworn by the end of it, not discharged before it started), one row eachActive Volunteers (all but Birthday / Anniversary) and the Assigned Volunteers demographics
New Volunteersvolunteers sworn in during the date rangeNew Volunteers
Discharged Volunteersvolunteers discharged during the date rangeDischarged Volunteers
Volunteer Birthdaysactive volunteers by birth month, as of todayBirthday by Month
Volunteer Anniversariesactive volunteers by sworn month, as of todayAnniversary by Month
Volunteer Assignmentsvolunteers' case assignments, one row per volunteer and case or per volunteer and childAssigned Volunteers (Caseload, New Assignments, the supervisor's Roster)
Trainingtraining activities completed in the date range, one row eachIn-Service Training, by Supervisor, Un-Approved
Volunteer Hourshours, mileage and expenses summed over the date range, one row per volunteer and case plus Training and Non-case rowsVolunteer Case Hours, Volunteer Total Hours
Non-Case Hoursnon-case activities in the date range, one row eachVolunteer Non-Case Hours
Mileage and Expensesactivities with mileage or expenses in the date range, one row eachVolunteer Mileage/Expenses, Supervisor Hours/Mileage/Expenses
Volunteers - Data Checksvolunteers failing a data check, one row per checkthe 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 reportOpens withNotes
All AlphabeticalShow: All · Preset: Roster · Group: By Supervisoror no grouping for the plain list; Volunteer type: filter the Volunteer type column (Is any of), legacy's type picker
All Alphabetical by CountyShow: All · Preset: Roster · Group: By Countyor the County picker
All Alphabetical by JurisdictionShow: All · Preset: Roster · Group: By Jurisdictionor the Jurisdiction picker
Volunteer Demographics - by Supervisor (Active)Show: All · Preset: Demographics · Group: By SupervisorJurisdiction 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 Supervisorlegacy listed a volunteer once per case supervisor; here once, with the supervisors as a list
Available - AlphabeticalDate range: today · Show: Available · Preset: Availability · Group: none
Available - Alphabetical - UnassignedDate range: today · Show: Available, unassigned · Preset: Availability · Group: none
Available - by SupervisorDate range: today · Show: Available · Preset: Availability · Group: By SupervisorSupervisor picker to pick some
Availability - Unavailable - UnassignedDate range: today · Show: Unavailable, unassigned · Preset: Availability · Group: none
Availability - Returning From LeaveShow: Returning from leave in range · Preset: Availability · Group: By Supervisorthe date range is when the leave ends
Contact InformationDate range: today · Show: All · Preset: Contact info · Group: noneVolunteer type filter for legacy's type picker
Contact Information - Best Email/PhoneDate range: today · Show: All · Preset: Best contact · Group: none
Contact Information - UpdatesShow: All · Preset: Contact info · Group: nonefilter Contact info mod date: Is between the dates you want
Emergency Contact Info - UpdatesShow: All · Preset: Screening · Group: nonefilter Emergency contact mod date: Is between
Last Background CheckDate range: today · Show: All · Preset: Screening · Group: none
Volunteer - CertificationsShow: All · Preset: Certifications · Group: nonefilter Certifications: Is any of (legacy's certification picker); one row per volunteer with every certification listed
Volunteer EmailDate 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 reportOpens withNotes
First AssignmentsPreset: First assignments · Group: By Supervisorthe 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 SupervisorJurisdiction picker for the Jurisdiction variant
Volunteer Preferences - by Sworn DatePreset: Preferences · Group: none

Discharged Volunteers

Legacy reportOpens withNotes
Contact Information (Discharged)Preset: Contact info · Group: By Supervisorthe date range is the discharge window
Volunteer Demographics (Discharged)Preset: Demographics · Group: By Discharge ReasonJurisdiction picker for the Jurisdiction variant

Volunteer Birthdays

Legacy reportOpens withNotes
Birthday by Month - by SupervisorPreset: Birthday mailing · Group: By Supervisorpick the Birth month, or leave it unset for the whole year

Volunteer Anniversaries

Legacy reportOpens withNotes
Anniversary by Month - by SupervisorPreset: Anniversary mailing · Group: By Supervisorpick 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 reportOpens withNotes
Caseload - by SupervisorRows: One per case · Assignments: Open in range · Preset: Caseload · Group: By Case SupervisorCase supervisor picker to pick some; Children on case is legacy's kid count
Volunteer New Assignments - by DateRows: One per child · Assignments: Started in range · Preset: New assignments · Group: nonethe date range is when the assignment started
Contact Information - by Supervisor by CaseRows: One per child · Assignments: Current · Preset: Roster · Group: By Case Supervisorevery open child with a current supervisor, with or without a volunteer, as in legacy
Assigned Volunteer - with No Assigned ChildDate range: today · Rows: One per case · Assignments: Current · Preset: Caseload · Group: By Case Supervisor · Filter children on case = 0an 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 reportOpens withNotes
In-Service TrainingStatus: Approved · Preset: Training · Group: By Volunteerthe County variant is the County picker (under Advanced)
In-Service Training - by SupervisorStatus: Approved · Preset: Training · Group: By Supervisorlegacy's supervisor pick list = the Supervisor picker; hours total per supervisor
Un-Approved In-Service TrainingStatus: Pending · Preset: Pending · Group: By Volunteerthe 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 reportOpens withNotes
Volunteer Total HoursSource: All activity · Preset: Hours · Group: By Volunteerthe By Volunteer subtotal is legacy's one figure per volunteer
Volunteer Case HoursSource: Case activity · Preset: Hours · Group: By Supervisorone 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 reportOpens withNotes
Volunteer Non-Case HoursPreset: Non-case hours · Group: By Volunteer
Volunteer Non-Case Hours - by Volunteer TypePreset: Non-case hours · Group: By Volunteer Typelegacy'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 reportOpens withNotes
Volunteer Mileage/Expenses - by SupervisorLogged by: Volunteers · Preset: Mileage and expenses · Group: By Supervisorlegacy's supervisor pick list = the Supervisor picker
Volunteer Mileage/Expenses - by VolunteerLogged by: Volunteers · Preset: Mileage and expenses · Group: By Volunteerlegacy's supervisor then volunteer pick lists = the Volunteer picker
Supervisor Hours/Mileage/ExpensesLogged 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 reportOpens withNotes
Active Volunteers - Missing Sworn Date - by SupervisorDate range: today · Volunteers: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No sworn date
Active Volunteers - Missing Birthdate - by SupervisorDate range: today · Volunteers: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No birthdate
Active Volunteers - Missing CountyVolunteers: Active in range · Preset: Data checks · Group: none · Filter data check = No countylegacy kept paid staff in; here volunteers only
Active Volunteers - Missing EducationDate range: today · Volunteers: Active in range · Preset: Data checks · Group: none · Filter data check = No education
Active Volunteers - Missing Emergency Contact - by SupervisorDate range: today · Volunteers: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No emergency contact
Active Volunteers - Missing EmploymentVolunteers: Active in range · Preset: Data checks · Group: none · Filter data check = No employment
Active Volunteers - Missing JurisdictionDate range: today · Volunteers: Active in range · Preset: Data checks · Group: none · Filter data check = No jurisdiction
Active Volunteers - Missing Race - by SupervisorDate range: today · Volunteers: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No race
Active Volunteers/Applicants - Missing Background CheckDate range: today · Volunteers: Active in range · Preset: Data checks · Group: none · Filter data check = No completed background checklegacy picked a check type and included applicants; here any completed check, volunteers only
Discharged Volunteers - Missing Discharge Date - by SupervisorDate range: today · Volunteers: Inactive · Preset: Data checks · Group: By Supervisor · Filter data check = No discharge date
No In-Service TrainingDate range: the training period · Volunteers: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No training in range, Active = Yeslegacy 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 reportWhere it is going
Available - by Supervisor by Note Subjectneeds a note-subject picker; later
Missing Document; Missing Note Subjectthe 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.

On this page