Versions Compared

Old Version 3

changes.mady.by.user Daria Chebotaieva

Saved on

compared with

New Version Current

changes.mady.by.user Per Ove Kviteberg

Saved on

Key

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

...

Page Properties

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.

...

You can read more about this process in /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

Expand
Code Block
languagesql
--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

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