| Table um_job |
|
Description: This table contains information concerning jobs within the unit. |
| PRIMARY KEY | ||
|
pm_unit_key_n
bigint default: 0 NOT NULL | This is the partner key of the unit. It consists of the fund id followed by a computer generated six digit number. | p_unit |
|
pt_position_name_c
varchar (60) NOT NULL | Name of the position. | pt_position |
|
pt_position_scope_c
varchar (24) NOT NULL | Scope of the position. | pt_position |
|
um_job_key_i
integer NOT NULL | To make sure we can have two jobs in difference time-frames | |
|
um_job_type_c
varchar (40) default: 'Short Term' NOT NULL | Indicates the normal length of commitment, eg. short-term. | |
|
um_from_date_d
date | Date from um_training_period. | |
|
um_to_date_d
date | Date the job posting is to. | |
|
um_minimum_i
integer default: 0 | Indicates the minimum number of staff required. | |
|
um_maximum_i
integer default: 0 | Indicates the maximum number of staff required. | |
|
um_present_i
integer default: 0 | Indicates the present number on staff. | |
|
um_part_timers_i
integer default: 0 | Number of part-timers acceptable. | |
|
um_applications_i
integer default: 0 | Number of applications on file for this position. This field is driven from the pm_job_assignment. | |
|
um_part_time_flag_l
boolean default: '0' | Indicates if part-timers can be accepted for this position. | |
|
um_training_period_c
varchar (30) default: 'One month' NOT NULL | Length of training required for this position. | |
|
um_commitment_period_c
varchar (30) default: 'Three months' NOT NULL | Length of commitment required for this position. | |
|
um_public_flag_l
boolean default: '0' | Is this position available to other systems. | |
|
um_job_publicity_i
integer default: 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
boolean default: '0' | Indicates whether previous experience with our organisation is required for this job. | |
|
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 um_job_fk1: pm_unit_key_n => p_unit um_job_fk2: pt_position_name_c;pt_position_scope_c => pt_position um_job_fkcr: s_created_by_c => s_user um_job_fkmd: s_modified_by_c => s_user | ||
REFERENCED BY um_job_requirement, um_job_language, um_job_qualification, pm_job_assignment, s_job_group | ||