Versions Compared

Version Old Version 4 New Version 5
Changes made by

Sigrid Kviteberg

Daria Chebotaieva

Saved on

Key

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

...

Description

...

Confirmed Assignment

...

Summary

...

Table of Contents
minLevel1
maxLevel1
typeflat
separatorpipe
Page Properties

Summary

The notificatin informs the crew once the planned assignment is confirmed.

Customer

Keywords

Confirmed

Crew Change

File / Script Link

Compatibility APM Version

N/A

Compatibility SQL Version

N/A

, Assignment

Setup

  1. Go to Setup > Notification Service

  2. Add New, give the task a name, and define time and date settings. For more details on the settings, please check Notification Service#ScheduleTask

    Image RemovedImage Added

  3. Under the Notification E-mails tab, define the Sender email and name. Recipients will be picked up dynamically from the database. An example of a selection that can be used is shown below, please check with Adonis Support or Project Consultants if you can use the same selection.

    Image RemovedImage Added

  4. Insert Email Subject and Body. Note that you can insert screenshots, links and signatures to the mail body.

Cp panel macro
data%7B%22components%22%3A%5B%22title%22%5D%2C%22titleAlignment%22%3A%22left%22%2C%22contentAlignment%22%3A%22left%22%2C%22title%22%3A%22%22%2C%22titleColor%22%3A%22%23ffffff%22%2C%22titleContainerColor%22%3A%22%230052CC%22%2C%22background%22%3A%22%23ffffff%22%2C%22borderColor%22%3A%22%23FF8B00%22%2C%22borderRadius%22%3A4%2C%22borderType%22%3A%22solid%22%2C%22icon%22%3A%22%22%7D

Hello [#LASTNAME],

Please note that your next planned assignment on [#PLATFORM] platforms was confirmed. Details can be found below:

  • Platform name: [#VESSELNAME]

  • Departure date: [#DATEFROM]

  • "Go offshore" date: [#DATETO]

  • Sign off date: [#EED]

Please let us know as soon as possible in case there is any concern regarding the above planning.

Best regards,

Sample Output

N/A

...

SQL Statement

Code Block
SELECT p01.PIN
      ,CASE 
            WHEN P01.SEX='M' THEN 'Mr. '+P01.LASTNAME
            WHEN P01.SEX='F' THEN 'Mrs. '+P01.LASTNAME
            ELSE 'Mr/Mrs. '+P01.LASTNAME
       END                  AS #LASTNAME
      ,ves.[NAME]           AS #VESSELNAME
      ,VES.NUMORGID
      ,p03.DATEFROM         AS #DATEFROM
      ,p03.DATETO           AS #DATETO
      ,p03.TODATEESTIMATED  AS #EED
      ,pf.[NAME]            AS #PLATFORM
      ,P0T.TELENO           AS #EMAIL
FROM   PW001P01 P01
       JOIN PW001P03 P03
            ON  P03.PIN = P01.PIN
                AND ISNULL(P03.PLANNED ,'N') = 'Y'
                    --AND P03.DATEFROM = DATEADD(DAY ,DATEDIFF(DAY ,0 ,GETDATE()) ,30)
                AND P03.CODE IN (SELECT CODE
                                 FROM   PW001C12
                                 WHERE  OPTIONS LIKE '%S%')
       LEFT JOIN (
                SELECT NUMORGID
                      ,dbo.ad_scanorgtree(NUMORGID ,3) AS VesselID
                FROM   pworg
            ) ou
            ON  ou.NUMORGID = p03.NUMORGID
       LEFT JOIN pworg ves
            ON  ves.NUMORGID = ou.VesselID
       LEFT JOIN PWCTCCMP pf
            ON  pf.COMPANYID = ves.NUMORGID
       JOIN PW001P0T P0T
            ON  P0T.PIN = P01.PIN
                AND P0T.TELETYPE = '6'
                AND P0T.TELEPRIORITY = '1'
WHERE  EXISTS (
           SELECT 1
           FROM   PWORGVESACT PRT
                  JOIN PWCCMCHANGECREWLIST CCL
                       ON  CCL.SEQNO = PRT.SEQNO
                           AND CCL.SIGNON = 1
                           AND CCL.CHANGEDONE = 0
                           AND DATEADD(DAY ,DATEDIFF(DAY ,0 ,CCL.repl_ModifiedDate) ,0) = DATEADD(DAY ,DATEDIFF(DAY ,0 ,GETDATE()) ,0)
                  JOIN PW001P01 P
                       ON  P.PIN = CCL.PIN
           WHERE  P.PIN = P01.PIN
       )