...
Description
...
CONFIRMED ASSIGNMENT
...
Summary
...
| Table of Contents |
|---|
| minLevel | 1 |
|---|
| maxLevel | 1 |
|---|
| type | flat |
|---|
| separator | pipe |
|---|
|
| Page Properties |
|---|
Summary | The notification task informs the crew once the planned assignment is confirmed. |
|---|
|
...
Customer
...
...
...
File / Script Link
...
Compatibility APM Version
...
N/A
...
Compatibility SQL Version
...
N/A
Setup
Go to Setup > Notification Service
Image RemovedAdd New, give the task a name, define time and date settings. For more details on the settings, please check Notification Service#ScheduleTask
Image RemovedUnder 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.
Image RemovedInsert 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
...
Description
The notification task informs the crew once the planned assignment is confirmed.
Setup and Configuration
Task Settings
Schedule: Daily, every day.
Recipients: affected crew.
Can be set to a fixed email list.
Image Added Image Added SQL Statement
| Expand |
|---|
|
| 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
|
|
...
...
,
ves.[NAME] AS #VESSELNAME |
|
...
...
,
p03.DATEFROM AS #DATEFROM |
|
...
...
,
p03.TODATEESTIMATED AS #EED,
|
|
...
p03.SEQUENCENO,
pf.[NAME] AS #PLATFORM |
|
...
,
email.TELENO AS #EMAIL
FROM PW001P01 P01 |
|
...
...
...
...
...
...
AND ISNULL(P03.PLANNED ,'N') = 'Y'
|
|
...
--AND P03.DATEFROM = DATEADD(DAY ,DATEDIFF(DAY ,0 ,GETDATE()) ,30)
|
|
...
AND P03.CODE IN (SELECT CODE |
|
...
...
...
...
...
WHERE OPTIONS LIKE '%S%') |
|
...
...
...
...
,dbo.ad_scanorgtree(NUMORGID ,3) AS VesselID |
|
...
...
...
...
ON ou.NUMORGID = p03.NUMORGID |
|
...
...
...
...
ON ves.NUMORGID = ou.VesselID |
|
...
...
...
...
ON pf.COMPANYID = ves.NUMORGID
LEFT |
|
...
...
email ON email.PIN = p01.PIN
AND email.TELETYPE = 6
AND email.TELEPRIORITY |
|
...
...
...
AND NOT EXISTS (SELECT 1 FROM PW001P0T t WHERE t.PIN = email.PIN |
|
...
...
...
email.TELETYPE AND t.TELEPRIORITY IS NOT NULL
AND (t.TELEPRIORITY < email.TELEPRIORITY OR t.TELEPRIORITY = email.TELEPRIORITY AND t.SEQUENCENO < email.SEQUENCENO))
WHERE EXISTS (
SELECT |
|
...
PRT.SEQNO
FROM PWORGVESACT PRT
JOIN PWCCMCHANGECREWLIST CCL
ON CCL.SEQNO = PRT.SEQNO
AND CCL.SIGNON = 1
AND CCL.CHANGEDONE = 0
AND |
|
...
Convert(date,CCL.repl_ModifiedDate) |
|
...
...
...
date,GetDate())
JOIN PW001P01 P
ON P.PIN = CCL.PIN
WHERE P.PIN = P01.PIN
)
|
|
Sample E-mail
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,
Crew Planning Team
