Latest Posts »
Latest Comments »
Popular Posts »
If you are new here, you may want to subscribe to the following feeds Business Intelligence ,InfoCaptor

Oracle HRMS (human resource management) HR key Tables (2)

Written by Nilesh Jethwa

 PER_ALL_VACANCIES holds definitions of vacancies within a specific requisition. A vacancy may include components identifying an organization, job, group, grade, position and location. These are used as the defaults for any applicant assignment to that vacancy. NOTE :This table is also part of i-Recruitment module

PER_APPLICATIONS holds the identifying information about applications for employment. Applications are equivalent to the period of service for an employee. An applicant may have only one open application at any time, but within each application they can apply for any number of different assignments. Information for each assignment
applied for, including the current status in that assignment, is held in PER_ALL_ASSIGNMENTS_F. When an applicant is terminated, or is hired as an employee DATE_END is set by the system.

PER_JOBS holds jobs that have been defined for a Business Group. The NAME is a concatenation of key flexfield segments, held in PER_JOB_DEFINITIONS. Jobs define the role that an employee can perform in the business group, and they are independent of specific organizations.


Posted in ERP Tables |

One Comment to “Oracle HRMS (human resource management) HR key Tables (2)”

  1. Jesús Leyte Says:

    Hi,

    I have a big problem, I can’t find de IRC when it’s create (Pending), I only see that when it’s approved on the table PER_ALL_VACANCIES, is there another table?

    Thanks a lot!!!!

Leave a Comment

Other Articles of interest
Free Dashboards and KPI examples
  • Can you count the number of products Oracle has? (2)
  • WIP Key tables wip_entities , wip_discrete_jobs, wip_transactions (1)
  • Application BI Tackles Tedious Task
  • Multi Org Structure
  • Oracle Cost Management Overview
  • Oracle HRMS key Tables (1)
  • Overview of Oracle Capacity Planning
  • Recent Jobs

    View All Jobs
    Post a Job