Number of Aboriginal children and young people involved in concern reports.
| Distribution/Table | Path/Column |
| Child Protection Reporting - Base Data Asset | CHILDSTORY_ID |
| CONTACT_START_DATE | |
| ABORIGINAL_STATUS_GROUPED |
Definition
A percentage of unique/individual Aboriginal children and young people involved in concern reports, divided by the total number of children and young people (CYP) reported to DCJ in concern reports.
Indicator Summary
Number of total children involved in concern reports
| Distribution/Table | Path/Column |
| Child Protection Reporting - Base Data Asset | CHILDSTORY_ID |
| CONTACT_START_DATE |
A percentage calculated by dividing the number of Aboriginal children and young people involved in concern reports, by the number of total children involved in concern reports, 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.
Quality Statement
Accuracy of Indigenous Status Data
Statuses:
[FACSIAR Data Governance Committee: Qualified, Oct. 13, 2023]
The accuracy of data held about Indigenous Status in current collections is poor for several factors. Firstly, the number of...
Framework Dimensions
Calculation rules
- Computation
A percentage calculated by dividing the number of Aboriginal children and young people involved in concern reports, by the number of total children involved in concern reports, during the reporting period, multiplied by 100.
- Description
Tableau:
[FinancialYearReporting]
COUNTD([CHILDSTORY_ID])
Number of Aboriginal children and young people involved in concern reports.
| Distribution/Table | Path/Column |
| Child Protection Reporting - Base Data Asset | CHILDSTORY_ID |
| CONTACT_START_DATE | |
| ABORIGINAL_STATUS_GROUPED |
-
- Data Element
- Person: Indigenous Status, Grouped Label X(14)
- Guide for use
Where value = "Aboriginal"
- Data Set
- Child Protection Data Set
-
- 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
Number of total children 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))- Data Set
- Child Protection Data Set
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.
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 |