ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9B79D2E0530100007F1FF2 PER Business Group Y select pbg.name value, hla.location_code description from per_business_groups pbg, hr_locations_all hla where pbg.location_id=hla.location_id(+) order by pbg.name US 8E2FF36EDEEE79D2E0530100007F1FF2 PER Person Full Name Y select ppx.full_name value, xxen_util.meaning(ppx.sex,'SEX',3)||' '||pptv.user_person_type description from per_people_x ppx, per_person_types_v pptv where ppx.person_type_id=pptv.person_type_id order by ppx.full_name US 05E9017B295DCCDF98A4502151213589 select haouv.name business_group, papf.employee_number, papf.full_name, haouv2.name organization, pjv.name job, hapft.name position, hla.location_code location, paat.name absence_type, xxen_util.meaning(paat.absence_category,'ABSENCE_CATEGORY',3) absence_category, paa.date_start absence_start_date, paa.date_end absence_end_date, paa.time_start, paa.time_end, paa.absence_days, paa.absence_hours, paar.name absence_reason, paa.date_notification notification_date, paa.date_projected_start projected_start_date, paa.date_projected_end projected_end_date, papf2.full_name authorizing_person, papf3.full_name replacement_person, xxen_util.meaning(paa.approval_status,'ABSENCE_APPROVAL_STATUS',3) approval_status, paa.occurrence, xxen_util.user_name(paa.created_by) created_by, xxen_util.client_time(paa.creation_date) creation_date, xxen_util.user_name(paa.last_updated_by) last_updated_by, xxen_util.client_time(paa.last_update_date) last_update_date from hr_all_organization_units_vl haouv, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, per_absence_attendances paa, per_absence_attendance_types paat, per_abs_attendance_reasons paar, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf2, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf3, (select paaf.* from per_all_assignments_f paaf where sysdate between paaf.effective_start_date and paaf.effective_end_date) paaf, hr_all_organization_units_vl haouv2, per_jobs_vl pjv, hr_all_positions_f_tl hapft, hr_locations_all hla where 1=1 and paa.person_id=papf.person_id and papf.business_group_id=haouv.organization_id and paa.absence_attendance_type_id=paat.absence_attendance_type_id and paa.abs_attendance_reason_id=paar.abs_attendance_reason_id(+) and paa.authorising_person_id=papf2.person_id(+) and paa.replacement_person_id=papf3.person_id(+) and paa.person_id=paaf.person_id(+) and paaf.primary_flag(+)='Y' and paaf.assignment_type(+)='E' and paaf.organization_id=haouv2.organization_id(+) and paaf.job_id=pjv.job_id(+) and paaf.position_id=hapft.position_id(+) and hapft.language(+)=userenv('lang') and paaf.location_id=hla.location_id(+) order by haouv.name, papf.full_name, paa.date_start desc Y US PER Employee Absences Employee absence and attendance records showing absence type, category, dates, duration in days and hours, reason, authorizing person, replacement person, and approval status. Useful for leave management, absence tracking, and compliance reporting. Enginatics 1=1 1 10 1=1 haouv.name=:business_group LOV PER Business Group 8E2FF36EDE9B79D2E0530100007F1FF2 Y select pbg.name value, hla.location_code description from per_business_groups pbg, hr_locations_all hla where pbg.location_id=hla.location_id(+) order by pbg.name US Business Group 2 20 1=1 papf.full_name=:full_name LOV PER Person Full Name 8E2FF36EDEEE79D2E0530100007F1FF2 Y select ppx.full_name value, xxen_util.meaning(ppx.sex,'SEX',3)||' '||pptv.user_person_type description from per_people_x ppx, per_person_types_v pptv where ppx.person_type_id=pptv.person_type_id order by ppx.full_name US Person Full Name 3 30 1=1 paat.name=:absence_type LOV custom Y select paat.name value, xxen_util.meaning(paat.absence_category,'ABSENCE_CATEGORY',3) description from per_absence_attendance_types paat where nvl(paat.date_end,sysdate+1)>sysdate order by paat.name US Absence Type 4 40 1=1 paa.date_start>=:absence_date_from Date add_months(trunc(sysdate,'MM'),-3) US Absence Date From 5 50 1=1 paa.date_start<:absence_date_to+1 Date last_day(:$flex$.absence_date_from) US Absence Date To 6 60 1=1 haouv2.name=:organization LOV custom Y select haouv.name value, hla.location_code description from hr_all_organization_units_vl haouv, hr_locations_all hla where haouv.location_id=hla.location_id(+) order by haouv.name US Organization :$flex$.absence_date_from Absence Date From Y Absence Date To