ESS Profile Assignment Report

Report that displays employee profile assignments for the Employee Self Service (ESS) module, providing a listing of each employee and their assigned ESS profile

Parameters

This report does not require any parameters. It automatically includes all employees with ESS profile assignments.

Data Components

The report consists of one simple query joining employee information with their profile assignments.

Output Format

The report outputs a table with employee information and their assigned ESS profile.

Column	Description
Fullname	Employee's full name (last name, first name)
IDNUM	Employee's ID number
DESCR	Description of the assigned ESS profile

Technical Implementation

The script uses:

Simple INNER JOIN between EMPLOYEES and EMPASSIGNS tables
Concatenation to format the employee's full name

Prerequisites

Before running this report, the following setup is required:

Set the HDB ESSProfileLookup boolean to True in the system node
Add and run the "Freshen Profile Assignments" process
See the 1092 release notes for more information on the task and HDB

T-SQL

ess_profile_assignment.sql

/*
EMPASSIGNS - employee profile assignment. NEEDS 
Set this boolean HDB ESSProfileLookup (True) - system node
Add the Freshen Profile Assignments process and run it, then verify: 1092 release notes has information on the task and HDB 
*/

Select 
	e.Lastname+', '+e.firstname,
	e.IDNUM,
	ess.DESCR

From EMPLOYEES e
Inner Join EMPASSIGNS ess
on e.FILEKEY = ess.filekey

Content Inventory

Doc File: content/docs/reports/employee_information/ess_profile_assignment.mdx
SQL Script: SQL/reports/employee_information/ess_profile_assignment.sql