| 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 default: CURRENT_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 | ||