...
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. All candidates for the vacancies will be added to the Recruitment Organization and Customized Topics will be used to track their status related to the Vacancy.
...
List all records from the Customized Topics Datagroup for Candidates that are Approved for HOD interview and the approved candidate=Yes, and the candidate has not declined , and is marked to be in the hold pool.
SQL statement
Code Block |
---|
CREATE VIEW dbo.PW001SRV715 asselectcadas select cad.PIN, 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', p01.Employmentstartdate, p01.Employmentenddate, p01.Client as NumorgidfromNumorgid 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 by HODcadUfield13 where cad.ufield7='Y' --Candidate has not declinedand is approved by HOD AND (cad.Ufield14='N' OR cad.Ufield14='') --Candidate is in hold poolandhas not declinedand AND cad.ufield10='Y' --Candidate is in hold pool |
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: |
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