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

Out-of-home care base data asset

Download CSV
Logical Path Data Element Number of Unique Values Uniqueness Score Min Max Average
ChildStoryID Person: ChildStory Identifier, A-N(8) - - - - -
LEGACY_ID Person: Identifier, Legacy Identifier X(15) - - - - -
LEGACY_KIDS_PERSON_NUMBER Person: Identifier, Legacy KIDS Number X(15) - - - - -
FIRST_NAME Person: Given Name, Hashed - - - - -
MIDDLE_NAME Person: Middle Name, Hashed - - - - -
LAST_NAME Person: Family Name, Hashed - - - - -
DOB Person: Date of Birth, Hashed - - - - -
AGE Person: Age, Total Years NNN - - - - -
AGE_AS_AT Person: Age, Total Years NNN - - - - -
GENDER Person: Gender, Label A(20) - - - - -
ABORIGINAL_STATUS Person: Indigenous Status, Label X(40) - - - - -
ABORIGINAL_STATUS_FACS_GROUPED Person: Indigenous Status, FaCS Grouped Label X(14) - - - - -
DISABILITY_FLAG Person: Disability Indicator, Yes/No Code A - - - - -
DISABILITY_DETAILS Person: Disability Details, Hashed - - - - -
COUNTRY_OF_BIRTH Person: Country of Birth, Label X(100) - - - - -
PREFERRED_LANGUAGE Person: Preferred Language, Label X(50) - - - - -
PRIMARY_CULTURAL_BACKGROUND Person: Primary Cultural Background, Label X(25) - - - - -
CURRENT_POSTCODE Person: Australian Postcode, Code NNNN - - - - -
CURRENT_SUBURB Person: Locality Name, Text X(50) - - - - -
SECURED_FLAG Person: Secured Flag, Indicator X(5) - - - - -
PLACEMENT_ID Placement: Placement Identifier, AAA - NNNNNN - - - - -
FLAG_AS_AT_PLACEMENT Placement: Primary Placement Flag, Indicator X(5) - - - - -
PLACEMENT_LEGACY_ID Placement: Placement Identifier, Legacy Placement Identifier X(20) - - - - -
PLACEMENT_RECORD_ID Record: Identifier, X(18) - - - - -
PLACEMENT_STATUS Placement: Status, Label A(10) - - - - -
PLACEMENT_SOURCE_OF_DATA Placement: Data Source, Label A(30) - - - - -
PLACEMENT_START_DATE Service Episode: Start Date, YYYY-MM-DD - - - - -
PLACEMENT_END_DATE Service Episode: End Date, DateTime YYYY-MM-DD - - - - -
PLACEMENT_TYPE Placement: Type, Label A(50) - - - - -
PLACEMENT_TYPE_GROUPED Placement: Type, Grouped Label X(30) - - - - -
PLACEMENT_PURPOSE Service Episode: Placement Purpose, label X(50) - - - - -
PLACEMENT_ENTRY_REASON Placement: Entry Reason, OOHC Label A(50) - - - - -
PLACEMENT_EXIT_REASON Service episode: Service cessation reason, Exit label X(50) - - - - -
PLACEMENT_APP_FLG Placement: Aboriginal Placement Principle, Yes/No Code A - - - - -
TYPE_OF_CAREGIVER_GROUPED Carer household: Caregiver type, group label X(40) - - - - -
TYPE_OF_CAREGIVER Carer household: Caregiver type, label X(40) - - - - -
CARE_CATEGORY Care Category: Placement-Living Arrangement, label X(50) - - - - -
CARE_CATEGORY_START_DATE Care Category: Start Date, DateTime YYYY-MM-DD[Thh:mm:ss] - - - - -
CARE_CATEGORY_END_DATE Care Category: End Date, DateTime YYYY-MM-DD[Thh:mm:ss] - - - - -
LENGTH_OF_TIME_IN_CARE_GROUPED Person: Length of time in care, Group Label X(20) - - - - -
CARE_ARRANGEMENT Care Event: Care Arrangement, OOHC label X(50) - - - - -
CARE_ARRANGEMENT_START_DATE Care Event: Start Date, DateTime YYYY-MM-DD[Thh:mm:ss] - - - - -
CARE_ARRANGEMENT_END_DATE Care Event: End Date, DateTime YYYY-MM-DD[Thh:mm:ss] - - - - -
SERVICE_PROVIDER_ID Organisation: Identifier, A-N(7) - - - - -
PLACEMENT_PROVIDER_NAME_DRVD Organisation: Organisation Name, Text X(200) - - - - -
HH_ACCOUNT_ID Carer Household: Household Identifier, A-N(7) - - - - -
HH_ORGANISATION_NAME Carer Household: Full Name, Hashed - - - - -
HH_ABORIGINAL_STATUS Carer Household: Indigenous Status, Label X(40) - - - - -
HH_PRIMARY_CARER_ID Person: Identifier, X(18) - - - - -
HH_PRIMARY_CARER_REL_TO_CYP Carer Household: Relationship to Child or Young Person, label X(50) - - - - -
LEGAL_ORDER_ID Legal Order: Identifier, AAA - NNNNNN - - - - -
LEGAL_RECORD_TYPE Legal Order: Record type, label A(30) - - - - -
LEGAL_RECORD_STATUS Legal Order: Record status, label A(30) - - - - -
LEGAL_APPROVAL_STATUS Legal Order: Approval status, label A(20) - - - - -
LEGAL_ORDER_START_DATE Legal Order: Start Date, YYYY-MM-DD - - - - -
LEGAL_ORDER_END_DATE Legal Order: End Date, YYYY-MM-DD - - - - -
LEGAL_IMPUTED_END_DATE Legal Order: End Date, YYYY-MM-DD - - - - -
LEGAL_ORDER_TYPE Legal Order: Order type, label A(30) - - - - -
LEGAL_ORDER_LEGAL_BASIS Legal Order: Legal Basis, Label X(150) - - - - -
FLAG_ADOPTION Record: Adoption Flag, Yes/No Code X - - - - -
FLAG_AFTERCARE Record: Aftercare Flag, Yes/No Code X - - - - -
PLACEMENT_ID_AT_ENTRY Record: Identifier, X(18) - - - - -
PLACEMENT_ID_AT_EXIT Record: Identifier, X(18) - - - - -
PR_AT_ENTRY_INTO_CARE_CATEGORY Care Category: Legal Responsibility, Label X(50) - - - - -
PR_AT_EXIT_FROM_CARE_CATEGORY Care Category: Legal Responsibility, Label X(50) - - - - -
PR_GROUPED_AT_ENTRY Care Category: Legal Responsibility, Group Label X(50) - - - - -
PR_GROUPED_AT_EXIT Care Category: Legal Responsibility, Group Label X(50) - - - - -
EXIT_CARE_TYPE Placement: Placement Exit Reason, Label X(16) - - - - -
FLAG_ENTRY_EVENT Placement: Entry Indicator, Yes/No/NA Code A(A) - - - - -
FLAG_EXIT_EVENT Placement: Exit Indicator, Yes/No/NA Code A(A) - - - - -
SEQ_NUMBER_PER_CARE_CATEGORY Care Category: Care sequence number, N(2) - - - - -
DATE_FIRST_TIME_ENTRY_OOHC Service Episode: Start Date, YYYY-MM-DD - - - - -
HASCPO_ORDER_180DAYS_FROM_EXIT Person: New Care and Protection Order, Yes/No Code A(A) - - - - -
AGE_AT_ENTRY_INTO_CARE Person: Age, Total Years NNN - - - - -
AGE_AT_EXIT_FROM_CARE Person: Age, Total Years NNN - - - - -
PLACEMENT_MANAGEMENT Person: Placement Management, label X(20) - - - - -
CASEWORKER_POSITION_NAME Person: Caseworker Position, Text X(200) - - - - -
CASEWORKER_NAME_QUEUE_NAME Person: Caseworker Name, Hashed - - - - -
CLUSTER_NAME Organisation: NSW Department of Communities and Justice District, Cluster Label A(30) - - - - -
AREA Organisation: NSW Department of Communities and Justice District, Area Label A(60) - - - - -
DISTRICT Organisation: NSW Department of Communities and Justice District, Label A(25) - - - - -
BUSINESS_UNIT Organisation: Internal Business Unit, label X(50) - - - - -
CARE_CATEGORY_PR_GROUPED Care Category: Legal Responsibility, Group Label X(50) - - - - -
CARE_CATEGORY_PR_UNGROUPED Care Category: Legal Responsibility, Label X(50) - - - - -
CARER_ABORIGINAL_STATUS Carer household: Indigenous status, Yes/No Code X - - - - -
SOURCE_OF_PLACEMENT_DATA Placement: Data Source, Label A(30) - - - - -
CAT_ASSESSMENT_NUMBER Record: Assessment Number, AAA - NNNNNN - - - - -
CAT_LEGACY_KIDS_ID Person: KiDS Number, Identifier X(14) - - - - -
CAT_SCORE_ASSESSMENT_DATE Client Assessment: Assessment Date, DateTime YYYY-MM-DD[Thh:mm:ss] - - - - -
CAT_APPROVAL_STATUS Client Assessment: CAT Approval Status, Label A(10) - - - - -
CAT_STATUS Client Assessment: CAT Status, Label X(50) - - - - -
CAT_SCORE_OUTCOME_MIGRATED Client Assessment: Assessment Score, CAT Label X(50) - - - - -
CAT_SCORE_OUTCOME_CALCULATED Client Assessment: Assessment Score, CAT Label X(50) - - - - -
CAT_SCORE_OUTCOME_FINAL Client Assessment: Assessment Score, CAT Label X(50) - - - - -
CAT_SCORE Client Assessment: Assessment Score, CAT Label X(50) - - - - -
CASE_MANAGEMENT_RESPONSIBILITY Person: Case Management, Label A(4) - - - - -
OOHC_CASE_PLAN_NUMBER Person: Case Management Plan Identifier, AAA-NNNNNNN - - - - -
OOHC_CASE_PLAN_RECORD_ID Record: Identifier, X(18) - - - - -
OOHC_CASE_PLAN_START_DATE Service Event: Start Date, DateTime YYYY-MM-DD - - - - -
OOHC_CASE_PLAN_END_DATE_DRVD Service Event: End Date, DateTime YYYY-MM-DD - - - - -
PLAN_APPROVAL_STATUS Person: Plan Approval Status, Label X(30) - - - - -
PLAN_OOHC_TYPE Person: OOHC Plan Type, Label X(20) - - - - -
PLAN_GOAL Person: OOHC Plan Goal, Label X(50) - - - - -
PLAN_GOAL_GROUPED Person: OOHC Plan Goal, Group Label X(50) - - - - -
OOHC_VALID_FLAG Record: Valid Report Indicator, Code A - - - - -
PLAN_REVIEW_DATE Person: Case Plan Review, DateTime YYYY-MM-DD - - - - -
PLAN_REASON_FOR_REVIEW Person: Case Plan Review, Reason X(50) - - - - -
PLAN_REVIEW_DECISION Person: Case Plan Review, Decision X(50) - - - - -
PLAN_REASON_FOR_REVIEW_OOHC Person: Case Plan Review, Reason X(50) - - - - -
PLAN_REVIEW_DECISION_OOHC Person: Case Plan Review, Decision X(50) - - - - -
LAST_OOHC_CASE_PLAN_ID Record: Identifier, X(18) - - - - -
PLAN_CHILD_PARTICIPATION Person: Plan Participation, Label X(50) - - - - -
LEAVING_CARE_PLAN Person: Leaving Care Plan, Label X(50) - - - - -
CULTURAL_SUPPORT_PLAN Person: Cultural Support Plan, Label X(50) - - - - -
CASE_RECORD_ID Record: Identifier, X(18) - - - - -
CASE_NUMBER Person: Case Identifier, X(10) - - - - -
CASE_START_DATE Service Event: Start Date, DateTime YYYY-MM-DD - - - - -
CASE_END_DATE Service Event: End Date, DateTime YYYY-MM-DD - - - - -
CASE_CLOSED_DATE Service Event: Case Closed Date, YYYY-MM-DD - - - - -
CASE_TYPE Person: Case Type, Label X(20) - - - - -
CASE_STATUS Person: Case Status, Label X(30) - - - - -
CASE_CLOSURE_REASON Service Event: Case Closure Reason, Label X(50) - - - - -
EXTERNAL_ORG_NAME Organisation: Organisation Name, Text X(200) - - - - -
CIW_STABILITY_INDICATOR_TAG Record: Identifier, X(18) - - - - -
EVENT_START_DT Service Episode: Start Date, YYYY-MM-DD - - - - -
EVENT_END_DT Service Episode: End Date, DateTime YYYY-MM-DD - - - - -
CM_RSP_HIST Person: Case Management, Label A(4) - - - - -
CM_RSP_HIST_DISTRICT Organisation: NSW Department of Communities and Justice District, Label X(40) - - - - -
CM_RSP_HIST_CSC Organisation: Internal Business Unit, Text X(200) - - - - -
CM_RSP_HIST_EXT_AGENCY Organisation: Organisation Name, Text X(200) - - - - -
ETL_RUN_DT Record: DateTime Stamp, YYYY-MM-DD - - - - -
PER_M_START_DT Record: DateTime Stamp, YYYY-MM-DD - - - - -
PER_M_END_DT Record: DateTime Stamp, YYYY-MM-DD - - - - -
PER_NAME_MONTH Record: Date, YYYY / MM - - - - -
AGED_M_START_DT Record: DateTime Stamp, YYYY-MM-DD - - - - -
AGED_M_END_DT Record: DateTime Stamp, YYYY-MM-DD - - - - -
AGED_PER_NAME_MONTH Record: Date, YYYY / MM - - - - -
INGESTTIME Record: DateTime Stamp, YYYY-MM-DD - - - - -
INGESTTYPE Record: Ingest Type, Label A(6) - - - - -
FILENAME Record: Filename, Text X(200) - - - - -
BATCHID Record: Batch Id, Text X(200) - - - - -
LENGTH_OF_TIME_IN_CARE_GROUPED_AS_AT FAP_PROCESS: Length of time in care, Group label X(20) - - - - -
FLAG_PLACEMENT_AS_AT_PER_M_END FAP_PROCESS: Placement Flag, Yes/No Code X - - - - -
FLAG_PLACEMENT_AS_AT_AGED_M_END_DT FAP_PROCESS: Placement Flag, Yes/No Code X - - - - -
FLAG_OOHC_CASE_PLAN_OPEN FAP_PROCESS: Open Status Flag, Yes/No Code X - - - - -
DAYS_IN_PLACEMENT_TO_PERIOD_END FAP_PROCESS: Number of days, N(5) - - - - -
DAYS_IN_CARE_CATEGORY_TO_PERIOD_END FAP_PROCESS: Number of days, N(5) - - - - -
LENGTH_OF_TIME_IN_PLACEMENT_GROUPED FAP_PROCESS: Length of time in placement, Group Label X(20) - - - - -
PLAN_GOAL_GROUPED_PERMANENCY FAP_PROCESS: OOHC Plan Goal, Permanency Group Label X(50) - - - - -
AGE_AT_ENTRY_GROUPED FAP_PROCESS: Age Group, Label X(13) - - - - -
AGED_M_START_DT_FINANCIAL_YEAR_START_DATE FAP_PROCESS: Date, YYYY-MM-DD - - - - -
AGED_M_END_DT_FINANCIAL_YEAR_END_DATE FAP_PROCESS: Date, YYYY-MM-DD - - - - -