Generate Letter / Notification

This page is used to define select queries that are used by the Generate Letter/Notification batch process to generate letters/email notifications based on employee information. Letter/notification distribution method is also be defined on this page.

Field InformationField Information

The Generate Letter / Notification reference page contains the following fields:

Field Name

Field Description

Letter Type

This field identifies the type of letter generated. This field can be up to ten characters in length. Special characters and spaces should not be used when defining a Letter Type.

Letter Type Description

This field is used to describe what the Letter Type is used for. This field can be up to sixty characters in length.

Letter Distribution Method

This field determines how the letter will be distributed to the employees. Valid options are Both, Employee E-mail, and  Mail.

 Email Subject

This field is used to populate text in the subject line of the email.

Email Message

This field is used to populate text in the body of the email.

Select

This field is used to include the system values a site wishes to have populated in the letter/notification generated. All selected statements must include INTERNAL_EMPLOYEE_ID as part of the query.

If the Letter Distribution Method is Mail or Both, the following Mailing Address columns from the ADDRESS table must be included in the Select text: STR_1_NM_2, CITY_NM_2, ZIP_2, and CTRY_CD_2.

If the Letter Distribution Method is Employee E-mail or Both, the EMAIL_AD_TXT column from the R_SC_USER_DIR_INFO table must be included in the Select text.

From

This field defines the From clause for the query.

Where

This field is to define the Where clause for the query.

Group by

This field is to define the Group By clause for the query.

Order by

This field is to define the Order By clause for the query.