Question

Access employees Gender

  • 1 September 2021
  • 2 replies
  • 80 views
N
Rank
Userlevel 5
Badge +10

Hi Hereos,

I have a lobby that gives gender count/percentage but not necessarily who the gender belongs to.…

Is there is a way to use access attributes to allow everyone access to gender without access to employees file?

Much appreciate any suggestion

 

This topic has been closed for comments

2 replies

Asela Munasinghe
Rank
Userlevel 7
Badge +19

@NMALKI perhaps you could anonymize some of the sensitive attributes like Employee ID, SSN, etc in the employee file, but can keep Gender visible through a GDPR setup?

Learn more about how IFS supports GDPR from here:
 

 

Let's connect on LinkedIn: https://www.linkedin.com/in/asela61/
william.klotz
Rank
Userlevel 7
Badge +21

Hi @NMALKI ,

 

If you’re developing a lobby component to display a gender count and gender percentages if you’re using IFS Enterprise Explorer I believe you could give users query only access to database view COMPANY_PERSON which would allow you retrieve employee genders and filter by employee status of Active.  

 

A lobby data source setup something like this would provide you with the genders of active employees.

View:   

         &AO.COMPANY_PERSON

 

Condition:

COMPANY_ID LIKE DECODE(instr(‘$COMPANY_ID$’, ‘COMPANY_ID’), 0, NVL(‘$COMPANY_ID$’, ‘%’), ‘%’)

AND GENDER IS NOT NULL

AND EMPLOYEE_STATUS=’ACTIVE’

 

Group By: 

        GENDER

 

Columns:

        GENDER

         ROUND(COUNT(*)*100.0 / SUM(COUNT(*)) over(), 0)

 

SQL QUERY                

SELECT gender,
       ROUND(COUNT(*)*100.0 / SUM(COUNT(*)) over(), 0)
  FROM COMPANY_PERSON
 WHERE company_id = 'Your Company ID'
   AND employee_status = 'ACTIVE'
GROUP BY gender

 

Regards,

William Klotz

Terms & ConditionsCookie settings