Definition
The Family Preservation consolidated table is a data asset used by the NSW Department of Communities & Justice for reporting and analysis purposes. This table compiles data from multiple infoShare tables into one flat file and applies basic cleaning rules to provide a comprehensive view of family preservation efforts. Its primary purpose is to monitor and evaluate the effectiveness of programs aimed at keeping families together and preventing child removal.
Data source details
Provenance records
Source distributions
-
Source DistributionsRelease Date No release date suppliedGeneration
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| aboriginal_or_torres_strait_islander_origin | Person: Indigenous Status, Label X(40) |
A label that represents the Aboriginal and/or Torres Strait Islander origin identified by a person. |
ALPHASTRING | A(55) |
| aboriginal_or_torres_strait_islander_origin_grouped_ | Person: Indigenous Status, group label X(42) |
An individual's Aboriginal status, as represented by a grouped label.
Specific Information:
"Reported as" grouped as Aboriginal. |
CHARACTERSTRING | X(42) |
| activity_auto_id | Service Event: Program Area, activity Code NN |
The type of program activity being delivered, as represented by a numeric code.
Lineage details:
|
Number | NN |
| activity_label | Service Event: Program Area, Label X(20) |
The type of program activity being delivered, as represented by a label.
Lineage details:
|
CHARACTERSTRING | X(20) |
| age_at_commence_ | Person: Age, Years NNN.NN |
The age of the person in (completed) years at a specific point in time.
Specific Information:
Age at service start, calculated as the difference in years between client birth_date_ and start_date_ |
INTEGERNUMBER | NNN.NN |
| age_at_commence_group_ | FAP_PROCESS: Age Group, Label X(10) |
A calculated/constructed field based on an SQL process to assign an Age Group label that represents the person’s completed age in years. |
CHARACTERSTRING | X(10) |
| age_at_referral_ | Person: Age, Total Years NNN |
The age of the person in (completed) years at a specific point in time.
Specific Information:
Age at referral, calculated as the difference in years between client birth_date_ and referral_date_ |
NUMBERSTRING | NNN |
| age_at_referral_group_ | FAP_PROCESS: Age Group, Label X(10) |
A calculated/constructed field based on an SQL process to assign an Age Group label that represents the person’s completed age in years. |
CHARACTERSTRING | X(10) |
| birth_country | Person: Country of Birth, Label X(100) |
The country in which the person was born, as represented by a label. |
ALPHANUMERICSTRING | X(100) |
| birth_date | Person: Date of Birth, YYYY-MM-DD |
The date of birth of the person, expressed as a date time stamp. |
DATETIME | YYYY-MM-DD(T00:00:00) |
| birth_date_ | Person: Date of Birth, YYYY-MM-DD |
The date of birth of the person, expressed as a date time stamp.
Specific Information:
If DOB earlier than 1901 (arbitrary date) then made NA. |
DATETIME | YYYY-MM-DD(T00:00:00) |
| caregiver_status | Person: Caregiver type, Status label A(25) |
The caregiver status of an individual currently receiving services, as represented by a label. |
ALPHASTRING | A(25) |
| caregiver_status_ | Person: Caregiver type, Status label A(25) |
The caregiver status of an individual currently receiving services, as represented by a label.
Specific Information:
Data cleaned so when age is under 18 person is categorised as CYP and categorised as caregiver if over 18. |
ALPHASTRING | A(25) |
| child_story_id | Person: ChildStory Identifier, A-N(8) |
Internal Department of Communities and Justice (DCJ) Person identifier from ChildStory. |
CHARACTERSTRING | A-N(8) |
| child_story_id_ | Person: ChildStory Identifier, A-N(8) |
Internal Department of Communities and Justice (DCJ) Person identifier from ChildStory.
Specific Information:
Cleaned to ensure consistent format for matching to ChildStory data. |
CHARACTERSTRING | A-N(8) |
| client_auto_id | Person: Client Identifier, N(5) |
A system-generated identifier for a unique client record, as represented by a number.
Specific Information:
Organisation's Client Id must be unique for all the clients registered with the Organisation. A client's name, part of a client's name, or other identifiable information should not be used.
Lineage details:
|
NUMBERSTRING | N(5) |
| client_label | Person: Client Identifier, X(40) |
A system-generated identifier for a unique client record, as represented by a characterstring.
Lineage details:
|
ALPHANUMERICSTRING | X(40) |
| disabilities | Person: Disability Status, Indicator X(5) |
An indicator of whether a person has a disability. A person has a disability if they have an intellectual, psychiatric, sensory physical or like impairment or a combination of such impairments, that is permanent or is likely to be permanent, and results in a significantly reduced capacity in one or more major life activities such as communication, learning mobility, decision-making or self-care and the need for support. |
BOOLEAN | X(5) |
| etl_run | Record: DateTime Stamp, YYYY-MM-DD |
A sequence of characters or encoded information identifying when a certain event occurred, on what day, and optionally including what particular time of day.
Specific Information:
Extract, transform, load date of the data. The 22/23 snapshot contains only single ETL. |
DATETIME | YYYY-MM-DD(T00:00:00) |
| exit_date | Service Event: Exit Date, DDMMYYYY |
The date recorded as the day of a particular month and year when an instance or occasion of assistance received by a client from a service provider disengaged or exited the program. |
DATE | DDMMYYYY |
| exit_date_ | Service Event: Exit Date, DDMMYYYY |
The date recorded as the day of a particular month and year when an instance or occasion of assistance received by a client from a service provider disengaged or exited the program.
Specific Information:
exit_date cleaned so where missing date and exit_reason is not 'NA', the exit_date_ is set to the end of the financial year that the start is on. |
DATE | DDMMYYYY |
| exit_reason | Person: Exit Reason, Description A(70) |
The reason a family/client (Child or Young Person) exited the service, as represented by a label. |
CHARACTERSTRING | A(70) |
| exit_reason_ | Person: Exit Reason, Description A(70) |
The reason a family/client (Child or Young Person) exited the service, as represented by a label.
Specific Information:
|
CHARACTERSTRING | A(70) |
| family_atsi_status_ | Family: Indigenous Status, Group label X(42) |
An Indicator of whether any members of a Family identify as Aboriginal or Torres Strait Islander, as represented by a label.
Specific Information:
If a group_auto_id exists and any aboriginal_or_torres_strait_islander_origin_grouped_ within that id is Aboriginal then flag Aboriginal else not. |
CHARACTERSTRING | X(42) |
| finyear | FAP_PROCESS: Financial Year, Label |
A calculated/constructed field based on an SQL process to assign a date relating to the financial year, as represented by a label.
Specific Information:
The period of filtering for the snapshot will be a financial year. |
CHARACTERSTRING | A(2)-N(4)/(2) |
| first_name | Person: Given Name, Text X(50) |
The name of a person within the family group or by which the person is socially identified.
Lineage details:
|
ALPHANUMERICSTRING | X(50) |
| fy | FAP_PROCESS: Financial Year, Label |
A calculated/constructed field based on an SQL process to assign a date relating to the financial year, as represented by a label.
Specific Information:
Financial year of service start date |
CHARACTERSTRING | A(2)-N(4)/(2) |
| fy_end_date | Record: Financial Year, YYYY-YY |
The fiscal year or twelve month accounting period, which in Australia commences 1 July of a given calendar year and ends 30 June of the following calendar year relating to a report.
Specific Information:
End date of the financial year a service commenced. |
NUMBERSTRING | N(4)-N(2) |
| gender | Person: Gender, Code X(40) |
A code that represents how a person identifies their masculine or feminine characteristics. An individual's gender is not always exclusively male or female, and doesn't always correspond to their sex assigned at birth.
Lineage details:
|
ALPHASTRING | X(40) |
| gender_grouped_ | Person: Gender, Code X(40) |
A code that represents how a person identifies their masculine or feminine characteristics. An individual's gender is not always exclusively male or female, and doesn't always correspond to their sex assigned at birth.
Specific Information:
Genders not Male or Female grouped as 'Other' |
ALPHASTRING | X(40) |
| group_auto_id | Family: Family identifier, N(5) |
A unique identifier representing a group of people considered to be a family in terms of program delivery. |
NUMBERSTRING | N(5) |
| group_id | Family: Family identifier, X(36) |
The identifier for a group of people considered to be a family, as represented by an alphanumeric sequence of characters. |
CHARACTERSTRING | X(36) |
| group_type | Family: Family type, Group label A(6) |
A description of a family or group unit, as represented by a label. |
ALPHASTRING | A(6) |
| group_type_ | Family: Family type, Group label A(6) |
A description of a family or group unit, as represented by a label.
Specific Information:
Original variable cleaned, where group_type='NA' and there is at least one caregiver_status_='CYP' in group + valid group auto id, then count group. If group type='Family' and no CYP in group, do not count. |
ALPHASTRING | A(6) |
| household_composition | Person: Household composition, Type Label X(36) |
The composition of an individual's household, as represented by a label.
Lineage details:
|
CHARACTERSTRING | X(36) |
| intellectual_learning | Person: Learning Disability Flag, Indicator X(5) |
A flag indicating whether a person has an impairment of intellectual functions which limit a range of daily activities and restrict participation in a range of life areas, for example, but not limited to; dyscalculia, dysgraphia, dyslexia, as represented by a True/False label.
Lineage details:
|
BOOLEAN | X(5) |
| is_homeless | Person: Homelessness status, Label |
The experience of unstable, inadequate or non-permanent housing identified by person, represented by a label. |
ALPHASTRING | A(6) |
| language | Person: Main language spoken at home, Label X(50) |
The main language spoken at home by a given client, recorded as a label representing a language. |
CHARACTERSTRING | X(50) |
| last_name | Person: Family Name, Text X(50) |
The text that represents a name by which a person’s family group may be identified. That part of a name a person usually has in common with some other members of his/her family, as distinguished from his/her given names. |
ALPHANUMERICSTRING | X(50) |
| lga_short_name | Organisation: Local Government Area, LGA Label X |
The local government area, as referred to by the Australian Bureau of Statistics (ABS), that an organisation is located.
Lineage details:
|
CHARACTERSTRING | - |
| los_ | FAP_PROCESS: Number of days, N(5) |
A calculated/constructed field based on an SQL process to show the number of days in care/placement
Specific Information:
Days of length of stay, calculated as difference between start_date_ and exit_date_
Lineage details:
|
INTEGERNUMBER | N(5) |
| matched_ | Service Event: Occurrence indicator, Referral match label |
An indicator of whether a referral was matched with a service or not, as represented by a label. |
ALPHASTRING | A(25) |
| meta_data_set_label | Record: Metadata type, Label |
The type or category of metadata used for a file, record, or collection of data, as represented by a label. |
CHARACTERSTRING | X(30) |
| organisation_auto_id | Organisation: Identifier, Code NNN |
An identifier assigned to an organisation that provides care or services, as represented by a unique numeric code. |
NUMBERSTRING | NNN |
| organisation_label | Organisation: Family Preservation Organisation, Label |
The operating name of an organisation which provides Family Preservation services, as represented by a label. |
- | - |
| outlet_activity_auto_id | Outlet: Program activity identifier, Code NNN |
An identifier for the record for an activity or service type being delivered by an outlet, as represented by a unique 2 to 3 digit code. |
INTEGERNUMBER | NNN |
| outlet_auto_id | Outlet: Identifier, Code NNN |
A system-generated identifier for an outlet where services are delivered, as represented by a code.
Lineage details:
|
INTEGERNUMBER | NNN |
| outlet_label | Organisation: Outlet Name, Text X(200) |
Text by which the nearest administrative premises is known or called where staff are based, and where they are likely to be travelling from to deliver services of the organisation engaged to provide services and/or care.
Specific Information:
The (Branded or Operating) name of the physical location from where a service is primarily being delivered. An outlet identifies the location where a service took place, or where staff travelled from to deliver a service. |
ALPHANUMERICSTRING | X(200) |
| physical_diverse | Person: Physical Disability Flag, Indicator X(5) |
A flag indicating whether a person has an impairment, which may have diverse effects within and among individuals, including effects on physical activities such as mobility. This grouping includes physical disability, for example; paraplegia, quadriplegia, muscular dystrophy, motor neurone disease, neuromuscular disorders, cerebral palsy, absence or deformities of limbs, acquired brain injury, neurological disability (including epilepsy, dementias, multiple sclerosis and Parkinson's disease), as represented by a True/False label.
Lineage details:
|
BOOLEAN | X(5) |
| proficiency_in_spoken_english | Person: Proficiency in spoken English, Label A(10) |
A person's self-assessed level of ability to speak English, as represented by a label. |
ALPHASTRING | A(10) |
| psychiatric | Person: Psychiatric Disability Flag, Indicator X(5) |
A flag indicating whether a person has an impairment associated with clinically recognisable symptoms and behaviour patterns frequently associated with distress that may impair personal functioning in normal social activity, for example, but not limited to; Asperger syndrome, attention deficit hyperactivity disorder, autism, behavioural disorders, bipolar, depression, eating disorders, epilepsy, manias, phobias, schizophrenia, somnias, as represented by a True/False label.
Lineage details:
|
BOOLEAN | X(5) |
| ref_service_date_ | Service Episode: Referral Date, DateTime YYYY-MM-DD |
The date expressed as YYYYMMDD a referral for the receipt for a given service episode.
Specific Information:
Date of referral (referral_date) or start_date_ if referral_date is non-existent |
DATETIME | YYYY-MM-DD(T00:00:00) |
| ref_to_commence_ | FAP_PROCESS: Number of days, N(5) |
A calculated/constructed field based on an SQL process to show the number of days in care/placement
Specific Information:
Number of days between referral_date_ and start_date_, coded as 'NA' if referral not before start_date_ |
INTEGERNUMBER | N(5) |
| referral_ | Service Event: Occurrence Indicator, X(5) |
An indicator of whether a service event took place, as represented by a True/False label.
Specific Information:
Uses matched_ to find out if referral occurred (True) or not (False). |
BOOLEAN | X(5) |
| referral_auto_id | Person: Referral Identifier, N(5) |
A sequence of characters which uniquely identifies a referral for an individual. |
NUMBERSTRING | N(5) |
| referral_consent | Person: Consent Indicator, Label A(10) |
A label that represents whether the person has given consent, that is giving or denying permission for something to happen or agreement to do something.
Lineage details:
|
CHARACTERSTRING | A(10) |
| referral_date | Activity: Referral Date, YYYY-MM-DD |
The date the referral form is received from the DCJ or any other agency or service was received by the Program service provider, in the format YYYY-MM-DD. |
DATETIME | YYYY-MM-DD(T00:00:00) |
| referral_date_ | FAP_PROCESS: Date, YYYY-MM-DD |
A calculated/constructed field based on an SQL process to assign an aged date relating to the financial year (start/end)
Specific Information:
Calculated referral date where before '2017-06-30 is recoded as NA as it is invalid |
DATE | YYYY-MM-DD |
| referral_id | Person: Referral Identifier, X(36) |
An identifier for a referral for an individual, as represented by a sequence of alphanumeric characters. |
CHARACTERSTRING | X(36) |
| referral_label | Record: Referral Identifier, X(36) |
An identifier for a referral record, as represented by a sequence of alphanumeric characters. |
CHARACTERSTRING | X(36) |
| referral_outcome | Service Event: Referral outcome Label A(80) |
The outcome of a client's referral to a program, once assessed by the service provider, as represented by a label.
Lineage details:
|
ALPHASTRING | A(80) |
| referral_pathway | Person: Referral Pathway, Label X(50) |
A referral pathway into a program for an individual, as represented by a label.
Lineage details:
|
CHARACTERSTRING | X(50) |
| sensory_speech | Person: Sensory Disability Flag, Indicator X(5) |
A flag indicating whether a person has a vision disability (blindness, vision impairment); hearing disability (deafness, hearing impairment that cause severe restrictions in communication); deaf-blind (dual sensory impairments causing severe restrictions in communication); speech disability (speech loss, impairment which causes severe restrictions in communication), as represented by a True/False label.
Lineage details:
|
BOOLEAN | X(5) |
| service_ | Service Event: Occurrence Indicator, X(5) |
An indicator of whether a service event took place, as represented by a True/False label. |
BOOLEAN | X(5) |
| service_auto_id | Service Event: Program identifier, N(5) |
A system generated identifier which uniquely identifies a service record, as represented by a 2 - 5 character numeric string.
Lineage details:
|
NUMBERSTRING | N(5) |
| service_consent_date | Family: Consent Date, Date YYYY-MM-DD |
The date on which a Family grants permission or agreement to receive services, expressed as YYYY-MM-DD.
Lineage details:
|
DATE | YYYY-MM-DD |
| service_id | Service Event: Program identifier, X(36) |
A system generated identifier which uniquely identifies an instance or occasion of assistance received by a client from a service provider.
Lineage details:
|
CHARACTERSTRING | X(36) |
| service_label | Service Event: Program identifier, X(36) |
A system generated identifier which uniquely identifies an instance or occasion of assistance received by a client from a service provider.
Specific Information:
Used to identify the activity provided during a service event. |
CHARACTERSTRING | X(36) |
| start_date | Family: First Service Date, DateTime YYYY-MM-DD |
The date a family started receiving a service. |
DATETIME | YYYY-MM-DD(T00:00:00) |
| start_date_ | FAP_PROCESS: Date, YYYY-MM-DD |
A calculated/constructed field based on an SQL process to assign an aged date relating to the financial year (start/end)
Specific Information:
Calculated start date so invalid dates (those before '2017-06-30') are coded as 'NA'. |
DATE | YYYY-MM-DD |
| step_down_start_date | Family: Step-down start date, Date YYYY-MM-DD |
The date a family stepped down from receiving services, expressed as YYYY-MM-DD.
Specific Information:
Note: Source data has not been cleaned of arbitrary dates (e.g. dates of "1900-01-01").
Lineage details:
|
DATE | YYYY-MM-DD |
| suburb | Person: Locality Name, Text X(50) |
The full name of the locality, suburb or town contained within the specific address of a person, as represented by text. |
ALPHANUMERICSTRING | X(50) |
| unique_id_ | FAP_PROCESS: Identifier, X(20) |
A calculated/constructed field based on an SQL process to assign a unique identifier to an individual or record, as represented by a sequence of characters.
Specific Information:
Unique ID created as paste0(client_auto_id, '-', referral_auto_id, '-', service_auto_id) |
ALPHANUMERICSTRING | X(20) |
| in_fap_data | FAP_PROCESS: Linkage key check, Yes/No Code N |
A calculated/constructed field based on an SQL process to check that a key enabling the matching of two or more records that are believed to belong to the same individual, is present and/or correct, as represented by a numeric code.
Specific Information:
The CYP from Family Preservation data also appears in ChildStory data, that is the two datasets can be matched using ChildStoryID_ |
NUMBERSTRING | N |
| rosh_12m_prior | FAP_PROCESS: ROSH Flag, Yes/No Code N |
A calculated/constructed field based on an SQL process to indicate whether a valid ROSH report is present in the specified data, as represented by a numeric code.
Specific Information:
A ROSH report appears in Child Protection data, matching child_story_id_ within 12 months prior to referral_date_. |
NUMBERSTRING | N |
| concern_12m_prior | FAP_PROCESS: Concern Report, Yes/No Code N |
A calculated/constructed field based on an SQL process to indicate whether a valid Concern report is present in the specified data, as represented by a numeric code.
Specific Information:
A Concern report appears in Child Protection data, matching child_story_id_ within 12 months prior to referral_date_. |
NUMBERSTRING | N |
| fa_12m_flag | FAP_PROCESS: Field Assessment, Yes/No Code N |
A calculated/constructed field based on an SQL process to indicate whether a valid Field Assessment is present in the specified data, as represented by a numeric code.
Specific Information:
A Field Assessment appears in Child Protection data, matching child_story_id_ within 12 months prior to referral_date_ |
NUMBERSTRING | N |
| last_rosh_prior_or_on_ref | FAP_PROCESS: ROSH Flag, DateTime YYYY-MM-DD |
A calculated/constructed field based on an SQL process to indicate whether and when, a valid ROSH report is present in the specified data, as represented by a UTC Date stamp.
Specific Information:
A ROSH report appears in Child Protection data, matching child_story_id_ prior to or on the referral_date_. |
DATETIME | YYYY-MM-DD(T00:00:00) |
| HLA_CYP_ISSUES_FLG_12m_prior_ref | Assessment: Field Issues Flag, Yes/No/NA Code A(A) |
Flag based on presence of any CYP issue in Child Protection Report: Primary Field Assessed Issue (Grouped)
Specific Information:
A Concern Report for a child or young person's behaviour appears in Child Protection data, matching child_story_id_ within 12 months prior to referral_date_. |
ALPHASTRING | A(A) |
| HLA_DV_FLG_12m_prior_ref | Assessment: Domestic Violence Flag, Yes/No/NA Code A(A) |
Flag to indicate the presence of any Domestic Violence issues by an Assessment (Helpline/Field), as represented by yes/no code.
Specific Information:
A Concern Report for the presence of domestic violence appears in Child Protection data, matching child_story_id_ within 12 months prior to referral_date_. |
ALPHASTRING | A(A) |
| HLA_EMOTIONAL_ABUSE_FLG_12m_prior_ref | Assessment: Emotional Abuse Flag, Yes/No/NA Code A(A) |
Flag to indicate the presence of any emotional abuse issues by an Assessment (Helpline/Field), as represented by a yes/no code.
Specific Information:
A Concern Report for the presence of emotional abuse appears in Child Protection data, matching child_story_id_ within 12 months prior to referral_date_. |
ALPHASTRING | A(A) |
| HLA_NEGLECT_FLG_12m_prior_ref | Assessment: Neglect Flag, Yes/No/NA Code A(A) |
Flag to indicate the presence of any neglect issues by an Assessment (Helpline/Field), as represented by a yes/no code.
Specific Information:
A Concern Report for the presence of neglect appears in Child Protection data, matching child_story_id_ within 12 months prior to referral_date_. |
ALPHASTRING | A(A) |
| HLA_PHYSICAL_ABUSE_FLG_12m_prior_ref | Assessment: Physical Abuse Flag, Yes/No/NA Code A(A) |
Flag to indicate the presence of any physical abuse issues by an Assessment (Helpline/Field), as represented by a yes/no code.
Specific Information:
A Concern Report for the presence of physical abuse appears in Child Protection data, matching child_story_id_ within 12 months prior to referral_date_. |
ALPHASTRING | A(A) |
| HLA_SEXUAL_ABUSE_FLG_12m_prior_ref | Assessment: Sexual Abuse Flag, Yes/No/NA Code A(A) |
Flag to indicate the presence of any sexual abuse issues by an Assessment (Helpline/Field), as represented by a yes/no code.
Specific Information:
A Concern Report for the presence of sexual abuse appears in Child Protection data, matching child_story_id_ within 12 months prior to referral_date_. |
ALPHASTRING | A(A) |
| HLA_OTHER_ISSUES_FLG_12m_prior_ref | Assessment: Other Issues Flag, Yes/No/NA Code A(A) |
Flag to indicate the presence of any other issues not covered by other groupings by an Assessment (Helpline/Field), as represented by a yes/no code.
Specific Information:
A Concern Report for the presence of any other issues (e.g., care issues, CYP issues, DV, emotional abuse, neglect, physical abuse, sexual abuse) appears in Child Protection data, matching child_story_id_ within 12 months prior to referral_date_. |
ALPHASTRING | A(A) |
| HLA_CARER_MH_FLG_12m_prior_ref | Assessment: Mental health issues flag, Yes/No/NA Code A(A) |
Flag to indicate the presence of any mental health or psychological issues by an Assessment (Helpline/Field), as represented by a yes/no code.
Specific Information:
A Concern Report for the presence of carer mental health issues appears in Child Protection data, matching child_story_id_ within 12 months prior to referral_date_. |
ALPHASTRING | A(A) |
| HLA_CARER_DRUG_ALC_FLG_12m_prior_ref | Assessment: Alcohol or drug use problem, Yes/No/NA Code A(A) |
Whether a primary parent or carer has a past or current alcohol/drug abuse problem that interferes or interfered with their or the family’s functioning, as represented by a code.
Specific Information:
A Concern Report for the presence of carer drug and alcohol issues appears in Child Protection data, matching child_story_id_ within 12 months prior to referral_date_. |
ALPHASTRING | A(A) |
| oohc_prior_to_ref | FAP_PROCESS: Placement Flag, Yes/No Code N |
A calculated/constructed field based on an SQL process to indicate whether a valid Placement/OOHC is present in the specified data, as represented by a numeric code.
Specific Information:
A matching child_story_id_ appears in Out-of-Home Care data, and the CYP was in OOHC prior to the referral_date_. |
NUMBERSTRING | N |
| oohc_asat_ref | FAP_PROCESS: Placement Flag, Yes/No Code N |
A calculated/constructed field based on an SQL process to indicate whether a valid Placement/OOHC is present in the specified data, as represented by a numeric code.
Specific Information:
A matching child_story_id_ appears in Out-of-Home Care data, and the CYP was in OOHC at the time of the referral_date_. |
NUMBERSTRING | N |
| rosh_3m_post_exit | FAP_PROCESS: ROSH Flag, Yes/No Code N |
A calculated/constructed field based on an SQL process to indicate whether a valid ROSH report is present in the specified data, as represented by a numeric code.
Specific Information:
A ROSH report appears in Child Protection data, matching child_story_id_ within 3 months of exiting Family Preservation exit_date_. |
NUMBERSTRING | N |
| rosh_6m_post_exit | FAP_PROCESS: ROSH Flag, Yes/No Code N |
A calculated/constructed field based on an SQL process to indicate whether a valid ROSH report is present in the specified data, as represented by a numeric code.
Specific Information:
A ROSH report appears in Child Protection data, matching child_story_id_ within 6 months of exiting Family Preservation exit_date_. |
NUMBERSTRING | N |
| rosh_9m_post_exit | FAP_PROCESS: ROSH Flag, Yes/No Code N |
A calculated/constructed field based on an SQL process to indicate whether a valid ROSH report is present in the specified data, as represented by a numeric code.
Specific Information:
A ROSH report appears in Child Protection data, matching child_story_id_ within 9 months of exiting Family Preservation exit_date_. |
NUMBERSTRING | N |
| oohc_3m_post_exit | FAP_PROCESS: Placement Flag, Yes/No Code N |
A calculated/constructed field based on an SQL process to indicate whether a valid Placement/OOHC is present in the specified data, as represented by a numeric code.
Specific Information:
An OOHC placement start date appears in Out-of-Home Care data, matching child_story_id_ within 3 months of exiting Family Preservation exit_date_. |
NUMBERSTRING | N |
| oohc_6m_post_exit | FAP_PROCESS: Placement Flag, Yes/No Code N |
A calculated/constructed field based on an SQL process to indicate whether a valid Placement/OOHC is present in the specified data, as represented by a numeric code.
Specific Information:
An OOHC placement start date appears in Out-of-Home Care data, matching child_story_id_ within 6 months of exiting Family Preservation exit_date_. |
NUMBERSTRING | N |
| oohc_9m_post_exit | FAP_PROCESS: Placement Flag, Yes/No Code N |
A calculated/constructed field based on an SQL process to indicate whether a valid Placement/OOHC is present in the specified data, as represented by a numeric code.
Specific Information:
An OOHC placement start date appears in Out-of-Home Care data, matching child_story_id_ within 9 months of exiting Family Preservation exit_date_. |
NUMBERSTRING | N |