Distribution/Table | Path/Column |
FCaS_Attendance_Table | CLIENTID |
PARTICIPATIONTYPE | |
CONDUCTEDDATE | |
FCaS_Client_Table | CLIENTID |
CURRENTRECORD |
A count of unique individual clients who received Family Connect and Support (FCS) services in the reporting period.
These clients have a client record created in the Data Exchange where client details and demographic information are collected. The client must receive a service under the FCS program and that service must lead to a measurable outcome. The client attendance has occurs in the specified time period to be counted.
Distribution/Table | Path/Column |
FCaS_Attendance_Table | CLIENTID |
PARTICIPATIONTYPE | |
CONDUCTEDDATE | |
FCaS_Client_Table | CLIENTID |
CURRENTRECORD |
The numerator is a count of distinct Client Identifiers, where Current Records are selected and the Participation Type is client. The time period is based on the Conducted Date.
This indicator may be disaggregated by:
Indicator Specific Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
FCaS_Attendance_Table | SERVICETYPEID | Service type |
FCaS_Attendance_Table | DELIVERYORGID | Delivery organisation |
FCaS_Attendance_Table | REFERRALFROMSOURCE | Referral source |
Geographic Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
FCaS_Outlet_Table | MB2016BOUNDARYCODE | District (outlet)* |
FCaS_Outlet_Table | MB2016BOUNDARYCODE | LGA (outlet)* |
FCaS_Outlet_Table | OUTLETPOSTCODE | Remoteness Area (outlet)* |
DCJ_NAME_2019 | District (client) | |
LGA2016BoundaryCode | LGA (client) |
*The FCS Mesh Block is used with a geographical conversion table to calculate into DCJ Districts and Local Government Area. The Outlet Postcode is used …
The Family Connect and Support Program dashboard reports annually.
The indicator provides practical information for managers and front-line staff to better understand their program.
Alignment: This aligns with reporting in Data Exchange by the Australian Government Department of Social Services (DSS).
The numerator is a count of distinct Client Identifiers, where Current Records are selected and the Participation Type is client. The time period is based on the Conducted Date.
Distribution/Table | Path/Column |
FCaS_Attendance_Table | CLIENTID |
PARTICIPATIONTYPE | |
CONDUCTEDDATE | |
FCaS_Client_Table | CLIENTID |
CURRENTRECORD |
The CurrentRecord flag in a binary code (1 or 0) that indicates whether the record is current. 1 denotes current and 0 means it is inactive. It is important when running queries the current record flag is set to 1. CurrentRecord of 0 means the record is historical.
Current record = '1'.
Where Participation Type is equal to 'Client'.
A count of distinct Client Identifiers.
Where the conducted date is set for the desired month or financial year.
This indicator may be disaggregated by:
Indicator Specific Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
FCaS_Attendance_Table | SERVICETYPEID | Service type |
FCaS_Attendance_Table | DELIVERYORGID | Delivery organisation |
FCaS_Attendance_Table | REFERRALFROMSOURCE | Referral source |
Geographic Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
FCaS_Outlet_Table | MB2016BOUNDARYCODE | District (outlet)* |
FCaS_Outlet_Table | MB2016BOUNDARYCODE | LGA (outlet)* |
FCaS_Outlet_Table | OUTLETPOSTCODE | Remoteness Area (outlet)* |
DCJ_NAME_2019 | District (client) | |
LGA2016BoundaryCode | LGA (client) |
*The FCS Mesh Block is used with a geographical conversion table to calculate into DCJ Districts and Local Government Area. The Outlet Postcode is used with a geographical conversion table to calculate into Remoteness Areas.
Demographic Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
FCaS_Attendance_Table | AGEATSESSION | Age |
FCaS_Attendance_Table | AGEATSESSION | 0 - 5 year olds |
FCaS_Attendance_Table | AGEATSESSION | 0-18 year old clients affected by mental health* |
FCaS_Attendance_Table | PRIMARYASSISTANCENEEDEDKEY | |
FCaS_Attendance_Table | ASSISTANCENEEDEDKEY | |
AssistanceNeededKey | ||
FCaS_Client_Disability_Table | DISABILITYCODE | Disability status |
FCaS_Client_Table | ATSICODE | Aboriginality |
FCaS_Client_Table | CALDSTATUS | CALD |
FCaS_Client_Table | HOMELESSCODE | Homelessness status |
FCaS_Client_Table | GENDERCODE | Gender |
FCaS_Client_Table | HOMELESSCODE | Homeless |
FCaS_Client_Table | HOUSEHOLDCOMPOSITIONCODE | Household Composition |
FCaS_Client_Table | BIRTHCOUNTRYCODE | Country of birth |
* For the 0-18 year old clients affected by mental health the Primary Assistance Needed Key and the Assistance Needed Key from the from the Attendance Table connect to the Assistance Needed Key in the Reference Assistance Needed Table, where the value for MENTAL is equal to '1', and the value for Age At Session is 0 - 18.
The Family Connect and Support Program Dashboard disaggregates by district (outlet), LGA (outlet), Aboriginality, CALD, referral source, 0-5 years of age, 0-18 years of age affected by mental health and top 5 service types.
Where the Age at Session variable is used.
Where the value for CALD Status is equal to 'CALD'.
The FCS Mesh Block is used with a geographical conversion table to calculate into DCJ Districts and Local Government Area.
Where the value of ATSICODE is equal to 'Aboriginal', 'TSI' (Torres Strait Islander) or Both (Aboriginal and Torres Strait Islander).
The Primary Assistance Needed Key and the Assistance Needed Key from the from the Attendance Table connect to the Assistance Needed Key in the Reference Assistance Needed Table, where the value for MENTAL is equal to "1"
Data ageing:
Relation | Count |
---|---|
Indicator Sets that include this Indicator | 0 |
Data Sets that are used in this Indicator | 1 |