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. |