Table p_partner_attribute
Diagram PartnerEdit 
Description:
Mainly introduced for Partner Contact Details like email addresses and (mobile) phone numbers, but can be used for any attribute we might want to save for a Partner.
PRIMARY KEY
p_partner_key_n
bigint default: 0 NOT NULL
This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number. p_partner
p_attribute_type_c
varchar (60) NOT NULL
The Partner Attribute Type that the Partner Attribute that is assigned here has got. p_partner_attribute_type
p_sequence_i
integer default: 0 NOT NULL
A normal sequence so that each partner can have more than one value for any particular attribute type.

p_index_i
integer NOT NULL
Allows for manual ordering of Partner Attributes within a Partner Attribute Type by the user (e.g. re-ordering of phone numbers within the 'Phone Number' Partner Attribute Type).
p_value_c
varchar (400) NOT NULL
The value of the attribute.
p_value_country_c
varchar (8)
The country of the value of the attribute (only relevant for Telephone and Fax Numbers). p_country
p_comment_c
varchar (400)
Any comment to explain this attribute value, or some additional info that may be required.
p_primary_l
boolean default: '0' NOT NULL
Flag to indicate whether this Partner Attribute is the primary one among several that have the same Partner Attribute Type.
p_within_organisation_l
boolean default: '0' NOT NULL
Flag to indicate whether this Partner Attribute is for use within The Organisation.
p_specialised_l
boolean default: '0' NOT NULL
Flag to indicate whether this Partner Attribute is specialised. For Partner Contact Details this flag is set for work-related Partner Attribute Types. The label is set in p_partner_attribute_type.p_special_label_c, eg. Business
p_confidential_l
boolean default: '0' NOT NULL
Flag to indicate whether this Partner Attribute is confidential.
p_current_l
boolean default: '1' NOT NULL
Flag to indicate whether this Partner Attribute is current.
p_no_longer_current_from_d
date
When this Partner Attribute value is no longer current from.
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_attribute_fk1: p_partner_key_n => p_partner
p_partner_attribute_fk2: p_attribute_type_c => p_partner_attribute_type
p_partner_attribute_fk3: p_value_country_c => p_country
p_partner_attribute_fkcr: s_created_by_c => s_user
p_partner_attribute_fkmd: s_modified_by_c => s_user