| Distribution/Table | Path/Column |
| Child Protection Reporting - Base Data Asset | CHILDSTORY_ID |
| CONTACT_START_DATE |
Definition
A count of unique/individual children and young people involved in concern reports received by the DCJ Child Protection Helpline, during the reporting period.
Indicator Summary
No description available
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 |
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.
Outcome Areas
Framework Dimensions
Calculation rules
- Computation
A count of unique/individual children and young persons (calculated by counting distinct Child Identifiers) with a Contact Start Date in the reporting period.
- Description
Tableau:
[FinancialYearReporting]
COUNTD([CHILDSTORY_ID])
| 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
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 Element
- Service Event: Contactor Type, Grouped Label X(45)
- Description
Reporter agency is driven by data in CONTACTOR_TYPE_GROUP
- Data Set
- Child Protection Data Set
-
- Data Element
- Service Event: Contact, Label X(25)
- Description
Contact method is driven by data in CONTACT_ORIGIN
- Data Set
- Child Protection Data Set
-
- Data Element
- Assessment: Helpline Primary Issue, Grouped Label X(50)
- Description
Primary helpline assessed issue is driven by data in PRIMARY_HL_ASSESSED_ISSUE_GRPD
- Data Set
- Child Protection Data Set
-
- Data Element
- Person: Gender, Code X(20)
- Description
Gender is driven by data in GENDER
- Data Set
- Child Protection Data Set
-
- Data Element
- Person: Age, NN
- Description
Age Group is derived by data in AGE_AT_CONTACT_GROUPED
- Data Set
- Child Protection Data Set
-
- Data Element
- Person: Indigenous Status, Grouped Label X(14)
- Description
Aboriginality is driven by data in ABORIGINAL_STATUS_GROUPED
- Data Set
- Child Protection Data Set
-
- Data Element
- Person: Disability Indicator, Yes/No Code A
- Description
Disability flag is driven by data in DISABILITY_FLAG
- Data Set
- Child Protection Data Set
-
- Data Element
- Person: Country of Birth, Label X(100)
- Description
Top 5 country of birth outside of Australia is driven by data in COUNTRY_OF_BIRTH
- Data Set
- Child Protection Data Set
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.
Origin
Related content
| Relation | Count |
|---|---|
| Indicator Sets that include this Indicator | 1 |
| Data Sets that are used in this Indicator | 1 |