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

Please remember to add labels to the article. Only the labels from the lit are allowed: /wiki/spaces/PnP/pages/4523197124

Description

This view is will show you the recods of planning progress and status of individuals and groups who are planned to travel for a Sea Service using a customized topic called Planning Process.

You can read more about this process in Record Rotation Planning Progress and Status

View Sample

Main Data Selection

All crews that has records in customized topic called Planning Process.

SQL statement

Click here to expand...

--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	Text 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
Available from	Date
Planned for Sea Service	Date
Vessel	Drop-down with vessels
Planned Sign on	Date
Competence Documents Checked	Checkbox
Travel Documents Checked	Checkbox
Visa needed	Checkbox
Documents comment	Text
Medical considerations	Text
NOK info checked	Checkbox
Flight booked	Text
PNR	Text
Hotel booking	Checkbox
General comments	Memo/Rich Text Editor
Agent informed	Text
Port authorities informed	Date

Start Page

N/A

Planning Process