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
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