Table openpetra_trunk.public.a_ep_match
the matches that can be used to identify recurring gift or GL transactions

 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
a_ep_match_key_i int4 10
a_ep_transaction.a_ep_match_key_i a_ep_transaction_fk2 R
this is a sequence to easily identify which transaction has been matched and how
a_match_text_c varchar 200  √  null this is a separated list of all the recurring details of a_ep_transaction (ie. name, bank account, sort code, IBAN, amount, description)
a_detail_i int4 10  √  0 the match can be applied to split gifts as well
a_action_c varchar 40 What to do with this match: gift, GL, or discard
a_recent_match_d date 13 ('now'::text)::date The date when this match was recently applied; useful for purging old entries
a_ledger_number_i int4 10 0
a_cost_centre.a_ledger_number_i a_ep_match_fk5 R
a_account.a_ledger_number_i a_ep_match_fk9 R
a_motivation_detail.a_ledger_number_i a_ep_match_fk1 R
The four digit ledger number of the gift.
a_recipient_ledger_number_n numeric 10  √  0
p_partner.p_partner_key_n a_ep_match_fk4 R
The partner key of the commitment field (the unit) of the recipient of the gift. This is not the ledger number but rather the partner key of the unit associated with the ledger.
a_motivation_group_code_c varchar 16  √  null
a_motivation_detail.a_motivation_group_code_c a_ep_match_fk1 R
This defines a motivation group.
a_motivation_detail_code_c varchar 16  √  null
a_motivation_detail.a_motivation_detail_code_c a_ep_match_fk1 R
This defines the motivation detail within a motivation group.
a_comment_one_type_c varchar 24  √  null Used to decide whose reports will see this comment
a_gift_comment_one_c varchar 160  √  null This is a long description and is 80 characters long.
a_confidential_gift_flag_l bool 1 false Defines whether the donor wishes the recipient to know who gave the gift
a_tax_deductable_l bool 1  √  true Whether this gift is tax deductable
p_recipient_key_n numeric 10 0
p_partner.p_partner_key_n a_ep_match_fk2 R
The partner key of the recipient of the gift.
a_charge_flag_l bool 1  √  true To determine whether an admin fee on the transaction should be overwritten if it normally has a charge associated with it. Used for both local and ilt transaction.
a_cost_centre_code_c varchar 24  √  null
a_cost_centre.a_cost_centre_code_c a_ep_match_fk5 R
This identifies which cost centre an account is applied to. A cost centre can be a partner.
p_mailing_code_c varchar 50  √  null
p_mailing.p_mailing_code_c a_ep_match_fk3 R
Mailing Code of the mailing that the gift was a response to.
a_comment_two_type_c varchar 24  √  null Used to decide whose reports will see this comment
a_gift_comment_two_c varchar 160  √  null This is a long description and is 80 characters long.
a_comment_three_type_c varchar 24  √  null Used to decide whose reports will see this comment
a_gift_comment_three_c varchar 160  √  null This is a long description and is 80 characters long.
a_gift_transaction_amount_n numeric 24,10 0 This is a number of currency units in the entered Currency
a_home_admin_charges_flag_l bool 1 true Used to get a yes no response from the user
a_ilt_admin_charges_flag_l bool 1 true Used to get a yes no response from the user
a_receipt_letter_code_c varchar 16  √  null
a_method_of_giving_code_c varchar 24  √  null
a_method_of_giving.a_method_of_giving_code_c a_ep_match_fk6 R
Defines how a gift is given.
a_method_of_payment_code_c varchar 16  √  null
a_method_of_payment.a_method_of_payment_code_c a_ep_match_fk7 R
This is how the partner paid. Eg cash, Cheque etc
p_donor_key_n numeric 10 0
p_partner.p_partner_key_n a_ep_match_fk8 R
This is the partner key of the donor.
a_admin_charge_l bool 1  √  false NOT USED AT ALL
a_narrative_c varchar 240  √  null
a_reference_c varchar 20  √  null Reference number/code for the transaction
p_donor_short_name_c varchar 500  √  null short name of the donor; will be used for generating export files
p_recipient_short_name_c varchar 500  √  null short name of recipient
a_restricted_l bool 1  √  false Indicates whether or not the gift has restricted access. If it does then the access will be controlled by s_group_gift
a_account_code_c varchar 16  √  null
a_account.a_account_code_c a_ep_match_fk9 R
This identifies the account the financial transaction must be stored against
a_key_ministry_key_n numeric 10  √  null
p_unit.p_partner_key_n a_ep_match_fk10 R
Key ministry to which this transaction applies (just for fund transfers)
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c a_ep_match_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c a_ep_match_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 0 rows at Do Nov 10 18:00 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name Anomalies
a_ep_match_key_i Primary key Asc a_ep_match_pk  
a_match_text_c + a_detail_i Must be unique Asc/Asc a_ep_match_uk These unique columns are also nullable
a_match_text_c Performance Asc a_match_text_k0  
a_key_ministry_key_n Performance Asc inx_a_ep_match_fk10_key11  
a_ledger_number_i + a_motivation_group_code_c + a_motivation_detail_code_c Performance Asc/Asc/Asc inx_a_ep_match_fk1_key2  
p_recipient_key_n Performance Asc inx_a_ep_match_fk2_key3  
p_mailing_code_c Performance Asc inx_a_ep_match_fk3_key4  
a_recipient_ledger_number_n Performance Asc inx_a_ep_match_fk4_key5  
a_ledger_number_i + a_cost_centre_code_c Performance Asc/Asc inx_a_ep_match_fk5_key6  
a_method_of_giving_code_c Performance Asc inx_a_ep_match_fk6_key7  
a_method_of_payment_code_c Performance Asc inx_a_ep_match_fk7_key8  
p_donor_key_n Performance Asc inx_a_ep_match_fk8_key9  
a_ledger_number_i + a_account_code_c Performance Asc/Asc inx_a_ep_match_fk9_key10  
s_created_by_c Performance Asc inx_a_ep_match_fkcr_key12  
s_modified_by_c Performance Asc inx_a_ep_match_fkmd_key13  
a_ep_match_key_i Must be unique Asc inx_a_ep_match_pk0  
a_match_text_c + a_detail_i Must be unique Asc/Asc inx_a_ep_match_uk1 These unique columns are also nullable

Close relationships  within of separation: