PER Employee Missing Details

Description
Categories: BI Publisher, Human Resources
Application: Human Resources
Source: Employee Missing Details Report (XML)
Short Name: PERFREMD_XML
DB package: PER_PERFREMD_XMLP_PKG
            select full_name||decode(:P_SESSION_DATE,NULL,'    (' || to_char(per.effective_start_date, 'DD-MON-YYYY')||')',NULL) FULL_NAME,
                       decode(per.region_of_birth,null,'X',null) region_of_birth,
                       decode(per.country_of_birth,null,'X',null) country_of_birth,
                       decode(per.date_of_birth,null,'X',null) DOB,
                       decode(asg.establishment_id,null,'X',null) estab,
                       decode(asg.contract_id,null,'X',null) Contract,
                       decode(scl.segment2,null,'X',null) Emp_cat
            from per_all_people_f per
                    ,per_person_types pt
                    ,per_assignments_f asg
                    ,hr_soft_coding_keyflex scl
            where per.business_group_id = :p_business_group_id
                and nvl(:P_SESSION_DATE,per.effective_start_date) between per.effective_start_date
                      and per.effective_end_date
                and asg.person_id = per.person_id
                and per.effective_start_date between asg.effective_start_date
                        and asg.effective_end_date
                and scl.soft_coding_keyflex_id(+) = asg.soft_coding_keyflex_id
                and per.person_type_id = pt.person_type_id
                and pt.business_group_id = :p_business_group_id
                and pt.system_person_type = 'EMP'
                and (per.region_of_birth is NULL
                        or per.country_of_birth is NULL
                        or per.date_of_birth is NULL
                        or per.sex is NULL
                        or asg.establishment_id is NULL
                        or asg.contract_id is NULL
                        or scl.segment2 is NULL)
               order by per.order_name, per.effective_start_date
Parameter NameSQL textValidation
Business Group ID
 
Number
Effective Date (Blank for All)
 
Date