Distribution/Table | Path/Column |
Child Protection Reporting - Base Data Asset | REPORT_WID |
ROSH_FLAG | |
CONTACT_START_DATE |
A count of concern reports meeting the Risk of Significant Harm (ROSH) threshold for statutory authority intervention, during the reporting period.
ROSH threshold screening occurs at the DCJ Child Protection Helpline. A child or young person is at ROSH if the circumstances that are causing concern for their safety, welfare or wellbeing are present to a significant extent. This means it is sufficiently serious to warrant a response by a statutory authority irrespective of a family's consent (see References below).
Distribution/Table | Path/Column |
Child Protection Reporting - Base Data Asset | REPORT_WID |
ROSH_FLAG | |
CONTACT_START_DATE |
A count of Concern Reports assessed at the ROSH threshold requiring statutory authority intervention (calculated by counting Report Identifiers that meet the threshold for ROSH), in the reporting period.
This indicator may be disaggregated by:
Indicator Specific breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
Child Protection Reporting - Base Data Asset | CONTACTOR_TYPE_GROUP | Reporter type |
PRIMARY_HL_ASSESSED_ISSUE_GRPD | Primary helpline assessed issue | |
Number of reports per child* |
Geographic Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
Child Protection Reporting - Base Data Asset | DITRICT_COMMON | District |
DITRICT_COMMON | Cluster* | |
BUSINESS_UNIT_COMMON | Business unit |
* District has been recoded into cluster using the District Common variable.
Demographic breakdown
Distribution/Table | Path/Column | Dashboard Filter Label … |
This indicator allows monitoring the demand for child protection investigations, including making resource decisions.
Alignment: This aligns with national reporting in Report on Government Services (RoGS).
A count of Concern Reports assessed at the ROSH threshold requiring statutory authority intervention (calculated by counting Report Identifiers that meet the threshold for ROSH), in the reporting period.
Distribution/Table | Path/Column |
Child Protection Reporting - Base Data Asset | REPORT_WID |
ROSH_FLAG | |
CONTACT_START_DATE |
DISTINCT REPORT_WID
ROSH Flag = Y
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)
This indicator may be disaggregated by:
Indicator Specific breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
Child Protection Reporting - Base Data Asset | CONTACTOR_TYPE_GROUP | Reporter type |
PRIMARY_HL_ASSESSED_ISSUE_GRPD | Primary helpline assessed issue | |
Number of reports per child* |
Geographic Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
Child Protection Reporting - Base Data Asset | DITRICT_COMMON | District |
DITRICT_COMMON | Cluster* | |
BUSINESS_UNIT_COMMON | Business unit |
* District has been recoded into cluster using the District Common variable.
Demographic breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
Child Protection Reporting - Base Data Asset | ABORIGINAL_STATUS_GROUPED | Aboriginal status |
Age | ||
Age grouped | ||
DISABILITY_FLAG | Disability |
The Annual Statistical Report disaggregates by Aboriginality, District, Number of reports, Reporter type and Selected issue.
Contact method is driven by data in CONTACT_ORIGIN
Primary helpline assessed issue is driven by data in PRIMARY_HL_ASSESSED_ISSUE_GRPD
District is driven by data in DITRICT_COMMON
Reporter agency is driven by data in CONTACTOR_TYPE_GROUP
Where the values for Aboriginal Status Grouped of 'not stated' and blank have been recoded as 'Non-Aboriginal.'
Response priority is driven by data in FINAL_RESPONSE_PRIORITY
Caseworkers in DCJ Child Protection Helpline apply the Structured Decision Making (SDM) Screening and Response Priority (SCRPT) tools to reports to determine the level of response category.
The District reflects where the child/young person's case plan is held at their first ROSH report in the reporting period.
Since the implementation of ChildStory there has been a change in the way reporter type is reported. From 2017-18 onwards, the category of 'Non-mandatory reporters' has replaced the categories of ‘Community/Social organisations’, ‘Family members’, 'Subject child/young person' and ‘Other/Not stated’ which are no longer used.
NP (Not Publishable) refers to small numbers that are not published to preserve privacy of individuals.
Data ageing:
Data limitations:
Data source:
In 2009 the threshold for legislative statutory authority intervention was amended from ‘risk of harm’ to ‘risk of significant harm’.
The NSW Interagency Guidelines outlines what is meant by ‘significant’ in ‘risk of significant harm’.
https://reporter.childstory.nsw.gov.au/s/article/Significant-harm-policy-definition
Relation | Count |
---|---|
Indicator Sets that include this Indicator | 0 |
Data Sets that are used in this Indicator | 1 |