Table of Contents

minLevel	1
maxLevel	1
type	flat
separator	pipe

Page Properties

Summary	The notification informs the crew of the next planned assignment for the next 30 days.
Keywords	Activity, Planned Sign-On

Description

The notification informs the crew of the next planned assignment for the next 30 days.

Setup

...

Go to Setup > Notification Service.
Image Removed
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 Removed
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 Removed
Insert Email Subject and Body. Note that you can insert screenshots, links, and signatures to the mail body.

Sample Output

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%22Example%20mail%20body%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 Mr./Mrs. (depending on Gender) [#LASTNAME],

Please note that your next planned assignment on [#PLATFORM] platforms is as follows:

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 abover planning.

Best regards,

and Configuration

Task Settings

Schedule: Daily, every day.

Recipients: affected crew.
Can be set to a fixed email list.

Image Added

SQL Statement

Expand

title	SQL Statement

Code Block

language	sql

SELECT 
		P01.PIN as #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

...

,
		email.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

...

LEFT JOIN PW001P0T

...

email ON email.PIN = p01.PIN 
							AND email.TELETYPE = 6 
							AND email.TELEPRIORITY

...

IS NOT

...

NULL

...


							AND NOT EXISTS (SELECT 1  FROM   PW001P0T t WHERE  t.PIN = email.PIN

...

AND

...

t.TELETYPE =

...

email.TELETYPE AND t.TELEPRIORITY IS NOT NULL
							AND (t.TELEPRIORITY < email.TELEPRIORITY OR t.TELEPRIORITY = email.TELEPRIORITY AND t.SEQUENCENO < email.SEQUENCENO))

Sample E-mail