Description:
DEPRECATED. USE P_FAMILY INSTEAD. 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 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 default: CURRENT_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 |
|