Create Validation Rule

Category * COLLECTIONS TRANSACTION CHARGES EMPLOYEE INCENTIVES

Field Name * Human-readable field name (e.g., "City", "Opening Bucket")

Validation Type * Master Lookup - Check if value exists in master table Required - Value cannot be NULL or empty Range - Numeric value must be within range Enum - Value must match allowed values

Severity * ERROR - Critical issue WARNING - Non-critical issue INFO - Informational

Source Table * -- Select Source Table -- active_ingestions_view agency_bill_master allocation_history allocation_master allocation_performance approval_actions approval_delegations approval_requests approval_workflows arrangement_optimization_suggestion audit_logs bounce_penalty_master bounce_report bounce_report_inputs branch_master bucket_master category_derived_field_groups change_request_master city_master close_dump_inputs collection_timeseries collections_evolved_records connection_configs cycle_batch_index cycle_expected_files cycle_finalization_controls cycle_master cycle_master_generation daily_ingestion_metrics data_change_logs data_deletion_logs data_deletion_requests data_finalization_records data_retention_policies derived_field_versions derived_fields digital_bounce_penal_inputs digital_live_base dpd_bom_inputs dpd_eom_inputs dry_run_executions dsa_master dual_allocation_inputs ecs_dump_inputs employee_assignment employee_file_uploads enhanced_employee_master error_code_master evolved_records external_employees external_organizations field_dependencies field_inventory field_registry field_requests file_ingestion_errors file_ingestions file_replacement_history ic_four_receipt_dump_inputs ingestion_change_logs ingestion_cycle_record ingestion_events ingestion_expectation ingestion_expected_files ingestion_file_log ingestion_frequency_configs ingestion_lifecycle_status ingestion_log ingestion_pipeline_stages ingestion_snapshots ingestion_stage_history ingestion_status ingestion_trackers ingestion_upload_sessions interface_master intermediary_evolved_records intermediary_record_changes lifecycle_event_types lifecycle_events lifecycle_sub_events login_attempts master_ingestion_config master_lookups master_run_config master_run_generation master_template_config min_max model_registry online_dump_inputs organization_documents password_history password_reset_tokens payout_aggregations payout_approval_request payout_business_filters payout_calculations payout_categories payout_category_progress payout_cycle_records payout_cycle_template_arrangement payout_field_metadata payout_function_progress payout_functions payout_grid_conditions payout_grid_entries payout_grid_matrices payout_inputs payout_mappings payout_norms payout_recipients payout_requirement_specs payout_template payout_types permissions processed_events product_code_name_mapping product_group product_master receipt_master recipient_ledger repo_dump_inputs reporting_relationship requirement_templates requirement_validations role_category_master role_master role_permissions roles run_cycle_record run_cycle_stack_execution run_cycle_stage_execution run_cycle_template_execution run_template_config rural_allocation_inputs rural_death_inputs rural_ncl_recovery_inputs rural_settlement_inputs security_events settlement_master settlement_tracking stage_performance_metrics staging_payout_inputs state_master sub_product_master summarized_receipts summary_queries summary_results tc_dashboard template_conditional_variances template_engine_templates template_execution_history template_field_usage template_multi_dim_grid_entries template_multi_dim_grids template_variance_groups trail_history_dump_inputs transaction_ingestion_config two_factor_backup_codes two_factor_devices two_factor_methods two_factor_sessions urban_allocation_inputs urban_bounce_penal_inputs urban_death_inputs urban_live_base urban_settlement_inputs user_roles user_sessions users validation_exceptions validation_failures validation_results validation_rules vendortracker vertical_master vintage_master ymo_receipt_dump_inputs Table to validate data from

Source Column * -- Select Source Column -- Column to validate

Master Table -- Select Master Table -- active_ingestions_view agency_bill_master allocation_history allocation_master allocation_performance approval_actions approval_delegations approval_requests approval_workflows arrangement_optimization_suggestion audit_logs bounce_penalty_master bounce_report bounce_report_inputs branch_master bucket_master category_derived_field_groups change_request_master city_master close_dump_inputs collection_timeseries collections_evolved_records connection_configs cycle_batch_index cycle_expected_files cycle_finalization_controls cycle_master cycle_master_generation daily_ingestion_metrics data_change_logs data_deletion_logs data_deletion_requests data_finalization_records data_retention_policies derived_field_versions derived_fields digital_bounce_penal_inputs digital_live_base dpd_bom_inputs dpd_eom_inputs dry_run_executions dsa_master dual_allocation_inputs ecs_dump_inputs employee_assignment employee_file_uploads enhanced_employee_master error_code_master evolved_records external_employees external_organizations field_dependencies field_inventory field_registry field_requests file_ingestion_errors file_ingestions file_replacement_history ic_four_receipt_dump_inputs ingestion_change_logs ingestion_cycle_record ingestion_events ingestion_expectation ingestion_expected_files ingestion_file_log ingestion_frequency_configs ingestion_lifecycle_status ingestion_log ingestion_pipeline_stages ingestion_snapshots ingestion_stage_history ingestion_status ingestion_trackers ingestion_upload_sessions interface_master intermediary_evolved_records intermediary_record_changes lifecycle_event_types lifecycle_events lifecycle_sub_events login_attempts master_ingestion_config master_lookups master_run_config master_run_generation master_template_config min_max model_registry online_dump_inputs organization_documents password_history password_reset_tokens payout_aggregations payout_approval_request payout_business_filters payout_calculations payout_categories payout_category_progress payout_cycle_records payout_cycle_template_arrangement payout_field_metadata payout_function_progress payout_functions payout_grid_conditions payout_grid_entries payout_grid_matrices payout_inputs payout_mappings payout_norms payout_recipients payout_requirement_specs payout_template payout_types permissions processed_events product_code_name_mapping product_group product_master receipt_master recipient_ledger repo_dump_inputs reporting_relationship requirement_templates requirement_validations role_category_master role_master role_permissions roles run_cycle_record run_cycle_stack_execution run_cycle_stage_execution run_cycle_template_execution run_template_config rural_allocation_inputs rural_death_inputs rural_ncl_recovery_inputs rural_settlement_inputs security_events settlement_master settlement_tracking stage_performance_metrics staging_payout_inputs state_master sub_product_master summarized_receipts summary_queries summary_results tc_dashboard template_conditional_variances template_engine_templates template_execution_history template_field_usage template_multi_dim_grid_entries template_multi_dim_grids template_variance_groups trail_history_dump_inputs transaction_ingestion_config two_factor_backup_codes two_factor_devices two_factor_methods two_factor_sessions urban_allocation_inputs urban_bounce_penal_inputs urban_death_inputs urban_live_base urban_settlement_inputs user_roles user_sessions users validation_exceptions validation_failures validation_results validation_rules vendortracker vertical_master vintage_master ymo_receipt_dump_inputs Reference master table

Master Key Column -- Select Master Column -- Column to match against

Blocking Behavior Blocking - Stop downstream processing if failed Non-blocking - Allow processing with warnings

Failure Threshold % Block only if failure % exceeds this (0 = any failure blocks)

Error Message User-friendly error message to display