| Table pm_past_experience |
|
Description: This details any previous ministry experience the individual has. |
| PRIMARY KEY | ||
|
p_site_key_n
bigint default: 0 NOT NULL | The connection to the site | |
|
pm_key_n
bigint NOT NULL | Key to make editing these records easier | |
| UNIQUE 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_person |
|
pm_start_date_d
date | Start date of previous experience. | |
|
pm_end_date_d
date | End date of previous experience. | |
|
pm_prev_location_c
varchar (60) NOT NULL | Location of previous work . | |
|
pm_prev_role_c
varchar (60) | Describes role played in previous work. | |
|
pm_category_c
varchar (60) | Category/area of previous work | |
|
pm_other_organisation_c
varchar (50) | Worked with which organisation before (if other than our organisation). | |
|
pm_past_exp_comments_c
varchar (640) | Comments on previous experience. | |
|
pm_prev_work_here_l
boolean default: '0' | Indicates if past experience was with this organisation. | |
|
pm_prev_work_l
boolean default: '0' | Indicates whether the individual has previous worked with similar organisations. | |
|
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_past_experience_fk1: p_partner_key_n => p_person pm_past_experience_fkcr: s_created_by_c => s_user pm_past_experience_fkmd: s_modified_by_c => s_user | ||