Table openpetra_trunk.public.a_gift_detail
The gift recipient information for a gift. A single gift can be split among more than one recipient. A gift detail record is created for each recipient.

 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_ledger_number_i int4 10 0
a_processed_fee.a_ledger_number_i a_processed_fee_fk3 R
a_cost_centre.a_ledger_number_i a_gift_detail_fk6 R
a_gift.a_ledger_number_i a_gift_detail_fk1 R
a_motivation_detail.a_ledger_number_i a_gift_detail_fk2 R
The four digit ledger number of the gift.
a_batch_number_i int4 10 0
a_processed_fee.a_batch_number_i a_processed_fee_fk3 R
a_gift.a_batch_number_i a_gift_detail_fk1 R
Number of the gift batch containing this detail.
a_gift_transaction_number_i int4 10 0
a_processed_fee.a_gift_transaction_number_i a_processed_fee_fk3 R
a_gift.a_gift_transaction_number_i a_gift_detail_fk1 R
Identifies a gift transaction within a gift batch.
a_detail_number_i int4 10 0
a_processed_fee.a_detail_number_i a_processed_fee_fk3 R
Identifies a gift detail within a gift transaction. When a donor gives a donation to multiple recipients (a split gift), a gift detail record is created for each recipient.
a_recipient_ledger_number_n numeric 10 0
p_partner.p_partner_key_n a_gift_detail_fk5 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_gift_amount_n numeric 24,10  √  0 This is a number of currency units of the ledger base currency.
a_motivation_group_code_c varchar 16
a_motivation_detail.a_motivation_group_code_c a_gift_detail_fk2 R
This defines a motivation group.
a_motivation_detail_code_c varchar 16
a_motivation_detail.a_motivation_detail_code_c a_gift_detail_fk2 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_gift_detail_fk3 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_gift_detail_fk6 R
This identifies which cost centre an account is applied to. A cost centre can be a partner.
a_gift_amount_intl_n numeric 24,10  √  0 This is a number of currency units in the International Currency
a_modified_detail_l bool 1  √  false Indicates whether this gift detail has a matching inverse detail record because a modification was made
a_gift_transaction_amount_n numeric 24,10 0 This is a number of currency units in the entered Currency
a_ich_number_i int4 10 0 identifes the ICH process number
p_mailing_code_c varchar 50  √  null
p_mailing.p_mailing_code_c a_gift_detail_fk4 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.
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c a_gift_detail_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c a_gift_detail_fkmd R
s_modification_id_c varchar 150  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
a_ledger_number_i + a_batch_number_i + a_gift_transaction_number_i + a_detail_number_i Primary key Asc/Asc/Asc/Asc a_gift_detail_pk
a_ledger_number_i + a_recipient_ledger_number_n + p_recipient_key_n Performance Asc/Asc/Asc a_recipient_ledger_number_i0
a_ledger_number_i + a_batch_number_i + a_gift_transaction_number_i Performance Asc/Asc/Asc inx_a_gift_detail_fk1_key2
a_ledger_number_i + a_motivation_group_code_c + a_motivation_detail_code_c Performance Asc/Asc/Asc inx_a_gift_detail_fk2_key3
p_recipient_key_n Performance Asc inx_a_gift_detail_fk3_key4
p_mailing_code_c Performance Asc inx_a_gift_detail_fk4_key5
a_recipient_ledger_number_n Performance Asc inx_a_gift_detail_fk5_key6
a_ledger_number_i + a_cost_centre_code_c Performance Asc/Asc inx_a_gift_detail_fk6_key7
s_created_by_c Performance Asc inx_a_gift_detail_fkcr_key8
s_modified_by_c Performance Asc inx_a_gift_detail_fkmd_key9
a_ledger_number_i + a_batch_number_i + a_gift_transaction_number_i + a_detail_number_i Must be unique Asc/Asc/Asc/Asc inx_a_gift_detail_pk1
a_ledger_number_i + a_batch_number_i + a_gift_transaction_number_i + a_detail_number_i Performance Asc/Asc/Asc/Asc inx_a_processed_fee_fk3_ref0
a_ledger_number_i + p_recipient_key_n Performance Asc/Asc p_recipient_key1

Close relationships  within of separation: