Conceptual Variable
Name
Children
en-NZ
Label
Children
en-NZ
Concept
Children
en-NZ
| Dataset | Variable |
|---|
No variables to compare
-
Children - Children
- [otfs_cid_birth_month_nbr] - SNZ Birth Month
- [otfs_cid_birth_year_nbr] - SNZ Birth Year
- [otfs_cid_child_surname_imputed] - OTFS Name Imputation Indicator
- [otfs_snz_sex_code] - SNZ Sex
- [snz_otfs_uid] - SNZ OTFS Identifier
- [education_yn] - CYF Education Needs Indicator
- [health_yn] - CYF Health Needs Indicator
- [need_category_code] - CYF Need Category
- [need_selection_type_code] - CYF Need Selection Type
- [need_type_code] - CYF Need Type
- [needs_cat_desc] - CYF Need Category Description
- [needs_created_date] - CYF Needs Created Date
- [needs_desc] - CYF Needs Type Description
- [earlst_atnd_hlth_asmt_apt_date] - CYF Earliest Attended Health Assessment Date
- [edn_profile_received_date] - CYF Education Profile Received Date
- [edn_profile_requested_date] - CYF Education Profile Requested Date
- [extract_date] - CYF Extracted Date
- [gw_referral_date] - CYF Gateway Referral Date
- [gw_referral_source] - CYF Gateway Referral Source
- [hlth_asmnt_report_upload_date] - CYF Health Assessment Report Upload Date
- [isa_file_uploaded_date] - CYF Inter-agency Service Agreement Upload Date
- [mdc_meeting_completed_yn] - CYF Multi-disciplinary Clinical Meeting Completed Indicator
- [mdc_meeting_date] - CYF Multi-disciplinary Clinical Meeting Date
- [mdc_meeting_needed_yn] - CYF Multi-disciplinary Clinical Meeting Needed Indicator
- [snz_current_prsn_uid] - SNZ Current Person Identifier
- [snz_gateway_uid] - SNZ CYF Gateway Identifier
- [snz_swp_uid] - SNZ CYF Social Work Phase Identifier
- [cyf_lse_direct_daily_gross_amt] - CYF Direct Daily Gross Amount
- [cyf_lse_direct_daily_nett_amt] - CYF Direct Daily Nett Amount
- [cyf_lse_event_from_date_wid_date] - CYF Event From Date Warehouse ID Lookup
- [cyf_lse_event_from_datetime] - CYF Event From Date
- [cyf_lse_event_to_date_wid_date] - CYF Event To Date Warehouse ID Lookup
- [cyf_lse_event_to_datetime] - CYF Event To Date
- [cyf_lse_event_type_wid_nbr] - CYF Event Type Warehouse ID Lookup
- [cyf_lse_extracted_datetime] - CYF Extracted Date
- [cyf_lse_indirect_daily_gross_amt] - CYF Indirect Daily Gross Amount
- [cyf_lse_indirect_daily_nett_amt] - CYF Indirect Daily Nett Amount
- [cyf_lse_number_of_days_nbr] - CYF Number of Days
- [cyf_lsd_business_area_type_code] - CYF Business Area
- [cyf_lsd_comp_dq_value_wid_nbr] - CYF Data Quality Warehouse ID Lookup
- [cyf_lsd_court_result_type_code] - CYF Court Result Type
- [cyf_lsd_custody_group_text] - CYF Custody Group
- [cyf_lsd_extracted_datetime] - CYF Extracted Date
- [cyf_lsd_in_custody_ind] - CYF In Custody Indicator
- [cyf_lsd_in_favour_of_type_code] - CYF Legal Status In Favour Of Type
- [cyf_lsd_legal_status_code] - CYF Legal Status Code
- [cyf_lsd_legal_status_group_text] - CYF Legal Status Group
- [cyf_lsd_logically_deleted_ind] - CYF Logically Deleted Indicator
- [cyf_lsd_output_class_code] - CYF Output Class
- [cyf_fwe_direct_daily_gross_amt] - CYF Direct Daily Gross Amount
- [cyf_fwe_direct_daily_nett_amt] - CYF Direct Daily Nett Amount
- [cyf_fwe_event_from_date_wid_date] - CYF Event From Date Warehouse ID Lookup
- [cyf_fwe_event_from_datetime - CYF Event From Date
- [cyf_fwe_event_to_date_wid_date] - CYF Event To Date Warehouse ID Lookup
- [cyf_fwe_event_to_datetime] - CYF Event To Date
- [cyf_fwe_event_type_wid_nbr] - CYF Event Type Warehouse ID Lookup
- [cyf_fwe_extracted_datetime] - CYF Extracted Date
- [cyf_fwe_indirect_daily_gross_amt] - CYF Indirect Daily Gross Amount
- [cyf_fwe_indirect_daily_nett_amt] - CYF Indirect Daily Nett Amount
- [cyf_fwe_number_of_days_nbr] - CYF Number of Days
- [cyf_fwd_business_area_type_code] - CYF Business Area
- [cyf_fwd_comp_dq_value_wid_nbr] - CYF Data Quality Warehouse ID Lookup
- [cyf_fwd_extracted_datetime] - CYF Extracted Date
- [cyf_fwd_review_due_date] - CYF Review Due Date
- [snz_composite_event_uid] - SNZ Composite Event Identifier
- [snz_cyf_social_work_phase_id_nbr] - SNZ CYF Social Phase Identifier
- [snz_org_unit_uid] - SNZ Organisation Unit Identifier
- [cyf_cli_caller_role_text] - CYF Caller Role
- [cyf_cli_client_status_text] - CYF Client Status
- [cyf_cli_cr_created_datetime] - CYF Created Date
- [cyf_cli_cr_id_nbr] - CYF Contact Record ID
- [cyf_cli_extracted_datetime] - CYF Extracted Date
- [cyf_cli_family_violence_ind] - CYF Family Violence Indicator
- [cyf_cli_phase_role_text] - CYF Phase Role
- [cyf_cli_section_15_ind] - CYF Section 15 Indicator
- [cyf_cli_smacking_ind] - CYF Smacking Indicator
- [cyf_cli_source_uk_var_1_text] - CYF Notification Record ID
- [cyf_fva_activity_type_code] - CYF Activity Type
- [cyf_fva_btd_date] - CYF Batch Transfer Date
- [cyf_fva_business_area_type_code] - CYF Business Area
- [cyf_fva_clients_per_event_nbr] - CYF Count
- [cyf_fva_cost_centre_code] - CYF Cost Centre
- [cyf_fva_cost_sub_type_text] - CYF Cost Subtype
- [cyf_fva_cost_type_text] - CYF Cost Type
- [cyf_fva_days_in_period_nbr] - CYF Days in Period
- [cyf_fva_event_from_date_wid_date] - CYF Event From Date Warehouse ID Lookup
- [cyf_fva_event_to_date_wid_date] - Event To Date Warehouse ID Lookup
- [cyf_fva_event_type_wid_nbr] - CYF Event Type Warehouse ID
- [cyf_fva_extracted_datetime] - CYF Extracted Date
- [cyf_fva_fin_item_type_code] - CYF Financial Item Type
- [cyf_fva_fin_item_type_text] - CYF Financial Item Description
- [cyf_fva_fin_year_end_date] - CYF Financial Year End Date
- [cyf_fva_gl_accnt_type_code_nbr] - CYF General Ledger Account Type
- [cyf_fva_gross_amt] - CYF Gross Amount
- [cyf_fva_gst_amt] - CYF GST Amount
- [cyf_fva_indirect_cost_amt] - CYF Indirect Daily Amount
- [cyf_fva_indirect_cost_prd_amt] - CYF Indirect Period Amount
- [cyf_fva_month_ending_date] - CYF Month Ending Date
- [cyf_fva_net_amt] - CYF Net Amount
- [cyf_fva_number_of_days_nbr] - CYF Number of Days
- [cyf_fva_period_end_date] - CYF Period End Date
- [cyf_fva_period_start_date] - CYF Period Start Date
- [cyf_fva_sw_activity_type_code] - CYF Social Work Activity Type
- [snz_prsn_uid] - SNZ MSD System Person Identifier
- [cyf_cec_business_area_type_code] - CYF Business Area
- [cyf_cec_clients_per_event_nbr] - CYF Count
- [cyf_cec_contrib_row_count_nbr] - CYF Contributing Row Count
- [cyf_cec_creation_datetime] - CYF Created Date
- [cyf_cec_data_quality_flag_nbr] - CYF Data Quality Flag
- [cyf_cec_data_quality_issue_code] - CYF Data Quality Issue Indicator
- [cyf_cec_derived_payment_date] - CYF Derived Payment Date
- [cyf_cec_direct_gross_amt] - CYF Direct Daily Gross Amount
- [cyf_cec_direct_net_amt] - CYF Direct Daily Nett Amount
- [cyf_cec_event_duration_nbr] - CYF Event Duration
- [cyf_cec_event_end_date] - CYF Event End Date
- [cyf_cec_event_nature_code] - CYF Event Nature
- [cyf_cec_event_start_date] - CYF Event Start Date
- [cyf_cec_event_type_specific_text] - CYF Event Type Specific
- [cyf_cec_event_type_text] - CYF Event Type
- [cyf_cec_fin_item_code] - CYF Financial Item
- [cyf_cec_fin_item_desc_text] - CYF Financial Item Description
- [cyf_cec_fp_end_date] - CYF Financial Period End Date
- [cyf_cec_fp_start_date] - CYF Financial Period Start Date
- [cyf_cec_group_event_end_date] - CYF Group End Date
- [cyf_cec_group_event_start_date] - CYF Group Start Date
- [cyf_cec_group_type_specific_text] - CYF Group Type Specific
- [cyf_cec_indirect_gross_amt] - CYF Indirect Daily Gross Amount
- [cyf_cec_indirect_net_amt] - CYF Indirect Daily Nett Amount
- [cyf_spe_count_nbr] - CYF Count
- [cyf_spe_direct_daily_gross_amt] - CYF Direct Daily Gross Amount
- [cyf_spe_direct_daily_nett_amt] - CYF Direct Daily Nett Amount
- [cyf_spe_event_from_date_wid_date] - CYF Event From Date Warehouse ID Lookup
- [cyf_spe_event_from_datetime] - CYF Event From Date
- [cyf_spe_event_to_date_wid_date] - CYF Event To Date Warehouse ID Lookup
- [cyf_spe_event_to_datetime] - CYF Event To Date
- [cyf_spe_event_type_wid_nbr] - CYF Event Type Warehouse ID Lookup
- [cyf_spe_extracted_datetime] - CYF Extracted Date
- [cyf_spe_indirect_daily_gross_amt] - CYF Indirect Daily Gross Amount
- [cyf_spe_indirect_daily_nett_amt] - CYF Indirect Daily Nett Amount
- [cyf_spe_number_of_days_nbr] - CYF Number of Days
- [cyf_spe_source_uk_var1_text] - CYF Allocation ID
- [cyf_spe_source_uk_var2_text] - CYF No Data
- [cyf_spe_source_uk_var3_text] - CYF No Data
- [cyf_spe_source_uk_var4_text] - CYF No Data
- [cyf_spe_source_uk_var5_text] - CYF No Data
- [cyf_spe_source_uk_var6_text] - CYF No Data
- [cyf_sre_count_nbr] - CYF Count
- [cyf_sre_direct_daily_gross_amt] - CYF Direct Daily Gross Amount
- [cyf_sre_direct_daily_nett_amt] - CYF Direct Daily Nett Amount
- [cyf_sre_event_from_date_wid_date] - CYF Event From Date and Warehouse ID Lookup
- [cyf_sre_event_from_datetime] - CYF Event From Date
- [cyf_sre_event_to_date_wid_date] - CYF Event To Date and Warehouse ID Lookup
- [cyf_sre_event_to_datetime] - CYF Event To Date
- [cyf_sre_event_type_wid_nbr] - CYF Event Type Lookup Warehouse ID
- [cyf_sre_extracted_datetime] - CYF Extracted Date
- [cyf_sre_indirect_daily_gross_amt] - CYF Indirect Daily Gross Amount
- [cyf_sre_indirect_daily_nett_amt] - CYF Indirect Daily Nett Amount
- [cyf_sre_number_of_days_nbr] - CYF Number of Days
- [cyf_sre_source_uk_var1_text] - CYF Safety Assessment ID
- [cyf_sre_source_uk_var2_text] - CYF Intake Event ID
- [cyf_sre_source_uk_var3_text] - CYF No Data
- [cyf_sre_source_uk_var4_text] - CYF No Data
- [cyf_sre_source_uk_var5_text] - CYF No Data
- [cyf_sre_source_uk_var6_text] - CYF No Data
- [cyf_srd_activity_approval_code] - CYF Activity Approval
- [cyf_srd_assoc_intake_evnt_id_nbr] - CYF Earliest Associated Intake Event ID
- [cyf_srd_business_area_type_code] - CYF Business Area
- [cyf_srd_comp_dq_value_wid_nbr] - CYF Data Quality Lookup Code
- [cyf_srd_extracted_datetime] - CYF Extracted Date
- [cyf_srd_final_urg_type_code] - CYF Final Urgency Type
- [cyf_srd_intake_event_id_nbr] - CYF Intake Event ID
- [cyf_srd_intake_found_ind] - CYF Intake Found Indicator
- [cyf_srd_safety_assess_id_nbr] - CYF Safety Assessment ID
- [cyf_pre_count_nbr] - CYF Count
- [cyf_pre_direct_daily_gross_amt] - CYF Direct Daily Gross Amount
- [cyf_pre_direct_daily_nett_amt] - CYF Direct Daily Nett Amount
- [cyf_pre_event_from_date_wid_date] - CYF Event From Date (Join)
- [cyf_pre_event_from_datetime] - CYF Event From Date
- [cyf_pre_event_to_date_wid_date] - CYF Event To Date (Join)
- [cyf_pre_event_to_datetime] - CYF Event To Date
- [cyf_pre_event_type_wid_nbr] - CYF Event Type Identifier
- [cyf_pre_extracted_datetime] - CYF Extracted Date
- [cyf_pre_indirect_daily_gross_amt] - CYF Indirect Daily Gross Amount
- [cyf_pre_indirect_daily_nett_amt] - CYF Indirect Daily Nett Amount
- [cyf_pre_number_of_days_nbr] - CYF Number of Days
- [cyf_pre_source_uk_var2_text] - CYF No Data
- [cyf_pre_source_uk_var3_text] - CYF No Data
- [cyf_pre_source_uk_var4_text] - CYF No Data
- [cyf_pre_source_uk_var5_text - CYF No Data
- [cyf_pre_source_uk_var6_text] - CYF No Data
- [cyf_prd_business_area_type_code] - CYF Business Area
- [cyf_prd_comp_dq_value_wid_nbr] - CYF Data Quality
- [cyf_prd_extracted_datetime_text] - CYF Extracted Date
- [cyf_prd_phase_status_code] - CYF Phase Status
- [cyf_ive_count_nbr] - CYF Count
- [cyf_ive_direct_daily_gross_amt] - CYF Direct Daily Gross Amount
- [cyf_ive_direct_daily_nett_amt] - CYF Direct Daily Nett Amount
- [cyf_ive_event_from_date_wid_date] - CYF Event From Date (Join)
- [cyf_ive_event_from_datetime] - CYF Event From Date
- [cyf_ive_event_to_date_wid_date] - CYF Event To Date (Join)
- [cyf_ive_event_to_datetime] - CYF Event To Date
- [cyf_ive_event_type_wid_nbr] - CYF Event Type Identifier
- [cyf_ive_extracted_datetime] - CYF Extracted Date
- [cyf_ive_indirect_daily_gross_amt] - CYF Indirect Daily Gross Amount
- [cyf_ive_indirect_daily_nett_amt] - CYF Indirect Daily Nett Amount
- [cyf_ive_number_of_days_nbr] - CYF Number of Days
- [cyf_ive_source_uk_var2_text] - CYF Social Work Phase Identifier
- [cyf_ive_source_uk_var3_text] - CYF Assessment Identifier
- [cyf_ive_source_uk_var4_text] - CYF No Data
- [cyf_ive_source_uk_var5_text] - CYF No Data
- [cyf_ive_source_uk_var6_text] - CYF No Data
- [cyf_ivd_assessment_id_nbr] - CYF Assessment Identifier
- [cyf_ivd_business_area_type_code] - CYF Business Area
- [cyf_ivd_comp_dq_value_wid_nbr] - CYF Composite Data Quality Value
- [cyf_ivd_extracted_datetime] - CYF Extracted Date
- [cyf_ivd_outcome_type_code] - CYF Outcome Type
- [cyf_to_calendar_date] - CYF Event Calendar End Date
- [cyf_to_calendar_month_nbr] - CYF Calendar Month
- [cyf_to_calendar_quarter_nbr] - CYF Calendar Quarter
- [cyf_to_calendar_year_nbr] - CYF Calendar Year
- [cyf_to_date_number_format_nbr] - CYF Date Number Format
- [cyf_to_date_wid_date] - CYF To Date (Join)
- [cyf_to_day_in_week_nbr] - CYF Weekday Number
- [cyf_to_day_name_text] - CYF Weekday Name
- cyf_to_extracted_datetime] - CYF Extracted Date
- [cyf_to_fiscal_month_nbr] - CYF Fiscal Month
- [cyf_to_fiscal_quarter_nbr] - CYF Fiscal Quarter
- [cyf_to_fiscal_year_quarter_text] - CYF Fiscal Year/Quarter
- [cyf_to_fiscal_year_text] - CYF Fiscal Year
- [cyf_to_holiday_ind] - CYF Public Holiday Indicator
- [cyf_to_month_name_text] - CYF Month Name
- [cyf_to_weekend_ind] - CYF Weekend Indicator
- [cyf_to_year_quarter_text] - CYF Year/Quarter
- [cyf_frm_calendar_date] - CYF Event Calendar Start Date
- [cyf_frm_calendar_month_nbr] - CYF Calendar Month
- [cyf_frm_calendar_quarter_nbr] - CYF Calendar Quarter
- [cyf_frm_calendar_year_nbr] - CYF Calendar Year
- [cyf_frm_date_number_format_nbr] - CYF Date Number Format
- [cyf_frm_date_wid_date] - CYF From Date (Join)
- [cyf_frm_day_in_week_nbr] - CYF Weekday Number
- [cyf_frm_day_name_text] - CYF Weekday Name
- [cyf_frm_extracted_datetime] - CYF Extracted Date
- [cyf_frm_fiscal_month_nbr] - CYF Fiscal Month
- [cyf_frm_fiscal_quarter_nbr] - CYF Fiscal Quarter
- [cyf_frm_fiscal_year_quarter_text] - CYF Fiscal Year/Quarter
- [cyf_frm_fiscal_year_text] - CYF Fiscal Year
- [cyf_frm_holiday_ind] - CYF Public Holiday Indicator
- [cyf_frm_month_name_text] - CYF Month Name
- [cyf_frm_weekend_ind] - CYF Weekend Indicator
- [cyf_frm_year_quarter_text] - CYF Year/Quarter
- [cyf_soc_ethnic_1_code] - CYF Ethnicity 1
- [cyf_soc_ethnic_2_code] - CYF Ethnicity 2
- [cyf_soc_ethnic_3_code] - CYF Ethnicity 3
- [cyf_soc_ethnic_4_code] - CYF Ethnicity 4
- [cyf_soc_ethnic_5_code] - CYF Ethnicity 5
- [cyf_soc_ethnic_6_code] - CYF Ethnicity 6
- [cyf_soc_ethnic_asian_ind] - CYF Asian Ethnicity Indicator
- [cyf_soc_ethnic_european_ind] - CYF European Ethnicity Indicator
- [cyf_soc_ethnic_grp1_snz_ind] - SNZ European Ethnicity Indicator
- [cyf_soc_ethnic_grp2_snz_ind] - SNZ Maori Ethnicity Indicator
- [cyf_soc_ethnic_grp3_snz_ind] - SNZ Pacific Peoples Ethnicity Indicator
- [cyf_soc_ethnic_grp4_snz_ind] - SNZ Asian Ethnicity Indicator
- [cyf_soc_ethnic_grp5_snz_ind] - SNZ MELAA Ethnicity Indicator
- [cyf_soc_ethnic_grp6_snz_ind] - SNZ Other Ethnicity Indicator
- [cyf_soc_ethnic_maori_ind] - CYF Maori Ethnicity Indicator
- [cyf_soc_ethnic_melaa_ind] - CYF MELAA Ethnicity Indicator
- [cyf_soc_ethnic_other_ind] - CYF Other Ethnicity Indicator
- [cyf_soc_ethnic_pacific_ind] - CYF Pacific Peoples Ethnicity Indicator
- [cyf_soc_ethnic_residual_ind] - CYF Maori Residual Ethnicity Indicator
- [cyf_soc_ethnic1_snz_code] - SNZ Ethnicity 1
- [cyf_soc_ethnic2_snz_code] - SNZ Ethnicity 2
- [cyf_soc_ethnic3_snz_code] - SNZ Ethnicity 3
- [cyf_soc_ethnic4_snz_code] - SNZ Ethnicity 4
- [cyf_soc_ethnic5_snz_code] - SNZ Ethnicity 5
- [cyf_soc_ethnic6_snz_code] - SNZ Ethnicity 6
- [cyf_soc_extracted_datetime] - CYF Extracted Date
- [cyf_idc_birth_month_nbr] - SNZ Birth Month
- [cyf_idc_birth_year_nbr] - SNZ Birth Year
- [cyf_idc_death_month_nbr] - SNZ Death Month
- [cyf_idc_death_year_nbr] - SNZ Death Year
- [cyf_idc_extracted_datetime] - CYF Extracted Date
- [cyf_idc_identity_type_text] - CYF Identity Type
- [cyf_idc_role_type_text] - CYF Role Type
- [cyf_idc_sex_code] - SNZ Sex
- [cyf_idc_source_system_code] - CYF Source System
- [cyf_idc_systm_persn_id_var_text] - CYF System Person Identifier Name
- [snz_crnt_systm_prsn_uid] - SNZ Current System Person Identifier
- [snz_from_msd_uid] - SNZ Distinct Record Identifier
- [cyf_ple_count_nbr] - CYF Count
- [cyf_ple_direct_daily_gross_amt] - CYF Direct Daily Gross Amount
- [cyf_ple_direct_daily_nett_amt] - CYF Direct Daily Nett Amount
- [cyf_ple_event_from_date_wid_date] - CYF Event From Date (Join)
- [cyf_ple_event_from_datetime] - CYF Event From Date
- [cyf_ple_event_to_date_wid_date] - CYF Event To Date (Join)
- [cyf_ple_event_to_datetime] - CYF Event To Date
- [cyf_ple_event_type_wid_nbr] - CYF Event Type
- [cyf_ple_extracted_datetime] - CYF Extracted Date
- [cyf_ple_indirect_daily_gross_amt] - CYF Indirect Daily Gross Amount
- [cyf_ple_indirect_daily_nett_amt] - CYF Indirect Daily Nett Amount
- [cyf_ple_number_of_days_nbr] - CYF Number of Days
- [cyf_ple_source_uk_var1_text] - CYF Placement Identifier
- [cyf_ple_source_uk_var2_text] - CYF No Data
- [cyf_ple_source_uk_var3_text] - CYF No Data
- [cyf_ple_source_uk_var4_text] - CYF No Data
- [snz_systm_prsn_uid] - SNZ MSD System Person Identifier
- [cyf_plc_extracted_datetime] - CYF Extracted Date
- [cyf_plc_respite_ind] - CYF Respite Indicator
- [cyf_plc_rsrc_id_nbr] - CYF Resource Identifier
- [cyf_plc_source_uk_var1_text] - CYF Placement Identifier
- [cyf_pld_business_area_type_code] - CYF Business Area
- [cyf_pld_extracted_datetime] - CYF Extracted Date
- [cyf_pld_full_time_ind] - CYF Full-time Placement Indicator
- [cyf_pld_open_suspension_date] - CYF Open Suspension Date
- [cyf_pld_open_suspension_ind] - CYF Open Suspension Indicator
- [cyf_pld_output_class_code] - CYF Output Class
- [cyf_pld_placement_type_code] - CYF Placement Type
- [cyf_ine_count_nbr] - CYF Count
- [cyf_ine_direct_daily_gross_amt] - CYF Daily Direct Gross Amount
- [cyf_ine_direct_daily_nett_amt] - CYF Direct Daily Nett Amount
- [cyf_ine_event_from_date_wid_date] - CYF Event From Date (Join)
- [cyf_ine_event_from_datetime] - CYF Event From Date
- [cyf_ine_event_to_date_wid_date] - CYF Event To Date (Join)
- [cyf_ine_event to_datetime] - CYF Event To Date
- [cyf_ine_event_type_wid_nbr] - CYF Event Type
- [cyf_ine_extracted_datetime] - CYF Extracted Date
- [cyf_ine_indirect_daily_gross_amt] - CYF Indirect Daily Gross Amount
- [cyf_ine_indirect_daily_nett_amt] - CYF Indirect Daily Nett Amount
- [cyf_ine_number_of_days_nbr] - cyf_ ine_number_of_days_nbr
- [cyf_ine_source_uk_var1_text] - CYF Notification Record Identifier
- [cyf_ine_source_uk_var2_text] - CYF No Data
- [cyf_ine_source_uk_var3_text] - CYF No Data
- [cyf_ine_source_uk_var4_text] - CYF No Data
- [cyf_ind_business_area_type_code] - CYF Business Area
- [cyf_ind_cnp_notification_ind] - CYF Care and Protection Indicator
- [cyf_ind_contact_method_code] - CYF Contact Method
- [cyf_ind_extracted_datetime] - CYF Extracted Date
- [cyf_ind_fgc_referral_ind] - CYF Family Group Conference Indicator
- [cyf_ind_final_outcome_actn_code] - CYF Final Outcome Action
- [cyf_ind_final_outcome_type_code] - CYF Final Outcome Type
- [cyf_ind_final_urgency_type_code] - CYF Final Urgency Type
- [cyf_ind_intake_ref_status_code] - CYF Intake Referral Status
- [cyf_ind_intake_type_code] - CYF Intake Type
- [cyf_ind_notifier_role_type] - CYF Notifier Role Type
- [snz_crnt_org_unit_uid] - SNZ Current Organisation Unit Identifier
- [snz_rcvd_org_unit_uid] - SNZ Received Organisation Unit Identifier
- [snz_refrd_org_unit_uid] - SNZ Referred Organisation Unit Identifier
- [cyf_abe_count_nbr] - CYF Abuse Event Count
- [cyf_abe_direct_daily_gross_amt] - CYF Direct Daily Gross Amount
- [cyf_abe_direct_daily_nett_amt] - CYF Direct Daily Nett Amount
- [cyf_abe_event_from_date_wid_date] - CYF Event From Date (Join)
- [cyf_abe_event_from_datetime] - CYF Event From Date
- [cyf_abe_event_to_date_wid_date] - CYF Event To Date (Join)
- [cyf_abe_event_to_datetime] - CYF Event To Date
- [cyf_abe_event_type_wid_nbr] - CYF Event Type
- [cyf_abe_extracted_datetime] - CYF Extracted Date
- [cyf_abe_indirect_daily_gross_amt] - CYF Indirect Daily Gross Amount
- [cyf_abe_indirect_daily_nett_amt] - CYF Indirect Daily Nett Amount
- [cyf_abe_number_of_days_nbr] - CYF Number of Days
- [cyf_abe_source_uk_var1_text] - CYF Assessment ID
- [cyf_abe_source_uk_var2_text] - CYF Assessment Finding Type
- [cyf_abe_source_uk_var4_text] - CYF Source 4
- [snz_uk_var3_uid] - SNZ CYF Perpetrator Person ID
- [cyf_abd_business_area_type_code] - CYF Business Area
- [cyf_abd_extracted_datetime] - CYF Extracted Date
- [snz_perp_prsn_uid] - SNZ Perpetrator Identifier
- [cap_ref_agency_text] - CAP Referral Agency (Published)
- [cap_ref_comment_text] - CAP Referral Comments
- [cap_ref_escalation_reason_code] - CAP Escalation Reason
- [cap_ref_exit_date] - CAP Exit Date
- [cap_ref_exit_reason_text] - CAP Exit Reason
- [cap_ref_more_info_req_code] - CAP Further Information
- [cap_ref_na_reason_code] - CAP N/A Reason
- [cap_ref_presented_date] - CAP Presented Date
- [cap_ref_quality_code] - CAP Quality
- [cap_ref_received_ct_date] - CAP CT Received Date
- [cap_ref_received_date] - CAP Received Date
- [cap_ref_referral_count_nbr] - CAP Referral Count
- [cap_ref_referral_status_code] - CAP Referral Status
- [cap_ref_role_text] - CAP Role
- [cap_ref_sector_code] - CAP Sector
- [cap_ref_signed_date] - CAP Signed Date
- [cap_ref_sp_completed_date] - CAP Safety Plan Completed Date
- [cap_ref_sp_reason_text] - CAP Safety Plan Reason
- [cap_ref_status_code] - CAP Status
- [snz_cap_team_uid] - SNZ CAP Team Identifier
- [cap_dem_age_type_code] - CAP Child Referral Age (Published)
- [cap_dem_birth_month_nbr] - SNZ Birth Month (Published)
- [cap_dem_birth_year_nbr] - SNZ Birth Year (Published)
- [cap_dem_child_disabilities_code] - CAP Child Disabilities (Published)
- [cap_dem_children_no_referral_nbr] - CAP Children With No Referral
- [cap_dem_drug_alcohol_code] - CAP Drug & Alcohol Issues
- [cap_dem_ethnic_grp1_snz_uid] - SNZ European Ethnicity Indicator
- [cap_dem_ethnic_grp2_snz_uid] - SNZ Maori Ethnicity Indicator
- [cap_dem_ethnic_grp3_snz_ind] - SNZ Pacific Peoples Ethnicity Indicator
- [cap_dem_ethnic_grp4_snz_uid] - SNZ Asian Ethnicity Indicator
- [cap_dem_ethnic_grp5_snz_uid] - SNZ MELAA Ethnicity Indicator
- [cap_dem_ethnic_grp6_snz_uid] - SNZ Other Ethnicity Indicator
- [cap_dem_ethnic1_snz_code] - SNZ Ethnicity 1
- [cap_dem_ethnic2_snz_uid] - SNZ Ethnicity 2
- [cap_dem_ethnicity_1_code] - CAP Ethnicity 1
- [cap_dem_ethnicity_2_code] - CAP Ethnicity 2
- [cap_dem_family_violence_code] - CAP Family Violence
- [cap_dem_home_arrangement_code] - CAP Home Arrangement
- [cap_dem_income_source_code] - CAP Income Source
- [cap_dem_involve_corr_ind] - CAP Corrections Involvement Indicator
- [cap_dem_involve_prison_ind] - CAP Prison Involvement Indicator
- [cap_dem_iwi1_code] - CAP Iwi 1
- [cap_dem_iwi2_code] - CAP Iwi 2
- [cap_dem_parent_count_nbr] - CAP Parent Count
- [cap_dem_range_code] - CAP Age Range
- [cap_dem_site_code] - CAP Site
- [cap_snz_sex_code] - SNZ Sex
- [snz_cap_family_uid] - SNZ CAP Family Identifier
- [snz_cyf_prsn_uid] - SNZ CYF Identifier
- [snz_msd_uid] - SNZ MSD Identifier
