Table p_partner_attribute_type
Diagram PartnerEdit 
Description:
Holds various Partner Attribute Types.
PRIMARY KEY
p_attribute_type_c
varchar (60) NOT NULL
Attribute Type. This can be anything really: Phone Number, Mobile Number, Email Address, etc (not limited to Partner Contact Details, though). Use singular words/phrases (e.g. 'Phone Number' and not 'Phone Numbers').

p_category_code_c
varchar (60) NOT NULL
Category of the Partner Attribute Type. p_partner_attribute_category
p_description_c
varchar (100) NOT NULL
Description of what this Partner Attribute Type is all about.
p_index_i
integer default: 0 NOT NULL
Allows for manual ordering of Partner Attribute Types by the user (e.g. to list all Partner Attributes that have a Partner Attribute Type of 'phone number' *grouped together* first, then list all that have a Partner Attribute Type of 'assistant phone number' *grouped together*).
p_attribute_type_value_kind_c
varchar (80) NOT NULL
Describes the kind (type) of Value that the Partner Attributes that are linked to this Partner Attribute Type are. Valid values for Contact Detail Attributes: 'CONTACTDETAIL_GENERAL', 'CONTACTDETAIL_HYPERLINK', 'CONTACTDETAIL_HYPERLINK_WITHVALUE', 'CONTACTDETAIL_EMAILADDRESS', 'CONTACTDETAIL_SKYPEID'.
p_hyperlink_format_c
varchar (120)
For use with p_attribute_type_value_kind_c 'CONTACTDETAIL_HYPERLINK_WITHVALUE' only. Specifies how to 'construct' a hyperlink where the Value of a Partner Attribute is part of the URL.
p_special_label_c
varchar (100)
Label that should be displayed/printed instead of p_code_c if a Partner Attribute's 'specialised' Flag is set.
p_unassignable_l
boolean default: '0' NOT NULL
Can this Partner Attribute Type be assigned?
p_unassignable_date_d
date
This is the date where the record was set to unassignable.
p_deletable_l
boolean default: '0' NOT NULL
Flag to indicate whether this Partner Attribute Type is deletable by a user or not.
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_attribute_type_fk1: p_category_code_c => p_partner_attribute_category
p_partner_attribute_type_fkcr: s_created_by_c => s_user
p_partner_attribute_type_fkmd: s_modified_by_c => s_user


REFERENCED BY
p_partner_attribute