Versions Compared

Version Old Version 1 New Version 2
Changes made by

Arvin John Salandanan

Sigrid Kviteberg

Saved on

Key

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

Description

CONFIRMED ASSIGNMENT

Summary

Auto generated email from Notification Service that will inform the crew once the planned assignment is confirmed.

Customer

Wilhelmsen

Keywords

Confirmed Crew Change

File / Script Link

Compatibility APM Version

N/A

Compatibility SQL Version

N/A

Setup

  1. Go to Setup > Notification Service

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

  3. Under the Notification E-mails tab, define 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.

  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 Script

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
       )

...