Wiki: UEMAIL

EMAIL EMPLOYEES#

Processing Information#

The Email Employees (UEMAIL) screen allows you to send mass emails to groups of employees based on information on their Assignment records.

A log of all emails sent is currently logged in the the P2K_RE_RECRUITING_LOGS table showing the email address and text that was sent.

Report Parameters & Filters#

Report Parameters
Priority Tag	Optional, LOV available, <Normal Priority> You may select the level of logging desired: ‘Not Specified’, ‘Highest Priority’, ‘High Priority’, ‘Normal Priority’, ‘Low Priority’ or ‘Lowest Priority’.
Email Subject	Mandatory, Text This field will hold the subject title of the email
Email Body	Mandatory, Text The contents of the email will be held in this field
Exception Level	Mandatory, LOV available, <Exceptions Only> You may select the level of logging desired: ‘Exceptions Only’, ‘User Trace’, ‘Legislation’, ‘UserCalc Trace’, ‘Program Trace’ or Utility Trace
User Comment	Optional, Text This field holds the user-supplied comment which will appear in the header of all pages of the report.

Report Filters
People List	Optional, Multiple selection available, LOV available This will limit the report to the people lists selected
Person	Optional, Multiple selection available, LOV available This field will limit the report to the people selected
Entity	Optional, Multiple selection available, LOV available This will limit the report to the entity listed.
Location	Optional, Multiple selection available, LOV available This will limit the report to the locations selected.
Authorization	Optional, Multiple selection available, LOV available This will limit the report to the authorization levels selected.
Department	Optional, Multiple selection available, LOV available This will limit the report to the departments selected.
Org Level Type	Optional, Lexicon Available This will limit the report to the organization level type selected. Note: Org Level Type MUST be specified IF you are using the Sort Option of Org Level OR if you want to filter by Org Levels.
Org Level	Optional, Multiple Selection Available, LOV Available This will limit the report to the organization levels selected..
Unit	Optional, Multiple selection available, LOV available This will limit the report to the units selected.
Group	Optional, Multiple selection available, LOV available This will limit the report to the groups selected.
Payroll	Optional, Multiple Selection Available, LOV Available This will limit the report to the payrolls selected.
Job	Optional, Multiple selection available, LOV available This will limit the report to the jobs selected.
Position	Optional, Multiple selection available, LOV available This will limit the report to the positions selected.
Employment Status	Optional, Multiple selection available, LOV available This will limit the report to the employee status levels selected.
Employment Type	Optional, Multiple selection available, LOV available This will limit the report to the employment types selected.
Assignment Type	Optional, Multiple selection available, LOV available This will limit the report to the assignment types selected.
Pay Type	Optional, Multiple Selection Available, LOV Available This will limit the report to the pay types selected.

Tables column information can be referenced from#

There are a number of tables that you can pull information from linked to each candidate using the <<TABLE_ALIAS.COLUMN_NAME>> notation as in the samples below. These tables are:

EAS	P2K_HR_ASSIGNMENTS
EASD	P2K_HR_ASSIGNMENT_DETAILS
DAA	P2K_CM_AUTHORIZATION_AREAS
DCR	P2K_CM_CHANGE_REASONS
DDP	P2K_CM_DEPARTMENTS
DES	P2K_CM_EMPLOYMENT_STATUSES
DGR	P2K_CM_GROUPS
DJB	P2K_CM_JOBS
DLN	P2K_CM_LOCATIONS
DPS	P2K_CM_POSITIONS
DTX	P2K_CM_TAX_JURISDICTIONS
DUN	P2K_CM_UNITS
DWC	P2K_CM_WORK_CALENDARS
DWR	P2K_CM_WORK_RULES
SSR	P2K_SA_SALARY_RANGES
SWSS	P2K_SA_WAGE_SCALE_STEPS
RJP	P2K_RE_JOB_PROFILES
EID_SUP	P2K_HR_IDENTITIES_SUP (supervisor's identity)
EEM	P2K_HR_EMPLOYMENTS
EID	P2K_HR_IDENTITIES

Sample Usage#

UEMAIL - Location Change

Email Subject:#

The High Line Recruiting Web Site is available once again.

Email Body:#

Dear <<eid.first_name>> <<eid.last_name>> (<<eid.person_code>>)

We are pleased to announce that we will be consolidating our warehouse and storage  facilities from where you work now at <<DLN.ADDRESS_LINE_1>> to 1234 Main Street in Springfield.  

This work will commence within the next three months and you will be advised by your manager, <<eid_sup.first_name>> <<eid_sup.last_name>>, of when your department will start planning its move.

Regards,
John Doe
Head of Facilities

Results:#

Dear John Smith - Candidate Code: X2026,

Thank you for you patience, our Recruiting Web site is now available again for you to update your candidate records and application as well as take the assigned on-line assessment questionnaire.

Please note that there are over 140 applicants for this position so the information entered will be vital in the initial screening process.

Mary Jones.
HR Representative.

Notes #

Click to create a new notes page