...
...
...
...
...
...
...
NotificationTask, Birthday
...
File / Script Link
...
...
Compatibility APM Version
...
N/A
...
Compatibility SQL Version
...
N/A
| Page Properties |
|---|
Summary | This notification task sends an email to all active employees with congratulations on their Birthday. |
|---|
Keywords | Birthday |
|---|
|
Description
This notification task sends an email to all active employees with congratulations on their Birthday.
Sample setup
...
...
SQL Statement
| Expand |
|---|
|
| Code Block |
|---|
SELECT
p01.PIN #Pin, |
|
...
p01.firstname #Firstname, |
|
...
...
...
...
...
...
...
AND email.TELEPRIORITY IS NOT NULL |
|
...
...
(
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 |
|
...
)
)
WHERE
DATEPART(dd, p01.BIRTHDATE) = DATEPART(dd, GETDATE()) AND DATEPART(mm, p01.BIRTHDATE) = DATEPART(mm, GETDATE()) |
|
...
AND NULLIF(email.TELENO, '') IS NOT NULL |
|
...
AND (p01.Employmentenddate='' or p01.Employmentenddate is NULL) |
|
...
Fields Desciprion
Field | Description |
|---|
#Pin | The PIN number. |
#Firstname | The First Name of the person. |
#Lastname | The Last Name of the person. |
#Email | The e-mail of the manager(s). |
Sample Email
Hi [#Firstname],
Happy Birthday!
Wishing you a memorable day and that your life is filled with love, harmony and
good health during the coming year. Enjoy the adventure and stay amazing!
...
