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 |
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.
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 |
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 |
Data is sourced from ChildStory/CIW (not from KiDS) - Published by the NSW Department of Family and Community Services - from financial year 2018 onwards.
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.
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 |
Where value = "Aboriginal"
DISTINCT CHILDSTORY_ID
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))
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)
Number of total children involved in concern reports
Distribution/Table | Path/Column |
Child Protection Reporting - Base Data Asset | CHILDSTORY_ID |
CONTACT_START_DATE |
DISTINCT CHILDSTORY_ID
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))
By LGA and DCJ district
Demographic Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
Child Protection Reporting - Base Data Asset | DITRICT_COMMON | District |
Data Source:
Data limitations:
Relation | Count |
---|---|
Indicator Sets that include this Indicator | 0 |
Data Sets that are used in this Indicator | 1 |