Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, 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 and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Thread Rating:
  • 35 Vote(s) - 2.83 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Queries for HRMS Hirecount,Termination Count,Head Count
02-21-2013, 04:39 AM,
#1
Queries for HRMS Hirecount,Termination Count,Head Count
Can anyone please provide queries for hirecount ,Termination Count,head Count in HRMS.
Thanks in advance.
Reply
02-22-2013, 09:43 AM,
#2
RE: Queries for HRMS Hirecount,Termination Count,Head Count
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
09-12-2013, 08:06 PM,
#3
RE: Queries for HRMS Hirecount,Termination Count,Head Count
Good Post........Keep it Up Good Work.



Regards,

Surendra
Reply


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



Users browsing this thread: 1 Guest(s)