Table pm_person_skill
Description:
This table describes the skills that a person has (including professional skills but also other ones).
PRIMARY KEY
pm_person_skill_key_i
integer NOT NULL

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_person
pm_skill_category_code_c
varchar (60) NOT NULL
Skill Category pt_skill_category
pm_description_english_c
varchar (160) NOT NULL
Description of skill in english language
pm_description_local_c
varchar (160)
Description of skill in local language
pm_description_language_c
varchar (20)
Language that is used in field pm_description_local_c p_language
pm_skill_level_i
integer NOT NULL
This field is a numeric representation of level of skill. pt_skill_level
pm_years_of_experience_i
integer default: 99
Years of experience this person has had this skill.
pm_years_of_experience_as_of_d
date
The date the years of experience were up to date.
pm_professional_skill_l
boolean default: '0'
Indicates if this is a professional skill
pm_current_occupation_l
boolean default: '0'
Indicates if this is the person's current occupation
pm_degree_c
varchar (160)
Degree that is linked with the skill (if applicable)
pm_year_of_degree_i
integer
Year the degree was obtained.
pm_comment_c
varchar (1000)
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
pm_person_skill_fk1: p_partner_key_n => p_person
pm_person_skill_fk2: pm_skill_category_code_c => pt_skill_category
pm_person_skill_fk3: pm_description_language_c => p_language
pm_person_skill_fk4: pm_skill_level_i => pt_skill_level
pm_person_skill_fkcr: s_created_by_c => s_user
pm_person_skill_fkmd: s_modified_by_c => s_user