Table openpetra_trunk.public.s_user
List of users

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
s_user_id_c varchar 20
a_account.s_created_by_c a_account_fkcr R
a_account.s_modified_by_c a_account_fkmd R
a_account_hierarchy.s_created_by_c a_account_hierarchy_fkcr R
a_account_hierarchy.s_modified_by_c a_account_hierarchy_fkmd R
a_account_hierarchy_detail.s_created_by_c a_account_hierarchy_detail_fkcr R
a_account_hierarchy_detail.s_modified_by_c a_account_hierarchy_detail_fkmd R
a_account_property.s_created_by_c a_account_property_fkcr R
a_account_property.s_modified_by_c a_account_property_fkmd R
a_account_property_code.s_created_by_c a_account_property_code_fkcr R
a_account_property_code.s_modified_by_c a_account_property_code_fkmd R
a_accounting_period.s_created_by_c a_accounting_period_fkcr R
a_accounting_period.s_modified_by_c a_accounting_period_fkmd R
a_accounting_system_parameter.s_created_by_c a_accounting_system_parameter_fkcr R
a_accounting_system_parameter.s_modified_by_c a_accounting_system_parameter_fkmd R
a_analysis_attribute.s_created_by_c a_analysis_attribute_fkcr R
a_analysis_attribute.s_modified_by_c a_analysis_attribute_fkmd R
a_analysis_store_table.s_created_by_c a_analysis_store_table_fkcr R
a_analysis_store_table.s_modified_by_c a_analysis_store_table_fkmd R
a_analysis_type.s_created_by_c a_analysis_type_fkcr R
a_analysis_type.s_modified_by_c a_analysis_type_fkmd R
a_ap_anal_attrib.s_created_by_c a_ap_anal_attrib_fkcr R
a_ap_anal_attrib.s_modified_by_c a_ap_anal_attrib_fkmd R
a_ap_document.s_created_by_c a_ap_document_fkcr R
a_ap_document.s_modified_by_c a_ap_document_fkmd R
a_ap_document_detail.s_created_by_c a_ap_document_detail_fkcr R
a_ap_document_detail.s_modified_by_c a_ap_document_detail_fkmd R
a_ap_document_payment.s_created_by_c a_ap_document_payment_fkcr R
a_ap_document_payment.s_modified_by_c a_ap_document_payment_fkmd R
a_ap_payment.s_created_by_c a_ap_payment_fkcr R
a_ap_payment.s_modified_by_c a_ap_payment_fkmd R
a_ap_payment.s_user_id_c a_ap_payment_fk2 R
a_ap_supplier.s_created_by_c a_ap_supplier_fkcr R
a_ap_supplier.s_modified_by_c a_ap_supplier_fkmd R
a_ar_article.s_created_by_c a_ar_article_fkcr R
a_ar_article.s_modified_by_c a_ar_article_fkmd R
a_ar_article_price.s_created_by_c a_ar_article_price_fkcr R
a_ar_article_price.s_modified_by_c a_ar_article_price_fkmd R
a_ar_category.s_created_by_c a_ar_category_fkcr R
a_ar_category.s_modified_by_c a_ar_category_fkmd R
a_ar_default_discount.s_created_by_c a_ar_default_discount_fkcr R
a_ar_default_discount.s_modified_by_c a_ar_default_discount_fkmd R
a_ar_discount.s_created_by_c a_ar_discount_fkcr R
a_ar_discount.s_modified_by_c a_ar_discount_fkmd R
a_ar_discount_per_category.s_created_by_c a_ar_discount_per_category_fkcr R
a_ar_discount_per_category.s_modified_by_c a_ar_discount_per_category_fkmd R
a_ar_invoice.s_created_by_c a_ar_invoice_fkcr R
a_ar_invoice.s_modified_by_c a_ar_invoice_fkmd R
a_ar_invoice_detail.s_created_by_c a_ar_invoice_detail_fkcr R
a_ar_invoice_detail.s_modified_by_c a_ar_invoice_detail_fkmd R
a_ar_invoice_detail_discount.s_created_by_c a_ar_invoice_detail_discount_fkcr R
a_ar_invoice_detail_discount.s_modified_by_c a_ar_invoice_detail_discount_fkmd R
a_ar_invoice_discount.s_created_by_c a_ar_invoice_discount_fkcr R
a_ar_invoice_discount.s_modified_by_c a_ar_invoice_discount_fkmd R
a_batch.s_created_by_c a_batch_fkcr R
a_batch.s_modified_by_c a_batch_fkmd R
a_budget.s_created_by_c a_budget_fkcr R
a_budget.s_modified_by_c a_budget_fkmd R
a_budget_period.s_created_by_c a_budget_period_fkcr R
a_budget_period.s_modified_by_c a_budget_period_fkmd R
a_budget_revision.s_created_by_c a_budget_revision_fkcr R
a_budget_revision.s_modified_by_c a_budget_revision_fkmd R
a_budget_type.s_created_by_c a_budget_type_fkcr R
a_budget_type.s_modified_by_c a_budget_type_fkmd R
a_corporate_exchange_rate.s_created_by_c a_corporate_exchange_rate_fkcr R
a_corporate_exchange_rate.s_modified_by_c a_corporate_exchange_rate_fkmd R
a_cost_centre.s_created_by_c a_cost_centre_fkcr R
a_cost_centre.s_modified_by_c a_cost_centre_fkmd R
a_cost_centre_types.s_created_by_c a_cost_centre_types_fkcr R
a_cost_centre_types.s_modified_by_c a_cost_centre_types_fkmd R
a_crdt_note_invoice_link.s_created_by_c a_crdt_note_invoice_link_fkcr R
a_crdt_note_invoice_link.s_modified_by_c a_crdt_note_invoice_link_fkmd R
a_currency.s_created_by_c a_currency_fkcr R
a_currency.s_modified_by_c a_currency_fkmd R
a_currency_language.s_created_by_c a_currency_language_fkcr R
a_currency_language.s_modified_by_c a_currency_language_fkmd R
a_daily_exchange_rate.s_created_by_c a_daily_exchange_rate_fkcr R
a_daily_exchange_rate.s_modified_by_c a_daily_exchange_rate_fkmd R
a_email_destination.s_created_by_c a_email_destination_fkcr R
a_email_destination.s_modified_by_c a_email_destination_fkmd R
a_ep_account.s_created_by_c a_ep_account_fkcr R
a_ep_account.s_modified_by_c a_ep_account_fkmd R
a_ep_document_payment.s_created_by_c a_ep_document_payment_fkcr R
a_ep_document_payment.s_modified_by_c a_ep_document_payment_fkmd R
a_ep_match.s_created_by_c a_ep_match_fkcr R
a_ep_match.s_modified_by_c a_ep_match_fkmd R
a_ep_payment.s_created_by_c a_ep_payment_fkcr R
a_ep_payment.s_modified_by_c a_ep_payment_fkmd R
a_ep_payment.s_user_id_c a_ep_payment_fk2 R
a_ep_statement.s_created_by_c a_ep_statement_fkcr R
a_ep_statement.s_modified_by_c a_ep_statement_fkmd R
a_ep_transaction.s_created_by_c a_ep_transaction_fkcr R
a_ep_transaction.s_modified_by_c a_ep_transaction_fkmd R
a_fees_payable.s_created_by_c a_fees_payable_fkcr R
a_fees_payable.s_modified_by_c a_fees_payable_fkmd R
a_fees_receivable.s_created_by_c a_fees_receivable_fkcr R
a_fees_receivable.s_modified_by_c a_fees_receivable_fkmd R
a_form.s_created_by_c a_form_fkcr R
a_form.s_modified_by_c a_form_fkmd R
a_form_element.s_created_by_c a_form_element_fkcr R
a_form_element.s_modified_by_c a_form_element_fkmd R
a_form_element_type.s_created_by_c a_form_element_type_fkcr R
a_form_element_type.s_modified_by_c a_form_element_type_fkmd R
a_freeform_analysis.s_created_by_c a_freeform_analysis_fkcr R
a_freeform_analysis.s_modified_by_c a_freeform_analysis_fkmd R
a_frequency.s_created_by_c a_frequency_fkcr R
a_frequency.s_modified_by_c a_frequency_fkmd R
a_general_ledger_master.s_created_by_c a_general_ledger_master_fkcr R
a_general_ledger_master.s_modified_by_c a_general_ledger_master_fkmd R
a_general_ledger_master_period.s_created_by_c a_general_ledger_master_period_fkcr R
a_general_ledger_master_period.s_modified_by_c a_general_ledger_master_period_fkmd R
a_gift.s_created_by_c a_gift_fkcr R
a_gift.s_modified_by_c a_gift_fkmd R
a_gift_batch.s_created_by_c a_gift_batch_fkcr R
a_gift_batch.s_modified_by_c a_gift_batch_fkmd R
a_gift_detail.s_created_by_c a_gift_detail_fkcr R
a_gift_detail.s_modified_by_c a_gift_detail_fkmd R
a_ich_stewardship.s_created_by_c a_ich_stewardship_fkcr R
a_ich_stewardship.s_modified_by_c a_ich_stewardship_fkmd R
a_journal.s_created_by_c a_journal_fkcr R
a_journal.s_modified_by_c a_journal_fkmd R
a_key_focus_area.s_created_by_c a_key_focus_area_fkcr R
a_key_focus_area.s_modified_by_c a_key_focus_area_fkmd R
a_ledger.s_created_by_c a_ledger_fkcr R
a_ledger.s_modified_by_c a_ledger_fkmd R
a_ledger_init_flag.s_created_by_c a_ledger_init_flag_fkcr R
a_ledger_init_flag.s_modified_by_c a_ledger_init_flag_fkmd R
a_method_of_giving.s_created_by_c a_method_of_giving_fkcr R
a_method_of_giving.s_modified_by_c a_method_of_giving_fkmd R
a_method_of_payment.s_created_by_c a_method_of_payment_fkcr R
a_method_of_payment.s_modified_by_c a_method_of_payment_fkmd R
a_motivation_detail.s_created_by_c a_motivation_detail_fkcr R
a_motivation_detail.s_modified_by_c a_motivation_detail_fkmd R
a_motivation_detail_fee.s_created_by_c a_motivation_detail_fee_fkcr R
a_motivation_detail_fee.s_modified_by_c a_motivation_detail_fee_fkmd R
a_motivation_group.s_created_by_c a_motivation_group_fkcr R
a_motivation_group.s_modified_by_c a_motivation_group_fkmd R
a_prev_year_corp_ex_rate.s_created_by_c a_prev_year_corp_ex_rate_fkcr R
a_prev_year_corp_ex_rate.s_modified_by_c a_prev_year_corp_ex_rate_fkmd R
a_prev_year_trans_anal_attrib.s_created_by_c a_prev_year_trans_anal_attrib_fkcr R
a_prev_year_trans_anal_attrib.s_modified_by_c a_prev_year_trans_anal_attrib_fkmd R
a_previous_year_batch.s_created_by_c a_previous_year_batch_fkcr R
a_previous_year_batch.s_modified_by_c a_previous_year_batch_fkmd R
a_previous_year_journal.s_created_by_c a_previous_year_journal_fkcr R
a_previous_year_journal.s_modified_by_c a_previous_year_journal_fkmd R
a_previous_year_transaction.s_created_by_c a_previous_year_transaction_fkcr R
a_previous_year_transaction.s_modified_by_c a_previous_year_transaction_fkmd R
a_processed_fee.s_created_by_c a_processed_fee_fkcr R
a_processed_fee.s_modified_by_c a_processed_fee_fkmd R
a_recurring_batch.s_created_by_c a_recurring_batch_fkcr R
a_recurring_batch.s_modified_by_c a_recurring_batch_fkmd R
a_recurring_batch.s_user_id_c a_recurring_batch_fk2 R
a_recurring_gift.s_created_by_c a_recurring_gift_fkcr R
a_recurring_gift.s_modified_by_c a_recurring_gift_fkmd R
a_recurring_gift_batch.s_created_by_c a_recurring_gift_batch_fkcr R
a_recurring_gift_batch.s_modified_by_c a_recurring_gift_batch_fkmd R
a_recurring_gift_detail.s_created_by_c a_recurring_gift_detail_fkcr R
a_recurring_gift_detail.s_modified_by_c a_recurring_gift_detail_fkmd R
a_recurring_journal.s_created_by_c a_recurring_journal_fkcr R
a_recurring_journal.s_modified_by_c a_recurring_journal_fkmd R
a_recurring_trans_anal_attrib.s_created_by_c a_recurring_trans_anal_attrib_fkcr R
a_recurring_trans_anal_attrib.s_modified_by_c a_recurring_trans_anal_attrib_fkmd R
a_recurring_transaction.s_created_by_c a_recurring_transaction_fkcr R
a_recurring_transaction.s_modified_by_c a_recurring_transaction_fkmd R
a_recurring_transaction.s_user_id_c a_recurring_transaction_fk7 R
a_special_trans_type.s_created_by_c a_special_trans_type_fkcr R
a_special_trans_type.s_modified_by_c a_special_trans_type_fkmd R
a_sub_system.s_created_by_c a_sub_system_fkcr R
a_sub_system.s_modified_by_c a_sub_system_fkmd R
a_suspense_account.s_created_by_c a_suspense_account_fkcr R
a_suspense_account.s_modified_by_c a_suspense_account_fkmd R
a_system_interface.s_created_by_c a_system_interface_fkcr R
a_system_interface.s_modified_by_c a_system_interface_fkmd R
a_tax_table.s_created_by_c a_tax_table_fkcr R
a_tax_table.s_modified_by_c a_tax_table_fkmd R
a_tax_type.s_created_by_c a_tax_type_fkcr R
a_tax_type.s_modified_by_c a_tax_type_fkmd R
a_this_year_old_batch.s_created_by_c a_this_year_old_batch_fkcr R
a_this_year_old_batch.s_modified_by_c a_this_year_old_batch_fkmd R
a_this_year_old_journal.s_created_by_c a_this_year_old_journal_fkcr R
a_this_year_old_journal.s_modified_by_c a_this_year_old_journal_fkmd R
a_this_year_old_transaction.s_created_by_c a_this_year_old_transaction_fkcr R
a_this_year_old_transaction.s_modified_by_c a_this_year_old_transaction_fkmd R
a_thisyearold_trans_anal_attrib.s_created_by_c a_thisyearold_trans_anal_attrib_fkcr R
a_thisyearold_trans_anal_attrib.s_modified_by_c a_thisyearold_trans_anal_attrib_fkmd R
a_trans_anal_attrib.s_created_by_c a_trans_anal_attrib_fkcr R
a_trans_anal_attrib.s_modified_by_c a_trans_anal_attrib_fkmd R
a_transaction.s_created_by_c a_transaction_fkcr R
a_transaction.s_modified_by_c a_transaction_fkmd R
a_transaction_type.s_created_by_c a_transaction_type_fkcr R
a_transaction_type.s_modified_by_c a_transaction_type_fkmd R
a_valid_ledger_number.s_created_by_c a_valid_ledger_number_fkcr R
a_valid_ledger_number.s_modified_by_c a_valid_ledger_number_fkmd R
m_extract.s_created_by_c m_extract_fkcr R
m_extract.s_modified_by_c m_extract_fkmd R
m_extract_master.m_manual_mod_by_c m_extract_master_fk3 R
m_extract_master.s_created_by_c m_extract_master_fkcr R
m_extract_master.s_modified_by_c m_extract_master_fkmd R
m_extract_parameter.s_created_by_c m_extract_parameter_fkcr R
m_extract_parameter.s_modified_by_c m_extract_parameter_fkmd R
m_extract_type.s_created_by_c m_extract_type_fkcr R
m_extract_type.s_modified_by_c m_extract_type_fkmd R
p_acquisition.s_created_by_c p_acquisition_fkcr R
p_acquisition.s_modified_by_c p_acquisition_fkmd R
p_action.s_created_by_c p_action_fkcr R
p_action.s_modified_by_c p_action_fkmd R
p_address_element.s_created_by_c p_address_element_fkcr R
p_address_element.s_modified_by_c p_address_element_fkmd R
p_address_layout.s_created_by_c p_address_layout_fkcr R
p_address_layout.s_modified_by_c p_address_layout_fkmd R
p_address_layout_code.s_created_by_c p_address_layout_code_fkcr R
p_address_layout_code.s_modified_by_c p_address_layout_code_fkmd R
p_address_line.s_created_by_c p_address_line_fkcr R
p_address_line.s_modified_by_c p_address_line_fkmd R
p_addressee_title_override.s_created_by_c p_addressee_title_override_fkcr R
p_addressee_title_override.s_modified_by_c p_addressee_title_override_fkmd R
p_addressee_type.s_created_by_c p_addressee_type_fkcr R
p_addressee_type.s_modified_by_c p_addressee_type_fkmd R
p_bank.s_created_by_c p_bank_fkcr R
p_bank.s_modified_by_c p_bank_fkmd R
p_banking_details.s_created_by_c p_banking_details_fkcr R
p_banking_details.s_modified_by_c p_banking_details_fkmd R
p_banking_details_usage.s_created_by_c p_banking_details_usage_fkcr R
p_banking_details_usage.s_modified_by_c p_banking_details_usage_fkmd R
p_banking_details_usage_type.s_created_by_c p_banking_details_usage_type_fkcr R
p_banking_details_usage_type.s_modified_by_c p_banking_details_usage_type_fkmd R
p_banking_type.s_created_by_c p_banking_type_fkcr R
p_banking_type.s_modified_by_c p_banking_type_fkmd R
p_business.s_created_by_c p_business_fkcr R
p_business.s_modified_by_c p_business_fkmd R
p_church.s_created_by_c p_church_fkcr R
p_church.s_modified_by_c p_church_fkmd R
p_contact_attribute.s_created_by_c p_contact_attribute_fkcr R
p_contact_attribute.s_modified_by_c p_contact_attribute_fkmd R
p_contact_attribute_detail.s_created_by_c p_contact_attribute_detail_fkcr R
p_contact_attribute_detail.s_modified_by_c p_contact_attribute_detail_fkmd R
p_country.s_created_by_c p_country_fkcr R
p_country.s_modified_by_c p_country_fkmd R
p_customised_greeting.s_created_by_c p_customised_greeting_fkcr R
p_customised_greeting.s_modified_by_c p_customised_greeting_fkmd R
p_customised_greeting.s_user_id_c p_customised_greeting_fk2 R
p_data_label.s_created_by_c p_data_label_fkcr R
p_data_label.s_modified_by_c p_data_label_fkmd R
p_data_label_lookup.s_created_by_c p_data_label_lookup_fkcr R
p_data_label_lookup.s_modified_by_c p_data_label_lookup_fkmd R
p_data_label_lookup_category.s_created_by_c p_data_label_lookup_category_fkcr R
p_data_label_lookup_category.s_modified_by_c p_data_label_lookup_category_fkmd R
p_data_label_use.s_created_by_c p_data_label_use_fkcr R
p_data_label_use.s_modified_by_c p_data_label_use_fkmd R
p_data_label_value_application.s_created_by_c p_data_label_value_application_fkcr R
p_data_label_value_application.s_modified_by_c p_data_label_value_application_fkmd R
p_data_label_value_partner.s_created_by_c p_data_label_value_partner_fkcr R
p_data_label_value_partner.s_modified_by_c p_data_label_value_partner_fkmd R
p_denomination.s_created_by_c p_denomination_fkcr R
p_denomination.s_modified_by_c p_denomination_fkmd R
p_email.s_created_by_c p_email_fkcr R
p_email.s_modified_by_c p_email_fkmd R
p_family.s_created_by_c p_family_fkcr R
p_family.s_modified_by_c p_family_fkmd R
p_file_info.s_created_by_c p_file_info_fkcr R
p_file_info.s_modified_by_c p_file_info_fkmd R
p_first_contact.s_created_by_c p_first_contact_fkcr R
p_first_contact.s_modified_by_c p_first_contact_fkmd R
p_form_letter_body.p_owner_c p_form_letter_body_fk1 R
p_form_letter_body.s_created_by_c p_form_letter_body_fkcr R
p_form_letter_body.s_modified_by_c p_form_letter_body_fkmd R
p_form_letter_design.s_created_by_c p_form_letter_design_fkcr R
p_form_letter_design.s_modified_by_c p_form_letter_design_fkmd R
p_form_letter_insert.s_created_by_c p_form_letter_insert_fkcr R
p_form_letter_insert.s_modified_by_c p_form_letter_insert_fkmd R
p_formality.s_created_by_c p_formality_fkcr R
p_formality.s_modified_by_c p_formality_fkmd R
p_foundation.s_created_by_c p_foundation_fkcr R
p_foundation.s_modified_by_c p_foundation_fkmd R
p_foundation_deadline.s_created_by_c p_foundation_deadline_fkcr R
p_foundation_deadline.s_modified_by_c p_foundation_deadline_fkmd R
p_foundation_proposal.s_created_by_c p_foundation_proposal_fkcr R
p_foundation_proposal.s_modified_by_c p_foundation_proposal_fkmd R
p_foundation_proposal_detail.s_created_by_c p_foundation_proposal_detail_fkcr R
p_foundation_proposal_detail.s_modified_by_c p_foundation_proposal_detail_fkmd R
p_foundation_proposal_status.s_created_by_c p_foundation_proposal_status_fkcr R
p_foundation_proposal_status.s_modified_by_c p_foundation_proposal_status_fkmd R
p_interest.s_created_by_c p_interest_fkcr R
p_interest.s_modified_by_c p_interest_fkmd R
p_interest_category.s_created_by_c p_interest_category_fkcr R
p_interest_category.s_modified_by_c p_interest_category_fkmd R
p_international_postal_type.s_created_by_c p_international_postal_type_fkcr R
p_international_postal_type.s_modified_by_c p_international_postal_type_fkmd R
p_label.s_created_by_c p_label_fkcr R
p_label.s_modified_by_c p_label_fkmd R
p_language.s_created_by_c p_language_fkcr R
p_language.s_modified_by_c p_language_fkmd R
p_location.s_created_by_c p_location_fkcr R
p_location.s_modified_by_c p_location_fkmd R
p_location_type.s_created_by_c p_location_type_fkcr R
p_location_type.s_modified_by_c p_location_type_fkmd R
p_mailing.s_created_by_c p_mailing_fkcr R
p_mailing.s_modified_by_c p_mailing_fkmd R
p_merge_field.s_created_by_c p_merge_field_fkcr R
p_merge_field.s_modified_by_c p_merge_field_fkmd R
p_merge_form.s_created_by_c p_merge_form_fkcr R
p_merge_form.s_modified_by_c p_merge_form_fkmd R
p_method_of_contact.s_created_by_c p_method_of_contact_fkcr R
p_method_of_contact.s_modified_by_c p_method_of_contact_fkmd R
p_occupation.s_created_by_c p_occupation_fkcr R
p_occupation.s_modified_by_c p_occupation_fkmd R
p_organisation.s_created_by_c p_organisation_fkcr R
p_organisation.s_modified_by_c p_organisation_fkmd R
p_partner.s_created_by_c p_partner_fkcr R
p_partner.s_modified_by_c p_partner_fkmd R
p_partner_action.p_user_that_performed_action_c p_partner_action_fk5 R
p_partner_action.p_user_to_perform_action_c p_partner_action_fk3 R
p_partner_action.s_created_by_c p_partner_action_fkcr R
p_partner_action.s_modified_by_c p_partner_action_fkmd R
p_partner_attribute.s_created_by_c p_partner_attribute_fkcr R
p_partner_attribute.s_modified_by_c p_partner_attribute_fkmd R
p_partner_attribute_type.s_created_by_c p_partner_attribute_type_fkcr R
p_partner_attribute_type.s_modified_by_c p_partner_attribute_type_fkmd R
p_partner_banking_details.s_created_by_c p_partner_banking_details_fkcr R
p_partner_banking_details.s_modified_by_c p_partner_banking_details_fkmd R
p_partner_classes.s_created_by_c p_partner_classes_fkcr R
p_partner_classes.s_modified_by_c p_partner_classes_fkmd R
p_partner_comment.s_created_by_c p_partner_comment_fkcr R
p_partner_comment.s_modified_by_c p_partner_comment_fkmd R
p_partner_contact.s_created_by_c p_partner_contact_fkcr R
p_partner_contact.s_modified_by_c p_partner_contact_fkmd R
p_partner_contact.s_user_id_c p_partner_contact_fk7 R
p_partner_contact_attribute.s_created_by_c p_partner_contact_attribute_fkcr R
p_partner_contact_attribute.s_modified_by_c p_partner_contact_attribute_fkmd R
p_partner_contact_file.s_created_by_c p_partner_contact_file_fkcr R
p_partner_contact_file.s_modified_by_c p_partner_contact_file_fkmd R
p_partner_field_of_service.s_created_by_c p_partner_field_of_service_fkcr R
p_partner_field_of_service.s_modified_by_c p_partner_field_of_service_fkmd R
p_partner_file.s_created_by_c p_partner_file_fkcr R
p_partner_file.s_modified_by_c p_partner_file_fkmd R
p_partner_graphic.s_created_by_c p_partner_graphic_fkcr R
p_partner_graphic.s_modified_by_c p_partner_graphic_fkmd R
p_partner_interest.s_created_by_c p_partner_interest_fkcr R
p_partner_interest.s_modified_by_c p_partner_interest_fkmd R
p_partner_ledger.s_created_by_c p_partner_ledger_fkcr R
p_partner_ledger.s_modified_by_c p_partner_ledger_fkmd R
p_partner_location.s_created_by_c p_partner_location_fkcr R
p_partner_location.s_modified_by_c p_partner_location_fkmd R
p_partner_merge.s_created_by_c p_partner_merge_fkcr R
p_partner_merge.s_merged_by_c p_partner_merge_fk3 R
p_partner_merge.s_modified_by_c p_partner_merge_fkmd R
p_partner_relationship.s_created_by_c p_partner_relationship_fkcr R
p_partner_relationship.s_modified_by_c p_partner_relationship_fkmd R
p_partner_reminder.s_created_by_c p_partner_reminder_fkcr R
p_partner_reminder.s_modified_by_c p_partner_reminder_fkmd R
p_partner_reminder.s_user_id_c p_partner_reminder_fk3 R
p_partner_reminder.s_user_restriction_c p_partner_reminder_fk5 R
p_partner_set.s_created_by_c p_partner_set_fkcr R
p_partner_set.s_modified_by_c p_partner_set_fkmd R
p_partner_set_partner.s_created_by_c p_partner_set_partner_fkcr R
p_partner_set_partner.s_modified_by_c p_partner_set_partner_fkmd R
p_partner_short_code.s_created_by_c p_partner_short_code_fkcr R
p_partner_short_code.s_modified_by_c p_partner_short_code_fkmd R
p_partner_state.s_created_by_c p_partner_state_fkcr R
p_partner_state.s_modified_by_c p_partner_state_fkmd R
p_partner_status.s_created_by_c p_partner_status_fkcr R
p_partner_status.s_modified_by_c p_partner_status_fkmd R
p_partner_tax_deductible_pct.s_created_by_c p_partner_tax_deductible_pct_fkcr R
p_partner_tax_deductible_pct.s_modified_by_c p_partner_tax_deductible_pct_fkmd R
p_partner_type.s_created_by_c p_partner_type_fkcr R
p_partner_type.s_modified_by_c p_partner_type_fkmd R
p_person.s_created_by_c p_person_fkcr R
p_person.s_modified_by_c p_person_fkmd R
p_postcode_range.s_created_by_c p_postcode_range_fkcr R
p_postcode_range.s_modified_by_c p_postcode_range_fkmd R
p_postcode_region.s_created_by_c p_postcode_region_fkcr R
p_postcode_region.s_modified_by_c p_postcode_region_fkmd R
p_process.s_created_by_c p_process_fkcr R
p_process.s_modified_by_c p_process_fkmd R
p_proposal_submission_type.s_created_by_c p_proposal_submission_type_fkcr R
p_proposal_submission_type.s_modified_by_c p_proposal_submission_type_fkmd R
p_publication.s_created_by_c p_publication_fkcr R
p_publication.s_modified_by_c p_publication_fkmd R
p_publication_cost.s_created_by_c p_publication_cost_fkcr R
p_publication_cost.s_modified_by_c p_publication_cost_fkmd R
p_reason_subscription_cancelled.s_created_by_c p_reason_subscription_cancelled_fkcr R
p_reason_subscription_cancelled.s_modified_by_c p_reason_subscription_cancelled_fkmd R
p_reason_subscription_given.s_created_by_c p_reason_subscription_given_fkcr R
p_reason_subscription_given.s_modified_by_c p_reason_subscription_given_fkmd R
p_recent_partners.s_created_by_c p_recent_partners_fkcr R
p_recent_partners.s_modified_by_c p_recent_partners_fkmd R
p_recent_partners.s_user_id_c p_recent_partners_fk1 R
p_relation.s_created_by_c p_relation_fkcr R
p_relation.s_modified_by_c p_relation_fkmd R
p_relation_category.s_created_by_c p_relation_category_fkcr R
p_relation_category.s_modified_by_c p_relation_category_fkmd R
p_reminder_category.s_created_by_c p_reminder_category_fkcr R
p_reminder_category.s_modified_by_c p_reminder_category_fkmd R
p_reports.s_created_by_c p_reports_fkcr R
p_reports.s_modified_by_c p_reports_fkmd R
p_state.s_created_by_c p_state_fkcr R
p_state.s_modified_by_c p_state_fkmd R
p_subscription.s_created_by_c p_subscription_fkcr R
p_subscription.s_modified_by_c p_subscription_fkmd R
p_tax.s_created_by_c p_tax_fkcr R
p_tax.s_modified_by_c p_tax_fkmd R
p_title.s_created_by_c p_title_fkcr R
p_title.s_modified_by_c p_title_fkmd R
p_type.s_created_by_c p_type_fkcr R
p_type.s_modified_by_c p_type_fkmd R
p_type_category.s_created_by_c p_type_category_fkcr R
p_type_category.s_modified_by_c p_type_category_fkmd R
p_unit.s_created_by_c p_unit_fkcr R
p_unit.s_modified_by_c p_unit_fkmd R
p_venue.s_created_by_c p_venue_fkcr R
p_venue.s_modified_by_c p_venue_fkmd R
pc_attendee.s_created_by_c pc_attendee_fkcr R
pc_attendee.s_modified_by_c pc_attendee_fkmd R
pc_building.s_created_by_c pc_building_fkcr R
pc_building.s_modified_by_c pc_building_fkmd R
pc_conference.s_created_by_c pc_conference_fkcr R
pc_conference.s_modified_by_c pc_conference_fkmd R
pc_conference_cost.s_created_by_c pc_conference_cost_fkcr R
pc_conference_cost.s_modified_by_c pc_conference_cost_fkmd R
pc_conference_option.s_created_by_c pc_conference_option_fkcr R
pc_conference_option.s_modified_by_c pc_conference_option_fkmd R
pc_conference_option_type.s_created_by_c pc_conference_option_type_fkcr R
pc_conference_option_type.s_modified_by_c pc_conference_option_type_fkmd R
pc_conference_venue.s_created_by_c pc_conference_venue_fkcr R
pc_conference_venue.s_modified_by_c pc_conference_venue_fkmd R
pc_cost_type.s_created_by_c pc_cost_type_fkcr R
pc_cost_type.s_modified_by_c pc_cost_type_fkmd R
pc_discount.s_created_by_c pc_discount_fkcr R
pc_discount.s_modified_by_c pc_discount_fkmd R
pc_discount_criteria.s_created_by_c pc_discount_criteria_fkcr R
pc_discount_criteria.s_modified_by_c pc_discount_criteria_fkmd R
pc_early_late.s_created_by_c pc_early_late_fkcr R
pc_early_late.s_modified_by_c pc_early_late_fkmd R
pc_extra_cost.s_created_by_c pc_extra_cost_fkcr R
pc_extra_cost.s_modified_by_c pc_extra_cost_fkmd R
pc_group.s_created_by_c pc_group_fkcr R
pc_group.s_modified_by_c pc_group_fkmd R
pc_room.s_created_by_c pc_room_fkcr R
pc_room.s_modified_by_c pc_room_fkmd R
pc_room_alloc.s_created_by_c pc_room_alloc_fkcr R
pc_room_alloc.s_modified_by_c pc_room_alloc_fkmd R
pc_room_attribute.s_created_by_c pc_room_attribute_fkcr R
pc_room_attribute.s_modified_by_c pc_room_attribute_fkmd R
pc_room_attribute_type.s_created_by_c pc_room_attribute_type_fkcr R
pc_room_attribute_type.s_modified_by_c pc_room_attribute_type_fkmd R
pc_supplement.s_created_by_c pc_supplement_fkcr R
pc_supplement.s_modified_by_c pc_supplement_fkmd R
ph_booking.s_created_by_c ph_booking_fkcr R
ph_booking.s_modified_by_c ph_booking_fkmd R
ph_room_booking.s_created_by_c ph_room_booking_fkcr R
ph_room_booking.s_modified_by_c ph_room_booking_fkmd R
pm_application_file.s_created_by_c pm_application_file_fkcr R
pm_application_file.s_modified_by_c pm_application_file_fkmd R
pm_application_forms.s_created_by_c pm_application_forms_fkcr R
pm_application_forms.s_modified_by_c pm_application_forms_fkmd R
pm_application_forms_file.s_created_by_c pm_application_forms_file_fkcr R
pm_application_forms_file.s_modified_by_c pm_application_forms_file_fkmd R
pm_application_status_history.s_created_by_c pm_application_status_history_fkcr R
pm_application_status_history.s_modified_by_c pm_application_status_history_fkmd R
pm_commitment_status.s_created_by_c pm_commitment_status_fkcr R
pm_commitment_status.s_modified_by_c pm_commitment_status_fkmd R
pm_document.s_created_by_c pm_document_fkcr R
pm_document.s_modified_by_c pm_document_fkmd R
pm_document_category.s_created_by_c pm_document_category_fkcr R
pm_document_category.s_modified_by_c pm_document_category_fkmd R
pm_document_file.s_created_by_c pm_document_file_fkcr R
pm_document_file.s_modified_by_c pm_document_file_fkmd R
pm_document_type.s_created_by_c pm_document_type_fkcr R
pm_document_type.s_modified_by_c pm_document_type_fkmd R
pm_formal_education.s_created_by_c pm_formal_education_fkcr R
pm_formal_education.s_modified_by_c pm_formal_education_fkmd R
pm_general_application.pm_closed_by_c pm_general_application_fk10 R
pm_general_application.s_created_by_c pm_general_application_fkcr R
pm_general_application.s_modified_by_c pm_general_application_fkmd R
pm_interview.s_created_by_c pm_interview_fkcr R
pm_interview.s_modified_by_c pm_interview_fkmd R
pm_job_assignment.s_created_by_c pm_job_assignment_fkcr R
pm_job_assignment.s_modified_by_c pm_job_assignment_fkmd R
pm_long_term_support_figures.s_created_by_c pm_long_term_support_figures_fkcr R
pm_long_term_support_figures.s_modified_by_c pm_long_term_support_figures_fkmd R
pm_ownership.s_created_by_c pm_ownership_fkcr R
pm_ownership.s_modified_by_c pm_ownership_fkmd R
pm_passport_details.s_created_by_c pm_passport_details_fkcr R
pm_passport_details.s_modified_by_c pm_passport_details_fkmd R
pm_past_experience.s_created_by_c pm_past_experience_fkcr R
pm_past_experience.s_modified_by_c pm_past_experience_fkmd R
pm_pers_office_specific_data.s_created_by_c pm_pers_office_specific_data_fkcr R
pm_pers_office_specific_data.s_modified_by_c pm_pers_office_specific_data_fkmd R
pm_person_ability.s_created_by_c pm_person_ability_fkcr R
pm_person_ability.s_modified_by_c pm_person_ability_fkmd R
pm_person_absence.s_created_by_c pm_person_absence_fkcr R
pm_person_absence.s_modified_by_c pm_person_absence_fkmd R
pm_person_commitment_status.s_created_by_c pm_person_commitment_status_fkcr R
pm_person_commitment_status.s_modified_by_c pm_person_commitment_status_fkmd R
pm_person_evaluation.s_created_by_c pm_person_evaluation_fkcr R
pm_person_evaluation.s_modified_by_c pm_person_evaluation_fkmd R
pm_person_file.s_created_by_c pm_person_file_fkcr R
pm_person_file.s_modified_by_c pm_person_file_fkmd R
pm_person_language.s_created_by_c pm_person_language_fkcr R
pm_person_language.s_modified_by_c pm_person_language_fkmd R
pm_person_qualification.s_created_by_c pm_person_qualification_fkcr R
pm_person_qualification.s_modified_by_c pm_person_qualification_fkmd R
pm_person_skill.s_created_by_c pm_person_skill_fkcr R
pm_person_skill.s_modified_by_c pm_person_skill_fkmd R
pm_person_vision.s_created_by_c pm_person_vision_fkcr R
pm_person_vision.s_modified_by_c pm_person_vision_fkmd R
pm_personal_data.s_created_by_c pm_personal_data_fkcr R
pm_personal_data.s_modified_by_c pm_personal_data_fkmd R
pm_short_term_application.s_created_by_c pm_short_term_application_fkcr R
pm_short_term_application.s_modified_by_c pm_short_term_application_fkmd R
pm_special_need.s_created_by_c pm_special_need_fkcr R
pm_special_need.s_modified_by_c pm_special_need_fkmd R
pm_staff_data.s_created_by_c pm_staff_data_fkcr R
pm_staff_data.s_modified_by_c pm_staff_data_fkmd R
pm_year_program_application.s_created_by_c pm_year_program_application_fkcr R
pm_year_program_application.s_modified_by_c pm_year_program_application_fkmd R
pt_ability_area.s_created_by_c pt_ability_area_fkcr R
pt_ability_area.s_modified_by_c pt_ability_area_fkmd R
pt_ability_level.s_created_by_c pt_ability_level_fkcr R
pt_ability_level.s_modified_by_c pt_ability_level_fkmd R
pt_app_form_types.s_created_by_c pt_app_form_types_fkcr R
pt_app_form_types.s_modified_by_c pt_app_form_types_fkmd R
pt_applicant_status.s_created_by_c pt_applicant_status_fkcr R
pt_applicant_status.s_modified_by_c pt_applicant_status_fkmd R
pt_application_type.s_created_by_c pt_application_type_fkcr R
pt_application_type.s_modified_by_c pt_application_type_fkmd R
pt_arrival_point.s_created_by_c pt_arrival_point_fkcr R
pt_arrival_point.s_modified_by_c pt_arrival_point_fkmd R
pt_assignment_type.s_created_by_c pt_assignment_type_fkcr R
pt_assignment_type.s_modified_by_c pt_assignment_type_fkmd R
pt_congress_code.s_created_by_c pt_congress_code_fkcr R
pt_congress_code.s_modified_by_c pt_congress_code_fkmd R
pt_contact.s_created_by_c pt_contact_fkcr R
pt_contact.s_modified_by_c pt_contact_fkmd R
pt_driver_status.s_created_by_c pt_driver_status_fkcr R
pt_driver_status.s_modified_by_c pt_driver_status_fkmd R
pt_language_level.s_created_by_c pt_language_level_fkcr R
pt_language_level.s_modified_by_c pt_language_level_fkmd R
pt_leadership_rating.s_created_by_c pt_leadership_rating_fkcr R
pt_leadership_rating.s_modified_by_c pt_leadership_rating_fkmd R
pt_leaving_code.s_created_by_c pt_leaving_code_fkcr R
pt_leaving_code.s_modified_by_c pt_leaving_code_fkmd R
pt_marital_status.s_created_by_c pt_marital_status_fkcr R
pt_marital_status.s_modified_by_c pt_marital_status_fkmd R
pt_office_specific_data_labels.s_created_by_c pt_office_specific_data_labels_fkcr R
pt_office_specific_data_labels.s_modified_by_c pt_office_specific_data_labels_fkmd R
pt_outreach_preference_level.s_created_by_c pt_outreach_preference_level_fkcr R
pt_outreach_preference_level.s_modified_by_c pt_outreach_preference_level_fkmd R
pt_party_type.s_created_by_c pt_party_type_fkcr R
pt_party_type.s_modified_by_c pt_party_type_fkmd R
pt_passport_type.s_created_by_c pt_passport_type_fkcr R
pt_passport_type.s_modified_by_c pt_passport_type_fkmd R
pt_personal_data_labels.s_created_by_c pt_personal_data_labels_fkcr R
pt_personal_data_labels.s_modified_by_c pt_personal_data_labels_fkmd R
pt_position.s_created_by_c pt_position_fkcr R
pt_position.s_modified_by_c pt_position_fkmd R
pt_qualification_area.s_created_by_c pt_qualification_area_fkcr R
pt_qualification_area.s_modified_by_c pt_qualification_area_fkmd R
pt_qualification_level.s_created_by_c pt_qualification_level_fkcr R
pt_qualification_level.s_modified_by_c pt_qualification_level_fkmd R
pt_reports.s_created_by_c pt_reports_fkcr R
pt_reports.s_modified_by_c pt_reports_fkmd R
pt_skill_category.s_created_by_c pt_skill_category_fkcr R
pt_skill_category.s_modified_by_c pt_skill_category_fkmd R
pt_skill_level.s_created_by_c pt_skill_level_fkcr R
pt_skill_level.s_modified_by_c pt_skill_level_fkmd R
pt_special_applicant.s_created_by_c pt_special_applicant_fkcr R
pt_special_applicant.s_modified_by_c pt_special_applicant_fkmd R
pt_travel_type.s_created_by_c pt_travel_type_fkcr R
pt_travel_type.s_modified_by_c pt_travel_type_fkmd R
pt_valuable_item.s_created_by_c pt_valuable_item_fkcr R
pt_valuable_item.s_modified_by_c pt_valuable_item_fkmd R
pt_vision_area.s_created_by_c pt_vision_area_fkcr R
pt_vision_area.s_modified_by_c pt_vision_area_fkmd R
pt_vision_level.s_created_by_c pt_vision_level_fkcr R
pt_vision_level.s_modified_by_c pt_vision_level_fkmd R
s_batch_job.s_created_by_c s_batch_job_fkcr R
s_batch_job.s_modified_by_c s_batch_job_fkmd R
s_batch_job.s_user_id_c s_batch_job_fk2 R
s_change_event.s_created_by_c s_change_event_fkcr R
s_change_event.s_modified_by_c s_change_event_fkmd R
s_default_file_volume.s_created_by_c s_default_file_volume_fkcr R
s_default_file_volume.s_modified_by_c s_default_file_volume_fkmd R
s_error_log.s_created_by_c s_error_log_fkcr R
s_error_log.s_modified_by_c s_error_log_fkmd R
s_error_log.s_user_id_c s_error_log_fk2 R
s_error_message.s_created_by_c s_error_message_fkcr R
s_error_message.s_modified_by_c s_error_message_fkmd R
s_file.s_created_by_c s_file_fkcr R
s_file.s_modified_by_c s_file_fkmd R
s_form.s_created_by_c s_form_fkcr R
s_form.s_modified_by_c s_form_fkmd R
s_function.s_created_by_c s_function_fkcr R
s_function.s_modified_by_c s_function_fkmd R
s_function_relationship.s_created_by_c s_function_relationship_fkcr R
s_function_relationship.s_modified_by_c s_function_relationship_fkmd R
s_group.s_created_by_c s_group_fkcr R
s_group.s_modified_by_c s_group_fkmd R
s_group_cost_centre.s_created_by_c s_group_cost_centre_fkcr R
s_group_cost_centre.s_modified_by_c s_group_cost_centre_fkmd R
s_group_data_label.s_created_by_c s_group_data_label_fkcr R
s_group_data_label.s_modified_by_c s_group_data_label_fkmd R
s_group_extract.s_created_by_c s_group_extract_fkcr R
s_group_extract.s_modified_by_c s_group_extract_fkmd R
s_group_file_info.s_created_by_c s_group_file_info_fkcr R
s_group_file_info.s_modified_by_c s_group_file_info_fkmd R
s_group_function.s_created_by_c s_group_function_fkcr R
s_group_function.s_modified_by_c s_group_function_fkmd R
s_group_gift.s_created_by_c s_group_gift_fkcr R
s_group_gift.s_modified_by_c s_group_gift_fkmd R
s_group_ledger.s_created_by_c s_group_ledger_fkcr R
s_group_ledger.s_modified_by_c s_group_ledger_fkmd R
s_group_location.s_created_by_c s_group_location_fkcr R
s_group_location.s_modified_by_c s_group_location_fkmd R
s_group_module_access_permission.s_created_by_c s_group_module_access_permission_fkcr R
s_group_module_access_permission.s_modified_by_c s_group_module_access_permission_fkmd R
s_group_motivation.s_created_by_c s_group_motivation_fkcr R
s_group_motivation.s_modified_by_c s_group_motivation_fkmd R
s_group_partner_contact.s_created_by_c s_group_partner_contact_fkcr R
s_group_partner_contact.s_modified_by_c s_group_partner_contact_fkmd R
s_group_partner_location.s_created_by_c s_group_partner_location_fkcr R
s_group_partner_location.s_modified_by_c s_group_partner_location_fkmd R
s_group_partner_reminder.s_created_by_c s_group_partner_reminder_fkcr R
s_group_partner_reminder.s_modified_by_c s_group_partner_reminder_fkmd R
s_group_partner_set.s_created_by_c s_group_partner_set_fkcr R
s_group_partner_set.s_modified_by_c s_group_partner_set_fkmd R
s_group_table_access_permission.s_created_by_c s_group_table_access_permission_fkcr R
s_group_table_access_permission.s_modified_by_c s_group_table_access_permission_fkmd R
s_job_group.s_created_by_c s_job_group_fkcr R
s_job_group.s_modified_by_c s_job_group_fkmd R
s_label.s_created_by_c s_label_fkcr R
s_label.s_modified_by_c s_label_fkmd R
s_language_specific.s_created_by_c s_language_specific_fkcr R
s_language_specific.s_modified_by_c s_language_specific_fkmd R
s_login.s_created_by_c s_login_fkcr R
s_login.s_modified_by_c s_login_fkmd R
s_logon_message.s_created_by_c s_logon_message_fkcr R
s_logon_message.s_modified_by_c s_logon_message_fkmd R
s_module.s_created_by_c s_module_fkcr R
s_module.s_modified_by_c s_module_fkmd R
s_module_file.s_created_by_c s_module_file_fkcr R
s_module_file.s_modified_by_c s_module_file_fkmd R
s_patch_log.s_created_by_c s_patch_log_fkcr R
s_patch_log.s_modified_by_c s_patch_log_fkmd R
s_patch_log.s_user_id_c s_patch_log_fk1 R
s_report_file.s_created_by_c s_report_file_fkcr R
s_report_file.s_modified_by_c s_report_file_fkmd R
s_report_file.s_user_id_c s_report_file_fk1 R
s_report_options.s_created_by_c s_report_options_fkcr R
s_report_options.s_modified_by_c s_report_options_fkmd R
s_report_options.s_user_id_c s_report_options_fk1 R
s_reports_to_archive.s_created_by_c s_reports_to_archive_fkcr R
s_reports_to_archive.s_modified_by_c s_reports_to_archive_fkmd R
s_selected_output_destination.s_created_by_c s_selected_output_destination_fkcr R
s_selected_output_destination.s_modified_by_c s_selected_output_destination_fkmd R
s_selected_output_destination.s_user_id_c s_selected_output_destination_fk1 R
s_system_defaults.s_created_by_c s_system_defaults_fkcr R
s_system_defaults.s_modified_by_c s_system_defaults_fkmd R
s_system_status.s_created_by_c s_system_status_fkcr R
s_system_status.s_modified_by_c s_system_status_fkmd R
s_system_status.s_user_id_c s_system_status_fk1 R
s_system_status_log.s_created_by_c s_system_status_log_fkcr R
s_system_status_log.s_modified_by_c s_system_status_log_fkmd R
s_system_status_log.s_user_id_c s_system_status_log_fk1 R
s_user_defaults.s_created_by_c s_user_defaults_fkcr R
s_user_defaults.s_modified_by_c s_user_defaults_fkmd R
s_user_defaults.s_user_id_c s_user_defaults_fk1 R
s_user_group.s_created_by_c s_user_group_fkcr R
s_user_group.s_modified_by_c s_user_group_fkmd R
s_user_group.s_user_id_c s_user_group_fk1 R
s_user_module_access_permission.s_created_by_c s_user_module_access_permission_fkcr R
s_user_module_access_permission.s_modified_by_c s_user_module_access_permission_fkmd R
s_user_module_access_permission.s_user_id_c s_user_module_acc_perm_fk1 R
s_user_table_access_permission.s_created_by_c s_user_table_access_permission_fkcr R
s_user_table_access_permission.s_modified_by_c s_user_table_access_permission_fkmd R
s_user_table_access_permission.s_user_id_c s_user_table_acc_perm_fk1 R
s_valid_output_form.s_created_by_c s_valid_output_form_fkcr R
s_valid_output_form.s_modified_by_c s_valid_output_form_fkmd R
s_volume.s_created_by_c s_volume_fkcr R
s_volume.s_modified_by_c s_volume_fkmd R
s_volume_partner_group.s_created_by_c s_volume_partner_group_fkcr R
s_volume_partner_group.s_modified_by_c s_volume_partner_group_fkmd R
s_volume_partner_group_partner.s_created_by_c s_volume_partner_group_partner_fkcr R
s_volume_partner_group_partner.s_modified_by_c s_volume_partner_group_partner_fkmd R
s_workflow_definition.s_created_by_c s_workflow_definition_fkcr R
s_workflow_definition.s_modified_by_c s_workflow_definition_fkmd R
s_workflow_group.s_created_by_c s_workflow_group_fkcr R
s_workflow_group.s_modified_by_c s_workflow_group_fkmd R
s_workflow_instance.s_created_by_c s_workflow_instance_fkcr R
s_workflow_instance.s_modified_by_c s_workflow_instance_fkmd R
s_workflow_instance_step.s_created_by_c s_workflow_instance_step_fkcr R
s_workflow_instance_step.s_modified_by_c s_workflow_instance_step_fkmd R
s_workflow_instance_step.s_user_id_c s_workflow_instance_step_fk2 R
s_workflow_step.s_created_by_c s_workflow_step_fkcr R
s_workflow_step.s_modified_by_c s_workflow_step_fkmd R
s_workflow_user.s_created_by_c s_workflow_user_fkcr R
s_workflow_user.s_modified_by_c s_workflow_user_fkmd R
s_workflow_user.s_user_id_c s_workflow_user_fk2 R
u_unit_type.s_created_by_c u_unit_type_fkcr R
u_unit_type.s_modified_by_c u_unit_type_fkmd R
um_job.s_created_by_c um_job_fkcr R
um_job.s_modified_by_c um_job_fkmd R
um_job_language.s_created_by_c um_job_language_fkcr R
um_job_language.s_modified_by_c um_job_language_fkmd R
um_job_qualification.s_created_by_c um_job_qualification_fkcr R
um_job_qualification.s_modified_by_c um_job_qualification_fkmd R
um_job_requirement.s_created_by_c um_job_requirement_fkcr R
um_job_requirement.s_modified_by_c um_job_requirement_fkmd R
um_job_vision.s_created_by_c um_job_vision_fkcr R
um_job_vision.s_modified_by_c um_job_vision_fkmd R
um_unit_ability.s_created_by_c um_unit_ability_fkcr R
um_unit_ability.s_modified_by_c um_unit_ability_fkmd R
um_unit_cost.s_created_by_c um_unit_cost_fkcr R
um_unit_cost.s_modified_by_c um_unit_cost_fkmd R
um_unit_evaluation.s_created_by_c um_unit_evaluation_fkcr R
um_unit_evaluation.s_modified_by_c um_unit_evaluation_fkmd R
um_unit_language.s_created_by_c um_unit_language_fkcr R
um_unit_language.s_modified_by_c um_unit_language_fkmd R
um_unit_structure.s_created_by_c um_unit_structure_fkcr R
um_unit_structure.s_modified_by_c um_unit_structure_fkmd R
um_unit_vision.s_created_by_c um_unit_vision_fkcr R
um_unit_vision.s_modified_by_c um_unit_vision_fkmd R
This identifies who the current user is
s_first_name_c varchar 64  √  null
s_last_name_c varchar 64  √  null
s_password_hash_c varchar 64  √  null The .NET hash value of the user's salted password
s_password_salt_c varchar 64  √  null The salt value used to hide the password even more (cannot recognise 2 same passwords)
s_password_needs_change_l bool 1  √  false Forces change of password at next login. Set by either Petra 2.2 installation or if the SYSADMIN changes a password for a user (not yet implemented)
s_failed_logins_i int4 10  √  0
s_retired_l bool 1  √  false
s_last_login_time_i int4 10  √  0
s_last_login_date_d date 13  √  null The date the user last logged in.
s_language_code_c varchar 20  √  '99'::character varying This is the code used to identify a language.
s_can_modify_l bool 1  √  true This defines if the code can be modified
s_record_delete_l bool 1  √  false
s_acquisition_code_c varchar 16  √  null This code identifies the method of aquisition.
a_default_ledger_number_i int4 10  √  0 This is used as a key field in most of the accounting system files
s_failed_login_time_i int4 10  √  0 The last time a user failed to log in
s_failed_login_date_d date 13  √  null The last date a user failed to log in.
p_partner_key_n numeric 10  √  NULL::numeric
p_partner.p_partner_key_n s_user_fk1 R
If the user has a Partner record this is the key to it
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_modification_id_c varchar 150  √  null

Table contained 3 rows at Mi Nov 09 18:02 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
s_user_id_c Primary key Asc s_user_pk
s_user_id_c Performance Asc inx_p_language_fkcr_ref0
p_partner_key_n Performance Asc inx_s_user_fk1_key2
s_user_id_c Must be unique Asc inx_s_user_pk1

Close relationships: