Table openpetra_trunk.public.pm_job_assignment
This defines the position one fills.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
p_partner_key_n numeric 10 0
p_partner.p_partner_key_n pm_job_assignment_fk1 R
This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number.
pm_unit_key_n numeric 10 0
um_job.pm_unit_key_n pm_job_assignment_fk2 R
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.
pt_position_name_c varchar 60
um_job.pt_position_name_c pm_job_assignment_fk2 R
Name of the position.
pt_position_scope_c varchar 24
um_job.pt_position_scope_c pm_job_assignment_fk2 R
Scope of the position.
um_job_key_i int4 10
um_job.um_job_key_i pm_job_assignment_fk2 R
pm_job_assignment_key_i int4 10 A number to make this unique as other wise we would need to add date from/to
pt_assistant_to_l bool 1  √  false Indicates if the assignment is in assistance to the given position.
pt_assignment_type_code_c varchar 2  √  null
pt_assignment_type.pt_assignment_type_code_c pm_job_assignment_fk3 R
This defines the type of assignment.
um_costs_changed_flag_l bool 1  √  false Can these costs be changed?
pm_from_date_d date 13 This is the date from which this job is assigned.
pm_to_date_d date 13  √  null This is the date to which a job is expected to be filled.
pm_leaving_code_c varchar 4  √  null
pt_leaving_code.pt_leaving_code_ind_c pm_job_assignment_fk4 R
This is a one character field indicating the leaving code.
pm_leaving_code_updated_date_d date 13  √  null This date field indicating the date the leaving code was updated.
pm_hrd_cpy_detail_change_flag_l bool 1  √  false This field indicates if the hard copy details have been changed.
pm_deleteable_flag_l bool 1  √  false This field indicates if the record is deletable.
pm_registration_office_n numeric 10  √  null The office that entered this assignment
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c pm_job_assignment_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c pm_job_assignment_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 137 rows at Do Nov 10 18:00 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
p_partner_key_n + pm_unit_key_n + pt_position_name_c + pt_position_scope_c + um_job_key_i + pm_job_assignment_key_i Primary key Asc/Asc/Asc/Asc/Asc/Asc pm_job_assignment_pk
p_partner_key_n Performance Asc inx_pm_job_assignment_fk1_key1
pm_unit_key_n + pt_position_name_c + pt_position_scope_c + um_job_key_i Performance Asc/Asc/Asc/Asc inx_pm_job_assignment_fk2_key2
pt_assignment_type_code_c Performance Asc inx_pm_job_assignment_fk3_key3
pm_leaving_code_c Performance Asc inx_pm_job_assignment_fk4_key4
s_created_by_c Performance Asc inx_pm_job_assignment_fkcr_key5
s_modified_by_c Performance Asc inx_pm_job_assignment_fkmd_key6
p_partner_key_n + pm_unit_key_n + pt_position_name_c + pt_position_scope_c + um_job_key_i + pm_job_assignment_key_i Must be unique Asc/Asc/Asc/Asc/Asc/Asc inx_pm_job_assignment_pk0

Close relationships  within of separation: