Table p_person
Diagram PartnerClasses 
Description:
Details of a person. A person must also have a related FAMILY class p_partner record.
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

UNIQUE KEY
p_family_key_n
bigint default: 0
A cross reference to the family record of this person. It should be set to ? (not 0 because such a record does not exist!) when there is no family record. p_family
p_family_id_i
integer default: 0 NOT NULL
This field indicates the family id of the individual. ID's 0 and 1 are used for parents; 2, 3, 4 ... 9 are used for children.

p_title_c
varchar (64)
p_first_name_c
varchar (64)
p_prefered_name_c
varchar (64)
p_middle_name_1_c
varchar (64)
p_middle_name_2_c
varchar (64)
p_middle_name_3_c
varchar (64)
p_family_name_c
varchar (64)
p_decorations_c
varchar (64)
p_date_of_birth_d
date
This is the date the rthe person was born
p_gender_c
varchar (16) default: 'Unknown'
p_marital_status_c
varchar (4) default: 'U'
pt_marital_status
p_occupation_code_c
varchar (32)
p_occupation
p_academic_title_c
varchar (48)
A person's academic title such as BSc(Hons) or Prof. (eg. Herr Prof. Klaus Shmitt)
p_marital_status_since_d
date
p_marital_status_comment_c
varchar (512)
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_person_fk1: p_partner_key_n => p_partner
p_person_fk2: p_family_key_n => p_family
p_person_fk3: p_marital_status_c => pt_marital_status
p_person_fk4: p_occupation_code_c => p_occupation
p_person_fkcr: s_created_by_c => s_user
p_person_fkmd: s_modified_by_c => s_user


REFERENCED BY
pm_general_application, pm_general_application, pm_document,
pm_passport_details, pm_person_language, pm_past_experience,
pm_person_ability, pm_person_qualification, pm_person_skill,
pm_formal_education, pm_personal_data, pm_person_evaluation,
pm_person_absence, pm_special_need, pm_staff_data,
pm_person_commitment_status, pc_attendee, pm_person_file