Skip to end of banner
Go to start of banner

Canceled Vacancies

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 2 Current »

Summary

This view is related to a Recruitment process where a manning agency receives a request to fill an open vacancy.

Keywords

Recruitment, Vacancy

Description

This view is related to a Recruitment process where a manning agency receives a request to fill an open vacancy. You can read more about this process in /wiki/spaces/BLUEP/pages/4579590317

A manning agency will get a request to fill a vacancy and will enter the details of this vacancy in a Customized Topics Datagroup.

The crew list view will list all vacancies, and their details, that are Canceled.

Selection

List all records from the Customized Topics Datagroup for Vacancies that have the status Completed.

SQL statement

CREATE VIEW dbo.PW001SRV702 as
select
	vac.PIN,
	vac.UField1 as 'Vacancy Date',
	vac.UField2 as 'Vacancy Actual  Date',
	ves.Name as 'Vacancy Vessel',
	rank.Name as 'Vacancy Position',
	case when vac.ufield6='OP' then 'Open' 
		 when vac.ufield6='COMP' then 'Completed'  
		 when vac.ufield6='CANC' then 'Canceled' 
		 else '' 
	end as 'Vacancy Status',
	vac.UField7 as 'Vacancy Completion/Cancellation Date',
	vac.UField11 as 'Agency Fee',
	vac.UField12 as 'Agency Comment',
	vac.UField13 as 'Recruitment Fair Name',
	vac.UField14 as 'Recruitment Fair Date',
	vac.UField15 as 'Recruitment Fair Comment',
	vac.UField16 as 'SMC Name',
	vac.UField17 as 'SMC Date',
	vac.UField18 as 'SMC Comment',
	vac.UField19 as 'SMC Facebook',
	vac.UField20 as 'SMC Instagram',
	vac.UField21 as 'SMC LinkedIn',
	vac.UField22 as 'SMC Other',
	vac.UField23 as'SMC Channel Comments',
	p01.Employmentstartdate,
	p01.Employmentenddate,
	p01.Client as Numorgid
	
from PW001U02 VAC
left join pw001p01 p01 on p01.pin=vac.pin
left join pworg ves on ves.numorgid=vac.ufield3
left join pw001c02 rank on rank.code=vac.Ufield5
where vac.ufield6='CANC'

Field Specification

The fields available are specified for such a process.

The UField number can be different for each setup and the SQL statement must be checked and changed accordinglye.

UField1

Vacancy Date

Date Field

UField2

Agency Name

Dropdown TBD

UField3

Vacancy Vessel

Drop-down with vessels

UField4

Vacancy ID

Number Field

UField5

Vacancy Position

Drop-down with positions

UField6

Vacancy Status

OP - Open
COMP - Completed
CANC - Cancelled

UField7

Vacancy Completion/Cancellation Date

Date field

UField11

Agency Fee

Number (will always be entered as USD)

UField12

Agency Comment

Text

UField13

Recruitment Fair Name

Text

UField14

Recruitment Fair Date

Date

UField15

Recruitment Fair Comment

Text

UField16

SMC Name

Text

UField17

SMC Date

Date

UField18

SMC Comment

Text

UField19

SMC Facebook

Checkbox

UField20

SMC Instagram

Checkbox

UField21

SMC LinkedIn

Checkbox

UField22

SMC Other

Checkbox

UField23

SMC Channel Comments

Text

Start Page

N/A

  • No labels