Employee Matching Template/SQL

Usage

Use this tab to define selection criteria based on user defined SQL query.

The header part of the tab consists of three check boxes for option switching.

• Used - option turns on the employee selection based on the SQL query selected when checked,
• Inversion - option turns on the inverted employee selection based on the SQL query selected when checked,
• Union - option used for controlling the interaction between the SQL query-based selection and any selection based on other defined categories.

The table part of the tab presents a SQL query chosen as selection criteria (data presentation when the Show All option is checked) or a SQL query with the element usage check box selected (data presentation when the Show All option is unchecked).

Activity Diagrams

Template Definition

Activities

Define Employee Matching Template Header
Parameterize Template Selection Conditions