Access employees Gender

@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:
 

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