Query to find TOWN_OF_BIRTH,REGION_OF_BIRTH,COUNTRY_OF_BIRTH,PERSON_NUMBER,DATE_OF_DEATH,BLOOD_TYPE,DATE_OF_BIRTH OF EMPLOYEE of Employee - Oracle Fusion HCM

Fusion Queries

Employee Details in Fusion HCM



Oracle Fusion HCM : 

TOWN_OF_BIRTH,
REGION_OF_BIRTH,
COUNTRY_OF_BIRTH,
PERSON_NUMBER,
DATE_OF_DEATH,
BLOOD_TYPE,
DATE_OF_BIRTH  


per_persons,town_of_birth,region_of_birth,country_of_birth,person_number,date_of_death,blood_type,date_of_birth ,





SELECT 
papf.person_number,          
pp.blood_type,          
pp.date_of_birth dob,          
pp.date_of_death,          
pp.country_of_birth,          
pp.region_of_birth,          
pp.town_of_birth  
   
FROM 
per_all_people_f papf, 
per_persons pp    


WHERE 
papf.person_id = pp.person_id(+) -- (+)to fetch if some data is not present in system          AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date   AND papf.effective_end_date

 ORDER BY person_number

Comments

Post a Comment

Popular posts from this blog

Query to find Address Details of Employee - Oracle Fusion HCM

Image
Fusion Queries Employee Details in Fusion HCM Query to find Address Details of Employee - Oracle Fusion HCM Oracle Fusion HCM :  PERSON_NUMBER,           ADDRESS_TYPE,           ADDRESS_LINE_1,           ADDRESS_LINE_2,           ADDRESS_LINE_3,           ADDRESS_LINE_4,           BUILDING,           FLOOR_NUMBER,           TOWN_OR_CITY,           REGION_1,           REGION_2,           REGION_3,   COUNTRY,           POSTAL_CODE    SELECT  person_number,           ppauf.address_type,           paf.address_line_1,           paf.address_line_2,           paf.address_line_3,           paf.address_line_4,           paf.building,           paf.floor_number,           paf.town_or_city,           paf.region_1,           paf.region_2,           paf.region_3,   per_extract_utility.get_territory_name(paf.country)COUNTRY,           paf.postal_code      FROM  per_all_people_f papf,           per_person_addr_usages_f ppauf,           per_addresses_f paf     WHERE  papf.person_id = ppauf.perso
Read more

Query to find Email details of an Employee

Image
Fusion Queries Employee Details in Fusion HCM Query to find Email details of an Employee Oracle Fusion HCM :  PERSON_NUMBER,  EMAIL_TYPE,  EMAIL_ADDRESS    SELECT     papf.person_number,   pea.email_type,   pea.email_address         FROM per_all_people_f papf,   per_email_addresses pea        WHERE     papf.person_id = pea.person_id(+) -- (+)to fetch if some data is not present in system        AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date                                    AND papf.effective_end_date   ORDER BY person_number
Read more

Query to find PERSON_NUMBER, PHONE_TYPE, PHONE_NUMBER, AREA_CODE, SEARCH_PHONE_NUMBER, COUNTRY_CODE_NUMBER OF EMPLOYEE of Employee - Oracle Fusion HCM

Image
Fusion Queries Employee Details in Fusion HCM Oracle Fusion HCM :  PERSON_NUMBER , PHONE_TYPE,           PHONE_NUMBER,           AREA_CODE,           SEARCH_PHONE_NUMBER,           COUNTRY_CODE_NUMBER    SELECT  papf.person_number,          pp.PHONE_TYPE,           pp.PHONE_NUMBER,           pp.AREA_CODE,           pp.SEARCH_PHONE_NUMBER,           pp.COUNTRY_CODE_NUMBER      FROM  per_all_people_f papf,  per_phones pp     WHERE  papf.person_id = pp.person_id(+) --  to fetch if some data is not present in system           AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date   AND papf.effective_end_date  ORDER BY person_number
Read more