Optima

Children reports

Where the legacy Active, New, Closed and Eligibility children reports went

Each legacy report in the Active Children, New Children, Closed Children and Eligibility menu sections is now a view of one of seven Optima reports. The tables below say which report to open and what to set.

  • Date range is the report's date filter.
  • Children is the switch above the results (All active, With a volunteer, Without a volunteer, Unassigned, …).
  • Preset is a column layout in the View menu.
  • Group is the grouping switcher.
  • Picker is a filter in the toolbar (Supervisor, Eligible status, County, Jurisdiction under Advanced).
  • 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 seven reports

Optima reportWhat it listsReplaces
Active Childrenchildren in the program at some point in the date range, one row eachActive Children, the Eligibility section's active-children reports, the placement counts
New Childrenchildren accepted into the program during the date rangeNew Children
Closed Childrenchildren whose program involvement closed during the date rangeClosed Children
Re-Opened Childrenchildren re-accepted during the date range after an earlier closureRe-Opened Children
Child Birthdaysactive children by birth month, as of todayChild Birthdays
Children - Data Checksone row per child per failed data check (22 checks)the child-shaped Exception Reports
Child Factorsone row per child and factor (disability, need)Child Factors

Three things apply everywhere:

  • County and Jurisdiction variants of a legacy report are the same report with the County or Jurisdiction picker set (under Advanced), or grouped By County / By Jurisdiction where legacy grouped.
  • By Supervisor lists a child under the supervisor assigned to the case in the range; a child whose supervisor has since been discharged still shows under that supervisor (legacy dropped them).
  • Eligibility variants ("by Eligible Status") are the same report with the Eligible status picker set, or grouped By Eligible Status.

Active Children

Legacy reportOpens withNotes
Active - All AlphabeticalChildren: All · Preset: Roster · Group: noneor group By County / By Jurisdiction for those variants
Active - by Staff AttorneyChildren: All · Preset: Roster · Group: By Staff Attorney
Active - by SupervisorChildren: All · Preset: Roster · Group: By SupervisorCounty / Jurisdiction picker for those variants
Active - by Supervisor with Peer CoordinatorChildren: All · Preset: Roster · Group: By Peer Coordinator
Active - with Assigned Volunteer - by SupervisorChildren: With a volunteer · Preset: With volunteer & tenure · Group: By SupervisorCounty / Jurisdiction picker for those variants
Active - with Assigned Volunteer by Staff AttorneyChildren: With a volunteer · Preset: With volunteer & tenure · Group: By Staff Attorney
Active - with No VolunteerChildren: Without a volunteer · Preset: No volunteer · Group: noneor group By County / By Jurisdiction for those variants
Active - with No Volunteer by Staff AttorneyChildren: Without a volunteer · Preset: No volunteer · Group: By Staff Attorney
Active - with No Volunteer - by SupervisorChildren: Without a volunteer · Preset: No volunteer · Group: By Supervisor
Active - UnassignedDate range: today · Children: Unassigned · Preset: Unassigned · Group: none
Child Demographics (Active)Children: All · Preset: Demographics · Group: noneor group By County / By Jurisdiction for those variants
Child Demographics - with Assigned VolunteerChildren: With a volunteer · Preset: Demographics · Group: noneor group By County / By Jurisdiction for those variants
Child StatusChildren: All · Preset: Child status · Group: noneor group By County / By Jurisdiction for those variants
Removal Zip CodeChildren: All · Preset: Removal zip · Group: By Residency Ziplegacy's zip pick list = filter Residency Zip: Is any of
Active Children - by Eligible StatusChildren: All · Preset: Eligibility · Group: By Eligible StatusCounty / Jurisdiction variants: group By County / By Jurisdiction and set the Eligible status picker
Active Children - by Eligible Status - by SupervisorChildren: All · Preset: Eligibility · Group: By SupervisorEligible status picker
All Children - Unassigned by Eligible StatusDate range: today · Children: Unassigned · Preset: Unassigned · Group: noneEligible status picker
Child Demographics - Active - by Eligible StatusChildren: All · Preset: Eligibility · Group: By Eligible StatusCounty / Jurisdiction variants: group By County / By Jurisdiction and set the Eligible status picker
Active Children - Current Placements - by SupervisorDate range: today · Children: All · Preset: Current placement · Group: By Supervisorthe Placements report's Contact sheet is the fuller version
Active Children - # PlacementsChildren: All · Preset: Placement counts · Group: noneCounty / Jurisdiction picker for those variants; Placements in range and Placements total are legacy's two counts

New Children

Legacy reportOpens withNotes
New ChildrenChildren: All · Preset: New children · Group: noneor group By County / By Jurisdiction for those variants
New Children - by SupervisorChildren: All · Preset: New children · Group: By SupervisorCounty / Jurisdiction variants: group By County / By Jurisdiction
New Children - with Assigned VolunteerChildren: With a volunteer · Preset: New children · Group: none
Child Demographics (New)Children: All · Preset: Demographics · Group: noneor group By County / By Jurisdiction for those variants
New Children - by Eligible Status - by SupervisorChildren: All · Preset: New children · Group: By SupervisorEligible status picker; County / Jurisdiction picker for those variants
Child Demographics - New - by Eligible StatusChildren: All · Preset: Demographics · Group: noneEligible status picker; County / Jurisdiction picker for those variants

Closed Children

Legacy reportOpens withNotes
Closed ChildrenChildren: All · Preset: Closed · Group: noneor group By County / By Jurisdiction for those variants
Closed Children - by SupervisorChildren: All · Preset: Closed · Group: By SupervisorCounty / Jurisdiction variants: group By County / By Jurisdiction
Closed Children - with Assigned VolunteerChildren: With a volunteer · Preset: Closed · Group: noneor group By County / By Jurisdiction for those variants
Closed Children - with Petition Date - by SupervisorChildren: All · Preset: Closed + petition · Group: By Closing SupervisorCounty / Jurisdiction variants: group By County / By Jurisdiction
Child Demographics (Closed)Children: All · Preset: Demographics · Group: noneor group By County / By Jurisdiction for those variants
Final Placement TypeChildren: All · Preset: Final placement · Group: By Final Placementevery closed child is listed, with or without a final placement; County / Jurisdiction variants: group By County / By Jurisdiction
Closed Children - by Eligible StatusChildren: All · Preset: Closed · Group: By Closing SupervisorEligible status picker; County / Jurisdiction picker for those variants
Child Demographics - Closed - by Eligible StatusChildren: All · Preset: Demographics · Group: By CaseEligible status picker; County / Jurisdiction picker for those variants

Re-Opened Children

Legacy reportOpens withNotes
Re-Opened ChildrenChildren: All · Preset: Re-opened · Group: none

Child Birthdays

Legacy reportOpens withNotes
Child Birthdays - by SupervisorPreset: Birthdays · Group: By SupervisorBirth month unset = the whole year; County / Jurisdiction picker for those variants
Child Birthdays - by Supervisor - by MonthPreset: Birthday mailing · Group: By Supervisorpick the Birth month; County / Jurisdiction picker for those variants

Child Factors

Legacy reportOpens withNotes
Child FactorsPreset: Factors · Group: By Factora child with two factors is two rows; County / Jurisdiction picker for those variants
Child Factors - by SupervisorPreset: Factors · Group: By SupervisorCounty / Jurisdiction picker for those variants

Children - Data Checks

One row per child per failed check, opening grouped By Check; All checks lists every check the child fails. Legacy ran each check as its own report; here each is the same report with a column filter on Data check. The "as of today" checks are the date range set to today; the others use the date range as legacy did. Every check is evaluated on whichever children are in range, so a check that legacy only ran on open children also works on the closed population.

Legacy reportOpens withNotes
Open Children - Missing Assigned to Program Date - by SupervisorDate range: today · Children: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No assigned-to-program date
Active Children - Missing Birthdate - by SupervisorDate range: today · Children: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No birthdate
Active Children - Missing Race - by SupervisorDate range: today · Children: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No race
Active Children - Missing EligibilityDate range: today · Children: Active in range · Preset: Data checks · Group: none · Filter data check = No eligibility statuslegacy asked for particular statuses; here: no eligibility status at all
Active Children - Missing Placement RecordDate range: today · Children: Active in range · Preset: Data checks · Group: none · Filter data check = No open placement
Active Children - Missing Referral DateChildren: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No referral date
Active Children - Missing Referral ReasonChildren: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No referral reason
Active Children - Missing Removal DateChildren: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No removal date
Active Children - Missing Zip CodeDate range: today · Children: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No residency zip
Active Children - No County - by SupervisorDate range: today · Children: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No residency county
Active Children - No GeolocationDate range: today · Children: Active in range · Preset: Data checks · Group: none · Filter data check = No geolocation
Active Children - No ID NumberChildren: Active in range · Preset: Data checks · Group: none · Filter data check = No ID number
Active Children - No Child StatusChildren: Active in range · Preset: Data checks · Group: none · Filter data check = No child status
Active Children - No Permanent PlanChildren: Active in range · Preset: Data checks · Group: none · Filter data check = No permanent plan
Active Children - No School HistoryChildren: Active in range · Preset: Data checks · Group: none · Filter data check = No school history
Active Children - No AssessmentChildren: Active in range · Preset: Data checks · Group: none · Filter data check = No assessment in rangelegacy picked one assessment type and an age band; here: no assessment of any type dated in the range
Active Children - No Petition - by SupervisorChildren: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No petition
Active Children - No Petition Type - by SupervisorChildren: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = Petition without case type
Active Children - No Petition AllegationDate range: today · Children: Active in range · Preset: Data checks · Group: none · Filter data check = Open petition without allegation
Active Children - with Closed Petitions - by SupervisorDate range: today · Children: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = All petitions closed
Total Children Summary - UnservedChildren: Active in range · Preset: Data checks · Group: none · Filter data check = Unservedalso the Total Children Summary's Unserved drill-through
Closed Children - Missing Final PlacementChildren: Closed in range · Preset: Data checks · Group: none · Filter data check = No final placementlegacy listed only children who had a volunteer: filter Volunteer is not empty

Not in these reports

Legacy reportWhere it is going
First Volunteer Assignment; Parental Concernsnot migrating (negligible use)
Assigned Supervisor (Paid Staff / Non-Paid Staff) and Assigned Staff Attorney - with No Assigned Childthe data review dashboard, not the reports
Assessment Scores (Wellbeing Assessments)later

On this page