| Table p_partner |
|
Description: This is the main table of the partner system. Partners can be individuals, families, organisations (churches, businesses), fields, cost centers, and others. These represent various classes of partners. |
| PRIMARY KEY | ||
|
p_partner_key_n
bigint default: 0 NOT NULL | This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number. | |
|
p_partner_class_c
varchar (24) | This defines what type of partner this is. The classes that may be assigned are PERSON, FAMILY, CHURCH, ORGANISATION, UNIT, VENUE and BANK. | p_partner_classes |
|
p_addressee_type_code_c
varchar (24) default: 'DEFAULT' | This is a sub-class of the partner class. | p_addressee_type |
|
p_partner_short_name_c
varchar (160) | Name of the person or organisation. If a person, more name info is stored in p_person. | |
|
p_partner_short_name_loc_c
varchar (160) | An alternative name for a partner - mainly for entering the local language equivalent. | |
|
p_printed_name_c
varchar (160) | Partner name how it should appear as printed version (to be used if mechanism to build short name from first and last name does not work e.g. in case of different surnames for husband and wife) | |
|
p_language_code_c
varchar (20) default: '99' | Identifies the preferred language of the partner. | p_language |
|
p_key_information_c
varchar (500) | Important information about this partner that users need to be aware of. | |
|
p_comment_c
text | Additional information about the partner that is important to store in the database. | |
|
p_acquisition_code_c
varchar (16) | This code identifies the method of aquisition. | p_acquisition |
|
p_status_code_c
varchar (16) | This code describes the status of a partner. Eg, Active, Deceased etc | p_partner_status |
|
p_status_change_d
date default: CURRENT_DATE | This is the date the status of the partner was last updated. | |
|
p_status_change_reason_c
varchar (400) | Why was the status changed? | |
|
p_deleted_partner_l
boolean default: '0' | Yes if this partner has been ""deleted."" | |
|
p_finance_comment_c
varchar (510) | This is the finance details comment. | |
|
p_receipt_letter_frequency_c
varchar (24) | How often the partner receives a receipt letter. | |
|
p_receipt_each_gift_l
boolean default: '1' | Flags whether each gift given by a user is receipted | |
|
p_email_gift_statement_l
boolean default: '0' | Flag whether to include this partner when running the Recipient Gift Email report | |
|
p_anonymous_donor_l
boolean default: '0' | Yes if the donor wants to remain anonymous. Names of anonymous donors will not appear on recipient gift statements. | |
|
p_no_solicitations_l
boolean default: '0' | Yes if not ok to solicit the partner for funds. | |
|
p_child_indicator_l
boolean default: '0' | Inicates if this partner has been assigned as a child unit to another unit. | |
|
p_restricted_i
integer default: 0 | Restricts use of the partner record to the user in p_user_id_c if 2 or the group in p_group_id_c if 1. | |
|
p_user_id_c
varchar (40) | The Petra user that the partner record is restricted to if p_restricted_i is 2. | |
|
p_group_id_c
varchar (40) | The group of Petra users that the partner record is restricted to if p_restricted_i is 1. | |
|
p_previous_name_c
varchar (512) | ||
|
p_first_contact_code_c
varchar (60) | How did this Partner first hear about us? | p_first_contact |
|
p_first_contact_freeform_c
varchar (400) | How did this Partner first hear about us (freetext)? | |
|
p_intranet_id_c
varchar (200) | Intranet ID. Needed for making the link to the International Website, e.g. for using the Online Address Book. | |
|
p_timezone_c
varchar (100) | Timezone that applies to the partner (address does not necessarily determine that). This refers to data in the International Address Book. | |
|
s_date_created_d
date default: CURRENT_DATE | The date the record was created. | |
|
s_created_by_c
varchar (20) | User ID of who created this record. | s_user |
|
s_date_modified_d
date | The date the record was modified. | |
|
s_modified_by_c
varchar (20) | User ID of who last modified this record. | s_user |
|
s_modification_id_t
timestamp default: CURRENT_TIMESTAMP | This identifies the current version of the record. | |
FOREIGN KEY p_partner_fk1: p_acquisition_code_c => p_acquisition p_partner_fk2: p_language_code_c => p_language p_partner_fk3: p_status_code_c => p_partner_status p_partner_fk4: p_addressee_type_code_c => p_addressee_type p_partner_fk7: p_partner_class_c => p_partner_classes p_partner_fk8: p_first_contact_code_c => p_first_contact p_partner_fkcr: s_created_by_c => s_user p_partner_fkmd: s_modified_by_c => s_user | ||
REFERENCED BY s_user, p_recent_partners, p_partner_location, p_partner_attribute, p_unit, p_unit, p_family, p_person, p_church, p_church, p_organisation, p_organisation, p_bank, p_bank, p_venue, p_venue, p_partner_banking_details, p_partner_tax_deductible_pct, p_partner_type, p_partner_relationship, p_partner_relationship, m_extract, p_customised_greeting, p_subscription, p_subscription, p_partner_membership, p_partner_membership_paid, p_partner_contact, a_valid_ledger_number, a_valid_ledger_number, a_email_destination, a_motivation_detail, a_ep_match, a_ep_match, a_ep_match, a_recurring_gift, a_recurring_gift_detail, a_recurring_gift_detail, a_gift, a_gift_detail, a_gift_detail, a_ap_supplier, a_ar_invoice, pm_document, p_data_label_value_partner, p_data_label_value_partner, p_data_label_value_application, pm_job_assignment, ph_booking, p_tax, p_partner_interest, p_partner_merge, p_partner_merge, p_partner_reminder, p_partner_gift_destination, p_partner_short_code, p_partner_state, p_partner_action, p_partner_set_partner, p_partner_comment, p_foundation, p_foundation, p_foundation, p_foundation_proposal, p_file_info, p_partner_graphic, p_partner_file, p_partner_contact_file, pm_document_file, s_volume_partner_group_partner, p_consent_history | ||