| Distribution/Table | Path/Column |
| REFERRALTOINTERNALKEY/ REFERRALTOEXTERNALKEY |
|
| PARTICIPATIONTYPE | |
| CURRENTRECORD |
Definition
A count of the internal and external referrals out of the Family Connect and Support (FCS) Program in the reporting period. This reflects a client’s need for help outside the scope of FCS funded activities.
Internal referrals are referrals made to another service offered within the same organisation while external referrals were made to a service that is provided by another organisation.
An individual client can have multiple reasons for a referral out of the FCS Program.
Indicator Summary
A client may be referred to other services by a FCS provider, which are grouped into 14 categories in the DEX_Ref_Referral_to table. Each category is a binary code (i.e. 1 or 0) to indicate whether the respective reason(s) are referred. The ReferralToKey is an integer that shows the different combination of the 14 categories in the table. For example, ReferralToKey of 2 means clients' are referred due to Employment reasons as there is 1 against Employment category. ReferralToKey of 6 …
This indicator may be disaggregated by:
Indicator Specific Breakdowns
| Distribution/Table | Path/Column | Dashboard Filter Label |
| FCaS_Attendance_Table | ACTIVITYID | Program activity |
| FCaS_Attendance_Table | SERVICETYPEID | Service type |
| FCaS_Attendance_Table | DELIVERYORGID | Delivery organisation |
Geographic Breakdowns
| Distribution/Table | Path/Column | Dashboard Filter Label |
| FCaS_Outlet_Table | MB2016BOUNDARYCODE | LGA (outlet) |
| FCaS_Outlet_Table | MB2016BOUNDARYCODE | District (outlet)* |
*The FCS Mesh Block is used with a geographical conversion table to calculate into DCJ Districts and Local Government Areas,
Demographic Breakdowns
| Distribution/Table | Path/Column | Dashboard Filter Label |
| FCaS_Attendance_Table | AGEATSESSION | Age |
| FCaS_Attendance_Table | AGEATSESSION | 0 - 5 year olds |
| FCaS_Attendance_Table … |
Reporting Information
The Family Connect and Support Program dashboard reports annually.
Framework Dimensions
Rationale
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).
Calculation rules
- Computation
A client may be referred to other services by a FCS provider, which are grouped into 14 categories in the DEX_Ref_Referral_to table. Each category is a binary code (i.e. 1 or 0) to indicate whether the respective reason(s) are referred. The ReferralToKey is an integer that shows the different combination of the 14 categories in the table. For example, ReferralToKey of 2 means clients' are referred due to Employment reasons as there is 1 against Employment category. ReferralToKey of 6 means clients' are referred due to Employment and Caring reasons as there is a 1 against Employment and Caring category.
The ReferralToKey is joined to REFERRALTOEXTERNALKEY or REFERRALTOINTERNALKEY in the FCaS_Attendance Table. When joined to REFERRALTOEXTERNALKEY, the categories are the reasons clients' are referred to other services externally. When joined to REFERRALTOINTERNALKEY, the categories are the reasons clients' are referred to other services internally.
The summary total of primary reasons clients' seek assistance is therefore: AGE, MATERIAL, FAMILY, MONEY, PHYSICAL, COMMUNITY, MENTAL, PERSONAL, HOUSING, TRAINING, EMPLOYMENT, EDUCEMPL where it equals = 1.
| Distribution/Table | Path/Column |
| REFERRALTOINTERNALKEY/ REFERRALTOEXTERNALKEY |
|
| PARTICIPATIONTYPE | |
| CURRENTRECORD |
-
- Data Element
- Person: Participation type, Label A(10)
- Guide for use
Where the value for Participation Type is equal to 'client'.
- Data Set
- Family Connect & Support
-
- Data Element
- Record: Current Record Indicator, No/Yes Code N
- Description
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.
- Guide for use
Where CURRENTRECORD = 1.
- Data Set
- Family Connect & Support
-
- Data Element
- Session: Referral To External Key, Identifier N(5)
- Data Set
- Family Connect & Support
-
- Data Element
- Session: Referral To Internal Key, Identifier N(5)
- Data Set
- Family Connect & Support
This indicator may be disaggregated by:
Indicator Specific Breakdowns
| Distribution/Table | Path/Column | Dashboard Filter Label |
| FCaS_Attendance_Table | ACTIVITYID | Program activity |
| FCaS_Attendance_Table | SERVICETYPEID | Service type |
| FCaS_Attendance_Table | DELIVERYORGID | Delivery organisation |
Geographic Breakdowns
| Distribution/Table | Path/Column | Dashboard Filter Label |
| FCaS_Outlet_Table | MB2016BOUNDARYCODE | LGA (outlet) |
| FCaS_Outlet_Table | MB2016BOUNDARYCODE | District (outlet)* |
*The FCS Mesh Block is used with a geographical conversion table to calculate into DCJ Districts and Local Government Areas,
Demographic Breakdowns
| 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* |
| PRIMARYASSISTANCENEEDEDKEY | ||
| 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 |
* 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 connects 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 and internal or external referral.
-
- Data Element
- Person: Indigenous Status, Label A(10)
- Guide for use
Where the value of ATSICODE is equal to 'Aboriginal', 'TSI' (Torres Strait Islander) or Both (Aboriginal and Torres Strait Islander).
- Data Set
- Family Connect & Support
-
- Data Element
- Person: Culturally and Linguistically Diverse Indicator, label A(8)
- Data Set
- Family Connect & Support
Comments
Data ageing:
- This indicator does not have any data ageing rules.
Custom Fields
DCJ - Domain
Targeted Earlier Intervention
Related content
| Relation | Count |
|---|---|
| Indicator Sets that include this Indicator | 0 |
| Data Sets that are used in this Indicator | 1 |