Table pm_staff_data |
Description: This table contains information regarding recruitment, home office, field office, etc. . |
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 | |
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_status_code_c
varchar (40) | This is a field indicating the status of the commitment | pm_commitment_status |
pm_start_of_commitment_d
date NOT NULL | This is the expected date their commitment starts. | |
pm_start_date_approx_l
boolean default: '0' | Is the commitment start date an approximate date? | |
pm_end_of_commitment_d
date | This is the expected date their commitment ends. | |
pm_office_recruited_by_n
bigint NOT NULL | The office that recruited the partner. This is a unit of type field, not of type office. | p_unit |
pm_home_office_n
bigint NOT NULL | The home office of the person. This is a unit of type field, not of type office. | p_unit |
pm_receiving_field_n
bigint NOT NULL | The person's is serving for that field. | p_unit |
pm_receiving_field_office_n
bigint | The office they work at in the receiving field. | p_unit |
pm_staff_data_comments_c
varchar (640) | Comments on commitment record. | |
pm_job_title_c
varchar (400) | A free text field for a job title for a person. This is not the same as the person's role, however it may be auto generated from the roles. | |
pm_office_phone_ext_c
varchar (50) | Phone extension of the person at this office | |
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_staff_data_fk1: p_partner_key_n => p_person pm_staff_data_fk2: pm_office_recruited_by_n => p_unit pm_staff_data_fk3: pm_home_office_n => p_unit pm_staff_data_fk4: pm_receiving_field_n => p_unit pm_staff_data_fk5: pm_receiving_field_office_n => p_unit pm_staff_data_fk6: pm_status_code_c => pm_commitment_status pm_staff_data_fkcr: s_created_by_c => s_user pm_staff_data_fkmd: s_modified_by_c => s_user | ||
REFERENCED BY p_partner_gift_destination | ||