Summary	Commissions Report pending e-signing
Keywords	commission, e-sign
Category	Notification Task

Description

The notification informs the employees that they’ve got a new Commission report ready for e-signing in the Employee Portal and instructs them how to do it.

Main Data Selection

Select all pins that have a new commission report with the status Pending for signing during the previous day by checking on the Date in the dedicated ESIGNEDDATE field and the status - ESIGNSTATUS.

1 Description
2 Main Data Selection
3 Setup and Configuration
- 3.1 Task settings
- 3.2 SQL statement
- 3.3 Field Specification
4 Sample Email

Setup and Configuration

Task settings

Schedule: run daily at 6 am GMT

Recipient: dynamic from database

Field identifying e-mail address: #email

E-mail Subject: New Commission report for e-signing in Employee Portal

SQL statement

select
distinct
p01.pin #pin,
p01.firstname #Firstname,
p01.lastname #Lastname,
--format (p01.birthdate, 'MM/dd/yyyy') #BIRTHDATE,
email.teleno #email
from
pw001p01 p01
join pworg org on org.numorgid=p01.client
left join PW_EFFY_SALES_TRANSACT comm on comm.PIN=p01.PIN 
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
                               )
                )
WHERE NULLIF(email.TELENO, '') IS NOT NULL
and comm.ESIGNSTATUS=1 and CAST (comm.ESIGNEDDATE as date) = CAST( GETDATE()-1 AS Date )

Field Specification

Field	Description

Field	Description
First Name	Personal Details
Last Name	Personal Details
email	Personal Details Telecommunication, email with the highest priority is used
ESIGNSTATUS	default '0', set to '1' when the item is sent for signature by payroll manager in the plugin
ESIGNEDDATE	gets date when the document is sent for signature or signed

Sample Email

Hi [#Firstname] [#Lastname],

You have received a new Commissions Report for verification. Please login to the Employee Portal [link] navigate to the Electronic Signing module, check for pending documents, and place your electronic signature.

If you are doing it for the first time, here is a short guide.

Navigate to the Electronic Signing Module and check for pending documents.
Click on the document and choose "Open to sign" to view it and sign.

Use the "Add Signature" button to add your electronic signature, you will have options to Type, Draw, or upload an image of your signature. Use the "Save Signature" option to save it for the future. So the next time you sign a document, you can skip this step and go directly for the next one - placing your saved signature and signing.
When the signature is added, place it in the dedicated spot on the document by holding down the cursor and dragging it to the extent needed. When done, hit the "Sign" button and you are done.

Thank you.

[Signature of the payroll manager]

Reports, Views and Similar

Commissions: Pending E-signing