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.