Skip to content Learn about the access keys available for Metadata.NSW
A NSW Government website
NSW Government
Metadata.NSW

Family Preservation flat file data asset

Download CSV
Logical Path Data Element Number of Unique Values Uniqueness Score Min Max Average
aboriginal_or_torres_strait_islander_origin Person: Indigenous Status, Label X(40) - - - - -
aboriginal_or_torres_strait_islander_origin_grouped_derived Person: Indigenous Status, group label X(42) - - - - -
activity_auto_id Service Event: Program Area, activity Code NN - - - - -
activity_label Service Event: Program Area, Label X(20) - - - - -
age_at_commence_derived Person: Age, Years NNN.NN - - - - -
age_at_commence_group_derived FAP_PROCESS: Age Group, Label X(10) - - - - -
age_at_referral_derived Person: Age, Total Years NNN - - - - -
age_at_referral_group_derived FAP_PROCESS: Age Group, Label X(10) - - - - -
birth_country Person: Country of Birth, Label X(100) - - - - -
birth_date Person: Date of Birth, YYYY-MM-DD - - - - -
birth_date_derived Person: Date of Birth, YYYY-MM-DD - - - - -
caregiver_status Person: Caregiver type, Status label A(25) - - - - -
caregiver_status_derived Person: Caregiver type, Status label A(25) - - - - -
child_story_id Person: ChildStory Identifier, A-N(8) - - - - -
child_story_id_derived Person: ChildStory Identifier, A-N(8) - - - - -
client_auto_id Person: Client Identifier, N(5) - - - - -
client_label Person: Client Identifier, X(40) - - - - -
disabilities Person: Disability Status, Indicator X(5) - - - - -
etl_run Record: DateTime Stamp, YYYY-MM-DD - - - - -
exit_date Service Event: Exit Date, DDMMYYYY - - - - -
exit_date_derived Service Event: Exit Date, DDMMYYYY - - - - -
exit_reason Person: Exit Reason, Description A(70) - - - - -
exit_reason_derived Person: Exit Reason, Description A(70) - - - - -
family_atsi_status_derived Family: Indigenous Status, Group label X(42) - - - - -
finyear FAP_PROCESS: Financial Year, Label - - - - -
first_name Person: Given Name, Text X(50) - - - - -
fy FAP_PROCESS: Financial Year, Label - - - - -
fy_end_date Record: Financial Year, YYYY-YY - - - - -
gender Person: Gender, Code X(40) - - - - -
gender_grouped_derived Person: Gender, Code X(40) - - - - -
group_auto_id Family: Family identifier, N(5) - - - - -
group_id Family: Family identifier, X(36) - - - - -
group_type Family: Family type, Group label A(6) - - - - -
group_type_derived Family: Family type, Group label A(6) - - - - -
household_composition Person: Household composition, Type Label X(36) - - - - -
intellectual_learning Person: Learning Disability Flag, Indicator X(5) - - - - -
is_homeless Person: Homelessness status, Label - - - - -
language Person: Main language spoken at home, Label X(50) - - - - -
last_name Person: Family Name, Text X(50) - - - - -
lga_short_name Organisation: Local Government Area, LGA Label X - - - - -
length_of_stay_derived FAP_PROCESS: Number of days, N(5) - - - - -
matched_derived Service Event: Occurrence indicator, Referral match label - - - - -
meta_data_set_label Record: Metadata type, Label - - - - -
organisation_auto_id Organisation: Identifier, Code NNN - - - - -
organisation_label Organisation: Family Preservation Organisation, Label - - - - -
outlet_activity_auto_id Outlet: Program activity identifier, Code NNN - - - - -
outlet_auto_id Outlet: Identifier, Code NNN - - - - -
outlet_label Organisation: Outlet Name, Text X(200) - - - - -
physical_diverse Person: Physical Disability Flag, Indicator X(5) - - - - -
proficiency_in_spoken_english Person: Proficiency in spoken English, Label A(10) - - - - -
psychiatric Person: Psychiatric Disability Flag, Indicator X(5) - - - - -
ref_service_date_derived Service Episode: Referral Date, DateTime YYYY-MM-DD - - - - -
ref_to_commence_derived FAP_PROCESS: Number of days, N(5) - - - - -
referral_derived Service Event: Occurrence Indicator, X(5) - - - - -
referral_auto_id Person: Referral Identifier, N(5) - - - - -
referral_consent Person: Consent Indicator, Label A(10) - - - - -
referral_date Activity: Referral Date, YYYY-MM-DD - - - - -
referral_date_derived FAP_PROCESS: Date, YYYY-MM-DD - - - - -
referral_id Person: Referral Identifier, X(36) - - - - -
referral_label Record: Referral Identifier, X(36) - - - - -
referral_outcome Service Event: Referral outcome Label A(80) - - - - -
referral_pathway Person: Referral Pathway, Label X(50) - - - - -
sensory_speech Person: Sensory Disability Flag, Indicator X(5) - - - - -
service_derived Service Event: Occurrence Indicator, X(5) - - - - -
service_auto_id Service Event: Program identifier, N(5) - - - - -
service_consent_date Family: Consent Date, Date YYYY-MM-DD - - - - -
service_id Service Event: Program identifier, X(36) - - - - -
service_label Service Event: Program identifier, X(36) - - - - -
start_date Family: First Service Date, DateTime YYYY-MM-DD - - - - -
start_date_derived FAP_PROCESS: Date, YYYY-MM-DD - - - - -
step_down_start_date Family: Step-down start date, Date YYYY-MM-DD - - - - -
suburb Person: Locality Name, Text X(50) - - - - -
unique_id_derived FAP_PROCESS: Identifier, X(20) - - - - -
in_fap_data_derived FAP_PROCESS: Linkage key check, Yes/No Code N - - - - -
rosh_12m_prior_derived FAP_PROCESS: ROSH Flag, Yes/No Code N - - - - -
concern_12m_prior_derived FAP_PROCESS: Concern Report, Yes/No Code N - - - - -
fa_12m_flag_derived FAP_PROCESS: Field Assessment, Yes/No Code N - - - - -
last_rosh_prior_or_on_ref_derived FAP_PROCESS: ROSH Flag, DateTime YYYY-MM-DD - - - - -
HLA_CYP_ISSUES_FLG_12m_prior_ref_derived Assessment: Field Issues Flag, Yes/No/NA Code A(A) - - - - -
HLA_DV_FLG_12m_prior_ref_derived Assessment: Domestic Violence Flag, Yes/No/NA Code A(A) - - - - -
HLA_EMOTIONAL_ABUSE_FLG_12m_prior_ref_derived Assessment: Emotional Abuse Flag, Yes/No/NA Code A(A) - - - - -
HLA_NEGLECT_FLG_12m_prior_ref_derived Assessment: Neglect Flag, Yes/No/NA Code A(A) - - - - -
HLA_PHYSICAL_ABUSE_FLG_12m_prior_ref_derived Assessment: Physical Abuse Flag, Yes/No/NA Code A(A) - - - - -
HLA_SEXUAL_ABUSE_FLG_12m_prior_ref_derived Assessment: Sexual Abuse Flag, Yes/No/NA Code A(A) - - - - -
HLA_OTHER_ISSUES_FLG_12m_prior_ref_derived Assessment: Other Issues Flag, Yes/No/NA Code A(A) - - - - -
HLA_CARER_MH_FLG_12m_prior_ref_derived Assessment: Mental health issues flag, Yes/No/NA Code A(A) - - - - -
HLA_CARER_DRUG_ALC_FLG_12m_prior_ref_derived Assessment: Alcohol or drug use problem, Yes/No/NA Code A(A) - - - - -
oohc_prior_to_ref_derived FAP_PROCESS: Placement Flag, Yes/No Code N - - - - -
oohc_asat_ref_derived FAP_PROCESS: Placement Flag, Yes/No Code N - - - - -
rosh_3m_post_exit_derived FAP_PROCESS: ROSH Flag, Yes/No Code N - - - - -
rosh_6m_post_exit_derived FAP_PROCESS: ROSH Flag, Yes/No Code N - - - - -
rosh_9m_post_exit_derived FAP_PROCESS: ROSH Flag, Yes/No Code N - - - - -
oohc_3m_post_exit_derived FAP_PROCESS: Placement Flag, Yes/No Code N - - - - -
oohc_6m_post_exit_derived FAP_PROCESS: Placement Flag, Yes/No Code N - - - - -
oohc_9m_post_exit_derived FAP_PROCESS: Placement Flag, Yes/No Code N - - - - -