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

Child Protection Reporting - Base Data Asset

Download CSV
Logical Path Data Element Number of Unique Values Uniqueness Score Min Max Average
CHILDSTORY_ID Person: ChildStory Identifier, A-N(8) - - - - -
LEGACY_ID Person: KiDS Number, Identifier X(14) - - - - -
LEGACY_KIDS_PERSON_NUMBER Person: KiDS Number, Identifier X(14) - - - - -
FIRST_NAME Person: Given Name, Hashed - - - - -
MIDDLE_NAME Person: Middle Name, Hashed - - - - -
LAST_NAME Person: Family Name, Hashed - - - - -
DOB Person: Date of Birth, YYYY-MM-DD - - - - -
AGE_GROUP Person: Age, NN - - - - -
AGE_AT_CONTACT_GROUPED Person: Age, NN - - - - -
GENDER Person: Gender, Code X(20) - - - - -
ABORIGINAL_STATUS Person: Indigenous Status, Label X(40) - - - - -
ABORIGINAL_STATUS_GROUPED Person: Indigenous Status, Grouped Label X(14) - - - - -
COUNTRY_OF_BIRTH Person: Country of Birth, Label X(100) - - - - -
SECURED_FLAG Person: Secured Flag, Yes/No/NA Code AA - - - - -
DISABILITY_FLAG Person: Disability Indicator, Yes/No Code A - - - - -
DISABILITY_IMPAIRMENT_NATURE Person: Disability Impairment, Hashed - - - - -
DISABILITY_DETAILS Person: Disability Details, Hashed - - - - -
PREFERRED_LANGUAGE Person: Preferred Language, Label X(50) - - - - -
PRIMARY_CULTURAL_BACKGROUND Person: Culturally and Linguistically Diverse (CALD) Background, Text X(50) - - - - -
RESIDENTIAL_POSTCODE Person: Australian Postcode, Code NNNN - - - - -
RESIDENTIAL_SUBURB Person: Locality Name, Text X(50) - - - - -
CONTACT_ID Record: Contact Identifier, N(8) - - - - -
CONTACT_RECORD_ID Record: Contact Record Identifier, X(18) - - - - -
CONTACTOR_TYPE Service Event: Contactor Type, Label X(50) - - - - -
CONTACTOR_TYPE_GROUP Service Event: Contactor Type, Grouped Label X(45) - - - - -
CONTACTOR_REGION Service Event: Contactor Region, Text X(50) - - - - -
CONTACTOR_ROLE Service Event: Contactor Role, Label X(50) - - - - -
MANDATORY_REPORTER Service Event: Mandatory Reporter, Yes/No Label X(3) - - - - -
MANDATORY_REPORTER_DERIVED Service Event: Mandatory Reporter, Yes/No Label X(3) - - - - -
MRG_COMPLETED Service Event: Mandatory Reporter Guide Completed, Yes/No/Not Asked Label A(10) - - - - -
PRIMARY_CONTACT_REASON Service Event: Primary Contact Reason, Label X(40) - - - - -
PRIMARY_CONCERN Service Event: Contact Primary Concern, Label X(100) - - - - -
PRIMARY_CONCERN_GROUPED Service Event: Contact Primary Concern, Grouped Label X(50) - - - - -
CONTACT_ORIGIN Service Event: Contact, Label X(25) - - - - -
SOURCE_OF_NOTIFICATION Service Event: Source of Notification, Label A(50) - - - - -
CONTACT_OUTCOME Service Event: Contact Outcome, Label X(100) - - - - -
CONTACT_START_DATE Service Event: Start Date, DateTime YYYY-MM-DD - - - - -
CONTACT_RECORD_STATUS Service Event: Contact Record Status, Label A(20) - - - - -
CONTACT_APPROVAL_STATUS Service Event: Contact Record Approval Status, Label X(20) - - - - -
POSTCODE_AT_CONTACT Person: Australian Postcode, Code NNNN - - - - -
SUBURB_AT_CONTACT Person: Locality Name, Text X(50) - - - - -
REPORT_WID Record: Identifier, N(8) - - - - -
VALID_REPORT_FLAG Record: Valid Report Flag, Yes/No Code A(A) - - - - -
VALID_CONTACT_FLAG Record: Valid Contact Flag, Yes/No Code A(A) - - - - -
ROSH_FLAG Assessment: ROSH Flag, Yes/No/NA Code A(A) - - - - -
PSEUDO_REPORT_FLAG Service Event: Pseudo Report Flag, Yes/No Code A - - - - -
REREPORT_FLAG Service Event: ReReport Flag, Yes/No/NA Code X - - - - -
SAFETYINCARE_FLAG Assessment: Safety in Care Flag, Yes/No/NA Code A(A) - - - - -
PRIMARY_HL_ASSESSED_ISSUE Assessment: Helpline Primary Issue, Label X(200) - - - - -
PRIMARY_HL_ASSESSED_ISSUE_GRPD Assessment: Helpline Primary Issue, Grouped Label X(50) - - - - -
OTHER_HL_ASSESSED_ISSUES Assessment: Other Assessed Issues, Label X(200) - - - - -
PRIMARY_FA_ASSESSED_ISSUE Assessment: Field Assessment Primary Issue, Label X(200) - - - - -
PRIMARY_FA_ASSESSED_ISSUE_GRPD Assessment: Field Assessment Primary Issue, Grouped Label X(50) - - - - -
OTHER_FA_ASSESSED_ISSUES Assessment: Other Assessed Issues, Label X(200) - - - - -
FACS_ACTUAL_RISK_GRPD Assessment: Field Assessment - Actual Harm or Risk of Harm, ROSH Label X(20) - - - - -
FACS_HARM_TYPE_GRPD Assessment: Field Harm Type, Group Label X(30) - - - - -
SAFET_OUTCOME Service Event: Safety Assessment Outcome, Label X(25) - - - - -
FINAL_RISK_LEVEL Assessment: Risk Level, Label X(22) - - - - -
REPORTED_BY Service Event: Contact Reporter, Label A(40) - - - - -
N1 Service Event: Helpline Contact, N1 Code NX - - - - -
N2 Service Event: Helpline Contact, N2 Code NX - - - - -
N3 Service Event: Helpline Assessment Outcome, Code NX - - - - -
N4 Service Event: Triage Decision Outcome, Code NX(N) - - - - -
N5 Service Event: Field Assessment Outcome, Code NX(N) - - - - -
DITRICT_COMMON Organisation: NSW Department of Communities and Justice District, Label X(40) - - - - -
BUSINESS_UNIT_COMMON Organisation: Internal Business Unit, label X(50) - - - - -
HELPLINE_ASSESSMENT_ID Record: Helpline Assessment ID, XXX-NNNNNNN - - - - -
HLA_RECORD_ID Record: Helpline Assessment ID, XXX-NNNNNNN - - - - -
HLA_START_DATE Service Event: Start Date, DateTime YYYY-MM-DD - - - - -
HELPLINE_ASSESSMENT_STATUS Assessment: Helpline Assessment Status, Label X(10) - - - - -
HLA_APPROVAL_STATUS Assessment: Helpline Approval Status, Label X(25) - - - - -
HLA_CARER_ISSUES_FLG Assessment: Carer Issues Flag, Yes/No/NA Code A(A) - - - - -
HLA_CYP_ISSUES_FLG Assessment: Issues Flag, Yes/No/NA Code A(A) - - - - -
HLA_DV_FLG Assessment: Domestic Violence Flag, Yes/No/NA Code A(A) - - - - -
HLA_EMOTIONAL_ABUSE_FLG Assessment: Emotional Abuse Flag, Yes/No/NA Code A(A) - - - - -
HLA_NEGLECT_FLG Assessment: Neglect Flag, Yes/No/NA Code A(A) - - - - -
HLA_PHYSICAL_ABUSE_FLG Assessment: Physical Abuse Flag, Yes/No/NA Code A(A) - - - - -
HLA_SEXUAL_ABUSE_FLG Assessment: Sexual Abuse Flag, Yes/No/NA Code A(A) - - - - -
HLA_OTHER_ISSUES_FLG Assessment: Other Issues Flag, Yes/No/NA Code A(A) - - - - -
FINAL_SCREENING_RESULT Assessment: Final Screening, Result Label X(50) - - - - -
FINAL_RESPONSE_PRIORITY Service Event: Final Response Priority, Label X(40) - - - - -
RESPONSE_PRIORITY_OVERRIDE_APP Service Event: Response Priority Override, Label A(40) - - - - -
TRANSFER_HL_ID Record: Identifier, A(3)-N(7) - - - - -
TRANSFER_HL_ASSIGNED_DATE Service Event: Report transfer, DateTime YYYY-MM-DD - - - - -
TRANSFER_HL_RECORD_STATUS Service Event: Record Transfer Status, Label X(15) - - - - -
TRANSFER_HL_TO_DISTRICT Service Event: NSW Department of Communities and Justice District, Label X(40) - - - - -
TRANSFER_HL_TO_BUSINESS_UNIT Service Event: Business Unit, Label X(50) - - - - -
TRANSFER_LAST_ID Record: Identifier, A(3)-N(7) - - - - -
TRANSFER_LAST_ASSIGNED_DATE Service Event: Report transfer, DateTime YYYY-MM-DD - - - - -
TRANSFER_LAST_RECORD_STATUS Service Event: Record Transfer Status, Label X(15) - - - - -
TRANSFER_LAST_TO_DISTRICT Service Event: NSW Department of Communities and Justice District, Label X(40) - - - - -
TRANSFER_LAST_TO_BUSINESS_UNIT Service Event: Business Unit, Label X(50) - - - - -
TRIAGE_ID Record: Triage Identifier, X(18) - - - - -
TRIAGE_LEGACY_ID Record: Legacy Triage Identifier, Identifier X(12) - - - - -
TRIAGE_RECORD_ID Record: Triage Identifier, X(18) - - - - -
TRIAGE_RECORD_TYPE Service Event: Triage Record Type, Label A(30) - - - - -
TRIAGE_START_DATE Service Event: Start Date, DateTime YYYY-MM-DD - - - - -
TRIAGE_END_DATE Service Event: End Date, DateTime YYYY-MM-DD - - - - -
TRIAGE_STATUS Service Event: Triage Status, Label A(20) - - - - -
TRIAGE_APPROVAL_STATUS Service Event: Triage Record Approval Status, Label X(20) - - - - -
TRIAGE_BUSINESS_UNIT Organisation: Internal Business Unit, label X(50) - - - - -
TRIAGE_DISTRICT Organisation: NSW Department of Communities and Justice District, Label X(40) - - - - -
TRIAGE_OUTCOME Service Event: Triage Outcome, Label A(20) - - - - -
TRIAGE_DECISION_STATUS Service Event: Triage Decision Status, Label X(30) - - - - -
ALLOCATION_PURPOSE Service Event: Allocation Purpose, Label A(25) - - - - -
CLOSURE_REASON Service Event: Triage Closure Reason, Label X(50) - - - - -
DATE_DECISION_CLOSURE Service Event: Decision Date, YYYY-MM-DD - - - - -
DATE_TRANSFER_DECISION_MADE Service Event: Decision Date, YYYY-MM-DD - - - - -
TRANSFER_PURPOSE Service Event: Transfer Purpose, Text X(50) - - - - -
TRANSFER_TO_BUSINESS_UNIT Service Event: Business Unit, Label X(50) - - - - -
FIELD_ASSESSMENT_ID Record: Field Assessment, Identifier X(19) - - - - -
FA_LEGACY_ID Record: Field Assessment, Identifier X(19) - - - - -
FA_RECORD_ID Record: Field Assessment, Identifier X(19) - - - - -
FA_CREATED_DATE Service Event: Start Date, DateTime YYYY-MM-DD - - - - -
FA_START_DATE Service Event: Start Date, DateTime YYYY-MM-DD - - - - -
FA_END_DATE Service Event: End Date, DateTime YYYY-MM-DD - - - - -
FIELD_ASSESSMENT_STATUS Assessment: Field Assessment Status, Label X(10) - - - - -
FA_APPROVAL_STATUS Assessment: Field Assessment Approval Status, Label A(20) - - - - -
FA_BUSINESS_UNIT Organisation: Internal Business Unit, label X(50) - - - - -
FA_DISTRICT Organisation: NSW Department of Communities and Justice District, Label X(40) - - - - -
FIELD_ASSESSMENT_PATHWAY Service Event: Field Assessment Pathway, Label X(50) - - - - -
FIELD_ASSESSMENT_OUTCOME Service Event: Field Assessment Outcome, Label A(25) - - - - -
REASON_FA_NOT_PROCEEDING Service Event: Reason for Assessment not Proceeding, Label X(50) - - - - -
FA_CARER_ISSUES_FLAG Assessment: Carer Issues Flag, Yes/No/NA Code A(A) - - - - -
FA_CYP_ISSUES_FLAG Assessment: Issues Flag, Yes/No/NA Code A(A) - - - - -
FA_DV_FLAG Assessment: Domestic Violence Flag, Yes/No/NA Code A(A) - - - - -
FA_EMOTIONAL_ABUSE_FLAG Assessment: Emotional Abuse Flag, Yes/No/NA Code A(A) - - - - -
FA_NEGLECT_FLAG Assessment: Neglect Flag, Yes/No/NA Code A(A) - - - - -
FA_PHYSICAL_ABUSE_FLAG Assessment: Physical Abuse Flag, Yes/No/NA Code A(A) - - - - -
FA_SEXUAL_ABUSE_FLAG Assessment: Sexual Abuse Flag, Yes/No/NA Code A(A) - - - - -
FA_OTHER_ISSUES_FLAG Assessment: Other Issues Flag, Yes/No/NA Code A(A) - - - - -
SUBSTANTIATED_STATUS Assessment: Substantiated Status, Label A(20) - - - - -
ALTERNATE_ASSESSMENT_ID Record: Alternative Assessment ID, X(19) - - - - -
AA_PERFORMED_DATE Assessment: Performed Date, YYYY-MM-DD - - - - -
AA_FIRST_SUBMITTED_DATE Assessment: Submitted Date, YYYY-MM-DD - - - - -
ALTERNATE_ASSESSMEN_STATUS Assessment: Assessment Status, Label A(25) - - - - -
AA_APPROVAL_STATUS Assessment: Approval Status, Alternative Assessment Label A(20) - - - - -
AA_BUSINESS_UNIT Organisation: Internal Business Unit, label X(50) - - - - -
AA_DISTRICT Organisation: NSW Department of Communities and Justice District, Label X(40) - - - - -
AA_RISK_LEVEL Assessment: Risk Level, Label X(22) - - - - -
RISK_ASSESSMENT_ID Record: Risk Assessment ID, X(19) - - - - -
RA_PERFORMED_DATE Assessment: Performed Date, YYYY-MM-DD - - - - -
RA_FIRST_SUBMITTED_DATE Assessment: Submitted Date, YYYY-MM-DD - - - - -
RISK_ASSESSMENT_STATUS Assessment: Assessment Status, Label A(25) - - - - -
RA_APPROVAL_STATUS Assessment: Approval Status, Risk-Safety Label X(20) - - - - -
RA_BUSINESS_UNIT Organisation: Internal Business Unit, label X(50) - - - - -
RA_DISTRICT Organisation: NSW Department of Communities and Justice District, Label X(40) - - - - -
RA_FINAL_RISK_LEVEL Assessment: Risk Level, Label X(22) - - - - -
RISK_RE_ASSESSMENT_ID_PRILAST Record: Risk Re Assessment, Identifier N(5) - - - - -
RRA_PERFORMED_DATE Assessment: Performed Date, YYYY-MM-DD - - - - -
RRA_FIRST_SUBMITTED_DATE Assessment: Submitted Date, YYYY-MM-DD - - - - -
RRA_ASSESSMENT_STATUS Assessment: Assessment Status, Label A(25) - - - - -
RRA_APPROVAL_STATUS Assessment: Approval Status, Risk Re-Assessment Label A(20) - - - - -
RRA_BUSINESS_UNIT Organisation: Internal Business Unit, label X(50) - - - - -
RRA_DISTRICT Organisation: NSW Department of Communities and Justice District, Label X(40) - - - - -
RRA_OUTCOME Service Event: Risk Re-Assessment Outcome, Label A(25) - - - - -
RRA_FINAL_RISK_LEVEL Assessment: Risk Level, Label X(22) - - - - -
SAFETY_ASSESSSMENT_ID Record: Safety Assessment, Identifier X(18) - - - - -
ASSESSSMENT_RECORD_ID Record: Assessment Record, Identifier X(18) - - - - -
SA_PERFORMED_DATE Assessment: Performed Date, YYYY-MM-DD - - - - -
SA_FIRST_SUBMITTED_DATE Assessment: Submitted Date, YYYY-MM-DD - - - - -
SA_RECORD_STATUS Service Event: Record Transfer Status, Label X(15) - - - - -
SA_APPROVAL_STATUS Assessment: Approval Status, Risk-Safety Label X(20) - - - - -
SA_BUSINESS_UNIT Organisation: Internal Business Unit, label X(50) - - - - -
SA_DISTRICT Organisation: NSW Department of Communities and Justice District, Label X(40) - - - - -
SA_ASSESSMENT_STATUS Assessment: Assessment Status, Label A(25) - - - - -
ASSESSMENT_TYPE Assessment: Assessment Type, Label A(25) - - - - -
ASSESSMENT_OUTCOME Assessment: Outcome, Label X(70) - - - - -
PROTECTIVE_ACTION_REQUIRED Person: Protective action required, Yes/No/NA Code A(A) - - - - -
RMD_PROTECTIVE_ACTION_REQUIRED Person: Protective action required, Yes/No/NA Code A(A) - - - - -
CASE_NUMBER Person: Case Identifier, X(10) - - - - -
CASE_RECORD_ID Record: Identifier, X(18) - - - - -
CASE_LEGACY_ID Person: KiDS Number, Identifier X(14) - - - - -
CASE_CREATED_DATE Service Event: Start Date, DateTime YYYY-MM-DD - - - - -
CASE_START_DATE Service Event: Start Date, DateTime YYYY-MM-DD - - - - -
CASE_END_DATE Service Event: End Date, DateTime YYYY-MM-DD - - - - -
CASE_BUSINESS_UNIT_AGENCYNAME Service Event: Business Unit, Label X(50) - - - - -
CASE_DISTRICT_PARENTAGENCY Service Event: NSW Department of Communities and Justice District, Label X(40) - - - - -
CASE_TYPE Person: Case Type, Label X(20) - - - - -
CASE_CLOSURE_REASON Service Event: Case Closure Reason, Label X(50) - - - - -
CASE_STATUS Person: Case Status, Label X(30) - - - - -
CALD_FLAG Person: Culturally and Linguistically Diverse (CALD), Yes/No Code A - - - - -
CYP_RECORD_ID Record: Identifier, X(18) - - - - -
SHS_HYAP_REPORTING_UNACCOMPANI Person: Presenting Alone Indicator, Yes/No/NA Label A(3) - - - - -
ETL_RUN_DT Record: DateTime Stamp, YYYY-MM-DD - - - - -
AGED_M_START_DT Record: DateTime Stamp, YYYY-MM-DD - - - - -
AGED_M_START_DT_FINANCIAL_YEAR_START_DATE FAP_PROCESS: Date, YYYY-MM-DD - - - - -
AGED_M_END_DT Record: DateTime Stamp, YYYY-MM-DD - - - - -
AGED_M_END_DT_FINANCIAL_YEAR_END_DATE FAP_PROCESS: Date, YYYY-MM-DD - - - - -
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) - - - - -