Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick, Simple and Absolutely Free.

Thread Rating:
  • 23 Vote(s) - 2.65 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Queries for HRMS Hirecount,Termination Count,Head Count
#1
Can anyone please provide queries for hirecount ,Termination Count,head Count in HRMS.
Thanks in advance.
Reply
Thanks given by:
#2
1. Employee joined between two dates
select
b.full_name,
b.applicant_number,
a.current_employer,
d.name job,
e.date_start Actual_DOJ,
b.business_group_id
from
per_applications a,
per_all_people_f b,
per_all_assignments_f c,
per_jobs d,
per_periods_of_service e
where 1=1
and a.person_id(+) = b.person_id
and b.person_id = c.person_id
and trunc(sysdate) between b.effective_start_date and b.effective_end_date
and trunc(sysdate) between c.effective_start_date and c.effective_end_date
and C.JOB_ID = D.JOB_ID(+)
and E.PERSON_ID = B.PERSON_ID
and e.date_start between to_date('01-JAN-2013','DD-MON-YYYY') and to_date('31-JAN-2013','DD-MON-YYYY')

2. Employees left between two dates

select
b.full_name,
b.applicant_number,
a.current_employer,
d.name job,
e.date_start Actual_DOJ,
b.business_group_id
from
per_applications a,
per_all_people_f b,
per_all_assignments_f c,
per_jobs d,
per_periods_of_service e
where 1=1
and a.person_id(+) = b.person_id
and b.person_id = c.person_id
and trunc(sysdate) between b.effective_start_date and b.effective_end_date
and trunc(sysdate) between c.effective_start_date and c.effective_end_date
and C.JOB_ID = D.JOB_ID(+)
and E.PERSON_ID = B.PERSON_ID
and e.date_start between to_date('01-JAN-2013','DD-MON-YYYY') and to_date('31-JAN-2013','DD-MON-YYYY')
Reply
Thanks given by:
#3
Good Post........Keep it Up Good Work.



Regards,

Surendra
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
  BR 100 document for HRMS uniquenaga 4 2,348 05-04-2016, 02:13 PM
Last Post: braganza.jude@yahoo.in
  Oracle HRMS Techno Functional Training fanni339 0 1,422 07-05-2015, 04:35 PM
Last Post: fanni339
  Measure your HRMS Skill Set in Free fanni339 0 824 06-29-2015, 06:16 AM
Last Post: fanni339
  Practice Solutions for Oracle HRMS Beginners fanni339 0 1,001 05-17-2015, 02:32 PM
Last Post: fanni339
  HRMS - Leave Accrual Plan Rubab Ali 2 5,003 03-18-2014, 03:38 PM
Last Post: fanni339
  Termination of employee Sara Khan 1 1,708 12-28-2013, 10:54 PM
Last Post: Kashif Manzoor



Users browsing this thread: 1 Guest(s)
OTech Talks, Lets Talk OPEN! Get Oracle Tutorials, Tips! Post a Question!