SchemaSpy Analysis of openpetra_trunk.public - ConstraintsOpenPetra Version 3 Database Generated by
SchemaSpy
1325 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
a_account_fk1 a_account.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_account_fk2 a_account.a_budget_type_code_c a_budget_type.a_budget_type_code_c Restrict delete 
a_account_fk3 a_account.a_foreign_currency_code_c a_currency.a_currency_code_c Restrict delete 
a_account_fk4 a_account.p_banking_details_key_i p_banking_details.p_banking_details_key_i Restrict delete 
a_account_fkcr a_account.s_created_by_c s_user.s_user_id_c Restrict delete 
a_account_fkmd a_account.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_account_hierarchy_detail_fk1 a_account_hierarchy_detail.a_ledger_number_i
a_account_hierarchy_detail.a_account_hierarchy_code_c
a_account_hierarchy.a_ledger_number_i
a_account_hierarchy.a_account_hierarchy_code_c
Restrict delete 
a_account_hierarchy_detail_fk2 a_account_hierarchy_detail.a_ledger_number_i
a_account_hierarchy_detail.a_reporting_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_account_hierarchy_detail_fk3 a_account_hierarchy_detail.a_ledger_number_i
a_account_hierarchy_detail.a_account_code_to_report_to_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_account_hierarchy_detail_fkcr a_account_hierarchy_detail.s_created_by_c s_user.s_user_id_c Restrict delete 
a_account_hierarchy_detail_fkmd a_account_hierarchy_detail.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_account_hierarchy_fk1 a_account_hierarchy.a_ledger_number_i
a_account_hierarchy.a_root_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_account_hierarchy_fkcr a_account_hierarchy.s_created_by_c s_user.s_user_id_c Restrict delete 
a_account_hierarchy_fkmd a_account_hierarchy.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_account_property_code_fkcr a_account_property_code.s_created_by_c s_user.s_user_id_c Restrict delete 
a_account_property_code_fkmd a_account_property_code.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_account_property_fk1 a_account_property.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_account_property_fk2 a_account_property.a_ledger_number_i
a_account_property.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_account_property_fk3 a_account_property.a_property_code_c a_account_property_code.a_property_code_c Restrict delete 
a_account_property_fkcr a_account_property.s_created_by_c s_user.s_user_id_c Restrict delete 
a_account_property_fkmd a_account_property.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_accounting_period_fk1 a_accounting_period.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_accounting_period_fkcr a_accounting_period.s_created_by_c s_user.s_user_id_c Restrict delete 
a_accounting_period_fkmd a_accounting_period.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_accounting_system_param_fk1 a_accounting_system_parameter.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_accounting_system_parameter_fkcr a_accounting_system_parameter.s_created_by_c s_user.s_user_id_c Restrict delete 
a_accounting_system_parameter_fkmd a_accounting_system_parameter.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_analysis_attribute_fk1 a_analysis_attribute.a_ledger_number_i
a_analysis_attribute.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_analysis_attribute_fk2 a_analysis_attribute.a_analysis_type_code_c a_analysis_type.a_analysis_type_code_c Restrict delete 
a_analysis_attribute_fk3 a_analysis_attribute.a_ledger_number_i
a_analysis_attribute.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_analysis_attribute_fkcr a_analysis_attribute.s_created_by_c s_user.s_user_id_c Restrict delete 
a_analysis_attribute_fkmd a_analysis_attribute.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_analysis_store_table_fkcr a_analysis_store_table.s_created_by_c s_user.s_user_id_c Restrict delete 
a_analysis_store_table_fkmd a_analysis_store_table.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_analysis_type_fkcr a_analysis_type.s_created_by_c s_user.s_user_id_c Restrict delete 
a_analysis_type_fkmd a_analysis_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ap_anal_attrib_fk1 a_ap_anal_attrib.a_ledger_number_i
a_ap_anal_attrib.a_ap_number_i
a_ap_anal_attrib.a_detail_number_i
a_ap_document_detail.a_ledger_number_i
a_ap_document_detail.a_ap_number_i
a_ap_document_detail.a_detail_number_i
Restrict delete 
a_ap_anal_attrib_fk2 a_ap_anal_attrib.a_ledger_number_i
a_ap_anal_attrib.a_account_code_c
a_ap_anal_attrib.a_analysis_type_code_c
a_analysis_attribute.a_ledger_number_i
a_analysis_attribute.a_account_code_c
a_analysis_attribute.a_analysis_type_code_c
Restrict delete 
a_ap_anal_attrib_fk3 a_ap_anal_attrib.a_ledger_number_i
a_ap_anal_attrib.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_ap_anal_attrib_fk4 a_ap_anal_attrib.a_ledger_number_i
a_ap_anal_attrib.a_analysis_type_code_c
a_ap_anal_attrib.a_analysis_attribute_value_c
a_freeform_analysis.a_ledger_number_i
a_freeform_analysis.a_analysis_type_code_c
a_freeform_analysis.a_analysis_value_c
Restrict delete 
a_ap_anal_attrib_fkcr a_ap_anal_attrib.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ap_anal_attrib_fkmd a_ap_anal_attrib.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ap_document_detail_fk1 a_ap_document_detail.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_ap_document_detail_fk2 a_ap_document_detail.a_ledger_number_i
a_ap_document_detail.a_ap_number_i
a_ap_document.a_ledger_number_i
a_ap_document.a_ap_number_i
Restrict delete 
a_ap_document_detail_fk3 a_ap_document_detail.a_ledger_number_i
a_ap_document_detail.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_ap_document_detail_fk4 a_ap_document_detail.a_ledger_number_i
a_ap_document_detail.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_ap_document_detail_fkcr a_ap_document_detail.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ap_document_detail_fkmd a_ap_document_detail.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ap_document_fk1 a_ap_document.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_ap_document_fk2 a_ap_document.p_partner_key_n a_ap_supplier.p_partner_key_n Restrict delete 
a_ap_document_fk3 a_ap_document.a_ledger_number_i
a_ap_document.a_ap_account_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_ap_document_fkcr a_ap_document.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ap_document_fkmd a_ap_document.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ap_document_payment_fk1 a_ap_document_payment.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_ap_document_payment_fk2 a_ap_document_payment.a_ledger_number_i
a_ap_document_payment.a_ap_number_i
a_ap_document.a_ledger_number_i
a_ap_document.a_ap_number_i
Restrict delete 
a_ap_document_payment_fk3 a_ap_document_payment.a_ledger_number_i
a_ap_document_payment.a_payment_number_i
a_ap_payment.a_ledger_number_i
a_ap_payment.a_payment_number_i
Restrict delete 
a_ap_document_payment_fkcr a_ap_document_payment.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ap_document_payment_fkmd a_ap_document_payment.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ap_payment_fk1 a_ap_payment.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_ap_payment_fk2 a_ap_payment.s_user_id_c s_user.s_user_id_c Restrict delete 
a_ap_payment_fk3 a_ap_payment.a_ledger_number_i
a_ap_payment.a_bank_account_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_ap_payment_fkcr a_ap_payment.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ap_payment_fkmd a_ap_payment.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ap_supplier_fk1 a_ap_supplier.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
a_ap_supplier_fk2 a_ap_supplier.a_currency_code_c a_currency.a_currency_code_c Restrict delete 
a_ap_supplier_fkcr a_ap_supplier.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ap_supplier_fkmd a_ap_supplier.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ar_article_fk1 a_ar_article.a_ar_category_code_c a_ar_category.a_ar_category_code_c Restrict delete 
a_ar_article_fk2 a_ar_article.a_tax_type_code_c a_tax_type.a_tax_type_code_c Restrict delete 
a_ar_article_fkcr a_ar_article.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ar_article_fkmd a_ar_article.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ar_article_price_fkcr a_ar_article_price.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ar_article_price_fkmd a_ar_article_price.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ar_category_fkcr a_ar_category.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ar_category_fkmd a_ar_category.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ar_default_discount_fkcr a_ar_default_discount.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ar_default_discount_fkmd a_ar_default_discount.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ar_discount_fkcr a_ar_discount.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ar_discount_fkmd a_ar_discount.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ar_discount_per_category_fkcr a_ar_discount_per_category.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ar_discount_per_category_fkmd a_ar_discount_per_category.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ar_invoice_detail_discount_fk1 a_ar_invoice_detail_discount.a_ledger_number_i
a_ar_invoice_detail_discount.a_invoice_key_i
a_ar_invoice_detail_discount.a_detail_number_i
a_ar_invoice_detail.a_ledger_number_i
a_ar_invoice_detail.a_invoice_key_i
a_ar_invoice_detail.a_detail_number_i
Restrict delete 
a_ar_invoice_detail_discount_fk2 a_ar_invoice_detail_discount.a_ar_discount_code_c
a_ar_invoice_detail_discount.a_ar_discount_date_valid_from_d
a_ar_discount.a_ar_discount_code_c
a_ar_discount.a_ar_date_valid_from_d
Restrict delete 
a_ar_invoice_detail_discount_fkcr a_ar_invoice_detail_discount.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ar_invoice_detail_discount_fkmd a_ar_invoice_detail_discount.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ar_invoice_detail_fk1 a_ar_invoice_detail.a_ledger_number_i
a_ar_invoice_detail.a_invoice_key_i
a_ar_invoice.a_ledger_number_i
a_ar_invoice.a_key_i
Restrict delete 
a_ar_invoice_detail_fk2 a_ar_invoice_detail.a_ledger_number_i
a_ar_invoice_detail.a_tax_type_code_c
a_ar_invoice_detail.a_tax_rate_code_c
a_ar_invoice_detail.a_tax_valid_from_d
a_tax_table.a_ledger_number_i
a_tax_table.a_tax_type_code_c
a_tax_table.a_tax_rate_code_c
a_tax_table.a_tax_valid_from_d
Restrict delete 
a_ar_invoice_detail_fk3 a_ar_invoice_detail.a_currency_code_c a_currency.a_currency_code_c Restrict delete 
a_ar_invoice_detail_fk4 a_ar_invoice_detail.a_ar_article_code_c a_ar_article.a_ar_article_code_c Restrict delete 
a_ar_invoice_detail_fk5 a_ar_invoice_detail.a_ar_article_code_c
a_ar_invoice_detail.a_ar_article_price_d
a_ar_article_price.a_ar_article_code_c
a_ar_article_price.a_ar_date_valid_from_d
Restrict delete 
a_ar_invoice_detail_fkcr a_ar_invoice_detail.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ar_invoice_detail_fkmd a_ar_invoice_detail.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ar_invoice_discount_fk1 a_ar_invoice_discount.a_ledger_number_i
a_ar_invoice_discount.a_invoice_key_i
a_ar_invoice.a_ledger_number_i
a_ar_invoice.a_key_i
Restrict delete 
a_ar_invoice_discount_fk2 a_ar_invoice_discount.a_ar_discount_code_c
a_ar_invoice_discount.a_ar_discount_date_valid_from_d
a_ar_discount.a_ar_discount_code_c
a_ar_discount.a_ar_date_valid_from_d
Restrict delete 
a_ar_invoice_discount_fkcr a_ar_invoice_discount.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ar_invoice_discount_fkmd a_ar_invoice_discount.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ar_invoice_fk1 a_ar_invoice.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
a_ar_invoice_fk2 a_ar_invoice.a_ledger_number_i
a_ar_invoice.a_special_tax_type_code_c
a_ar_invoice.a_special_tax_rate_code_c
a_ar_invoice.a_special_tax_valid_from_d
a_tax_table.a_ledger_number_i
a_tax_table.a_tax_type_code_c
a_tax_table.a_tax_rate_code_c
a_tax_table.a_tax_valid_from_d
Restrict delete 
a_ar_invoice_fk3 a_ar_invoice.a_currency_code_c a_currency.a_currency_code_c Restrict delete 
a_ar_invoice_fkcr a_ar_invoice.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ar_invoice_fkmd a_ar_invoice.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_batch_fk1 a_batch.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_batch_fkcr a_batch.s_created_by_c s_user.s_user_id_c Restrict delete 
a_batch_fkmd a_batch.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_budget_fk1 a_budget.a_ledger_number_i
a_budget.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_budget_fk2 a_budget.a_ledger_number_i
a_budget.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_budget_fk3 a_budget.a_budget_type_code_c a_budget_type.a_budget_type_code_c Restrict delete 
a_budget_fk4 a_budget.a_ledger_number_i
a_budget.a_year_i
a_budget.a_revision_i
a_budget_revision.a_ledger_number_i
a_budget_revision.a_year_i
a_budget_revision.a_revision_i
Restrict delete 
a_budget_fkcr a_budget.s_created_by_c s_user.s_user_id_c Restrict delete 
a_budget_fkmd a_budget.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_budget_period_fk1 a_budget_period.a_budget_sequence_i a_budget.a_budget_sequence_i Restrict delete 
a_budget_period_fkcr a_budget_period.s_created_by_c s_user.s_user_id_c Restrict delete 
a_budget_period_fkmd a_budget_period.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_budget_revision_fkcr a_budget_revision.s_created_by_c s_user.s_user_id_c Restrict delete 
a_budget_revision_fkmd a_budget_revision.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_budget_type_fk1 a_budget_type.a_budget_process_to_call_c s_file.s_file_name_c Restrict delete 
a_budget_type_fkcr a_budget_type.s_created_by_c s_user.s_user_id_c Restrict delete 
a_budget_type_fkmd a_budget_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_corporate_exchange_rate_fk1 a_corporate_exchange_rate.a_from_currency_code_c a_currency.a_currency_code_c Restrict delete 
a_corporate_exchange_rate_fk2 a_corporate_exchange_rate.a_to_currency_code_c a_currency.a_currency_code_c Restrict delete 
a_corporate_exchange_rate_fkcr a_corporate_exchange_rate.s_created_by_c s_user.s_user_id_c Restrict delete 
a_corporate_exchange_rate_fkmd a_corporate_exchange_rate.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_cost_centre_fk1 a_cost_centre.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_cost_centre_fk2 a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_type_c
a_cost_centre_types.a_ledger_number_i
a_cost_centre_types.a_cost_centre_type_c
Restrict delete 
a_cost_centre_fk3 a_cost_centre.a_key_focus_area_c a_key_focus_area.a_key_focus_area_c Restrict delete 
a_cost_centre_fkcr a_cost_centre.s_created_by_c s_user.s_user_id_c Restrict delete 
a_cost_centre_fkmd a_cost_centre.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_cost_centre_types_fk1 a_cost_centre_types.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_cost_centre_types_fkcr a_cost_centre_types.s_created_by_c s_user.s_user_id_c Restrict delete 
a_cost_centre_types_fkmd a_cost_centre_types.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_crdt_note_invoice_link_fk1 a_crdt_note_invoice_link.a_ledger_number_i
a_crdt_note_invoice_link.a_credit_note_number_i
a_ap_document.a_ledger_number_i
a_ap_document.a_ap_number_i
Restrict delete 
a_crdt_note_invoice_link_fk2 a_crdt_note_invoice_link.a_ledger_number_i
a_crdt_note_invoice_link.a_invoice_number_i
a_ap_document.a_ledger_number_i
a_ap_document.a_ap_number_i
Restrict delete 
a_crdt_note_invoice_link_fkcr a_crdt_note_invoice_link.s_created_by_c s_user.s_user_id_c Restrict delete 
a_crdt_note_invoice_link_fkmd a_crdt_note_invoice_link.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_currency_fk1 a_currency.p_country_code_c p_country.p_country_code_c Restrict delete 
a_currency_fkcr a_currency.s_created_by_c s_user.s_user_id_c Restrict delete 
a_currency_fkmd a_currency.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_currency_language_fk1 a_currency_language.a_currency_code_c a_currency.a_currency_code_c Restrict delete 
a_currency_language_fk2 a_currency_language.p_language_code_c p_language.p_language_code_c Restrict delete 
a_currency_language_fkcr a_currency_language.s_created_by_c s_user.s_user_id_c Restrict delete 
a_currency_language_fkmd a_currency_language.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_daily_exchange_rate_fk1 a_daily_exchange_rate.a_from_currency_code_c a_currency.a_currency_code_c Restrict delete 
a_daily_exchange_rate_fk2 a_daily_exchange_rate.a_to_currency_code_c a_currency.a_currency_code_c Restrict delete 
a_daily_exchange_rate_fkcr a_daily_exchange_rate.s_created_by_c s_user.s_user_id_c Restrict delete 
a_daily_exchange_rate_fkmd a_daily_exchange_rate.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_email_destination_fk1 a_email_destination.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
a_email_destination_fkcr a_email_destination.s_created_by_c s_user.s_user_id_c Restrict delete 
a_email_destination_fkmd a_email_destination.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ep_account_fk1 a_ep_account.a_banking_details_key_i p_banking_details.p_banking_details_key_i Restrict delete 
a_ep_account_fk2 a_ep_account.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_ep_account_fk3 a_ep_account.a_ledger_number_i
a_ep_account.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_ep_account_fk4 a_ep_account.a_ledger_number_i
a_ep_account.a_motivation_group_code_c
a_ep_account.a_motivation_detail_code_c
a_motivation_detail.a_ledger_number_i
a_motivation_detail.a_motivation_group_code_c
a_motivation_detail.a_motivation_detail_code_c
Restrict delete 
a_ep_account_fkcr a_ep_account.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ep_account_fkmd a_ep_account.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ep_document_payment_fk1 a_ep_document_payment.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_ep_document_payment_fk2 a_ep_document_payment.a_ledger_number_i
a_ep_document_payment.a_ap_number_i
a_ap_document.a_ledger_number_i
a_ap_document.a_ap_number_i
Restrict delete 
a_ep_document_payment_fk3 a_ep_document_payment.a_ledger_number_i
a_ep_document_payment.a_payment_number_i
a_ep_payment.a_ledger_number_i
a_ep_payment.a_payment_number_i
Restrict delete 
a_ep_document_payment_fkcr a_ep_document_payment.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ep_document_payment_fkmd a_ep_document_payment.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ep_match_fk1 a_ep_match.a_ledger_number_i
a_ep_match.a_motivation_group_code_c
a_ep_match.a_motivation_detail_code_c
a_motivation_detail.a_ledger_number_i
a_motivation_detail.a_motivation_group_code_c
a_motivation_detail.a_motivation_detail_code_c
Restrict delete 
a_ep_match_fk10 a_ep_match.a_key_ministry_key_n p_unit.p_partner_key_n Restrict delete 
a_ep_match_fk2 a_ep_match.p_recipient_key_n p_partner.p_partner_key_n Restrict delete 
a_ep_match_fk3 a_ep_match.p_mailing_code_c p_mailing.p_mailing_code_c Restrict delete 
a_ep_match_fk4 a_ep_match.a_recipient_ledger_number_n p_partner.p_partner_key_n Restrict delete 
a_ep_match_fk5 a_ep_match.a_ledger_number_i
a_ep_match.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_ep_match_fk6 a_ep_match.a_method_of_giving_code_c a_method_of_giving.a_method_of_giving_code_c Restrict delete 
a_ep_match_fk7 a_ep_match.a_method_of_payment_code_c a_method_of_payment.a_method_of_payment_code_c Restrict delete 
a_ep_match_fk8 a_ep_match.p_donor_key_n p_partner.p_partner_key_n Restrict delete 
a_ep_match_fk9 a_ep_match.a_ledger_number_i
a_ep_match.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_ep_match_fkcr a_ep_match.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ep_match_fkmd a_ep_match.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ep_payment_fk1 a_ep_payment.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_ep_payment_fk2 a_ep_payment.s_user_id_c s_user.s_user_id_c Restrict delete 
a_ep_payment_fk3 a_ep_payment.a_ledger_number_i
a_ep_payment.a_bank_account_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_ep_payment_fkcr a_ep_payment.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ep_payment_fkmd a_ep_payment.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ep_statement_fk1 a_ep_statement.a_bank_account_key_i p_banking_details.p_banking_details_key_i Restrict delete 
a_ep_statement_fk2 a_ep_statement.a_currency_code_c a_currency.a_currency_code_c Restrict delete 
a_ep_statement_fk3 a_ep_statement.a_ledger_number_i
a_ep_statement.a_bank_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_ep_statement_fkcr a_ep_statement.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ep_statement_fkmd a_ep_statement.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ep_transaction_fk1 a_ep_transaction.a_statement_key_i a_ep_statement.a_statement_key_i Restrict delete 
a_ep_transaction_fk2 a_ep_transaction.a_ep_match_key_i a_ep_match.a_ep_match_key_i Restrict delete 
a_ep_transaction_fkcr a_ep_transaction.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ep_transaction_fkmd a_ep_transaction.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_fees_payable_fk1 a_fees_payable.a_ledger_number_i
a_fees_payable.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_fees_payable_fk2 a_fees_payable.a_ledger_number_i
a_fees_payable.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_fees_payable_fk3 a_fees_payable.a_ledger_number_i
a_fees_payable.a_dr_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_fees_payable_fkcr a_fees_payable.s_created_by_c s_user.s_user_id_c Restrict delete 
a_fees_payable_fkmd a_fees_payable.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_fees_receivable_fk1 a_fees_receivable.a_ledger_number_i
a_fees_receivable.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_fees_receivable_fk2 a_fees_receivable.a_ledger_number_i
a_fees_receivable.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_fees_receivable_fk3 a_fees_receivable.a_ledger_number_i
a_fees_receivable.a_dr_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_fees_receivable_fkcr a_fees_receivable.s_created_by_c s_user.s_user_id_c Restrict delete 
a_fees_receivable_fkmd a_fees_receivable.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_form_element_fk1 a_form_element.a_form_code_c
a_form_element.a_form_name_c
a_form.a_form_code_c
a_form.a_form_name_c
Restrict delete 
a_form_element_fk2 a_form_element.a_form_code_c
a_form_element.a_form_element_type_code_c
a_form_element_type.a_form_code_c
a_form_element_type.a_form_element_type_code_c
Restrict delete 
a_form_element_fkcr a_form_element.s_created_by_c s_user.s_user_id_c Restrict delete 
a_form_element_fkmd a_form_element.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_form_element_type_fkcr a_form_element_type.s_created_by_c s_user.s_user_id_c Restrict delete 
a_form_element_type_fkmd a_form_element_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_form_fkcr a_form.s_created_by_c s_user.s_user_id_c Restrict delete 
a_form_fkmd a_form.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_freeform_analysis_fk1 a_freeform_analysis.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_freeform_analysis_fk2 a_freeform_analysis.a_analysis_type_code_c a_analysis_type.a_analysis_type_code_c Restrict delete 
a_freeform_analysis_fkcr a_freeform_analysis.s_created_by_c s_user.s_user_id_c Restrict delete 
a_freeform_analysis_fkmd a_freeform_analysis.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_frequency_fkcr a_frequency.s_created_by_c s_user.s_user_id_c Restrict delete 
a_frequency_fkmd a_frequency.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_general_ledger_master_fk1 a_general_ledger_master.a_ledger_number_i
a_general_ledger_master.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_general_ledger_master_fk2 a_general_ledger_master.a_ledger_number_i
a_general_ledger_master.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_general_ledger_master_fkcr a_general_ledger_master.s_created_by_c s_user.s_user_id_c Restrict delete 
a_general_ledger_master_fkmd a_general_ledger_master.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_general_ledger_master_period_fkcr a_general_ledger_master_period.s_created_by_c s_user.s_user_id_c Restrict delete 
a_general_ledger_master_period_fkmd a_general_ledger_master_period.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_gift_batch_fk1 a_gift_batch.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_gift_batch_fk2 a_gift_batch.a_ledger_number_i
a_gift_batch.a_bank_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_gift_batch_fk3 a_gift_batch.a_ledger_number_i
a_gift_batch.a_bank_cost_centre_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_gift_batch_fk4 a_gift_batch.a_currency_code_c a_currency.a_currency_code_c Restrict delete 
a_gift_batch_fkcr a_gift_batch.s_created_by_c s_user.s_user_id_c Restrict delete 
a_gift_batch_fkmd a_gift_batch.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_gift_detail_fk1 a_gift_detail.a_ledger_number_i
a_gift_detail.a_batch_number_i
a_gift_detail.a_gift_transaction_number_i
a_gift.a_ledger_number_i
a_gift.a_batch_number_i
a_gift.a_gift_transaction_number_i
Restrict delete 
a_gift_detail_fk2 a_gift_detail.a_ledger_number_i
a_gift_detail.a_motivation_group_code_c
a_gift_detail.a_motivation_detail_code_c
a_motivation_detail.a_ledger_number_i
a_motivation_detail.a_motivation_group_code_c
a_motivation_detail.a_motivation_detail_code_c
Restrict delete 
a_gift_detail_fk3 a_gift_detail.p_recipient_key_n p_partner.p_partner_key_n Restrict delete 
a_gift_detail_fk4 a_gift_detail.p_mailing_code_c p_mailing.p_mailing_code_c Restrict delete 
a_gift_detail_fk5 a_gift_detail.a_recipient_ledger_number_n p_partner.p_partner_key_n Restrict delete 
a_gift_detail_fk6 a_gift_detail.a_ledger_number_i
a_gift_detail.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_gift_detail_fkcr a_gift_detail.s_created_by_c s_user.s_user_id_c Restrict delete 
a_gift_detail_fkmd a_gift_detail.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_gift_fk1 a_gift.a_ledger_number_i
a_gift.a_batch_number_i
a_gift_batch.a_ledger_number_i
a_gift_batch.a_batch_number_i
Restrict delete 
a_gift_fk2 a_gift.a_method_of_giving_code_c a_method_of_giving.a_method_of_giving_code_c Restrict delete 
a_gift_fk3 a_gift.a_method_of_payment_code_c a_method_of_payment.a_method_of_payment_code_c Restrict delete 
a_gift_fk4 a_gift.p_donor_key_n p_partner.p_partner_key_n Restrict delete 
a_gift_fkcr a_gift.s_created_by_c s_user.s_user_id_c Restrict delete 
a_gift_fkmd a_gift.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_glm_period_fk1 a_general_ledger_master_period.a_glm_sequence_i a_general_ledger_master.a_glm_sequence_i Restrict delete 
a_ich_stewardship_fk1 a_ich_stewardship.a_ledger_number_i
a_ich_stewardship.a_period_number_i
a_accounting_period.a_ledger_number_i
a_accounting_period.a_accounting_period_number_i
Restrict delete 
a_ich_stewardship_fk2 a_ich_stewardship.a_ledger_number_i
a_ich_stewardship.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_ich_stewardship_fkcr a_ich_stewardship.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ich_stewardship_fkmd a_ich_stewardship.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_journal_fk1 a_journal.a_ledger_number_i
a_journal.a_batch_number_i
a_batch.a_ledger_number_i
a_batch.a_batch_number_i
Restrict delete 
a_journal_fk3 a_journal.a_ledger_number_i
a_journal.a_sub_system_code_c
a_journal.a_transaction_type_code_c
a_transaction_type.a_ledger_number_i
a_transaction_type.a_sub_system_code_c
a_transaction_type.a_transaction_type_code_c
Restrict delete 
a_journal_fk4 a_journal.a_transaction_currency_c a_currency.a_currency_code_c Restrict delete 
a_journal_fkcr a_journal.s_created_by_c s_user.s_user_id_c Restrict delete 
a_journal_fkmd a_journal.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_key_focus_area_fkcr a_key_focus_area.s_created_by_c s_user.s_user_id_c Restrict delete 
a_key_focus_area_fkmd a_key_focus_area.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ledger_fk1 a_ledger.a_tax_type_code_c a_tax_type.a_tax_type_code_c Restrict delete 
a_ledger_fk2 a_ledger.a_country_code_c p_country.p_country_code_c Restrict delete 
a_ledger_fk3 a_ledger.a_base_currency_c a_currency.a_currency_code_c Restrict delete 
a_ledger_fk4 a_ledger.a_intl_currency_c a_currency.a_currency_code_c Restrict delete 
a_ledger_fkcr a_ledger.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ledger_fkmd a_ledger.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_ledger_init_flag_fk1 a_ledger_init_flag.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_ledger_init_flag_fkcr a_ledger_init_flag.s_created_by_c s_user.s_user_id_c Restrict delete 
a_ledger_init_flag_fkmd a_ledger_init_flag.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_method_of_giving_fkcr a_method_of_giving.s_created_by_c s_user.s_user_id_c Restrict delete 
a_method_of_giving_fkmd a_method_of_giving.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_method_of_payment_fk1 a_method_of_payment.a_process_to_call_c s_file.s_file_name_c Restrict delete 
a_method_of_payment_fkcr a_method_of_payment.s_created_by_c s_user.s_user_id_c Restrict delete 
a_method_of_payment_fkmd a_method_of_payment.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_motivation_detail_fee_fk1 a_motivation_detail_fee.a_ledger_number_i
a_motivation_detail_fee.a_motivation_group_code_c
a_motivation_detail_fee.a_motivation_detail_code_c
a_motivation_detail.a_ledger_number_i
a_motivation_detail.a_motivation_group_code_c
a_motivation_detail.a_motivation_detail_code_c
Restrict delete 
a_motivation_detail_fee_fk2 a_motivation_detail_fee.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_motivation_detail_fee_fkcr a_motivation_detail_fee.s_created_by_c s_user.s_user_id_c Restrict delete 
a_motivation_detail_fee_fkmd a_motivation_detail_fee.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_motivation_detail_fk1 a_motivation_detail.a_ledger_number_i
a_motivation_detail.a_motivation_group_code_c
a_motivation_group.a_ledger_number_i
a_motivation_group.a_motivation_group_code_c
Restrict delete 
a_motivation_detail_fk2 a_motivation_detail.a_ledger_number_i
a_motivation_detail.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_motivation_detail_fk3 a_motivation_detail.a_ledger_number_i
a_motivation_detail.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_motivation_detail_fk4 a_motivation_detail.p_recipient_key_n p_partner.p_partner_key_n Restrict delete 
a_motivation_detail_fkcr a_motivation_detail.s_created_by_c s_user.s_user_id_c Restrict delete 
a_motivation_detail_fkmd a_motivation_detail.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_motivation_group_fk1 a_motivation_group.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_motivation_group_fkcr a_motivation_group.s_created_by_c s_user.s_user_id_c Restrict delete 
a_motivation_group_fkmd a_motivation_group.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_prev_year_corp_ex_rate_fk1 a_prev_year_corp_ex_rate.a_from_currency_code_c a_currency.a_currency_code_c Restrict delete 
a_prev_year_corp_ex_rate_fk2 a_prev_year_corp_ex_rate.a_to_currency_code_c a_currency.a_currency_code_c Restrict delete 
a_prev_year_corp_ex_rate_fkcr a_prev_year_corp_ex_rate.s_created_by_c s_user.s_user_id_c Restrict delete 
a_prev_year_corp_ex_rate_fkmd a_prev_year_corp_ex_rate.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_prev_year_trans_anal_attr_fk1 a_prev_year_trans_anal_attrib.a_ledger_number_i
a_prev_year_trans_anal_attrib.a_batch_number_i
a_prev_year_trans_anal_attrib.a_journal_number_i
a_prev_year_trans_anal_attrib.a_transaction_number_i
a_previous_year_transaction.a_ledger_number_i
a_previous_year_transaction.a_batch_number_i
a_previous_year_transaction.a_journal_number_i
a_previous_year_transaction.a_transaction_number_i
Restrict delete 
a_prev_year_trans_anal_attr_fk2 a_prev_year_trans_anal_attrib.a_ledger_number_i
a_prev_year_trans_anal_attrib.a_account_code_c
a_prev_year_trans_anal_attrib.a_analysis_type_code_c
a_analysis_attribute.a_ledger_number_i
a_analysis_attribute.a_account_code_c
a_analysis_attribute.a_analysis_type_code_c
Restrict delete 
a_prev_year_trans_anal_attr_fk3 a_prev_year_trans_anal_attrib.a_ledger_number_i
a_prev_year_trans_anal_attrib.a_analysis_type_code_c
a_prev_year_trans_anal_attrib.a_analysis_attribute_value_c
a_freeform_analysis.a_ledger_number_i
a_freeform_analysis.a_analysis_type_code_c
a_freeform_analysis.a_analysis_value_c
Restrict delete 
a_prev_year_trans_anal_attr_fk4 a_prev_year_trans_anal_attrib.a_ledger_number_i
a_prev_year_trans_anal_attrib.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_prev_year_trans_anal_attrib_fkcr a_prev_year_trans_anal_attrib.s_created_by_c s_user.s_user_id_c Restrict delete 
a_prev_year_trans_anal_attrib_fkmd a_prev_year_trans_anal_attrib.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_previous_year_batch_fk1 a_previous_year_batch.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_previous_year_batch_fk2 a_previous_year_batch.a_ledger_number_i
a_previous_year_batch.a_batch_period_i
a_accounting_period.a_ledger_number_i
a_accounting_period.a_accounting_period_number_i
Restrict delete 
a_previous_year_batch_fkcr a_previous_year_batch.s_created_by_c s_user.s_user_id_c Restrict delete 
a_previous_year_batch_fkmd a_previous_year_batch.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_previous_year_journal_fk1 a_previous_year_journal.a_ledger_number_i
a_previous_year_journal.a_batch_number_i
a_previous_year_batch.a_ledger_number_i
a_previous_year_batch.a_batch_number_i
Restrict delete 
a_previous_year_journal_fk2 a_previous_year_journal.a_ledger_number_i
a_previous_year_journal.a_journal_period_i
a_accounting_period.a_ledger_number_i
a_accounting_period.a_accounting_period_number_i
Restrict delete 
a_previous_year_journal_fk3 a_previous_year_journal.a_ledger_number_i
a_previous_year_journal.a_sub_system_code_c
a_previous_year_journal.a_transaction_type_code_c
a_transaction_type.a_ledger_number_i
a_transaction_type.a_sub_system_code_c
a_transaction_type.a_transaction_type_code_c
Restrict delete 
a_previous_year_journal_fk4 a_previous_year_journal.a_transaction_currency_c a_currency.a_currency_code_c Restrict delete 
a_previous_year_journal_fk5 a_previous_year_journal.a_base_currency_c a_currency.a_currency_code_c Restrict delete 
a_previous_year_journal_fkcr a_previous_year_journal.s_created_by_c s_user.s_user_id_c Restrict delete 
a_previous_year_journal_fkmd a_previous_year_journal.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_previous_year_transaction_fk1 a_previous_year_transaction.a_ledger_number_i
a_previous_year_transaction.a_batch_number_i
a_previous_year_transaction.a_journal_number_i
a_previous_year_journal.a_ledger_number_i
a_previous_year_journal.a_batch_number_i
a_previous_year_journal.a_journal_number_i
Restrict delete 
a_previous_year_transaction_fk2 a_previous_year_transaction.a_ledger_number_i
a_previous_year_transaction.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_previous_year_transaction_fk3 a_previous_year_transaction.a_ledger_number_i
a_previous_year_transaction.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_previous_year_transaction_fkcr a_previous_year_transaction.s_created_by_c s_user.s_user_id_c Restrict delete 
a_previous_year_transaction_fkmd a_previous_year_transaction.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_processed_fee_fk1 a_processed_fee.a_ledger_number_i
a_processed_fee.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_processed_fee_fk2 a_processed_fee.a_ledger_number_i
a_processed_fee.a_period_number_i
a_accounting_period.a_ledger_number_i
a_accounting_period.a_accounting_period_number_i
Restrict delete 
a_processed_fee_fk3 a_processed_fee.a_ledger_number_i
a_processed_fee.a_batch_number_i
a_processed_fee.a_gift_transaction_number_i
a_processed_fee.a_detail_number_i
a_gift_detail.a_ledger_number_i
a_gift_detail.a_batch_number_i
a_gift_detail.a_gift_transaction_number_i
a_gift_detail.a_detail_number_i
Restrict delete 
a_processed_fee_fk4 a_processed_fee.a_ledger_number_i
a_processed_fee.a_batch_number_i
a_gift_batch.a_ledger_number_i
a_gift_batch.a_batch_number_i
Restrict delete 
a_processed_fee_fkcr a_processed_fee.s_created_by_c s_user.s_user_id_c Restrict delete 
a_processed_fee_fkmd a_processed_fee.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_recurring_batch_fk1 a_recurring_batch.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_recurring_batch_fk2 a_recurring_batch.s_user_id_c s_user.s_user_id_c Restrict delete 
a_recurring_batch_fk3 a_recurring_batch.a_frequency_code_c a_frequency.a_frequency_code_c Restrict delete 
a_recurring_batch_fkcr a_recurring_batch.s_created_by_c s_user.s_user_id_c Restrict delete 
a_recurring_batch_fkmd a_recurring_batch.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_recurring_gift_batch_fk1 a_recurring_gift_batch.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_recurring_gift_batch_fk2 a_recurring_gift_batch.a_ledger_number_i
a_recurring_gift_batch.a_bank_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_recurring_gift_batch_fk3 a_recurring_gift_batch.a_ledger_number_i
a_recurring_gift_batch.a_bank_cost_centre_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_recurring_gift_batch_fk4 a_recurring_gift_batch.a_currency_code_c a_currency.a_currency_code_c Restrict delete 
a_recurring_gift_batch_fkcr a_recurring_gift_batch.s_created_by_c s_user.s_user_id_c Restrict delete 
a_recurring_gift_batch_fkmd a_recurring_gift_batch.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_recurring_gift_detail_fk1 a_recurring_gift_detail.a_ledger_number_i
a_recurring_gift_detail.a_batch_number_i
a_recurring_gift_detail.a_gift_transaction_number_i
a_recurring_gift.a_ledger_number_i
a_recurring_gift.a_batch_number_i
a_recurring_gift.a_gift_transaction_number_i
Restrict delete 
a_recurring_gift_detail_fk2 a_recurring_gift_detail.a_ledger_number_i
a_recurring_gift_detail.a_motivation_group_code_c
a_recurring_gift_detail.a_motivation_detail_code_c
a_motivation_detail.a_ledger_number_i
a_motivation_detail.a_motivation_group_code_c
a_motivation_detail.a_motivation_detail_code_c
Restrict delete 
a_recurring_gift_detail_fk3 a_recurring_gift_detail.p_recipient_key_n p_partner.p_partner_key_n Restrict delete 
a_recurring_gift_detail_fk4 a_recurring_gift_detail.p_mailing_code_c p_mailing.p_mailing_code_c Restrict delete 
a_recurring_gift_detail_fk5 a_recurring_gift_detail.a_recipient_ledger_number_n p_partner.p_partner_key_n Restrict delete 
a_recurring_gift_detail_fkcr a_recurring_gift_detail.s_created_by_c s_user.s_user_id_c Restrict delete 
a_recurring_gift_detail_fkmd a_recurring_gift_detail.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_recurring_gift_fk1 a_recurring_gift.a_ledger_number_i
a_recurring_gift.a_batch_number_i
a_recurring_gift_batch.a_ledger_number_i
a_recurring_gift_batch.a_batch_number_i
Restrict delete 
a_recurring_gift_fk2 a_recurring_gift.a_method_of_giving_code_c a_method_of_giving.a_method_of_giving_code_c Restrict delete 
a_recurring_gift_fk3 a_recurring_gift.a_method_of_payment_code_c a_method_of_payment.a_method_of_payment_code_c Restrict delete 
a_recurring_gift_fk4 a_recurring_gift.p_donor_key_n p_partner.p_partner_key_n Restrict delete 
a_recurring_gift_fkcr a_recurring_gift.s_created_by_c s_user.s_user_id_c Restrict delete 
a_recurring_gift_fkmd a_recurring_gift.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_recurring_journal_fk1 a_recurring_journal.a_ledger_number_i
a_recurring_journal.a_batch_number_i
a_recurring_batch.a_ledger_number_i
a_recurring_batch.a_batch_number_i
Restrict delete 
a_recurring_journal_fk2 a_recurring_journal.a_ledger_number_i
a_recurring_journal.a_sub_system_code_c
a_recurring_journal.a_transaction_type_code_c
a_transaction_type.a_ledger_number_i
a_transaction_type.a_sub_system_code_c
a_transaction_type.a_transaction_type_code_c
Restrict delete 
a_recurring_journal_fk3 a_recurring_journal.a_method_of_payment_code_c a_method_of_payment.a_method_of_payment_code_c Restrict delete 
a_recurring_journal_fk4 a_recurring_journal.a_transaction_currency_c a_currency.a_currency_code_c Restrict delete 
a_recurring_journal_fkcr a_recurring_journal.s_created_by_c s_user.s_user_id_c Restrict delete 
a_recurring_journal_fkmd a_recurring_journal.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_recurring_trans_anal_attr_fk1 a_recurring_trans_anal_attrib.a_ledger_number_i
a_recurring_trans_anal_attrib.a_batch_number_i
a_recurring_trans_anal_attrib.a_journal_number_i
a_recurring_trans_anal_attrib.a_transaction_number_i
a_recurring_transaction.a_ledger_number_i
a_recurring_transaction.a_batch_number_i
a_recurring_transaction.a_journal_number_i
a_recurring_transaction.a_transaction_number_i
Restrict delete 
a_recurring_trans_anal_attr_fk2 a_recurring_trans_anal_attrib.a_ledger_number_i
a_recurring_trans_anal_attrib.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_recurring_trans_anal_attr_fk3 a_recurring_trans_anal_attrib.a_ledger_number_i
a_recurring_trans_anal_attrib.a_account_code_c
a_recurring_trans_anal_attrib.a_analysis_type_code_c
a_analysis_attribute.a_ledger_number_i
a_analysis_attribute.a_account_code_c
a_analysis_attribute.a_analysis_type_code_c
Restrict delete 
a_recurring_trans_anal_attr_fk4 a_recurring_trans_anal_attrib.a_ledger_number_i
a_recurring_trans_anal_attrib.a_analysis_type_code_c
a_recurring_trans_anal_attrib.a_analysis_attribute_value_c
a_freeform_analysis.a_ledger_number_i
a_freeform_analysis.a_analysis_type_code_c
a_freeform_analysis.a_analysis_value_c
Restrict delete 
a_recurring_trans_anal_attr_fk5 a_recurring_trans_anal_attrib.a_ledger_number_i
a_recurring_trans_anal_attrib.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_recurring_trans_anal_attrib_fkcr a_recurring_trans_anal_attrib.s_created_by_c s_user.s_user_id_c Restrict delete 
a_recurring_trans_anal_attrib_fkmd a_recurring_trans_anal_attrib.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_recurring_transaction_fk1 a_recurring_transaction.a_ledger_number_i
a_recurring_transaction.a_batch_number_i
a_recurring_transaction.a_journal_number_i
a_recurring_journal.a_ledger_number_i
a_recurring_journal.a_batch_number_i
a_recurring_journal.a_journal_number_i
Restrict delete 
a_recurring_transaction_fk2 a_recurring_transaction.a_ledger_number_i
a_recurring_transaction.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_recurring_transaction_fk3 a_recurring_transaction.a_ledger_number_i
a_recurring_transaction.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_recurring_transaction_fk4 a_recurring_transaction.a_transaction_currency_c a_currency.a_currency_code_c Restrict delete 
a_recurring_transaction_fk5 a_recurring_transaction.a_base_currency_c a_currency.a_currency_code_c Restrict delete 
a_recurring_transaction_fk6 a_recurring_transaction.a_method_of_payment_code_c a_method_of_payment.a_method_of_payment_code_c Restrict delete 
a_recurring_transaction_fk7 a_recurring_transaction.s_user_id_c s_user.s_user_id_c Restrict delete 
a_recurring_transaction_fkcr a_recurring_transaction.s_created_by_c s_user.s_user_id_c Restrict delete 
a_recurring_transaction_fkmd a_recurring_transaction.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_special_trans_type_fk1 a_special_trans_type.a_sub_system_code_c a_sub_system.a_sub_system_code_c Restrict delete 
a_special_trans_type_fk2 a_special_trans_type.a_spec_trans_process_to_call_c s_file.s_file_name_c Restrict delete 
a_special_trans_type_fk3 a_special_trans_type.a_spec_trans_undo_process_c s_file.s_file_name_c Restrict delete 
a_special_trans_type_fkcr a_special_trans_type.s_created_by_c s_user.s_user_id_c Restrict delete 
a_special_trans_type_fkmd a_special_trans_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_sub_system_fkcr a_sub_system.s_created_by_c s_user.s_user_id_c Restrict delete 
a_sub_system_fkmd a_sub_system.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_suspence_account_fk1 a_suspense_account.a_ledger_number_i
a_suspense_account.a_suspense_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_suspense_account_fkcr a_suspense_account.s_created_by_c s_user.s_user_id_c Restrict delete 
a_suspense_account_fkmd a_suspense_account.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_system_interface_fk1 a_system_interface.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_system_interface_fk2 a_system_interface.a_sub_system_code_c a_sub_system.a_sub_system_code_c Restrict delete 
a_system_interface_fkcr a_system_interface.s_created_by_c s_user.s_user_id_c Restrict delete 
a_system_interface_fkmd a_system_interface.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_tax_table_fk1 a_tax_table.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_tax_table_fk2 a_tax_table.a_tax_type_code_c a_tax_type.a_tax_type_code_c Restrict delete 
a_tax_table_fkcr a_tax_table.s_created_by_c s_user.s_user_id_c Restrict delete 
a_tax_table_fkmd a_tax_table.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_tax_type_fkcr a_tax_type.s_created_by_c s_user.s_user_id_c Restrict delete 
a_tax_type_fkmd a_tax_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_this_year_old_batch_fk1 a_this_year_old_batch.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_this_year_old_batch_fk2 a_this_year_old_batch.a_ledger_number_i
a_this_year_old_batch.a_batch_period_i
a_accounting_period.a_ledger_number_i
a_accounting_period.a_accounting_period_number_i
Restrict delete 
a_this_year_old_batch_fkcr a_this_year_old_batch.s_created_by_c s_user.s_user_id_c Restrict delete 
a_this_year_old_batch_fkmd a_this_year_old_batch.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_this_year_old_journal_fk1 a_this_year_old_journal.a_ledger_number_i
a_this_year_old_journal.a_batch_number_i
a_this_year_old_batch.a_ledger_number_i
a_this_year_old_batch.a_batch_number_i
Restrict delete 
a_this_year_old_journal_fk2 a_this_year_old_journal.a_ledger_number_i
a_this_year_old_journal.a_journal_period_i
a_accounting_period.a_ledger_number_i
a_accounting_period.a_accounting_period_number_i
Restrict delete 
a_this_year_old_journal_fk3 a_this_year_old_journal.a_ledger_number_i
a_this_year_old_journal.a_sub_system_code_c
a_this_year_old_journal.a_transaction_type_code_c
a_transaction_type.a_ledger_number_i
a_transaction_type.a_sub_system_code_c
a_transaction_type.a_transaction_type_code_c
Restrict delete 
a_this_year_old_journal_fk4 a_this_year_old_journal.a_transaction_currency_c a_currency.a_currency_code_c Restrict delete 
a_this_year_old_journal_fkcr a_this_year_old_journal.s_created_by_c s_user.s_user_id_c Restrict delete 
a_this_year_old_journal_fkmd a_this_year_old_journal.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_this_year_old_transaction_fk1 a_this_year_old_transaction.a_ledger_number_i
a_this_year_old_transaction.a_batch_number_i
a_this_year_old_transaction.a_journal_number_i
a_this_year_old_journal.a_ledger_number_i
a_this_year_old_journal.a_batch_number_i
a_this_year_old_journal.a_journal_number_i
Restrict delete 
a_this_year_old_transaction_fk2 a_this_year_old_transaction.a_ledger_number_i
a_this_year_old_transaction.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_this_year_old_transaction_fk3 a_this_year_old_transaction.a_ledger_number_i
a_this_year_old_transaction.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_this_year_old_transaction_fkcr a_this_year_old_transaction.s_created_by_c s_user.s_user_id_c Restrict delete 
a_this_year_old_transaction_fkmd a_this_year_old_transaction.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_thisyearold_tran_anal_attr_fk1 a_thisyearold_trans_anal_attrib.a_ledger_number_i
a_thisyearold_trans_anal_attrib.a_batch_number_i
a_thisyearold_trans_anal_attrib.a_journal_number_i
a_thisyearold_trans_anal_attrib.a_transaction_number_i
a_this_year_old_transaction.a_ledger_number_i
a_this_year_old_transaction.a_batch_number_i
a_this_year_old_transaction.a_journal_number_i
a_this_year_old_transaction.a_transaction_number_i
Restrict delete 
a_thisyearold_tran_anal_attr_fk2 a_thisyearold_trans_anal_attrib.a_ledger_number_i
a_thisyearold_trans_anal_attrib.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_thisyearold_tran_anal_attr_fk3 a_thisyearold_trans_anal_attrib.a_ledger_number_i
a_thisyearold_trans_anal_attrib.a_account_code_c
a_thisyearold_trans_anal_attrib.a_analysis_type_code_c
a_analysis_attribute.a_ledger_number_i
a_analysis_attribute.a_account_code_c
a_analysis_attribute.a_analysis_type_code_c
Restrict delete 
a_thisyearold_tran_anal_attr_fk4 a_thisyearold_trans_anal_attrib.a_ledger_number_i
a_thisyearold_trans_anal_attrib.a_analysis_type_code_c
a_thisyearold_trans_anal_attrib.a_analysis_attribute_value_c
a_freeform_analysis.a_ledger_number_i
a_freeform_analysis.a_analysis_type_code_c
a_freeform_analysis.a_analysis_value_c
Restrict delete 
a_thisyearold_tran_anal_attr_fk5 a_thisyearold_trans_anal_attrib.a_ledger_number_i
a_thisyearold_trans_anal_attrib.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_thisyearold_trans_anal_attrib_fkcr a_thisyearold_trans_anal_attrib.s_created_by_c s_user.s_user_id_c Restrict delete 
a_thisyearold_trans_anal_attrib_fkmd a_thisyearold_trans_anal_attrib.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_trans_anal_attrib_fk1 a_trans_anal_attrib.a_ledger_number_i
a_trans_anal_attrib.a_batch_number_i
a_trans_anal_attrib.a_journal_number_i
a_trans_anal_attrib.a_transaction_number_i
a_transaction.a_ledger_number_i
a_transaction.a_batch_number_i
a_transaction.a_journal_number_i
a_transaction.a_transaction_number_i
Restrict delete 
a_trans_anal_attrib_fk2 a_trans_anal_attrib.a_ledger_number_i
a_trans_anal_attrib.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_trans_anal_attrib_fk3 a_trans_anal_attrib.a_ledger_number_i
a_trans_anal_attrib.a_account_code_c
a_trans_anal_attrib.a_analysis_type_code_c
a_analysis_attribute.a_ledger_number_i
a_analysis_attribute.a_account_code_c
a_analysis_attribute.a_analysis_type_code_c
Restrict delete 
a_trans_anal_attrib_fk4 a_trans_anal_attrib.a_ledger_number_i
a_trans_anal_attrib.a_analysis_type_code_c
a_trans_anal_attrib.a_analysis_attribute_value_c
a_freeform_analysis.a_ledger_number_i
a_freeform_analysis.a_analysis_type_code_c
a_freeform_analysis.a_analysis_value_c
Restrict delete 
a_trans_anal_attrib_fk5 a_trans_anal_attrib.a_ledger_number_i
a_trans_anal_attrib.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_trans_anal_attrib_fk6 a_trans_anal_attrib.a_ledger_number_i
a_trans_anal_attrib.a_batch_number_i
a_batch.a_ledger_number_i
a_batch.a_batch_number_i
Restrict delete 
a_trans_anal_attrib_fkcr a_trans_anal_attrib.s_created_by_c s_user.s_user_id_c Restrict delete 
a_trans_anal_attrib_fkmd a_trans_anal_attrib.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_transaction_fk1 a_transaction.a_ledger_number_i
a_transaction.a_batch_number_i
a_transaction.a_journal_number_i
a_journal.a_ledger_number_i
a_journal.a_batch_number_i
a_journal.a_journal_number_i
Restrict delete 
a_transaction_fk2 a_transaction.a_ledger_number_i
a_transaction.a_batch_number_i
a_batch.a_ledger_number_i
a_batch.a_batch_number_i
Restrict delete 
a_transaction_fk3 a_transaction.a_ledger_number_i
a_transaction.a_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_transaction_fk4 a_transaction.a_ledger_number_i
a_transaction.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_transaction_fk5 a_transaction.a_key_ministry_key_n p_unit.p_partner_key_n Restrict delete 
a_transaction_fkcr a_transaction.s_created_by_c s_user.s_user_id_c Restrict delete 
a_transaction_fkmd a_transaction.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_transaction_type_fk1 a_transaction_type.a_ledger_number_i
a_transaction_type.a_debit_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_transaction_type_fk2 a_transaction_type.a_ledger_number_i
a_transaction_type.a_credit_account_code_c
a_account.a_ledger_number_i
a_account.a_account_code_c
Restrict delete 
a_transaction_type_fk3 a_transaction_type.a_sub_system_code_c a_sub_system.a_sub_system_code_c Restrict delete 
a_transaction_type_fkcr a_transaction_type.s_created_by_c s_user.s_user_id_c Restrict delete 
a_transaction_type_fkmd a_transaction_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
a_valid_ledger_number_fk1 a_valid_ledger_number.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
a_valid_ledger_number_fk2 a_valid_ledger_number.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
a_valid_ledger_number_fk3 a_valid_ledger_number.a_ilt_processing_centre_n p_partner.p_partner_key_n Restrict delete 
a_valid_ledger_number_fk4 a_valid_ledger_number.a_ledger_number_i
a_valid_ledger_number.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
a_valid_ledger_number_fkcr a_valid_ledger_number.s_created_by_c s_user.s_user_id_c Restrict delete 
a_valid_ledger_number_fkmd a_valid_ledger_number.s_modified_by_c s_user.s_user_id_c Restrict delete 
ar_article_price_fk1 a_ar_article_price.a_ar_article_code_c a_ar_article.a_ar_article_code_c Restrict delete 
ar_article_price_fk2 a_ar_article_price.a_currency_code_c a_currency.a_currency_code_c Restrict delete 
ar_default_discount_fk1 a_ar_default_discount.a_ar_category_code_c a_ar_category.a_ar_category_code_c Restrict delete 
ar_default_discount_fk2 a_ar_default_discount.a_ar_discount_code_c
a_ar_default_discount.a_ar_date_valid_from_d
a_ar_discount.a_ar_discount_code_c
a_ar_discount.a_ar_date_valid_from_d
Restrict delete 
ar_discount_fk1 a_ar_discount.a_currency_code_c a_currency.a_currency_code_c Restrict delete 
ar_discount_fk2 a_ar_discount.p_partner_type_code_c p_type.p_type_code_c Restrict delete 
ar_discount_fk3 a_ar_discount.a_ar_article_code_c a_ar_article.a_ar_article_code_c Restrict delete 
ar_discount_per_category_fk1 a_ar_discount_per_category.a_ar_category_code_c a_ar_category.a_ar_category_code_c Restrict delete 
ar_discount_per_category_fk2 a_ar_discount_per_category.a_ar_discount_code_c
a_ar_discount_per_category.a_ar_date_valid_from_d
a_ar_discount.a_ar_discount_code_c
a_ar_discount.a_ar_date_valid_from_d
Restrict delete 
m_extract_fk1 m_extract.m_extract_id_i m_extract_master.m_extract_id_i Restrict delete 
m_extract_fk2 m_extract.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
m_extract_fk3 m_extract.p_site_key_n
m_extract.p_location_key_i
p_location.p_site_key_n
p_location.p_location_key_i
Restrict delete 
m_extract_fkcr m_extract.s_created_by_c s_user.s_user_id_c Restrict delete 
m_extract_fkmd m_extract.s_modified_by_c s_user.s_user_id_c Restrict delete 
m_extract_master_fk3 m_extract_master.m_manual_mod_by_c s_user.s_user_id_c Restrict delete 
m_extract_master_fk4 m_extract_master.m_extract_type_code_c m_extract_type.m_code_c Restrict delete 
m_extract_master_fkcr m_extract_master.s_created_by_c s_user.s_user_id_c Restrict delete 
m_extract_master_fkmd m_extract_master.s_modified_by_c s_user.s_user_id_c Restrict delete 
m_extract_parameter_fk1 m_extract_parameter.m_extract_id_i m_extract_master.m_extract_id_i Restrict delete 
m_extract_parameter_fkcr m_extract_parameter.s_created_by_c s_user.s_user_id_c Restrict delete 
m_extract_parameter_fkmd m_extract_parameter.s_modified_by_c s_user.s_user_id_c Restrict delete 
m_extract_type_fkcr m_extract_type.s_created_by_c s_user.s_user_id_c Restrict delete 
m_extract_type_fkmd m_extract_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_acquisition_fkcr p_acquisition.s_created_by_c s_user.s_user_id_c Restrict delete 
p_acquisition_fkmd p_acquisition.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_action_fk1 p_action.p_process_code_c p_process.p_process_code_c Restrict delete 
p_action_fkcr p_action.s_created_by_c s_user.s_user_id_c Restrict delete 
p_action_fkmd p_action.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_address_element_fkcr p_address_element.s_created_by_c s_user.s_user_id_c Restrict delete 
p_address_element_fkmd p_address_element.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_address_layout_code_fkcr p_address_layout_code.s_created_by_c s_user.s_user_id_c Restrict delete 
p_address_layout_code_fkmd p_address_layout_code.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_address_layout_fk1 p_address_layout.p_country_code_c p_country.p_country_code_c Restrict delete 
p_address_layout_fk2 p_address_layout.p_address_layout_code_c p_address_layout_code.p_code_c Restrict delete 
p_address_layout_fkcr p_address_layout.s_created_by_c s_user.s_user_id_c Restrict delete 
p_address_layout_fkmd p_address_layout.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_address_line_fk1 p_address_line.p_address_element_code_c p_address_element.p_address_element_code_c Restrict delete 
p_address_line_fkcr p_address_line.s_created_by_c s_user.s_user_id_c Restrict delete 
p_address_line_fkmd p_address_line.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_addressee_title_override_fk1 p_addressee_title_override.p_language_code_c p_language.p_language_code_c Restrict delete 
p_addressee_title_override_fkcr p_addressee_title_override.s_created_by_c s_user.s_user_id_c Restrict delete 
p_addressee_title_override_fkmd p_addressee_title_override.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_addressee_type_fkcr p_addressee_type.s_created_by_c s_user.s_user_id_c Restrict delete 
p_addressee_type_fkmd p_addressee_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_area_fk1 p_foundation_proposal_detail.p_area_partner_key_n p_unit.p_partner_key_n Restrict delete 
p_bank_fk1 p_bank.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_bank_fk2 p_bank.p_contact_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_bank_fkcr p_bank.s_created_by_c s_user.s_user_id_c Restrict delete 
p_bank_fkmd p_bank.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_banking_details_fk3 p_banking_details.p_banking_type_i p_banking_type.p_id_i Restrict delete 
p_banking_details_fk4 p_banking_details.p_bank_key_n p_bank.p_partner_key_n Restrict delete 
p_banking_details_fkcr p_banking_details.s_created_by_c s_user.s_user_id_c Restrict delete 
p_banking_details_fkmd p_banking_details.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_banking_details_usage_fk1 p_banking_details_usage.p_partner_key_n
p_banking_details_usage.p_banking_details_key_i
p_partner_banking_details.p_partner_key_n
p_partner_banking_details.p_banking_details_key_i
Restrict delete 
p_banking_details_usage_fk2 p_banking_details_usage.p_type_c p_banking_details_usage_type.p_type_c Restrict delete 
p_banking_details_usage_fkcr p_banking_details_usage.s_created_by_c s_user.s_user_id_c Restrict delete 
p_banking_details_usage_fkmd p_banking_details_usage.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_banking_details_usage_type_fkcr p_banking_details_usage_type.s_created_by_c s_user.s_user_id_c Restrict delete 
p_banking_details_usage_type_fkmd p_banking_details_usage_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_banking_type_fkcr p_banking_type.s_created_by_c s_user.s_user_id_c Restrict delete 
p_banking_type_fkmd p_banking_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_business_fkcr p_business.s_created_by_c s_user.s_user_id_c Restrict delete 
p_business_fkmd p_business.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_church_fk1 p_church.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_church_fk2 p_church.p_denomination_code_c p_denomination.p_denomination_code_c Restrict delete 
p_church_fk3 p_church.p_contact_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_church_fkcr p_church.s_created_by_c s_user.s_user_id_c Restrict delete 
p_church_fkmd p_church.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_contact_attribute_detail_fk1 p_contact_attribute_detail.p_contact_attribute_code_c p_contact_attribute.p_contact_attribute_code_c Restrict delete 
p_contact_attribute_detail_fkcr p_contact_attribute_detail.s_created_by_c s_user.s_user_id_c Restrict delete 
p_contact_attribute_detail_fkmd p_contact_attribute_detail.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_contact_attribute_fkcr p_contact_attribute.s_created_by_c s_user.s_user_id_c Restrict delete 
p_contact_attribute_fkmd p_contact_attribute.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_country_fk1 p_country.p_internat_postal_type_code_c p_international_postal_type.p_internat_postal_type_code_c Restrict delete 
p_country_fkcr p_country.s_created_by_c s_user.s_user_id_c Restrict delete 
p_country_fkmd p_country.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_customised_greeting_fk1 p_customised_greeting.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_customised_greeting_fk2 p_customised_greeting.s_user_id_c s_user.s_user_id_c Restrict delete 
p_customised_greeting_fkcr p_customised_greeting.s_created_by_c s_user.s_user_id_c Restrict delete 
p_customised_greeting_fkmd p_customised_greeting.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_data_label_fk1 p_data_label.p_currency_code_c a_currency.a_currency_code_c Restrict delete 
p_data_label_fk2 p_data_label.p_lookup_category_code_c p_data_label_lookup_category.p_category_code_c Restrict delete 
p_data_label_fkcr p_data_label.s_created_by_c s_user.s_user_id_c Restrict delete 
p_data_label_fkmd p_data_label.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_data_label_lookup_category_fkcr p_data_label_lookup_category.s_created_by_c s_user.s_user_id_c Restrict delete 
p_data_label_lookup_category_fkmd p_data_label_lookup_category.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_data_label_lookup_fk1 p_data_label_lookup.p_category_code_c p_data_label_lookup_category.p_category_code_c Restrict delete 
p_data_label_lookup_fkcr p_data_label_lookup.s_created_by_c s_user.s_user_id_c Restrict delete 
p_data_label_lookup_fkmd p_data_label_lookup.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_data_label_use_fk1 p_data_label_use.p_data_label_key_i p_data_label.p_key_i Restrict delete 
p_data_label_use_fkcr p_data_label_use.s_created_by_c s_user.s_user_id_c Restrict delete 
p_data_label_use_fkmd p_data_label_use.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_data_label_value_application_fk1 p_data_label_value_application.p_partner_key_n
p_data_label_value_application.pm_application_key_i
p_data_label_value_application.pm_registration_office_n
pm_general_application.p_partner_key_n
pm_general_application.pm_application_key_i
pm_general_application.pm_registration_office_n
Restrict delete 
p_data_label_value_application_fk2 p_data_label_value_application.p_data_label_key_i p_data_label.p_key_i Restrict delete 
p_data_label_value_application_fk3 p_data_label_value_application.p_value_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_data_label_value_application_fkcr p_data_label_value_application.s_created_by_c s_user.s_user_id_c Restrict delete 
p_data_label_value_application_fkmd p_data_label_value_application.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_data_label_value_partner_fk1 p_data_label_value_partner.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_data_label_value_partner_fk2 p_data_label_value_partner.p_data_label_key_i p_data_label.p_key_i Restrict delete 
p_data_label_value_partner_fk3 p_data_label_value_partner.p_value_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_data_label_value_partner_fkcr p_data_label_value_partner.s_created_by_c s_user.s_user_id_c Restrict delete 
p_data_label_value_partner_fkmd p_data_label_value_partner.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_denomination_fkcr p_denomination.s_created_by_c s_user.s_user_id_c Restrict delete 
p_denomination_fkmd p_denomination.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_detail_proposal_fk1 p_foundation_proposal_detail.p_foundation_partner_key_n
p_foundation_proposal_detail.p_foundation_proposal_key_i
p_foundation_proposal.p_foundation_partner_key_n
p_foundation_proposal.p_foundation_proposal_key_i
Restrict delete 
p_detail_proposal_fk2 p_foundation_proposal_detail.p_foundation_partner_key_n p_foundation.p_partner_key_n Restrict delete 
p_email_fkcr p_email.s_created_by_c s_user.s_user_id_c Restrict delete 
p_email_fkmd p_email.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_family_fk1 p_family.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_family_fk2 p_family.p_field_key_n p_unit.p_partner_key_n Restrict delete 
p_family_fk3 p_family.p_marital_status_c pt_marital_status.pt_code_c Restrict delete 
p_family_fkcr p_family.s_created_by_c s_user.s_user_id_c Restrict delete 
p_family_fkmd p_family.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_field_fk1 p_foundation_proposal_detail.p_field_partner_key_n p_unit.p_partner_key_n Restrict delete 
p_file_info_fk1 p_file_info.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_file_info_fk2 p_file_info.s_volume_name_c s_volume.s_name_c Restrict delete 
p_file_info_fkcr p_file_info.s_created_by_c s_user.s_user_id_c Restrict delete 
p_file_info_fkmd p_file_info.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_first_contact_fkcr p_first_contact.s_created_by_c s_user.s_user_id_c Restrict delete 
p_first_contact_fkmd p_first_contact.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_form_letter_body_fk1 p_form_letter_body.p_owner_c s_user.s_user_id_c Restrict delete 
p_form_letter_body_fkcr p_form_letter_body.s_created_by_c s_user.s_user_id_c Restrict delete 
p_form_letter_body_fkmd p_form_letter_body.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_form_letter_design_fk2 p_form_letter_design.p_body_name_c p_form_letter_body.p_body_name_c Restrict delete 
p_form_letter_design_fk3 p_form_letter_design.p_address_layout_code_c p_address_layout_code.p_code_c Restrict delete 
p_form_letter_design_fkcr p_form_letter_design.s_created_by_c s_user.s_user_id_c Restrict delete 
p_form_letter_design_fkmd p_form_letter_design.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_form_letter_insert_fk1 p_form_letter_insert.p_body_name_c p_form_letter_body.p_body_name_c Restrict delete 
p_form_letter_insert_fk2 p_form_letter_insert.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_form_letter_insert_fk3 p_form_letter_insert.m_extract_id_i m_extract_master.m_extract_id_i Restrict delete 
p_form_letter_insert_fkcr p_form_letter_insert.s_created_by_c s_user.s_user_id_c Restrict delete 
p_form_letter_insert_fkmd p_form_letter_insert.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_formality_fk1 p_formality.p_language_code_c p_language.p_language_code_c Restrict delete 
p_formality_fk2 p_formality.p_country_code_c p_country.p_country_code_c Restrict delete 
p_formality_fk3 p_formality.p_addressee_type_code_c p_addressee_type.p_addressee_type_code_c Restrict delete 
p_formality_fkcr p_formality.s_created_by_c s_user.s_user_id_c Restrict delete 
p_formality_fkmd p_formality.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_foundation_contact_fk1 p_foundation.p_contact_partner_n p_partner.p_partner_key_n Restrict delete 
p_foundation_deadline_fk1 p_foundation_deadline.p_foundation_partner_key_n p_foundation.p_partner_key_n Restrict delete 
p_foundation_deadline_fkcr p_foundation_deadline.s_created_by_c s_user.s_user_id_c Restrict delete 
p_foundation_deadline_fkmd p_foundation_deadline.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_foundation_fk1 p_foundation.p_partner_key_n p_organisation.p_partner_key_n Restrict delete 
p_foundation_fkcr p_foundation.s_created_by_c s_user.s_user_id_c Restrict delete 
p_foundation_fkmd p_foundation.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_foundation_proposal_detail_fkcr p_foundation_proposal_detail.s_created_by_c s_user.s_user_id_c Restrict delete 
p_foundation_proposal_detail_fkmd p_foundation_proposal_detail.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_foundation_proposal_fkcr p_foundation_proposal.s_created_by_c s_user.s_user_id_c Restrict delete 
p_foundation_proposal_fkmd p_foundation_proposal.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_foundation_proposal_status_fkcr p_foundation_proposal_status.s_created_by_c s_user.s_user_id_c Restrict delete 
p_foundation_proposal_status_fkmd p_foundation_proposal_status.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_foundation_submission_fk1 p_foundation.p_proposal_submission_type_c p_proposal_submission_type.p_submission_type_code_c Restrict delete 
p_interest_category_fkcr p_interest_category.s_created_by_c s_user.s_user_id_c Restrict delete 
p_interest_category_fkmd p_interest_category.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_interest_fk1 p_interest.p_category_c p_interest_category.p_category_c Restrict delete 
p_interest_fkcr p_interest.s_created_by_c s_user.s_user_id_c Restrict delete 
p_interest_fkmd p_interest.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_international_postal_type_fkcr p_international_postal_type.s_created_by_c s_user.s_user_id_c Restrict delete 
p_international_postal_type_fkmd p_international_postal_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_label_fk1 p_label.s_form_name_c s_form.s_form_name_c Restrict delete 
p_label_fkcr p_label.s_created_by_c s_user.s_user_id_c Restrict delete 
p_label_fkmd p_label.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_language_fkcr p_language.s_created_by_c s_user.s_user_id_c Restrict delete 
p_language_fkmd p_language.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_location_fk1 p_location.p_country_code_c p_country.p_country_code_c Restrict delete 
p_location_fkcr p_location.s_created_by_c s_user.s_user_id_c Restrict delete 
p_location_fkmd p_location.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_location_type_fkcr p_location_type.s_created_by_c s_user.s_user_id_c Restrict delete 
p_location_type_fkmd p_location_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_mailing_fkcr p_mailing.s_created_by_c s_user.s_user_id_c Restrict delete 
p_mailing_fkmd p_mailing.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_merge_field_fk1 p_merge_field.p_merge_form_name_c p_merge_form.p_merge_form_name_c Restrict delete 
p_merge_field_fkcr p_merge_field.s_created_by_c s_user.s_user_id_c Restrict delete 
p_merge_field_fkmd p_merge_field.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_merge_form_fkcr p_merge_form.s_created_by_c s_user.s_user_id_c Restrict delete 
p_merge_form_fkmd p_merge_form.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_method_of_contact_fkcr p_method_of_contact.s_created_by_c s_user.s_user_id_c Restrict delete 
p_method_of_contact_fkmd p_method_of_contact.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_occupation_fkcr p_occupation.s_created_by_c s_user.s_user_id_c Restrict delete 
p_occupation_fkmd p_occupation.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_organisation_fk1 p_organisation.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_organisation_fk2 p_organisation.p_business_code_c p_business.p_business_code_c Restrict delete 
p_organisation_fk3 p_organisation.p_contact_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_organisation_fkcr p_organisation.s_created_by_c s_user.s_user_id_c Restrict delete 
p_organisation_fkmd p_organisation.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_action_fk1 p_partner_action.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_action_fk2 p_partner_action.p_process_code_c
p_partner_action.p_action_code_c
p_action.p_process_code_c
p_action.p_action_code_c
Restrict delete 
p_partner_action_fk3 p_partner_action.p_user_to_perform_action_c s_user.s_user_id_c Restrict delete 
p_partner_action_fk4 p_partner_action.p_group_to_perform_action_c
p_partner_action.s_group_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
p_partner_action_fk5 p_partner_action.p_user_that_performed_action_c s_user.s_user_id_c Restrict delete 
p_partner_action_fk6 p_partner_action.p_partner_key_n
p_partner_action.p_contact_id_i
p_partner_action.p_reminder_id_i
p_partner_reminder.p_partner_key_n
p_partner_reminder.p_contact_id_i
p_partner_reminder.p_reminder_id_i
Restrict delete 
p_partner_action_fkcr p_partner_action.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_action_fkmd p_partner_action.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_attribute_fk1 p_partner_attribute.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_attribute_fk2 p_partner_attribute.p_code_c p_partner_attribute_type.p_code_c Restrict delete 
p_partner_attribute_fkcr p_partner_attribute.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_attribute_fkmd p_partner_attribute.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_attribute_type_fkcr p_partner_attribute_type.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_attribute_type_fkmd p_partner_attribute_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_banking_details_fkcr p_partner_banking_details.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_banking_details_fkmd p_partner_banking_details.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_banking_link_fk1 p_partner_banking_details.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_banking_link_fk2 p_partner_banking_details.p_banking_details_key_i p_banking_details.p_banking_details_key_i Restrict delete 
p_partner_classes_fkcr p_partner_classes.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_classes_fkmd p_partner_classes.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_comment_fk1 p_partner_comment.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_comment_fkcr p_partner_comment.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_comment_fkmd p_partner_comment.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_contact_attribute_fk1 p_partner_contact_attribute.p_contact_attribute_code_c
p_partner_contact_attribute.p_contact_attr_detail_code_c
p_contact_attribute_detail.p_contact_attribute_code_c
p_contact_attribute_detail.p_contact_attr_detail_code_c
Restrict delete 
p_partner_contact_attribute_fk2 p_partner_contact_attribute.p_contact_id_i p_partner_contact.p_contact_id_i Restrict delete 
p_partner_contact_attribute_fkcr p_partner_contact_attribute.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_contact_attribute_fkmd p_partner_contact_attribute.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_contact_file_fk1 p_partner_contact_file.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_contact_file_fk2 p_partner_contact_file.p_file_info_key_n p_file_info.p_key_n Restrict delete 
p_partner_contact_file_fk3 p_partner_contact_file.p_contact_id_i p_partner_contact.p_contact_id_i Restrict delete 
p_partner_contact_file_fkcr p_partner_contact_file.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_contact_file_fkmd p_partner_contact_file.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_contact_fk1 p_partner_contact.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_contact_fk2 p_partner_contact.p_mailing_code_c p_mailing.p_mailing_code_c Restrict delete 
p_partner_contact_fk3 p_partner_contact.p_contact_code_c p_method_of_contact.p_method_of_contact_code_c Restrict delete 
p_partner_contact_fk4 p_partner_contact.s_module_id_c s_module.s_module_id_c Restrict delete 
p_partner_contact_fk7 p_partner_contact.s_user_id_c s_user.s_user_id_c Restrict delete 
p_partner_contact_fkcr p_partner_contact.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_contact_fkmd p_partner_contact.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_field_of_service_fk1 p_partner_field_of_service.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_field_of_service_fk2 p_partner_field_of_service.p_field_key_n p_unit.p_partner_key_n Restrict delete 
p_partner_field_of_service_fk3 p_partner_field_of_service.p_partner_class_c p_partner_classes.p_partner_class_c Restrict delete 
p_partner_field_of_service_fk4 p_partner_field_of_service.p_commitment_site_key_n
p_partner_field_of_service.p_commitment_key_n
pm_staff_data.p_site_key_n
pm_staff_data.pm_key_n
Restrict delete 
p_partner_field_of_service_fkcr p_partner_field_of_service.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_field_of_service_fkmd p_partner_field_of_service.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_file_fk1 p_partner_file.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_file_fk2 p_partner_file.p_file_info_key_n p_file_info.p_key_n Restrict delete 
p_partner_file_fkcr p_partner_file.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_file_fkmd p_partner_file.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_fk1 p_partner.p_acquisition_code_c p_acquisition.p_acquisition_code_c Restrict delete 
p_partner_fk2 p_partner.p_language_code_c p_language.p_language_code_c Restrict delete 
p_partner_fk3 p_partner.p_status_code_c p_partner_status.p_status_code_c Restrict delete 
p_partner_fk4 p_partner.p_addressee_type_code_c p_addressee_type.p_addressee_type_code_c Restrict delete 
p_partner_fk7 p_partner.p_partner_class_c p_partner_classes.p_partner_class_c Restrict delete 
p_partner_fk8 p_partner.p_first_contact_code_c p_first_contact.p_first_contact_code_c Restrict delete 
p_partner_fkcr p_partner.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_fkmd p_partner.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_graphic_fk1 p_partner_graphic.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_graphic_fk2 p_partner_graphic.p_file_info_key_n p_file_info.p_key_n Restrict delete 
p_partner_graphic_fkcr p_partner_graphic.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_graphic_fkmd p_partner_graphic.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_interest_fk1 p_partner_interest.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_interest_fk2 p_partner_interest.p_field_key_n p_unit.p_partner_key_n Restrict delete 
p_partner_interest_fk3 p_partner_interest.p_country_c p_country.p_country_code_c Restrict delete 
p_partner_interest_fk4 p_partner_interest.p_interest_c p_interest.p_interest_c Restrict delete 
p_partner_interest_fkcr p_partner_interest.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_interest_fkmd p_partner_interest.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_ledger_fk1 p_partner_ledger.p_partner_key_n p_unit.p_partner_key_n Restrict delete 
p_partner_ledger_fkcr p_partner_ledger.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_ledger_fkmd p_partner_ledger.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_location_fk1 p_partner_location.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_location_fk2 p_partner_location.p_site_key_n
p_partner_location.p_location_key_i
p_location.p_site_key_n
p_location.p_location_key_i
Restrict delete 
p_partner_location_fk3 p_partner_location.p_location_type_c p_location_type.p_code_c Restrict delete 
p_partner_location_fkcr p_partner_location.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_location_fkmd p_partner_location.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_merge_fk1 p_partner_merge.p_merge_from_n p_partner.p_partner_key_n Restrict delete 
p_partner_merge_fk2 p_partner_merge.p_merge_to_n p_partner.p_partner_key_n Restrict delete 
p_partner_merge_fk3 p_partner_merge.s_merged_by_c s_user.s_user_id_c Restrict delete 
p_partner_merge_fkcr p_partner_merge.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_merge_fkmd p_partner_merge.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_relationship_fk1 p_partner_relationship.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_relationship_fk2 p_partner_relationship.p_relation_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_relationship_fk3 p_partner_relationship.p_relation_name_c p_relation.p_relation_name_c Restrict delete 
p_partner_relationship_fkcr p_partner_relationship.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_relationship_fkmd p_partner_relationship.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_reminder_fk1 p_partner_reminder.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_reminder_fk2 p_partner_reminder.p_contact_id_i p_partner_contact.p_contact_id_i Restrict delete 
p_partner_reminder_fk3 p_partner_reminder.s_user_id_c s_user.s_user_id_c Restrict delete 
p_partner_reminder_fk4 p_partner_reminder.s_module_id_c s_module.s_module_id_c Restrict delete 
p_partner_reminder_fk5 p_partner_reminder.s_user_restriction_c s_user.s_user_id_c Restrict delete 
p_partner_reminder_fk6 p_partner_reminder.p_category_code_c p_reminder_category.p_code_c Restrict delete 
p_partner_reminder_fkcr p_partner_reminder.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_reminder_fkmd p_partner_reminder.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_set_fk1 p_partner_set.p_unit_key_n p_unit.p_partner_key_n Restrict delete 
p_partner_set_fkcr p_partner_set.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_set_fkmd p_partner_set.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_set_partner_fk1 p_partner_set_partner.p_partner_set_id_c
p_partner_set_partner.p_partner_set_unit_key_n
p_partner_set.p_partner_set_id_c
p_partner_set.p_unit_key_n
Restrict delete 
p_partner_set_partner_fk2 p_partner_set_partner.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_set_partner_fkcr p_partner_set_partner.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_set_partner_fkmd p_partner_set_partner.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_short_code_fk1 p_partner_short_code.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_short_code_fkcr p_partner_short_code.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_short_code_fkmd p_partner_short_code.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_state_fk1 p_partner_state.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_state_fk2 p_partner_state.p_process_code_c
p_partner_state.p_state_code_c
p_state.p_process_code_c
p_state.p_state_code_c
Restrict delete 
p_partner_state_fkcr p_partner_state.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_state_fkmd p_partner_state.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_status_fkcr p_partner_status.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_status_fkmd p_partner_status.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_tax_deductible_pct_fk1 p_partner_tax_deductible_pct.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_tax_deductible_pct_fkcr p_partner_tax_deductible_pct.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_tax_deductible_pct_fkmd p_partner_tax_deductible_pct.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_partner_type_fk3 p_partner_type.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_partner_type_fk4 p_partner_type.p_type_code_c p_type.p_type_code_c Restrict delete 
p_partner_type_fkcr p_partner_type.s_created_by_c s_user.s_user_id_c Restrict delete 
p_partner_type_fkmd p_partner_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_person_fk1 p_person.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_person_fk2 p_person.p_family_key_n p_family.p_partner_key_n Restrict delete 
p_person_fk3 p_person.p_marital_status_c pt_marital_status.pt_code_c Restrict delete 
p_person_fk4 p_person.p_field_key_n p_unit.p_partner_key_n Restrict delete 
p_person_fk5 p_person.p_occupation_code_c p_occupation.p_occupation_code_c Restrict delete 
p_person_fkcr p_person.s_created_by_c s_user.s_user_id_c Restrict delete 
p_person_fkmd p_person.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_postcode_range_fkcr p_postcode_range.s_created_by_c s_user.s_user_id_c Restrict delete 
p_postcode_range_fkmd p_postcode_range.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_postcode_region_fk1 p_postcode_region.p_range_c p_postcode_range.p_range_c Restrict delete 
p_postcode_region_fkcr p_postcode_region.s_created_by_c s_user.s_user_id_c Restrict delete 
p_postcode_region_fkmd p_postcode_region.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_process_fkcr p_process.s_created_by_c s_user.s_user_id_c Restrict delete 
p_process_fkmd p_process.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_proposal_ministry_fk1 p_foundation_proposal_detail.p_key_ministry_key_n p_unit.p_partner_key_n Restrict delete 
p_proposal_motivation_fk1 p_foundation_proposal_detail.p_project_ledger_number_i
p_foundation_proposal_detail.p_project_motivation_group_c
p_foundation_proposal_detail.p_project_motivation_detail_c
a_motivation_detail.a_ledger_number_i
a_motivation_detail.a_motivation_group_code_c
a_motivation_detail.a_motivation_detail_code_c
Restrict delete 
p_proposal_status_fk1 p_foundation_proposal.p_foundation_partner_key_n p_foundation.p_partner_key_n Restrict delete 
p_proposal_status_fk2 p_foundation_proposal.p_proposal_status_c p_foundation_proposal_status.p_status_code_c Restrict delete 
p_proposal_submission_type_fkcr p_proposal_submission_type.s_created_by_c s_user.s_user_id_c Restrict delete 
p_proposal_submission_type_fkmd p_proposal_submission_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_proposal_submitted_fk3 p_foundation_proposal.p_partner_submitted_by_n p_partner.p_partner_key_n Restrict delete 
p_publication_cost_fk1 p_publication_cost.p_publication_code_c p_publication.p_publication_code_c Restrict delete 
p_publication_cost_fk2 p_publication_cost.p_currency_code_c a_currency.a_currency_code_c Restrict delete 
p_publication_cost_fkcr p_publication_cost.s_created_by_c s_user.s_user_id_c Restrict delete 
p_publication_cost_fkmd p_publication_cost.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_publication_fk1 p_publication.a_frequency_code_c a_frequency.a_frequency_code_c Restrict delete 
p_publication_fk2 p_publication.p_publication_language_c p_language.p_language_code_c Restrict delete 
p_publication_fkcr p_publication.s_created_by_c s_user.s_user_id_c Restrict delete 
p_publication_fkmd p_publication.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_reason_subscription_cancelled_fkcr p_reason_subscription_cancelled.s_created_by_c s_user.s_user_id_c Restrict delete 
p_reason_subscription_cancelled_fkmd p_reason_subscription_cancelled.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_reason_subscription_given_fkcr p_reason_subscription_given.s_created_by_c s_user.s_user_id_c Restrict delete 
p_reason_subscription_given_fkmd p_reason_subscription_given.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_recent_partners_fk1 p_recent_partners.s_user_id_c s_user.s_user_id_c Restrict delete 
p_recent_partners_fk2 p_recent_partners.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_recent_partners_fkcr p_recent_partners.s_created_by_c s_user.s_user_id_c Restrict delete 
p_recent_partners_fkmd p_recent_partners.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_relation_category_fkcr p_relation_category.s_created_by_c s_user.s_user_id_c Restrict delete 
p_relation_category_fkmd p_relation_category.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_relation_fk1 p_relation.p_relation_category_c p_relation_category.p_code_c Restrict delete 
p_relation_fkcr p_relation.s_created_by_c s_user.s_user_id_c Restrict delete 
p_relation_fkmd p_relation.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_reminder_category_fkcr p_reminder_category.s_created_by_c s_user.s_user_id_c Restrict delete 
p_reminder_category_fkmd p_reminder_category.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_reports_fk1 p_reports.p_report_program_c s_file.s_file_name_c Restrict delete 
p_reports_fkcr p_reports.s_created_by_c s_user.s_user_id_c Restrict delete 
p_reports_fkmd p_reports.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_state_fk1 p_state.p_process_code_c p_process.p_process_code_c Restrict delete 
p_state_fkcr p_state.s_created_by_c s_user.s_user_id_c Restrict delete 
p_state_fkmd p_state.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_subscription_fk1 p_subscription.p_publication_code_c p_publication.p_publication_code_c Restrict delete 
p_subscription_fk2 p_subscription.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_subscription_fk3 p_subscription.p_gift_from_key_n p_partner.p_partner_key_n Restrict delete 
p_subscription_fk4 p_subscription.p_reason_subs_given_code_c p_reason_subscription_given.p_code_c Restrict delete 
p_subscription_fk5 p_subscription.p_reason_subs_cancelled_code_c p_reason_subscription_cancelled.p_code_c Restrict delete 
p_subscription_fkcr p_subscription.s_created_by_c s_user.s_user_id_c Restrict delete 
p_subscription_fkmd p_subscription.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_tax_fk1 p_tax.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_tax_fkcr p_tax.s_created_by_c s_user.s_user_id_c Restrict delete 
p_tax_fkmd p_tax.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_title_fk1 p_title.p_default_addressee_type_code_c p_addressee_type.p_addressee_type_code_c Restrict delete 
p_title_fkcr p_title.s_created_by_c s_user.s_user_id_c Restrict delete 
p_title_fkmd p_title.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_type_category_fkcr p_type_category.s_created_by_c s_user.s_user_id_c Restrict delete 
p_type_category_fkmd p_type_category.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_type_fk1 p_type.p_category_code_c p_type_category.p_code_c Restrict delete 
p_type_fkcr p_type.s_created_by_c s_user.s_user_id_c Restrict delete 
p_type_fkmd p_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_unit_fk1 p_unit.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_unit_fk2 p_unit.u_unit_type_code_c u_unit_type.u_unit_type_code_c Restrict delete 
p_unit_fk3 p_unit.p_country_code_c p_country.p_country_code_c Restrict delete 
p_unit_fk4 p_unit.p_outreach_cost_currency_code_c a_currency.a_currency_code_c Restrict delete 
p_unit_fk7 p_unit.p_primary_office_n p_partner.p_partner_key_n Restrict delete 
p_unit_fkcr p_unit.s_created_by_c s_user.s_user_id_c Restrict delete 
p_unit_fkmd p_unit.s_modified_by_c s_user.s_user_id_c Restrict delete 
p_venue_fk1 p_venue.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_venue_fk2 p_venue.a_currency_code_c a_currency.a_currency_code_c Restrict delete 
p_venue_fk3 p_venue.p_contact_partner_key_n p_partner.p_partner_key_n Restrict delete 
p_venue_fkcr p_venue.s_created_by_c s_user.s_user_id_c Restrict delete 
p_venue_fkmd p_venue.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_attendee_fk1 pc_attendee.pc_conference_key_n pc_conference.pc_conference_key_n Restrict delete 
pc_attendee_fk2 pc_attendee.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pc_attendee_fk3 pc_attendee.pc_home_office_key_n p_unit.p_partner_key_n Restrict delete 
pc_attendee_fkcr pc_attendee.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_attendee_fkmd pc_attendee.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_building_fk1 pc_building.p_venue_key_n p_venue.p_partner_key_n Restrict delete 
pc_building_fkcr pc_building.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_building_fkmd pc_building.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_conference_cost_fk1 pc_conference_cost.pc_conference_key_n pc_conference.pc_conference_key_n Restrict delete 
pc_conference_cost_fkcr pc_conference_cost.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_conference_cost_fkmd pc_conference_cost.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_conference_fk1 pc_conference.pc_conference_key_n p_unit.p_partner_key_n Restrict delete 
pc_conference_fk2 pc_conference.a_currency_code_c a_currency.a_currency_code_c Restrict delete 
pc_conference_fkcr pc_conference.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_conference_fkmd pc_conference.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_conference_option_fk1 pc_conference_option.pc_conference_key_n pc_conference.pc_conference_key_n Restrict delete 
pc_conference_option_fk2 pc_conference_option.pc_option_type_code_c pc_conference_option_type.pc_option_type_code_c Restrict delete 
pc_conference_option_fkcr pc_conference_option.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_conference_option_fkmd pc_conference_option.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_conference_option_type_fkcr pc_conference_option_type.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_conference_option_type_fkmd pc_conference_option_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_conference_venue_fk1 pc_conference_venue.pc_conference_key_n pc_conference.pc_conference_key_n Restrict delete 
pc_conference_venue_fk2 pc_conference_venue.p_venue_key_n p_venue.p_partner_key_n Restrict delete 
pc_conference_venue_fkcr pc_conference_venue.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_conference_venue_fkmd pc_conference_venue.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_cost_type_fkcr pc_cost_type.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_cost_type_fkmd pc_cost_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_discount_criteria_fkcr pc_discount_criteria.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_discount_criteria_fkmd pc_discount_criteria.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_discount_fk1 pc_discount.pc_conference_key_n pc_conference.pc_conference_key_n Restrict delete 
pc_discount_fk2 pc_discount.pc_discount_criteria_code_c pc_discount_criteria.pc_discount_criteria_code_c Restrict delete 
pc_discount_fk3 pc_discount.pc_cost_type_code_c pc_cost_type.pc_cost_type_code_c Restrict delete 
pc_discount_fkcr pc_discount.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_discount_fkmd pc_discount.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_early_late_fk1 pc_early_late.pc_conference_key_n pc_conference.pc_conference_key_n Restrict delete 
pc_early_late_fkcr pc_early_late.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_early_late_fkmd pc_early_late.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_extra_cost_fk1 pc_extra_cost.pc_conference_key_n
pc_extra_cost.p_partner_key_n
pc_attendee.pc_conference_key_n
pc_attendee.p_partner_key_n
Restrict delete 
pc_extra_cost_fk2 pc_extra_cost.pc_cost_type_code_c pc_cost_type.pc_cost_type_code_c Restrict delete 
pc_extra_cost_fk3 pc_extra_cost.pc_authorising_field_n p_unit.p_partner_key_n Restrict delete 
pc_extra_cost_fkcr pc_extra_cost.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_extra_cost_fkmd pc_extra_cost.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_group_fk1 pc_group.pc_conference_key_n
pc_group.p_partner_key_n
pc_attendee.pc_conference_key_n
pc_attendee.p_partner_key_n
Restrict delete 
pc_group_fkcr pc_group.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_group_fkmd pc_group.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_room_alloc_fk1 pc_room_alloc.pc_conference_key_n
pc_room_alloc.p_partner_key_n
pc_attendee.pc_conference_key_n
pc_attendee.p_partner_key_n
Restrict delete 
pc_room_alloc_fk2 pc_room_alloc.p_venue_key_n
pc_room_alloc.pc_building_code_c
pc_room_alloc.pc_room_number_c
pc_room.p_venue_key_n
pc_room.pc_building_code_c
pc_room.pc_room_number_c
Restrict delete 
pc_room_alloc_fkcr pc_room_alloc.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_room_alloc_fkmd pc_room_alloc.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_room_attribute_fk1 pc_room_attribute.p_venue_key_n
pc_room_attribute.pc_building_code_c
pc_room_attribute.pc_room_number_c
pc_room.p_venue_key_n
pc_room.pc_building_code_c
pc_room.pc_room_number_c
Restrict delete 
pc_room_attribute_fk2 pc_room_attribute.pc_room_attr_type_code_c pc_room_attribute_type.pc_code_c Restrict delete 
pc_room_attribute_fkcr pc_room_attribute.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_room_attribute_fkmd pc_room_attribute.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_room_attribute_type_fkcr pc_room_attribute_type.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_room_attribute_type_fkmd pc_room_attribute_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_room_fk1 pc_room.p_venue_key_n
pc_room.pc_building_code_c
pc_building.p_venue_key_n
pc_building.pc_building_code_c
Restrict delete 
pc_room_fkcr pc_room.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_room_fkmd pc_room.s_modified_by_c s_user.s_user_id_c Restrict delete 
pc_supplement_fk1 pc_supplement.pc_conference_key_n pc_conference.pc_conference_key_n Restrict delete 
pc_supplement_fkcr pc_supplement.s_created_by_c s_user.s_user_id_c Restrict delete 
pc_supplement_fkmd pc_supplement.s_modified_by_c s_user.s_user_id_c Restrict delete 
ph_booking_fk1 ph_booking.p_contact_key_n p_partner.p_partner_key_n Restrict delete 
ph_booking_fk2 ph_booking.a_ledger_number_for_invoice_i
ph_booking.a_ar_invoice_key_i
a_ar_invoice.a_ledger_number_i
a_ar_invoice.a_key_i
Restrict delete 
ph_booking_fkcr ph_booking.s_created_by_c s_user.s_user_id_c Restrict delete 
ph_booking_fkmd ph_booking.s_modified_by_c s_user.s_user_id_c Restrict delete 
ph_room_booking_fk1 ph_room_booking.ph_booking_key_i ph_booking.ph_key_i Restrict delete 
ph_room_booking_fk2 ph_room_booking.ph_room_alloc_key_i pc_room_alloc.pc_key_i Restrict delete 
ph_room_booking_fkcr ph_room_booking.s_created_by_c s_user.s_user_id_c Restrict delete 
ph_room_booking_fkmd ph_room_booking.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_application_file_fk1 pm_application_file.p_file_info_key_n p_file_info.p_key_n Restrict delete 
pm_application_file_fk2 pm_application_file.p_partner_key_n
pm_application_file.pm_application_key_i
pm_application_file.pm_registration_office_n
pm_general_application.p_partner_key_n
pm_general_application.pm_application_key_i
pm_general_application.pm_registration_office_n
Restrict delete 
pm_application_file_fkcr pm_application_file.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_application_file_fkmd pm_application_file.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_application_forms_file_fk1 pm_application_forms_file.p_file_info_key_n p_file_info.p_key_n Restrict delete 
pm_application_forms_file_fk2 pm_application_forms_file.p_partner_key_n
pm_application_forms_file.pm_application_key_i
pm_application_forms_file.pm_registration_office_n
pm_application_forms_file.pt_form_name_c
pm_application_forms.p_partner_key_n
pm_application_forms.pm_application_key_i
pm_application_forms.pm_registration_office_n
pm_application_forms.pt_form_name_c
Restrict delete 
pm_application_forms_file_fkcr pm_application_forms_file.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_application_forms_file_fkmd pm_application_forms_file.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_application_forms_fk1 pm_application_forms.p_partner_key_n
pm_application_forms.pm_application_key_i
pm_application_forms.pm_registration_office_n
pm_general_application.p_partner_key_n
pm_general_application.pm_application_key_i
pm_general_application.pm_registration_office_n
Restrict delete 
pm_application_forms_fk2 pm_application_forms.pt_form_name_c pt_app_form_types.pt_form_name_c Restrict delete 
pm_application_forms_fk3 pm_application_forms.pm_reference_partner_key_n p_partner.p_partner_key_n Restrict delete 
pm_application_forms_fkcr pm_application_forms.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_application_forms_fkmd pm_application_forms.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_application_status_history_fk1 pm_application_status_history.p_partner_key_n
pm_application_status_history.pm_application_key_i
pm_application_status_history.pm_registration_office_n
pm_general_application.p_partner_key_n
pm_general_application.pm_application_key_i
pm_general_application.pm_registration_office_n
Restrict delete 
pm_application_status_history_fk2 pm_application_status_history.pm_status_code_c pt_applicant_status.pt_code_c Restrict delete 
pm_application_status_history_fkcr pm_application_status_history.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_application_status_history_fkmd pm_application_status_history.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_commitment_status_fkcr pm_commitment_status.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_commitment_status_fkmd pm_commitment_status.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_document_category_fkcr pm_document_category.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_document_category_fkmd pm_document_category.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_document_file_fk1 pm_document_file.p_file_info_key_n p_file_info.p_key_n Restrict delete 
pm_document_file_fk2 pm_document_file.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
pm_document_file_fk3 pm_document_file.p_site_key_n
pm_document_file.pm_document_key_n
pm_document.p_site_key_n
pm_document.pm_document_key_n
Restrict delete 
pm_document_file_fkcr pm_document_file.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_document_file_fkmd pm_document_file.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_document_fk1 pm_document.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_document_fk2 pm_document.pm_doc_code_c pm_document_type.pm_doc_code_c Restrict delete 
pm_document_fk3 pm_document.pm_contact_partner_key_n p_partner.p_partner_key_n Restrict delete 
pm_document_fkcr pm_document.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_document_fkmd pm_document.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_document_type_fk1 pm_document_type.pm_doc_category_c pm_document_category.pm_code_c Restrict delete 
pm_document_type_fkcr pm_document_type.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_document_type_fkmd pm_document_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_formal_education_fk1 pm_formal_education.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_formal_education_fk2 pm_formal_education.p_country_code_c p_country.p_country_code_c Restrict delete 
pm_formal_education_fkcr pm_formal_education.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_formal_education_fkmd pm_formal_education.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_general_application_fk1 pm_general_application.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_general_application_fk10 pm_general_application.pm_closed_by_c s_user.s_user_id_c Restrict delete 
pm_general_application_fk2 pm_general_application.pm_registration_office_n p_unit.p_partner_key_n Restrict delete 
pm_general_application_fk3 pm_general_application.pm_gen_app_poss_srv_unit_key_n p_unit.p_partner_key_n Restrict delete 
pm_general_application_fk4 pm_general_application.pm_gen_application_status_c pt_applicant_status.pt_code_c Restrict delete 
pm_general_application_fk5 pm_general_application.pt_app_type_name_c pt_application_type.pt_app_type_name_c Restrict delete 
pm_general_application_fk6 pm_general_application.pm_gen_contact1_c pt_contact.pt_contact_name_c Restrict delete 
pm_general_application_fk7 pm_general_application.pm_gen_contact2_c pt_contact.pt_contact_name_c Restrict delete 
pm_general_application_fk8 pm_general_application.pm_gen_app_currency_code_c a_currency.a_currency_code_c Restrict delete 
pm_general_application_fk9 pm_general_application.pm_placement_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_general_application_fkcr pm_general_application.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_general_application_fkmd pm_general_application.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_interview_fk1 pm_interview.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_interview_fkcr pm_interview.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_interview_fkmd pm_interview.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_job_assignment_fk1 pm_job_assignment.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
pm_job_assignment_fk2 pm_job_assignment.pm_unit_key_n
pm_job_assignment.pt_position_name_c
pm_job_assignment.pt_position_scope_c
pm_job_assignment.um_job_key_i
um_job.pm_unit_key_n
um_job.pt_position_name_c
um_job.pt_position_scope_c
um_job.um_job_key_i
Restrict delete 
pm_job_assignment_fk3 pm_job_assignment.pt_assignment_type_code_c pt_assignment_type.pt_assignment_type_code_c Restrict delete 
pm_job_assignment_fk4 pm_job_assignment.pm_leaving_code_c pt_leaving_code.pt_leaving_code_ind_c Restrict delete 
pm_job_assignment_fkcr pm_job_assignment.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_job_assignment_fkmd pm_job_assignment.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_long_term_support_figures_fk1 pm_long_term_support_figures.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_long_term_support_figures_fkcr pm_long_term_support_figures.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_long_term_support_figures_fkmd pm_long_term_support_figures.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_ownership_fk1 pm_ownership.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_ownership_fk2 pm_ownership.pt_valuable_item_name_c pt_valuable_item.pt_valuable_item_name_c Restrict delete 
pm_ownership_fkcr pm_ownership.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_ownership_fkmd pm_ownership.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_passport_details_fk1 pm_passport_details.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_passport_details_fk2 pm_passport_details.pm_passport_details_type_c pt_passport_type.pt_code_c Restrict delete 
pm_passport_details_fk3 pm_passport_details.p_passport_nationality_code_c p_country.p_country_code_c Restrict delete 
pm_passport_details_fk4 pm_passport_details.p_country_of_issue_c p_country.p_country_code_c Restrict delete 
pm_passport_details_fkcr pm_passport_details.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_passport_details_fkmd pm_passport_details.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_past_experience_fk1 pm_past_experience.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_past_experience_fkcr pm_past_experience.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_past_experience_fkmd pm_past_experience.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_pers_office_specific_data_fk1 pm_pers_office_specific_data.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_pers_office_specific_data_fkcr pm_pers_office_specific_data.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_pers_office_specific_data_fkmd pm_pers_office_specific_data.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_person_ability_fk1 pm_person_ability.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_person_ability_fk2 pm_person_ability.pt_ability_area_name_c pt_ability_area.pt_ability_area_name_c Restrict delete 
pm_person_ability_fk3 pm_person_ability.pt_ability_level_i pt_ability_level.pt_ability_level_i Restrict delete 
pm_person_ability_fkcr pm_person_ability.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_person_ability_fkmd pm_person_ability.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_person_absence_fk1 pm_person_absence.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_person_absence_fkcr pm_person_absence.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_person_absence_fkmd pm_person_absence.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_person_commitment_status_fk1 pm_person_commitment_status.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_person_commitment_status_fk2 pm_person_commitment_status.pm_status_code_c pm_commitment_status.pm_code_c Restrict delete 
pm_person_commitment_status_fkcr pm_person_commitment_status.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_person_commitment_status_fkmd pm_person_commitment_status.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_person_evaluation_fk1 pm_person_evaluation.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_person_evaluation_fkcr pm_person_evaluation.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_person_evaluation_fkmd pm_person_evaluation.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_person_file_fk1 pm_person_file.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_person_file_fk2 pm_person_file.p_file_info_key_n p_file_info.p_key_n Restrict delete 
pm_person_file_fkcr pm_person_file.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_person_file_fkmd pm_person_file.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_person_language_fk1 pm_person_language.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_person_language_fk2 pm_person_language.p_language_code_c p_language.p_language_code_c Restrict delete 
pm_person_language_fk3 pm_person_language.pt_language_level_i pt_language_level.pt_language_level_i Restrict delete 
pm_person_language_fkcr pm_person_language.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_person_language_fkmd pm_person_language.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_person_qualification_fk1 pm_person_qualification.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_person_qualification_fk2 pm_person_qualification.pt_qualification_area_name_c pt_qualification_area.pt_qualification_area_name_c Restrict delete 
pm_person_qualification_fk3 pm_person_qualification.pt_qualification_level_i pt_qualification_level.pt_qualification_level_i Restrict delete 
pm_person_qualification_fkcr pm_person_qualification.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_person_qualification_fkmd pm_person_qualification.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_person_skill_fk1 pm_person_skill.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_person_skill_fk2 pm_person_skill.pm_skill_category_code_c pt_skill_category.pt_code_c Restrict delete 
pm_person_skill_fk3 pm_person_skill.pm_description_language_c p_language.p_language_code_c Restrict delete 
pm_person_skill_fk4 pm_person_skill.pm_skill_level_i pt_skill_level.pt_level_i Restrict delete 
pm_person_skill_fkcr pm_person_skill.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_person_skill_fkmd pm_person_skill.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_person_vision_fk1 pm_person_vision.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_person_vision_fk2 pm_person_vision.pt_vision_area_name_c pt_vision_area.pt_vision_area_name_c Restrict delete 
pm_person_vision_fk3 pm_person_vision.pt_vision_level_i pt_vision_level.pt_vision_level_i Restrict delete 
pm_person_vision_fkcr pm_person_vision.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_person_vision_fkmd pm_person_vision.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_personal_data_fk1 pm_personal_data.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_personal_data_fk2 pm_personal_data.pm_driver_status_c pt_driver_status.pt_code_c Restrict delete 
pm_personal_data_fk3 pm_personal_data.p_language_code_c p_language.p_language_code_c Restrict delete 
pm_personal_data_fkcr pm_personal_data.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_personal_data_fkmd pm_personal_data.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_short_term_application_fk1 pm_short_term_application.p_partner_key_n
pm_short_term_application.pm_application_key_i
pm_short_term_application.pm_registration_office_n
pm_general_application.p_partner_key_n
pm_general_application.pm_application_key_i
pm_general_application.pm_registration_office_n
Restrict delete 
pm_short_term_application_fk10 pm_short_term_application.pm_st_pre_congress_code_c pt_congress_code.pt_code_c Restrict delete 
pm_short_term_application_fk11 pm_short_term_application.pm_st_congress_code_c pt_congress_code.pt_code_c Restrict delete 
pm_short_term_application_fk12 pm_short_term_application.pm_outreach_role_c pt_congress_code.pt_code_c Restrict delete 
pm_short_term_application_fk13 pm_short_term_application.pm_st_congress_language_c p_language.p_language_code_c Restrict delete 
pm_short_term_application_fk14 pm_short_term_application.pm_st_country_pref_c pt_outreach_preference_level.pt_code_c Restrict delete 
pm_short_term_application_fk15 pm_short_term_application.pm_st_activity_pref_c pt_outreach_preference_level.pt_code_c Restrict delete 
pm_short_term_application_fk16 pm_short_term_application.pm_st_confirmed_option_n p_unit.p_partner_key_n Restrict delete 
pm_short_term_application_fk17 pm_short_term_application.pm_st_option1_n p_unit.p_partner_key_n Restrict delete 
pm_short_term_application_fk18 pm_short_term_application.pm_st_option2_n p_unit.p_partner_key_n Restrict delete 
pm_short_term_application_fk19 pm_short_term_application.pm_st_current_field_n p_unit.p_partner_key_n Restrict delete 
pm_short_term_application_fk2 pm_short_term_application.pm_st_special_applicant_c pt_special_applicant.pt_code_c Restrict delete 
pm_short_term_application_fk20 pm_short_term_application.pm_st_field_charged_n p_unit.p_partner_key_n Restrict delete 
pm_short_term_application_fk21 pm_short_term_application.pm_st_recruit_efforts_c p_acquisition.p_acquisition_code_c Restrict delete 
pm_short_term_application_fk3 pm_short_term_application.pm_st_leadership_rating_c pt_leadership_rating.pt_code_c Restrict delete 
pm_short_term_application_fk4 pm_short_term_application.pt_arrival_point_code_c pt_arrival_point.pt_code_c Restrict delete 
pm_short_term_application_fk5 pm_short_term_application.pt_departure_point_code_c pt_arrival_point.pt_code_c Restrict delete 
pm_short_term_application_fk6 pm_short_term_application.pm_st_party_contact_n p_partner.p_partner_key_n Restrict delete 
pm_short_term_application_fk7 pm_short_term_application.pm_st_party_together_c pt_party_type.pt_code_c Restrict delete 
pm_short_term_application_fk8 pm_short_term_application.pt_travel_type_to_cong_code_c pt_travel_type.pt_code_c Restrict delete 
pm_short_term_application_fk9 pm_short_term_application.pt_travel_type_from_cong_code_c pt_travel_type.pt_code_c Restrict delete 
pm_short_term_application_fkcr pm_short_term_application.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_short_term_application_fkmd pm_short_term_application.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_special_need_fk1 pm_special_need.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_special_need_fkcr pm_special_need.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_special_need_fkmd pm_special_need.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_staff_data_fk1 pm_staff_data.p_partner_key_n p_person.p_partner_key_n Restrict delete 
pm_staff_data_fk2 pm_staff_data.pm_office_recruited_by_n p_unit.p_partner_key_n Restrict delete 
pm_staff_data_fk3 pm_staff_data.pm_home_office_n p_unit.p_partner_key_n Restrict delete 
pm_staff_data_fk4 pm_staff_data.pm_receiving_field_n p_unit.p_partner_key_n Restrict delete 
pm_staff_data_fk5 pm_staff_data.pm_receiving_field_office_n p_unit.p_partner_key_n Restrict delete 
pm_staff_data_fk6 pm_staff_data.pm_status_code_c pm_commitment_status.pm_code_c Restrict delete 
pm_staff_data_fkcr pm_staff_data.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_staff_data_fkmd pm_staff_data.s_modified_by_c s_user.s_user_id_c Restrict delete 
pm_year_program_application_fk1 pm_year_program_application.p_partner_key_n
pm_year_program_application.pm_application_key_i
pm_year_program_application.pm_registration_office_n
pm_general_application.p_partner_key_n
pm_general_application.pm_application_key_i
pm_general_application.pm_registration_office_n
Restrict delete 
pm_year_program_application_fk2 pm_year_program_application.pt_position_name_c
pm_year_program_application.pt_position_scope_c
pt_position.pt_position_name_c
pt_position.pt_position_scope_c
Restrict delete 
pm_year_program_application_fkcr pm_year_program_application.s_created_by_c s_user.s_user_id_c Restrict delete 
pm_year_program_application_fkmd pm_year_program_application.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_ability_area_fkcr pt_ability_area.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_ability_area_fkmd pt_ability_area.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_ability_level_fkcr pt_ability_level.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_ability_level_fkmd pt_ability_level.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_app_form_types_fkcr pt_app_form_types.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_app_form_types_fkmd pt_app_form_types.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_applicant_status_fkcr pt_applicant_status.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_applicant_status_fkmd pt_applicant_status.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_application_type_fkcr pt_application_type.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_application_type_fkmd pt_application_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_arrival_point_fkcr pt_arrival_point.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_arrival_point_fkmd pt_arrival_point.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_assignment_type_fkcr pt_assignment_type.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_assignment_type_fkmd pt_assignment_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_congress_code_fkcr pt_congress_code.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_congress_code_fkmd pt_congress_code.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_contact_fkcr pt_contact.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_contact_fkmd pt_contact.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_driver_status_fkcr pt_driver_status.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_driver_status_fkmd pt_driver_status.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_language_level_fkcr pt_language_level.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_language_level_fkmd pt_language_level.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_leadership_rating_fkcr pt_leadership_rating.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_leadership_rating_fkmd pt_leadership_rating.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_leaving_code_fkcr pt_leaving_code.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_leaving_code_fkmd pt_leaving_code.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_marital_status_fkcr pt_marital_status.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_marital_status_fkmd pt_marital_status.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_office_specific_data_labels_fkcr pt_office_specific_data_labels.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_office_specific_data_labels_fkmd pt_office_specific_data_labels.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_outreach_preference_level_fkcr pt_outreach_preference_level.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_outreach_preference_level_fkmd pt_outreach_preference_level.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_party_type_fkcr pt_party_type.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_party_type_fkmd pt_party_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_passport_type_fkcr pt_passport_type.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_passport_type_fkmd pt_passport_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_personal_data_labels_fkcr pt_personal_data_labels.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_personal_data_labels_fkmd pt_personal_data_labels.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_position_fk1 pt_position.pt_position_scope_c u_unit_type.u_unit_type_code_c Restrict delete 
pt_position_fkcr pt_position.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_position_fkmd pt_position.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_qualification_area_fkcr pt_qualification_area.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_qualification_area_fkmd pt_qualification_area.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_qualification_level_fkcr pt_qualification_level.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_qualification_level_fkmd pt_qualification_level.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_reports_fk1 pt_reports.pt_report_program_c s_file.s_file_name_c Restrict delete 
pt_reports_fkcr pt_reports.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_reports_fkmd pt_reports.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_skill_category_fkcr pt_skill_category.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_skill_category_fkmd pt_skill_category.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_skill_level_fkcr pt_skill_level.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_skill_level_fkmd pt_skill_level.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_special_applicant_fkcr pt_special_applicant.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_special_applicant_fkmd pt_special_applicant.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_travel_type_fkcr pt_travel_type.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_travel_type_fkmd pt_travel_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_valuable_item_fkcr pt_valuable_item.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_valuable_item_fkmd pt_valuable_item.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_vision_area_fkcr pt_vision_area.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_vision_area_fkmd pt_vision_area.s_modified_by_c s_user.s_user_id_c Restrict delete 
pt_vision_level_fkcr pt_vision_level.s_created_by_c s_user.s_user_id_c Restrict delete 
pt_vision_level_fkmd pt_vision_level.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_batch_job_fk1 s_batch_job.s_file_name_c s_file.s_file_name_c Restrict delete 
s_batch_job_fk2 s_batch_job.s_user_id_c s_user.s_user_id_c Restrict delete 
s_batch_job_fkcr s_batch_job.s_created_by_c s_user.s_user_id_c Restrict delete 
s_batch_job_fkmd s_batch_job.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_change_event_fkcr s_change_event.s_created_by_c s_user.s_user_id_c Restrict delete 
s_change_event_fkmd s_change_event.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_default_file_volume_fk1 s_default_file_volume.s_group_name_c s_volume_partner_group.s_name_c Restrict delete 
s_default_file_volume_fk2 s_default_file_volume.s_volume_name_c s_volume.s_name_c Restrict delete 
s_default_file_volume_fkcr s_default_file_volume.s_created_by_c s_user.s_user_id_c Restrict delete 
s_default_file_volume_fkmd s_default_file_volume.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_error_log_fk2 s_error_log.s_user_id_c s_user.s_user_id_c Restrict delete 
s_error_log_fkcr s_error_log.s_created_by_c s_user.s_user_id_c Restrict delete 
s_error_log_fkmd s_error_log.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_error_message_fk1 s_error_message.s_language_code_c p_language.p_language_code_c Restrict delete 
s_error_message_fkcr s_error_message.s_created_by_c s_user.s_user_id_c Restrict delete 
s_error_message_fkmd s_error_message.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_file_fkcr s_file.s_created_by_c s_user.s_user_id_c Restrict delete 
s_file_fkmd s_file.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_form_fkcr s_form.s_created_by_c s_user.s_user_id_c Restrict delete 
s_form_fkmd s_form.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_function_fkcr s_function.s_created_by_c s_user.s_user_id_c Restrict delete 
s_function_fkmd s_function.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_function_relationship_fk1 s_function_relationship.s_function_1_c s_function.s_function_id_c Restrict delete 
s_function_relationship_fk2 s_function_relationship.s_function_2_c s_function.s_function_id_c Restrict delete 
s_function_relationship_fkcr s_function_relationship.s_created_by_c s_user.s_user_id_c Restrict delete 
s_function_relationship_fkmd s_function_relationship.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_group_cost_centre_fk1 s_group_cost_centre.s_group_id_c
s_group_cost_centre.s_group_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_group_cost_centre_fk2 s_group_cost_centre.a_ledger_number_i
s_group_cost_centre.a_cost_centre_code_c
a_cost_centre.a_ledger_number_i
a_cost_centre.a_cost_centre_code_c
Restrict delete 
s_group_cost_centre_fkcr s_group_cost_centre.s_created_by_c s_user.s_user_id_c Restrict delete 
s_group_cost_centre_fkmd s_group_cost_centre.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_group_data_label_fk1 s_group_data_label.s_group_id_c
s_group_data_label.s_group_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_group_data_label_fk2 s_group_data_label.p_data_label_key_i p_data_label.p_key_i Restrict delete 
s_group_data_label_fkcr s_group_data_label.s_created_by_c s_user.s_user_id_c Restrict delete 
s_group_data_label_fkmd s_group_data_label.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_group_extract_fk1 s_group_extract.s_group_id_c
s_group_extract.s_group_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_group_extract_fk2 s_group_extract.m_extract_id_i m_extract_master.m_extract_id_i Restrict delete 
s_group_extract_fkcr s_group_extract.s_created_by_c s_user.s_user_id_c Restrict delete 
s_group_extract_fkmd s_group_extract.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_group_file_info_fk1 s_group_file_info.s_group_id_c
s_group_file_info.s_group_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_group_file_info_fk2 s_group_file_info.p_file_info_key_n p_file_info.p_key_n Restrict delete 
s_group_file_info_fkcr s_group_file_info.s_created_by_c s_user.s_user_id_c Restrict delete 
s_group_file_info_fkmd s_group_file_info.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_group_fkcr s_group.s_created_by_c s_user.s_user_id_c Restrict delete 
s_group_fkmd s_group.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_group_function_fk1 s_group_function.s_group_id_c
s_group_function.s_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_group_function_fk2 s_group_function.s_function_id_c s_function.s_function_id_c Restrict delete 
s_group_function_fkcr s_group_function.s_created_by_c s_user.s_user_id_c Restrict delete 
s_group_function_fkmd s_group_function.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_group_gift_fk1 s_group_gift.s_group_id_c
s_group_gift.s_group_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_group_gift_fk2 s_group_gift.a_ledger_number_i
s_group_gift.a_batch_number_i
s_group_gift.a_gift_transaction_number_i
a_gift.a_ledger_number_i
a_gift.a_batch_number_i
a_gift.a_gift_transaction_number_i
Restrict delete 
s_group_gift_fkcr s_group_gift.s_created_by_c s_user.s_user_id_c Restrict delete 
s_group_gift_fkmd s_group_gift.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_group_ledger_fk1 s_group_ledger.s_group_id_c
s_group_ledger.s_group_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_group_ledger_fk2 s_group_ledger.a_ledger_number_i a_ledger.a_ledger_number_i Restrict delete 
s_group_ledger_fkcr s_group_ledger.s_created_by_c s_user.s_user_id_c Restrict delete 
s_group_ledger_fkmd s_group_ledger.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_group_location_fk1 s_group_location.s_group_id_c
s_group_location.s_group_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_group_location_fk2 s_group_location.p_site_key_n
s_group_location.p_location_key_i
p_location.p_site_key_n
p_location.p_location_key_i
Restrict delete 
s_group_location_fkcr s_group_location.s_created_by_c s_user.s_user_id_c Restrict delete 
s_group_location_fkmd s_group_location.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_group_module_acc_perm_fk1 s_group_module_access_permission.s_group_id_c
s_group_module_access_permission.s_group_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_group_module_acc_perm_fk2 s_group_module_access_permission.s_module_id_c s_module.s_module_id_c Restrict delete 
s_group_module_access_permission_fkcr s_group_module_access_permission.s_created_by_c s_user.s_user_id_c Restrict delete 
s_group_module_access_permission_fkmd s_group_module_access_permission.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_group_motivation_fk1 s_group_motivation.s_group_id_c
s_group_motivation.s_group_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_group_motivation_fk2 s_group_motivation.a_ledger_number_i
s_group_motivation.a_motivation_group_code_c
s_group_motivation.a_motivation_detail_code_c
a_motivation_detail.a_ledger_number_i
a_motivation_detail.a_motivation_group_code_c
a_motivation_detail.a_motivation_detail_code_c
Restrict delete 
s_group_motivation_fkcr s_group_motivation.s_created_by_c s_user.s_user_id_c Restrict delete 
s_group_motivation_fkmd s_group_motivation.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_group_partner_contact_fk1 s_group_partner_contact.s_group_id_c
s_group_partner_contact.s_group_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_group_partner_contact_fk2 s_group_partner_contact.p_contact_id_i p_partner_contact.p_contact_id_i Restrict delete 
s_group_partner_contact_fkcr s_group_partner_contact.s_created_by_c s_user.s_user_id_c Restrict delete 
s_group_partner_contact_fkmd s_group_partner_contact.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_group_partner_location_fk1 s_group_partner_location.s_group_id_c
s_group_partner_location.s_group_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_group_partner_location_fk2 s_group_partner_location.p_partner_key_n
s_group_partner_location.p_site_key_n
s_group_partner_location.p_location_key_i
p_partner_location.p_partner_key_n
p_partner_location.p_site_key_n
p_partner_location.p_location_key_i
Restrict delete 
s_group_partner_location_fkcr s_group_partner_location.s_created_by_c s_user.s_user_id_c Restrict delete 
s_group_partner_location_fkmd s_group_partner_location.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_group_partner_reminder_fk1 s_group_partner_reminder.s_group_id_c
s_group_partner_reminder.s_group_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_group_partner_reminder_fk2 s_group_partner_reminder.p_partner_key_n
s_group_partner_reminder.p_contact_id_i
s_group_partner_reminder.p_reminder_id_i
p_partner_reminder.p_partner_key_n
p_partner_reminder.p_contact_id_i
p_partner_reminder.p_reminder_id_i
Restrict delete 
s_group_partner_reminder_fkcr s_group_partner_reminder.s_created_by_c s_user.s_user_id_c Restrict delete 
s_group_partner_reminder_fkmd s_group_partner_reminder.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_group_partner_set_fk1 s_group_partner_set.s_group_id_c
s_group_partner_set.s_group_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_group_partner_set_fk2 s_group_partner_set.p_partner_set_id_c
s_group_partner_set.p_partner_set_unit_key_n
p_partner_set.p_partner_set_id_c
p_partner_set.p_unit_key_n
Restrict delete 
s_group_partner_set_fkcr s_group_partner_set.s_created_by_c s_user.s_user_id_c Restrict delete 
s_group_partner_set_fkmd s_group_partner_set.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_group_table_acc_perm_fk1 s_group_table_access_permission.s_group_id_c
s_group_table_access_permission.s_group_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_group_table_access_permission_fkcr s_group_table_access_permission.s_created_by_c s_user.s_user_id_c Restrict delete 
s_group_table_access_permission_fkmd s_group_table_access_permission.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_job_group_fk1 s_job_group.s_unit_key_n
s_job_group.pt_position_name_c
s_job_group.pt_position_scope_c
s_job_group.um_job_key_i
um_job.pm_unit_key_n
um_job.pt_position_name_c
um_job.pt_position_scope_c
um_job.um_job_key_i
Restrict delete 
s_job_group_fk2 s_job_group.s_group_id_c
s_job_group.s_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_job_group_fkcr s_job_group.s_created_by_c s_user.s_user_id_c Restrict delete 
s_job_group_fkmd s_job_group.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_label_fk1 s_label.s_form_name_c s_form.s_form_name_c Restrict delete 
s_label_fkcr s_label.s_created_by_c s_user.s_user_id_c Restrict delete 
s_label_fkmd s_label.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_language_specific_fk1 s_language_specific.s_language_code_c p_language.p_language_code_c Restrict delete 
s_language_specific_fkcr s_language_specific.s_created_by_c s_user.s_user_id_c Restrict delete 
s_language_specific_fkmd s_language_specific.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_login_fkcr s_login.s_created_by_c s_user.s_user_id_c Restrict delete 
s_login_fkmd s_login.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_logon_message_fk1 s_logon_message.s_language_code_c p_language.p_language_code_c Restrict delete 
s_logon_message_fkcr s_logon_message.s_created_by_c s_user.s_user_id_c Restrict delete 
s_logon_message_fkmd s_logon_message.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_module_file_fkcr s_module_file.s_created_by_c s_user.s_user_id_c Restrict delete 
s_module_file_fkmd s_module_file.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_module_fkcr s_module.s_created_by_c s_user.s_user_id_c Restrict delete 
s_module_fkmd s_module.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_patch_log_fk1 s_patch_log.s_user_id_c s_user.s_user_id_c Restrict delete 
s_patch_log_fkcr s_patch_log.s_created_by_c s_user.s_user_id_c Restrict delete 
s_patch_log_fkmd s_patch_log.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_report_file_fk1 s_report_file.s_user_id_c s_user.s_user_id_c Restrict delete 
s_report_file_fk2 s_report_file.s_rpg_c s_file.s_file_name_c Restrict delete 
s_report_file_fkcr s_report_file.s_created_by_c s_user.s_user_id_c Restrict delete 
s_report_file_fkmd s_report_file.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_report_options_fk1 s_report_options.s_user_id_c s_user.s_user_id_c Restrict delete 
s_report_options_fk2 s_report_options.s_module_id_c s_module.s_module_id_c Restrict delete 
s_report_options_fk3 s_report_options.s_rpg_c s_file.s_file_name_c Restrict delete 
s_report_options_fkcr s_report_options.s_created_by_c s_user.s_user_id_c Restrict delete 
s_report_options_fkmd s_report_options.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_reports_to_archive_fkcr s_reports_to_archive.s_created_by_c s_user.s_user_id_c Restrict delete 
s_reports_to_archive_fkmd s_reports_to_archive.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_selected_output_destination_fk1 s_selected_output_destination.s_user_id_c s_user.s_user_id_c Restrict delete 
s_selected_output_destination_fk2 s_selected_output_destination.s_module_id_c s_module.s_module_id_c Restrict delete 
s_selected_output_destination_fkcr s_selected_output_destination.s_created_by_c s_user.s_user_id_c Restrict delete 
s_selected_output_destination_fkmd s_selected_output_destination.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_system_defaults_fkcr s_system_defaults.s_created_by_c s_user.s_user_id_c Restrict delete 
s_system_defaults_fkmd s_system_defaults.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_system_status_fk1 s_system_status.s_user_id_c s_user.s_user_id_c Restrict delete 
s_system_status_fkcr s_system_status.s_created_by_c s_user.s_user_id_c Restrict delete 
s_system_status_fkmd s_system_status.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_system_status_log_fk1 s_system_status_log.s_user_id_c s_user.s_user_id_c Restrict delete 
s_system_status_log_fkcr s_system_status_log.s_created_by_c s_user.s_user_id_c Restrict delete 
s_system_status_log_fkmd s_system_status_log.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_user_defaults_fk1 s_user_defaults.s_user_id_c s_user.s_user_id_c Restrict delete 
s_user_defaults_fkcr s_user_defaults.s_created_by_c s_user.s_user_id_c Restrict delete 
s_user_defaults_fkmd s_user_defaults.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_user_fk1 s_user.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
s_user_group_fk1 s_user_group.s_user_id_c s_user.s_user_id_c Restrict delete 
s_user_group_fk2 s_user_group.s_group_id_c
s_user_group.s_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_user_group_fkcr s_user_group.s_created_by_c s_user.s_user_id_c Restrict delete 
s_user_group_fkmd s_user_group.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_user_module_acc_perm_fk1 s_user_module_access_permission.s_user_id_c s_user.s_user_id_c Restrict delete 
s_user_module_acc_perm_fk2 s_user_module_access_permission.s_module_id_c s_module.s_module_id_c Restrict delete 
s_user_module_access_permission_fkcr s_user_module_access_permission.s_created_by_c s_user.s_user_id_c Restrict delete 
s_user_module_access_permission_fkmd s_user_module_access_permission.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_user_table_acc_perm_fk1 s_user_table_access_permission.s_user_id_c s_user.s_user_id_c Restrict delete 
s_user_table_access_permission_fkcr s_user_table_access_permission.s_created_by_c s_user.s_user_id_c Restrict delete 
s_user_table_access_permission_fkmd s_user_table_access_permission.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_valid_output_form_fk1 s_valid_output_form.s_module_id_c s_module.s_module_id_c Restrict delete 
s_valid_output_form_fk2 s_valid_output_form.s_form_name_c s_form.s_form_name_c Restrict delete 
s_valid_output_form_fkcr s_valid_output_form.s_created_by_c s_user.s_user_id_c Restrict delete 
s_valid_output_form_fkmd s_valid_output_form.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_volume_fk1 s_volume.s_parent_volume_name_c s_volume.s_name_c Restrict delete 
s_volume_fkcr s_volume.s_created_by_c s_user.s_user_id_c Restrict delete 
s_volume_fkmd s_volume.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_volume_partner_group_fkcr s_volume_partner_group.s_created_by_c s_user.s_user_id_c Restrict delete 
s_volume_partner_group_fkmd s_volume_partner_group.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_volume_partner_group_partner_fkcr s_volume_partner_group_partner.s_created_by_c s_user.s_user_id_c Restrict delete 
s_volume_partner_group_partner_fkmd s_volume_partner_group_partner.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_volume_partner_group_ptn_fk1 s_volume_partner_group_partner.s_group_name_c s_volume_partner_group.s_name_c Restrict delete 
s_volume_partner_group_ptn_fk2 s_volume_partner_group_partner.p_partner_key_n p_partner.p_partner_key_n Restrict delete 
s_workflow_definition_fkcr s_workflow_definition.s_created_by_c s_user.s_user_id_c Restrict delete 
s_workflow_definition_fkmd s_workflow_definition.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_workflow_group_fk1 s_workflow_group.s_workflow_id_i s_workflow_definition.s_workflow_id_i Restrict delete 
s_workflow_group_fk2 s_workflow_group.s_group_id_c
s_workflow_group.s_group_unit_key_n
s_group.s_group_id_c
s_group.s_unit_key_n
Restrict delete 
s_workflow_group_fkcr s_workflow_group.s_created_by_c s_user.s_user_id_c Restrict delete 
s_workflow_group_fkmd s_workflow_group.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_workflow_instance_fk1 s_workflow_instance.s_workflow_id_i s_workflow_definition.s_workflow_id_i Restrict delete 
s_workflow_instance_fkcr s_workflow_instance.s_created_by_c s_user.s_user_id_c Restrict delete 
s_workflow_instance_fkmd s_workflow_instance.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_workflow_instance_step_fk1 s_workflow_instance_step.s_workflow_instance_id_i s_workflow_instance.s_workflow_instance_id_i Restrict delete 
s_workflow_instance_step_fk2 s_workflow_instance_step.s_user_id_c s_user.s_user_id_c Restrict delete 
s_workflow_instance_step_fkcr s_workflow_instance_step.s_created_by_c s_user.s_user_id_c Restrict delete 
s_workflow_instance_step_fkmd s_workflow_instance_step.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_workflow_step_fk1 s_workflow_step.s_workflow_id_i s_workflow_definition.s_workflow_id_i Restrict delete 
s_workflow_step_fk2 s_workflow_step.s_function_id_c s_function.s_function_id_c Restrict delete 
s_workflow_step_fkcr s_workflow_step.s_created_by_c s_user.s_user_id_c Restrict delete 
s_workflow_step_fkmd s_workflow_step.s_modified_by_c s_user.s_user_id_c Restrict delete 
s_workflow_user_fk1 s_workflow_user.s_workflow_id_i s_workflow_definition.s_workflow_id_i Restrict delete 
s_workflow_user_fk2 s_workflow_user.s_user_id_c s_user.s_user_id_c Restrict delete 
s_workflow_user_fkcr s_workflow_user.s_created_by_c s_user.s_user_id_c Restrict delete 
s_workflow_user_fkmd s_workflow_user.s_modified_by_c s_user.s_user_id_c Restrict delete 
u_unit_type_fkcr u_unit_type.s_created_by_c s_user.s_user_id_c Restrict delete 
u_unit_type_fkmd u_unit_type.s_modified_by_c s_user.s_user_id_c Restrict delete 
um_job_fk1 um_job.pm_unit_key_n p_unit.p_partner_key_n Restrict delete 
um_job_fk2 um_job.pt_position_name_c
um_job.pt_position_scope_c
pt_position.pt_position_name_c
pt_position.pt_position_scope_c
Restrict delete 
um_job_fkcr um_job.s_created_by_c s_user.s_user_id_c Restrict delete 
um_job_fkmd um_job.s_modified_by_c s_user.s_user_id_c Restrict delete 
um_job_language_fk1 um_job_language.pm_unit_key_n
um_job_language.pt_position_name_c
um_job_language.pt_position_scope_c
um_job_language.um_job_key_i
um_job.pm_unit_key_n
um_job.pt_position_name_c
um_job.pt_position_scope_c
um_job.um_job_key_i
Restrict delete 
um_job_language_fk2 um_job_language.p_language_code_c p_language.p_language_code_c Restrict delete 
um_job_language_fk3 um_job_language.pt_language_level_i pt_language_level.pt_language_level_i Restrict delete 
um_job_language_fkcr um_job_language.s_created_by_c s_user.s_user_id_c Restrict delete 
um_job_language_fkmd um_job_language.s_modified_by_c s_user.s_user_id_c Restrict delete 
um_job_qualification_fk1 um_job_qualification.pm_unit_key_n
um_job_qualification.pt_position_name_c
um_job_qualification.pt_position_scope_c
um_job_qualification.um_job_key_i
um_job.pm_unit_key_n
um_job.pt_position_name_c
um_job.pt_position_scope_c
um_job.um_job_key_i
Restrict delete 
um_job_qualification_fk2 um_job_qualification.pt_qualification_area_name_c pt_qualification_area.pt_qualification_area_name_c Restrict delete 
um_job_qualification_fk3 um_job_qualification.pt_qualification_level_i pt_qualification_level.pt_qualification_level_i Restrict delete 
um_job_qualification_fkcr um_job_qualification.s_created_by_c s_user.s_user_id_c Restrict delete 
um_job_qualification_fkmd um_job_qualification.s_modified_by_c s_user.s_user_id_c Restrict delete 
um_job_requirement_fk1 um_job_requirement.pm_unit_key_n
um_job_requirement.pt_position_name_c
um_job_requirement.pt_position_scope_c
um_job_requirement.um_job_key_i
um_job.pm_unit_key_n
um_job.pt_position_name_c
um_job.pt_position_scope_c
um_job.um_job_key_i
Restrict delete 
um_job_requirement_fk2 um_job_requirement.pt_ability_area_name_c pt_ability_area.pt_ability_area_name_c Restrict delete 
um_job_requirement_fk3 um_job_requirement.pt_ability_level_i pt_ability_level.pt_ability_level_i Restrict delete 
um_job_requirement_fkcr um_job_requirement.s_created_by_c s_user.s_user_id_c Restrict delete 
um_job_requirement_fkmd um_job_requirement.s_modified_by_c s_user.s_user_id_c Restrict delete 
um_job_vision_fk1 um_job_vision.pm_unit_key_n
um_job_vision.pt_position_name_c
um_job_vision.pt_position_scope_c
um_job_vision.um_job_key_i
um_job.pm_unit_key_n
um_job.pt_position_name_c
um_job.pt_position_scope_c
um_job.um_job_key_i
Restrict delete 
um_job_vision_fk2 um_job_vision.pt_vision_area_name_c pt_vision_area.pt_vision_area_name_c Restrict delete 
um_job_vision_fk3 um_job_vision.pt_vision_level_i pt_vision_level.pt_vision_level_i Restrict delete 
um_job_vision_fkcr um_job_vision.s_created_by_c s_user.s_user_id_c Restrict delete 
um_job_vision_fkmd um_job_vision.s_modified_by_c s_user.s_user_id_c Restrict delete 
um_unit_ability_fk1 um_unit_ability.p_partner_key_n p_unit.p_partner_key_n Restrict delete 
um_unit_ability_fk2 um_unit_ability.pt_ability_area_name_c pt_ability_area.pt_ability_area_name_c Restrict delete 
um_unit_ability_fk3 um_unit_ability.pt_ability_level_i pt_ability_level.pt_ability_level_i Restrict delete 
um_unit_ability_fkcr um_unit_ability.s_created_by_c s_user.s_user_id_c Restrict delete 
um_unit_ability_fkmd um_unit_ability.s_modified_by_c s_user.s_user_id_c Restrict delete 
um_unit_cost_fk1 um_unit_cost.p_partner_key_n p_unit.p_partner_key_n Restrict delete 
um_unit_cost_fk2 um_unit_cost.a_local_currency_code_c a_currency.a_currency_code_c Restrict delete 
um_unit_cost_fkcr um_unit_cost.s_created_by_c s_user.s_user_id_c Restrict delete 
um_unit_cost_fkmd um_unit_cost.s_modified_by_c s_user.s_user_id_c Restrict delete 
um_unit_evaluation_fk1 um_unit_evaluation.p_partner_key_n p_unit.p_partner_key_n Restrict delete 
um_unit_evaluation_fkcr um_unit_evaluation.s_created_by_c s_user.s_user_id_c Restrict delete 
um_unit_evaluation_fkmd um_unit_evaluation.s_modified_by_c s_user.s_user_id_c Restrict delete 
um_unit_language_fk1 um_unit_language.p_partner_key_n p_unit.p_partner_key_n Restrict delete 
um_unit_language_fk2 um_unit_language.p_language_code_c p_language.p_language_code_c Restrict delete 
um_unit_language_fk3 um_unit_language.pt_language_level_i pt_language_level.pt_language_level_i Restrict delete 
um_unit_language_fkcr um_unit_language.s_created_by_c s_user.s_user_id_c Restrict delete 
um_unit_language_fkmd um_unit_language.s_modified_by_c s_user.s_user_id_c Restrict delete 
um_unit_structure_fk1 um_unit_structure.um_parent_unit_key_n p_unit.p_partner_key_n Restrict delete 
um_unit_structure_fk2 um_unit_structure.um_child_unit_key_n p_unit.p_partner_key_n Restrict delete 
um_unit_structure_fkcr um_unit_structure.s_created_by_c s_user.s_user_id_c Restrict delete 
um_unit_structure_fkmd um_unit_structure.s_modified_by_c s_user.s_user_id_c Restrict delete 
um_unit_vision_fk1 um_unit_vision.p_partner_key_n p_unit.p_partner_key_n Restrict delete 
um_unit_vision_fk2 um_unit_vision.pt_vision_area_name_c pt_vision_area.pt_vision_area_name_c Restrict delete 
um_unit_vision_fk3 um_unit_vision.pt_vision_level_i pt_vision_level.pt_vision_level_i Restrict delete 
um_unit_vision_fkcr um_unit_vision.s_created_by_c s_user.s_user_id_c Restrict delete 
um_unit_vision_fkmd um_unit_vision.s_modified_by_c s_user.s_user_id_c Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected