Table p_addressee_type
Diagram PartnerEdit 
Description:
Ex. Fam - Family, SM - Single Male, etc.
PRIMARY KEY
p_addressee_type_code_c
varchar (24) NOT NULL

p_description_c
varchar (64) NOT NULL
p_deletable_l
boolean default: '1' NOT NULL
This defines if the addressee type code can be deleted. This can only be updated by the system manager. At the risk of serious operational integrity. Default to Yes
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_addressee_type_fkcr: s_created_by_c => s_user
p_addressee_type_fkmd: s_modified_by_c => s_user


REFERENCED BY
p_title, p_formality, p_partner