APPENDIX XI.xlsx

Report Description

Note: Due to differences in the refresh schedules between this report and the corresponding Child Welfare Dashboard titled "Children Entering Out-of-Home Care," there may be a period between the 10th and 15th of each month where the “draft” data for the most recent two months on the Child Welfare Dashboard does not match the corresponding data in this listing report.

Key Terms: "Out-of-Home Care" placements are safety and case management services provided to families whose children have temporarily been removed from the caregiver’s home. Only out-of-home care placements in a “valid removal episode” are included in this report. If one or more of the following data discrepancies are true, the removal episode is not considered valid: one or more placements have an end date that is prior to the placement begin date; more than one placement is flagged as the removal placement; no placement is flagged as the removal placement; more than one placement is flagged as the discharge placement; the same placement is duplicated; the discharge date predates the removal date; the removal date is a future date; one or more placements have a future date; one or more placements have a begin date where the placement begin date is in the year 1901 or prior; the removal date is in the year 1901 or prior; one or more placements overlap with another placement in the removal; one or more placements has a begin date prior to the removal date; one or more placements have a begin date subsequent to the discharge date; the removal has not be discharged, but the case has a case closure date subsequent to the removal date; the same removal episode for the child is found in more than one case; the removal date is on or after the child’s eighteenth birthday; or, the out-of-home care episode overlaps with an in-home service or a family support service episode.

"Race" is calculated based on the following logic: "Black/African-American" (a person documented in FSFN as Black/African-American only), "White" (a person documented in FSFN as White only), "Other/Multi-Racial" (a person documented in FSFN as American Indian/Alaskan Native, Asian, or Native Hawaiian/Other Pacific Islander, or a person who has multiple races documented in FSFN).

"Age" is calculated as of the child's removal date.

“Initial Removal Reasons” are used to document the conditions under which a child is removed from his/her home. A child may be removed for more than one initial removal reason. This report includes a flag (Y/N) for each of the 23 initial removal reasons associated with a removal episode.

Criteria: Select all entries into out-of-home care where the removal date falls in the report period. The child remained in out-of-home care for a total of at least 24 hours, and the removal was not discharged with a discharge reason of “Dismissed by Court” or with a placement ending reason of “Dismissed by Court,” the child is between the ages of 0 and 17 as of their entry into out-of-home care, the child has a gender and race documented as of when the data is extracted.

A child is counted in the region, circuit, Community-Based-Care (CBC) lead agency, and county based on the primary caseworker assigned to the child's case as of the date of entry into out-of-home care or, if no such worker is assigned, the first primary caseworker assigned to the child's case following their entry. All children are included in the statewide counts regardless of whether or not a primary caseworker is assigned.

Listing and Input Controls: The “Listing” tab provides a complete listing of children who enter out-of-home care during the report period when the source data is extracted. The “Listing” tab provides the following information: region, circuit, agency, county, unit, and the name of the assigned primary caseworker to the case (the primary caseworker assigned to the child's case as of the date of entry into out-of-home care or if no such worker is assigned, the first primary caseworker assigned to the child's case); case ID and case name associated with the removal episode; the child’s ID, last name, first name, date of birth, age as of the removal date, race, gender; date of removal and initial removal reasons; and, a flag to indicate whether or not the record is a Statewide Only Record.

You may customize your report by filtering data using the following Input Controls: Region(Multi-Select), Circuit (Multi-Select), Agency (Multi-Select), County (Multi-Select), Age (Dual Slider), Race (Multi-Select), Gender (Radio Buttons), and Statewide Only Record (Radio Buttons).

Multi-Select filters allow you to select any combination of the available values. To select more than one value, click one value and then, as you click on other values, hold the CTRL key on your keyboard. Once you have made your selections, click the OK Button next to that particular Input Control.

Radio Buttons allow you to select whether or not a particular characteristic does or does not exist for a record and the report will only display records which match your selection.

A dual slider allows you to pick a range of values and will return records whose information matches that range of values. The top slider is the maximum value and the bottom is the minimum value. The range of values is inclusive of both the maximum value and minimum value.

The maximum value you can select in Age Input Control is 18, which includes all young adults age 18 and over. The minimum value is -1, which includes records where age cannot be calculated (i.e., either missing data of birth or a data of birth that indicates a negative values in age).

If the Input Controls are not visible when you first open the report, please make sure the Side Panel is open. If it is not, click the Web Intelligence button in the upper left-hand corner and set the Side Panel option to either Normal or Minimized. Once the Side Panel is open, you should see a series of four icons on the left-hand side. Click on the third icon from the top to open the Input Controls panel.

6/10/2019: All data was re-run to include a small number of children who were only included in the statewide counts for whom region, circuit, agency, and county data can now be identified. Previously published data may no longer match.

7/10/2019: CBC of Central Florida has changed its name to Embrace Families. All data previously shown as CBC of Central Florida is now shown as Embrace Families.

A new provider, Citrus Health Network, is now serving the area previously served by Our Kids of Miami-Dade/Monroe, Inc. All data previously shown as Our Kids of Miami-Dade/Monroe, Inc is now shown as Citrus Health Network.

10/11/2019: All data was re-run and young adults up to the age of 22 in extended foster care are included. Previously published data may no longer match.

10/15/2019: Updated to include Report Period Begin Date and Report Period End Date prompts to allow user to select Report Period.

http://www.dcf.state.fl.us/programs/childwelfare/dashboard/c-entering-ooh.shtml Tables

Pivot