Versions Compared

Version Old Version 1 New Version Current
Changes made by

Sigrid Kviteberg

Helen Ustych

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 Adonis Recruitment Set up /wiki/spaces/BLUEP/pages/4579590317

A manning agency will get a request to fill a vacancy and will enter in the details of this vacancy in a Customized Topics Datagroup. All candidates for the vacancies will be added to the Recruitment Organization and a Customized Topics will be used to track their status related to the Vacancy.

The crew list view will list all vacancies, and their details, candidates that are still openapproved for an interview.

Selection

List all records from the Customized Topics Datagroup for Candidates that are Approved for HOD interview and the approved Yes/No field is still blank, and the candidate has not declined.

...

Code Block
CREATE VIEW dbo.PW001SRV710asselectp01PW001SRV710 as
select
	p01.Employmentstartdate,
	p01.Employmentenddate,
	p01.Client Numorgid,
	cad.PIN,
	cad.Ufield19 'Vacancy ID',
	cad.UField1 as 'Date Submitted',
	case when cad.Ufield2<>'' THEN 'Yes'
		 else '' 
	end as 'CV',
	cad.Ufield4 as 'Agency',
	cad.Ufield5 as 'Approved for HOD Interview',
	cad.Ufield6 as 'HOD Interview Date',
	cad.Ufield7 as 'Approved by HOD',
	cad.Ufield8 as 'Approval Date',
	cad.Ufield9 as 'Availability Date',
	cad.Ufield10 as 'In hold pool',
	cad.Ufield11 as 'Onboard date',
	ves.Name as 'Onboard Vessel',
	rank.Name as 'Onboard Position',
	cad.Ufield14 as 'Declined Position',
	cad.Ufield15 as 'Declined Reason'
	
from PW001U03 CAD
CADleftleft join pw001p01 p01 on p01.pin=cad.pinleftpin
left join pworg ves on ves.numorgid=cad.ufield12leftufield12
left join pw001c02 rank on rank.code=cad.Ufield13where--Candidate is approved for HOD interviewcadUfield13
where cad.ufield5='Y'							--Candidate is not already approved and approved for HOD interview 
	  AND cad.ufield7='' 						--Candidate hasis not declined and already approved 
	  AND (cad.Ufield14='N' OR cad.Ufield14='')	--Candidate has not declined

Field Specification

The fields available are specified for such a process.

...

UField19

Vacancy ID

Number

UField1

Date Submitted

Date Field

UField2

CV

Enclosure

UField3

Source

Drop-down with:
MAC - Manning Agency Crew
PA - Partner Agency

UField4

Agency Name

Dropdown

UField5

Approved for HOD Interview

Checkbox Y/N

UField16

Approval for HOD Interview Comments

Text

UField17

Approved by HOD Comments

Text

UField6

HOD Interview Date

Date Field

UField7

Approved by HOD

Dropdown with Yes/No

UField8

Approval Date

Date Field

UField9

Availability Date

Date Field

UField10

In hold pool

Checkbox Y/N

UField18

Hold Comments

Text

UField11

Onboard Date

Date Field

UField12

Onboard Vessel Name

Drop-down with vessels

UField13

Onboard Rank

Drop-down with ranks

UField14

Declined Position

Checkbox Y/N

UField15

Declined Reason

Dropdown

UField20

Declined Comments

Start Page

Link to the documentation on the related Start Page Tile.

...

N/A