Table openpetra_trunk.public.um_job
This table contains information concerning jobs within the unit.

 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
pm_unit_key_n numeric 10 0
pm_job_assignment.pm_unit_key_n pm_job_assignment_fk2 R
s_job_group.s_unit_key_n s_job_group_fk1 R
um_job_language.pm_unit_key_n um_job_language_fk1 R
um_job_qualification.pm_unit_key_n um_job_qualification_fk1 R
um_job_requirement.pm_unit_key_n um_job_requirement_fk1 R
um_job_vision.pm_unit_key_n um_job_vision_fk1 R
p_unit.p_partner_key_n um_job_fk1 R
This is the partner key of the unit. It consists of the fund id followed by a computer generated six digit number.
pt_position_name_c varchar 60
pm_job_assignment.pt_position_name_c pm_job_assignment_fk2 R
s_job_group.pt_position_name_c s_job_group_fk1 R
um_job_language.pt_position_name_c um_job_language_fk1 R
um_job_qualification.pt_position_name_c um_job_qualification_fk1 R
um_job_requirement.pt_position_name_c um_job_requirement_fk1 R
um_job_vision.pt_position_name_c um_job_vision_fk1 R
pt_position.pt_position_name_c um_job_fk2 R
Name of the position.
pt_position_scope_c varchar 24
pm_job_assignment.pt_position_scope_c pm_job_assignment_fk2 R
s_job_group.pt_position_scope_c s_job_group_fk1 R
um_job_language.pt_position_scope_c um_job_language_fk1 R
um_job_qualification.pt_position_scope_c um_job_qualification_fk1 R
um_job_requirement.pt_position_scope_c um_job_requirement_fk1 R
um_job_vision.pt_position_scope_c um_job_vision_fk1 R
pt_position.pt_position_scope_c um_job_fk2 R
Scope of the position.
um_job_key_i int4 10
pm_job_assignment.um_job_key_i pm_job_assignment_fk2 R
s_job_group.um_job_key_i s_job_group_fk1 R
um_job_language.um_job_key_i um_job_language_fk1 R
um_job_qualification.um_job_key_i um_job_qualification_fk1 R
um_job_requirement.um_job_key_i um_job_requirement_fk1 R
um_job_vision.um_job_key_i um_job_vision_fk1 R
To make sure we can have two jobs in difference time-frames
um_job_type_c varchar 40 'Short Term'::character varying Indicates the normal length of commitment, eg. short-term.
um_from_date_d date 13  √  null Date from um_training_period.
um_to_date_d date 13  √  null Date the job posting is to.
um_minimum_i int4 10  √  0 Indicates the minimum number of staff required.
um_maximum_i int4 10  √  0 Indicates the maximum number of staff required.
um_present_i int4 10  √  0 Indicates the present number on staff.
um_part_timers_i int4 10  √  0 Number of part-timers acceptable.
um_applications_i int4 10  √  0 Number of applications on file for this position. This field is driven from the pm_job_assignment.
um_part_time_flag_l bool 1  √  false Indicates if part-timers can be accepted for this position.
um_training_period_c varchar 30 'One month'::character varying Length of training required for this position.
um_commitment_period_c varchar 30 'Three months'::character varying Length of commitment required for this position.
um_public_flag_l bool 1  √  false Is this position available to other systems.
um_job_publicity_i int4 10  √  0 Describes where you want to advertise about a job opening, only within the Unit, to the whole organisation, or outside our organisation.
um_previous_internal_exp_req_l bool 1  √  false Indicates whether previous experience with our organisation is required for this job.
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c um_job_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c um_job_fkmd R
s_modification_id_c varchar 150  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
pm_unit_key_n + pt_position_name_c + pt_position_scope_c + um_job_key_i Primary key Asc/Asc/Asc/Asc um_job_pk
pm_unit_key_n Performance Asc inx_um_job_fk1_key1
pt_position_name_c + pt_position_scope_c Performance Asc/Asc inx_um_job_fk2_key2
s_created_by_c Performance Asc inx_um_job_fkcr_key3
s_modified_by_c Performance Asc inx_um_job_fkmd_key4
pm_unit_key_n + pt_position_name_c + pt_position_scope_c + um_job_key_i Must be unique Asc/Asc/Asc/Asc inx_um_job_pk0

Close relationships  within of separation: