| Table pm_job_assignment |
|
Description: This defines the position one fills. |
| 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 |
|
pm_unit_key_n
bigint default: 0 NOT NULL | This is the partner key of the unit to which this person is assigned. It consists of the fund id followed by a computer generated six digit number. | um_job |
|
pt_position_name_c
varchar (60) NOT NULL | Name of the position. | um_job |
|
pt_position_scope_c
varchar (24) NOT NULL | Scope of the position. | um_job |
|
um_job_key_i
integer NOT NULL | um_job | |
|
pm_job_assignment_key_i
integer NOT NULL | A number to make this unique as other wise we would need to add date from/to | |
|
pt_assistant_to_l
boolean default: '0' | Indicates if the assignment is in assistance to the given position. | |
|
pt_assignment_type_code_c
varchar (2) | This defines the type of assignment. | pt_assignment_type |
|
um_costs_changed_flag_l
boolean default: '0' | Can these costs be changed? | |
|
pm_from_date_d
date NOT NULL | This is the date from which this job is assigned. | |
|
pm_to_date_d
date | This is the date to which a job is expected to be filled. | |
|
pm_hrd_cpy_detail_change_flag_l
boolean default: '0' | This field indicates if the hard copy details have been changed. | |
|
pm_deleteable_flag_l
boolean default: '0' | This field indicates if the record is deletable. | |
|
pm_registration_office_n
bigint | The office that entered this assignment | |
|
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_job_assignment_fk1: p_partner_key_n => p_partner pm_job_assignment_fk2: pm_unit_key_n;pt_position_name_c;pt_position_scope_c;um_job_key_i => um_job pm_job_assignment_fk3: pt_assignment_type_code_c => pt_assignment_type pm_job_assignment_fkcr: s_created_by_c => s_user pm_job_assignment_fkmd: s_modified_by_c => s_user | ||