PER Employee Details

Description
Categories: Enginatics
Repository: Github Columns: Primary Flag, Employee Number, Title, First Name, Last Name, Birth Date, Age, Gender, User Person Type, National Identifier ...
select distinct
pad.primary_flag,
papf.employee_number,
papf.title,
papf.first_name,
papf.last_name,
to_char(papf.date_of_birth,'DD-MON-RRRR') birth_Date,
trunc(months_between(sysdate, papf.date_of_birth)/12) Age,
hrlsex.meaning gender,
ppt.user_person_type,
papf.national_identifier,
hrlnat.meaning Nationality,
hrlms.meaning Marital_status,
papf.email_address,
to_char(papf.effective_start_date