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 report | What it lists | Replaces |
|---|---|---|
| Active Children | children in the program at some point in the date range, one row each | Active Children, the Eligibility section's active-children reports, the placement counts |
| New Children | children accepted into the program during the date range | New Children |
| Closed Children | children whose program involvement closed during the date range | Closed Children |
| Re-Opened Children | children re-accepted during the date range after an earlier closure | Re-Opened Children |
| Child Birthdays | active children by birth month, as of today | Child Birthdays |
| Children - Data Checks | one row per child per failed data check (22 checks) | the child-shaped Exception Reports |
| Child Factors | one 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 report | Opens with | Notes |
|---|---|---|
| Active - All Alphabetical | Children: All · Preset: Roster · Group: none | or group By County / By Jurisdiction for those variants |
| Active - by Staff Attorney | Children: All · Preset: Roster · Group: By Staff Attorney | |
| Active - by Supervisor | Children: All · Preset: Roster · Group: By Supervisor | County / Jurisdiction picker for those variants |
| Active - by Supervisor with Peer Coordinator | Children: All · Preset: Roster · Group: By Peer Coordinator | |
| Active - with Assigned Volunteer - by Supervisor | Children: With a volunteer · Preset: With volunteer & tenure · Group: By Supervisor | County / Jurisdiction picker for those variants |
| Active - with Assigned Volunteer by Staff Attorney | Children: With a volunteer · Preset: With volunteer & tenure · Group: By Staff Attorney | |
| Active - with No Volunteer | Children: Without a volunteer · Preset: No volunteer · Group: none | or group By County / By Jurisdiction for those variants |
| Active - with No Volunteer by Staff Attorney | Children: Without a volunteer · Preset: No volunteer · Group: By Staff Attorney | |
| Active - with No Volunteer - by Supervisor | Children: Without a volunteer · Preset: No volunteer · Group: By Supervisor | |
| Active - Unassigned | Date range: today · Children: Unassigned · Preset: Unassigned · Group: none | |
| Child Demographics (Active) | Children: All · Preset: Demographics · Group: none | or group By County / By Jurisdiction for those variants |
| Child Demographics - with Assigned Volunteer | Children: With a volunteer · Preset: Demographics · Group: none | or group By County / By Jurisdiction for those variants |
| Child Status | Children: All · Preset: Child status · Group: none | or group By County / By Jurisdiction for those variants |
| Removal Zip Code | Children: All · Preset: Removal zip · Group: By Residency Zip | legacy's zip pick list = filter Residency Zip: Is any of |
| Active Children - by Eligible Status | Children: All · Preset: Eligibility · Group: By Eligible Status | County / Jurisdiction variants: group By County / By Jurisdiction and set the Eligible status picker |
| Active Children - by Eligible Status - by Supervisor | Children: All · Preset: Eligibility · Group: By Supervisor | Eligible status picker |
| All Children - Unassigned by Eligible Status | Date range: today · Children: Unassigned · Preset: Unassigned · Group: none | Eligible status picker |
| Child Demographics - Active - by Eligible Status | Children: All · Preset: Eligibility · Group: By Eligible Status | County / Jurisdiction variants: group By County / By Jurisdiction and set the Eligible status picker |
| Active Children - Current Placements - by Supervisor | Date range: today · Children: All · Preset: Current placement · Group: By Supervisor | the Placements report's Contact sheet is the fuller version |
| Active Children - # Placements | Children: All · Preset: Placement counts · Group: none | County / Jurisdiction picker for those variants; Placements in range and Placements total are legacy's two counts |
New Children
| Legacy report | Opens with | Notes |
|---|---|---|
| New Children | Children: All · Preset: New children · Group: none | or group By County / By Jurisdiction for those variants |
| New Children - by Supervisor | Children: All · Preset: New children · Group: By Supervisor | County / Jurisdiction variants: group By County / By Jurisdiction |
| New Children - with Assigned Volunteer | Children: With a volunteer · Preset: New children · Group: none | |
| Child Demographics (New) | Children: All · Preset: Demographics · Group: none | or group By County / By Jurisdiction for those variants |
| New Children - by Eligible Status - by Supervisor | Children: All · Preset: New children · Group: By Supervisor | Eligible status picker; County / Jurisdiction picker for those variants |
| Child Demographics - New - by Eligible Status | Children: All · Preset: Demographics · Group: none | Eligible status picker; County / Jurisdiction picker for those variants |
Closed Children
| Legacy report | Opens with | Notes |
|---|---|---|
| Closed Children | Children: All · Preset: Closed · Group: none | or group By County / By Jurisdiction for those variants |
| Closed Children - by Supervisor | Children: All · Preset: Closed · Group: By Supervisor | County / Jurisdiction variants: group By County / By Jurisdiction |
| Closed Children - with Assigned Volunteer | Children: With a volunteer · Preset: Closed · Group: none | or group By County / By Jurisdiction for those variants |
| Closed Children - with Petition Date - by Supervisor | Children: All · Preset: Closed + petition · Group: By Closing Supervisor | County / Jurisdiction variants: group By County / By Jurisdiction |
| Child Demographics (Closed) | Children: All · Preset: Demographics · Group: none | or group By County / By Jurisdiction for those variants |
| Final Placement Type | Children: All · Preset: Final placement · Group: By Final Placement | every closed child is listed, with or without a final placement; County / Jurisdiction variants: group By County / By Jurisdiction |
| Closed Children - by Eligible Status | Children: All · Preset: Closed · Group: By Closing Supervisor | Eligible status picker; County / Jurisdiction picker for those variants |
| Child Demographics - Closed - by Eligible Status | Children: All · Preset: Demographics · Group: By Case | Eligible status picker; County / Jurisdiction picker for those variants |
Re-Opened Children
| Legacy report | Opens with | Notes |
|---|---|---|
| Re-Opened Children | Children: All · Preset: Re-opened · Group: none |
Child Birthdays
| Legacy report | Opens with | Notes |
|---|---|---|
| Child Birthdays - by Supervisor | Preset: Birthdays · Group: By Supervisor | Birth month unset = the whole year; County / Jurisdiction picker for those variants |
| Child Birthdays - by Supervisor - by Month | Preset: Birthday mailing · Group: By Supervisor | pick the Birth month; County / Jurisdiction picker for those variants |
Child Factors
| Legacy report | Opens with | Notes |
|---|---|---|
| Child Factors | Preset: Factors · Group: By Factor | a child with two factors is two rows; County / Jurisdiction picker for those variants |
| Child Factors - by Supervisor | Preset: Factors · Group: By Supervisor | County / 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 report | Opens with | Notes |
|---|---|---|
| Open Children - Missing Assigned to Program Date - by Supervisor | Date 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 Supervisor | Date range: today · Children: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No birthdate | |
| Active Children - Missing Race - by Supervisor | Date range: today · Children: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No race | |
| Active Children - Missing Eligibility | Date range: today · Children: Active in range · Preset: Data checks · Group: none · Filter data check = No eligibility status | legacy asked for particular statuses; here: no eligibility status at all |
| Active Children - Missing Placement Record | Date range: today · Children: Active in range · Preset: Data checks · Group: none · Filter data check = No open placement | |
| Active Children - Missing Referral Date | Children: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No referral date | |
| Active Children - Missing Referral Reason | Children: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No referral reason | |
| Active Children - Missing Removal Date | Children: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No removal date | |
| Active Children - Missing Zip Code | Date range: today · Children: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No residency zip | |
| Active Children - No County - by Supervisor | Date range: today · Children: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No residency county | |
| Active Children - No Geolocation | Date range: today · Children: Active in range · Preset: Data checks · Group: none · Filter data check = No geolocation | |
| Active Children - No ID Number | Children: Active in range · Preset: Data checks · Group: none · Filter data check = No ID number | |
| Active Children - No Child Status | Children: Active in range · Preset: Data checks · Group: none · Filter data check = No child status | |
| Active Children - No Permanent Plan | Children: Active in range · Preset: Data checks · Group: none · Filter data check = No permanent plan | |
| Active Children - No School History | Children: Active in range · Preset: Data checks · Group: none · Filter data check = No school history | |
| Active Children - No Assessment | Children: Active in range · Preset: Data checks · Group: none · Filter data check = No assessment in range | legacy picked one assessment type and an age band; here: no assessment of any type dated in the range |
| Active Children - No Petition - by Supervisor | Children: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = No petition | |
| Active Children - No Petition Type - by Supervisor | Children: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = Petition without case type | |
| Active Children - No Petition Allegation | Date range: today · Children: Active in range · Preset: Data checks · Group: none · Filter data check = Open petition without allegation | |
| Active Children - with Closed Petitions - by Supervisor | Date range: today · Children: Active in range · Preset: Data checks · Group: By Supervisor · Filter data check = All petitions closed | |
| Total Children Summary - Unserved | Children: Active in range · Preset: Data checks · Group: none · Filter data check = Unserved | also the Total Children Summary's Unserved drill-through |
| Closed Children - Missing Final Placement | Children: Closed in range · Preset: Data checks · Group: none · Filter data check = No final placement | legacy listed only children who had a volunteer: filter Volunteer is not empty |
Not in these reports
| Legacy report | Where it is going |
|---|---|
| First Volunteer Assignment; Parental Concerns | not migrating (negligible use) |
| Assigned Supervisor (Paid Staff / Non-Paid Staff) and Assigned Staff Attorney - with No Assigned Child | the data review dashboard, not the reports |
| Assessment Scores (Wellbeing Assessments) | later |