Completed Vacancies
- Sigrid Kviteberg
- Helen Ustych
- Daria Chebotaieva
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 https://rippleops.atlassian.net/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 Completed.
Selection
List all records from the Customized Topics Datagroup for Vacancies that have the status Completed.
SQL statement
CREATE VIEW dbo.PW001SRV701 as
select
vac.PIN,
vac.Ufield4 'Vacancy ID',
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='COMP'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 |
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