Table openpetra_trunk.public.a_recurring_gift_detail
Store recipient information for the recurring gift.

 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_recurring_gift.a_ledger_number_i a_recurring_gift_detail_fk1 R
a_motivation_detail.a_ledger_number_i a_recurring_gift_detail_fk2 R
This is used as a key field in most of the accounting system files
a_batch_number_i int4 10 0
a_recurring_gift.a_batch_number_i a_recurring_gift_detail_fk1 R
Number of the gift batch containing this detail.
a_gift_transaction_number_i int4 10 0
a_recurring_gift.a_gift_transaction_number_i a_recurring_gift_detail_fk1 R
Identifies a gift transaction within a gift batch.
a_detail_number_i int4 10 0 Identifies a gift
a_recipient_ledger_number_n numeric 10  √  0
p_partner.p_partner_key_n a_recurring_gift_detail_fk5 R
This is used as a key field in most of the accounting system files
a_gift_amount_n numeric 24,10  √  0 This is the amount in transaction currency. This field should be renamed to a_gift_transaction_amount_n, to be in analogy to a_gift_detail.a_gift_transaction_amount_n
a_motivation_group_code_c varchar 16
a_motivation_detail.a_motivation_group_code_c a_recurring_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_recurring_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_recurring_gift_detail_fk3 R
This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number.
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.
p_mailing_code_c varchar 50  √  null
p_mailing.p_mailing_code_c a_recurring_gift_detail_fk4 R
Mailing Code
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_start_donations_d date 13  √  null Date that donor wants to begin giving this recurring donation
a_end_donations_d date 13  √  null Date that donor wants to stop giving this recurring donation
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c a_recurring_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_recurring_gift_detail_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 1.003 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_recurring_gift_detail_pk
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_recurring_gift_detail_pk0
s_created_by_c Performance Asc inx_curring_gift_detail_fkcr_key6
s_modified_by_c Performance Asc inx_curring_gift_detail_fkmd_key7
a_ledger_number_i + a_batch_number_i + a_gift_transaction_number_i Performance Asc/Asc/Asc inx_ecurring_gift_detail_fk1_key1
a_ledger_number_i + a_motivation_group_code_c + a_motivation_detail_code_c Performance Asc/Asc/Asc inx_ecurring_gift_detail_fk2_key2
p_recipient_key_n Performance Asc inx_ecurring_gift_detail_fk3_key3
p_mailing_code_c Performance Asc inx_ecurring_gift_detail_fk4_key4
a_recipient_ledger_number_n Performance Asc inx_ecurring_gift_detail_fk5_key5

Close relationships  within of separation: