Table p_partner_gift_destination
Description:
Tracks the current gift destination for the Partner and maintains a history
PRIMARY KEY
p_key_i
integer NOT NULL
Surrogate Primary Key

p_partner_key_n
bigint NOT NULL
Partner key of Partner to which the field is assigned p_partner
p_field_key_n
bigint NOT NULL
Field to which Partner is assigned p_unit
p_date_effective_d
date NOT NULL
Date from which field assignment is valid
p_date_expires_d
date
Date on which field assignment expires
p_active_l
boolean
Is the field assignment currently valid
p_default_gift_destination_l
boolean
Is this field the default gift destination?
p_partner_class_c
varchar (24)
Is this the field for a person or a family? p_partner_classes
p_commitment_site_key_n
bigint
Needed if this field assignment relates to a specific commitment pm_staff_data
p_commitment_key_n
bigint
Needed if this field assignment relates to a specific commitment pm_staff_data
p_comment_c
varchar (400)
Any comments relating to this field assignment
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
This identifies the current version of the record.


FOREIGN KEY
p_partner_gift_destination_fk1: p_partner_key_n => p_partner
p_partner_gift_destination_fk2: p_field_key_n => p_unit
p_partner_gift_destination_fk3: p_partner_class_c => p_partner_classes
p_partner_gift_destination_fk4: p_commitment_site_key_n;p_commitment_key_n => pm_staff_data
p_partner_gift_destination_fkcr: s_created_by_c => s_user
p_partner_gift_destination_fkmd: s_modified_by_c => s_user