Number of children and young people involved in concern reports.
| Distribution/Table | Path/Column |
| Child Protection Reporting - Base Data Asset | CHILDSTORY_ID |
| CONTACT_START_DATE |
Definition
A percentage of unique/individual children and young people involved in concern reports, divided by the population of individuals aged 0 -17.
Indicator Summary
Population of individuals aged 0-17
A percentage calculated by dividing the number of unique/individual children and young people involved in concern reports, by the population of individuals aged 0-17, during the reporting period, multiplied by 100.
By LGA and DCJ district
Demographic Breakdown
| Distribution/Table | Path/Column | Dashboard Filter Label |
| Child Protection Reporting - Base Data Asset | DITRICT_COMMON | District |
Reporting Information
Data is sourced from ChildStory/CIW (not from KiDS) - Published by the NSW Department of Family and Community Services - from financial year 2018 onwards.
Framework Dimensions
Calculation rules
- Computation
A percentage calculated by dividing the number of unique/individual children and young people involved in concern reports, by the population of individuals aged 0-17, during the reporting period, multiplied by 100.
Number of children and young people involved in concern reports.
| Distribution/Table | Path/Column |
| Child Protection Reporting - Base Data Asset | CHILDSTORY_ID |
| CONTACT_START_DATE |
-
- Data Element
- Person: ChildStory Identifier, A-N(8)
- Description
DISTINCT CHILDSTORY_ID
- Data Set
- Child Protection Data Set
-
- Data Element
- Service Event: Start Date, DateTime YYYY-MM-DD
- Description
Where CONTACT_START_DATE is derived from data in the Federated Analytics Platform, which is built on data from ChildStory/CIW, relevant to a particular ETL run date period:
FinancialYearReporting:
extract(MONTH from ETL_RUN_DT)=9
AND (contact_start_date between Date_SUB(DATE_SUB(Date(etl_run_dt), INTERVAL 1 YEAR), interval 2 MONTH) and DATE_SUB(DATE_SUB(DATE(ETL_RUN_DT), INTERVAL 2 MONTH), INTERVAL 1 DAY))- Guide for use
ETL_RUN date '9' is selected to ensure, with 2 months aging, that all submitted data for the financial year is included in the calculation - eg by selecting 9 (September), all records up to the end of June are included (ie all data between 1 July and 30 June)
- Data Set
- Child Protection Data Set
Population of individuals aged 0-17
By LGA and DCJ district
Demographic Breakdown
| Distribution/Table | Path/Column | Dashboard Filter Label |
| Child Protection Reporting - Base Data Asset | DITRICT_COMMON | District |
Comments
Data Source:
- Key Information and Directory System (KiDS)/Client Information Warehouse (CIW) for data before 2017-18.
- ChildStory/Minimum Data Set (MDS)/Corporate Information Warehouse (CIW) for data after 2017-18.
- ABS Estimated Resident Population, NSW at 30 June Preliminary (Catalogue 3101.0 Table 51)
Data limitations:
- The LGA is derived based on the postcode 2019 to LGA 2020 concordance sourced from the ABS. The postcode is based on the location at contact of the CYP when the ROSH reports were received in the Helpline during the year. A new postcode 2022 to LGA 2022 concordance from the ABS are currently being reviewed and will be applied from 2023-24 onwards.
Origin
Related content
| Relation | Count |
|---|---|
| Indicator Sets that include this Indicator | 0 |
| Data Sets that are used in this Indicator | 1 |