| 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 default: CURRENT_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 | ||