1 Description | 2 SQL Statement | 3 Field Specification | 4 Task Settings | 5 Sample e-mail

Summary	The notification sends out an automatic e-mail to the new employee/ crew on the date set in the customized field.
Keywords	Employee Portal, registration, first-time login

Description

The notification task sends out an automatic e-mail to the new employee/ crew member on the date set under the customized field that is used for employee portal access.

SQL Statement

The p0u.EMPPORT value should be changed to the corresponding customized field code in your database.

select 
distinct
p01.pin #pin,
p01.firstname #Firstname,
convert (varchar (10), p01.birthdate, 103) #BIRTHDATE,
email.teleno #email
--'daria.chebotaieva@adonishr.com' #Email
from 
pw001p01 p01
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
                               )
                )
LEFT JOIN PW001p0U p0u on p0u.pin = p01.pin
left join WEB_CP_ACCOUNT_EMPLOYEE acc on acc.pin = p01.pin
WHERE
	NULLIF(email.TELENO, '') IS NOT NULL
	and(convert(date,p0u.EMPPORT) = convert(date,getdate()))
	and p01.pin not in (select pin from WEB_CP_ACCOUNT_EMPLOYEE)
	and p0u.repl_ModifiedDate > DATEADD (HOUR , -1, dateadd(MINUTE,-1,GETDATE()))

Field Specification

pin - personal id

Firstname - the first name of the person from the Personal Details.

BIRTHDATE - birth date of the person from the Personal Details.

email - e-mail address of the person from the Personal Details. The e-mail with the highest priority is taken.

Task Settings

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

Schedule: Hourly, every 60 minutes.

Sample e-mail

English	Norwegian

English

Norwegian

Hi [#FIRSTNAME],

Welcome to Company Name employee portal!

In the portal, you will be able to:

View and update your personal information
Upload and maintain certificates, training, and travel documents
- You will receive automatic email notifications reminding you about upcoming expiration dates.
Register next of kin information
View your payslips
Submit electronic travel expense documents

Going forward, we kindly ask you to submit your travel expense reports using the travel expense module in the Employee Portal.

You will be able to link the expense report to the vessel it belongs to. Once submitted, the reports will be sent to the ship’s captain for approval. Final approval will be carried out by the coordinators in the office. When approved, the expenses will be reimbursed on your next pay stub.

For any questions, please contact your Crew Coordinator.

To get started:

Navigate to http://portal_link
Click First Time Login
Enter the following information and click OK
Email: [#Email]
PIN: [#PIN]
Birthdate: [#Birthdate]
You will now receive an email with instructions on how to create an account.
Once you have created the password, you can proceed to log in.

Hei [#FIRSTNAME]

Velkommen til Company Name ansattportal.

I portalen har du muligheten til å:

se og vedlikeholde persondataene dine
vedlikeholde sertifikater og reisedokumenter
- Du vil motta automatiske varslinger på epost i forbindelse med utløp av dokumenter, med påminnelse om fornying. Fornyede dokumenter vil så kunne lastes opp rett i portalen.
registrere kontaktinformasjon til pårørende
sende inn reiseregninger elektronisk
se lønnsslippene dine

Vi ber om at du benytter reiseregningsmodulen i portalen for innsending av reiseregninger i henhold til beskrivelsen under.

Reiseregninger vil kunne føres på det fartøyet reisen ble gjennomført mot. Godkjenningsrutinen vil være først av kaptein, og deretter av koordinator på kontoret. Utbetaling vil skje via lønnskjøringen i rederiet og gå til samme konto som hyreutbetalingene.

For spørsmål i denne sammenheng, vennligst henvend deg til din Mannskapskoordinator.

Brukernavnet som dere benytter for å logge inn i reiseregningsportalen vil være samme e-postadresse som dere mottar lønnslippene deres på. Følg oppskriften under for å komme i gang.

Kom igang:

Gå til http://portal_link
Klikk på "First Time Login"
Fyll inn informasjonen under og klikk så "OK"
- Email: [#Email]
- PIN: [#PIN]
- BirthDate: [#BIRTHDATE]
Du vil så motta en lenke på epost for å opprette passord. Følg instruksjonene i e-posten. NB! Passord må inneholde minst 8 tegn, store- og små bokstaver, samt et spesialtegn (f.eks. ! eller %) for at systemet skal godkjenne det.
Når du har laget et passord, kan du gå til http://portal_link for å logge inn i portalen.

Adonis HR Reports, Views and Similar

Welcome to Employee Portal (on date)

Description

SQL Statement

Field Specification

Task Settings

Sample e-mail

Related content