Oracle Fusion HCM Position Table


Oracle Fusion HCM Position Table

In Oracle Fusion HCM, the data related to positions is stored in the PER_JOBS table. This table stores information about job positions within an organization, including details about the positions themselves and their associated attributes. The PER_JOBS table is a fundamental component of managing positions and job-related information in Oracle Fusion HCM.

Here are some key columns and information typically found in the PER_JOBS table:

  • JOB_ID: A unique identifier for the job position.
  • NAME: The name or title of the job position.
  • EFFECTIVE_START_DATE and EFFECTIVE_END_DATE: The date range during which the position information is valid.
  • BUSINESS_GROUP_ID: Identifies the business group to which the position belongs.
  • DEPARTMENT_ID: The ID of the department to which the position is associated.
  • POSITION_CODE: An optional code used to uniquely identify the position.
  • POSITION_TYPE: Indicates the type of position, such as full-time, part-time, contractor, etc.
  • MANAGER_ID: Identifies the manager assigned to the position.
  • SALARY_AMOUNT: The salary amount associated with the position.
  • CURRENCY_CODE: The currency used for salary calculations.
  • FTE_QUANTITY: Full-Time Equivalent (FTE) quantity for the position, representing the portion of a full-time role it corresponds to.

Please note that the actual structure and columns of the PER_JOBS table might vary based on the version of Oracle Fusion HCM you’re using. It’s important to refer to the official Oracle documentation or data dictionary for the most accurate and up-to-date information.

When querying the PER_JOBS table or any other tables in Oracle Fusion HCM, ensure you have a solid understanding of the database schema, apply appropriate filtering conditions to limit the data retrieved, and have the necessary permissions to access the data.



Oracle Fusion HCM Training Demo Day 1 Video:

You can find more information about Oracle Fusion HCM Cloud application in this Oracle HCM Cloud Docs Link



Unogeeks is the No.1 Training Institute for Fusion HCM Training. Anyone Disagree? Please drop in a comment

You can check out our Oracle Fusion HCM Training details here Oracle Fusion HCM Training

You can check out our other latest blogs on Oracle Fusion HCM Training in this Oracle Fusion HCM Blogs

💬 Follow & Connect with us:


For Training inquiries:

Call/Whatsapp: +91 73960 33555

Mail us at:

Our Website ➜

Follow us:





Leave a Reply

Your email address will not be published. Required fields are marked *