Distribution/Table | Path/Column |
Child Protection Reporting - Base Data Asset | CHILDSTORY_ID |
CONTACT_START_DATE |
A count of unique/individual children and young people involved in concern reports received by the DCJ Child Protection Helpline, during the reporting period.
Distribution/Table | Path/Column |
Child Protection Reporting - Base Data Asset | CHILDSTORY_ID |
CONTACT_START_DATE |
A count of unique/individual children and young persons (calculated by counting distinct Child Identifiers) with a Contact Start Date in the reporting period.
Service Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
Child Protection Reporting - Base Data Asset | CONTACTOR_TYPE_GROUP | Reporter agency |
CONTACT_ORIGIN | Contact method | |
PRIMARY_HL_ASSESSED_ISSUE_GRPD | Primary helpline assessed issue |
Demographic Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
Child Protection Reporting - Base Data Asset | GENDER | Gender |
AGE_AT_CONTACT_GROUPED | Age Group | |
ABORIGINAL_STATUS_GROUPED | Aboriginality | |
DISABILITY_FLAG | Disability flag | |
COUNTRY_OF_BIRTH | Top 5 country of birth outside of Australia |
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 count of unique/individual children and young persons (calculated by counting distinct Child Identifiers) with a Contact Start Date in the reporting period.
Tableau:
[FinancialYearReporting]
COUNTD([CHILDSTORY_ID])
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))
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)
Service Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
Child Protection Reporting - Base Data Asset | CONTACTOR_TYPE_GROUP | Reporter agency |
CONTACT_ORIGIN | Contact method | |
PRIMARY_HL_ASSESSED_ISSUE_GRPD | Primary helpline assessed issue |
Demographic Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
Child Protection Reporting - Base Data Asset | GENDER | Gender |
AGE_AT_CONTACT_GROUPED | Age Group | |
ABORIGINAL_STATUS_GROUPED | Aboriginality | |
DISABILITY_FLAG | Disability flag | |
COUNTRY_OF_BIRTH | Top 5 country of birth outside of Australia |
Reporter agency is driven by data in CONTACTOR_TYPE_GROUP
Contact method is driven by data in CONTACT_ORIGIN
Primary helpline assessed issue is driven by data in PRIMARY_HL_ASSESSED_ISSUE_GRPD
Gender is driven by data in GENDER
Age Group is derived by data in AGE_AT_CONTACT_GROUPED
Aboriginality is driven by data in ABORIGINAL_STATUS_GROUPED
Disability flag is driven by data in DISABILITY_FLAG
Top 5 country of birth outside of Australia is driven by data in COUNTRY_OF_BIRTH
Data Source:
Relation | Count |
---|---|
Indicator Sets that include this Indicator | 1 |
Data Sets that are used in this Indicator | 1 |