Summary	A view that will show the status of individuals and groups who are planned to travel for a Sea Service.
Keywords	Rotation Planning
Category	Crew List View

Description

This view shows you the people ready for planning onboard.

For tracking the planning process we are using a customized topic called Planning Process.

You can read more about this process in https://adonishr.atlassian.net/wiki/spaces/AFA/pages/4827873540

Note: A Customized Topic can not be changed once you have started to use it in full scale, without deep SQL knowledge. We recommend that you run a test with one record on just one person to fine-tune your process. If you delete the data record you have tested, you will be able to change the configuration, move or add fields, change fields properties etc.

View Sample

Main Data Selection

All the crew members have some record in the customized topic called Planning Process.

SQL statement

--CREATE VIEW dbo.PW001SRV604 AS
SELECT P01.PIN,
       P01.EMPLOYMENTSTARTDATE,
       P01.EMPLOYMENTENDDATE,
       P01.CLIENT       NUMORGID,
       P01.[NAME]    AS 'Full Name',
       c02.[NAME]    AS 'Rank',
       U25.UFIELD1   AS 'Accepted New Sea Service',
       U25.UFIELD2   AS 'Available from',
       U25.UFIELD3   AS 'Planned for Sea Service',
       VES.[NAME]    AS 'Vessel',
       U25.UFIELD5   AS 'Planned Sign on',
       U25.UFIELD6   AS 'Competence Documents Checked',
       U25.UFIELD7   AS 'Travel Documents checked',
       U25.UFIELD8   AS 'Visa needed',
       U25.UFIELD9   AS 'Documents comment',
       U25.UFIELD10  AS 'Medical considerations',
       U25.UFIELD11  AS 'NOK info checked',
       U25.UFIELD12  AS 'Flight booked',
       U25.UFIELD13  AS 'PNR',
       U25.UFIELD14  AS 'Hotel booking',
       U25.UFIELD15  AS 'General comments',
       U25.UFIELD16  AS 'Agent informed',
       U25.UFIELD17  AS 'Port authorities informed'
FROM   PW001U25 U25
       LEFT JOIN PW001P01 P01
            ON  P01.PIN = U25.PIN
       LEFT JOIN PWORG VES
            ON  VES.NUMORGID = U25.UFIELD4
       LEFT JOIN PW001C02 c02
            ON  c02.CODE = P01.[RANK]

Columns Specification

Column	Field Description	Location in APM

Column	Field Description	Location in APM
PIN	N/A	The PIN from the Personal Details
Employment Start Date	N/A	The employment start date from Personal the Details.
Employment End Date	N/A	The employment end date from Personal the Details.
NUMORGID	N/A	The employment organization id from the Personal Details.
Full Name	N/A	The Full Name from the Personal Details.
Rank	N/A	The Rank Name from the Personal Details
Accepted New Sea Service	Date	The Ufield1 from General Codes > Customized Topics
Available from	Date	The Ufield2 from General Codes > Customized Topics
Planned for Sea Service	Date	The Ufield3 from General Codes > Customized Topics
Vessel	Drop-down with vessels	The Ufield4 from General Codes > Customized Topics
Planned Sign on	Date	The Ufield5 from General Codes > Customized Topics
Competence Documents Checked	Checkbox	The Ufield6 from General Codes > Customized Topics
Travel Documents Checked	Checkbox	The Ufield7 from General Codes > Customized Topics
Visa needed	Checkbox	The Ufield8 from General Codes > Customized Topics
Documents comment	Text	The Ufield9 from General Codes > Customized Topics
Medical considerations	Text	The Ufield10 from General Codes > Customized Topics
NOK info checked	Checkbox	The Ufield11 from General Codes > Customized Topics
Flight booked	Text	The Ufield12 from General Codes > Customized Topics
PNR	Text	The Ufield13 from General Codes > Customized Topics
Hotel booking	Checkbox	The Ufield14 from General Codes > Customized Topics
General comments	Memo/Rich Text Editor	The Ufield15 from General Codes > Customized Topics
Agent informed	Text	The Ufield16 from General Codes > Customized Topics
Port authorities informed	Date	The Ufield17 from General Codes > Customized Topics

Start Page

N/A

Reports, Views and Similar

Create Planning Process