FTE Table in Oracle Fusion HCM

Oracle Fusion HCM has no specific “FTE table” as a standard feature. However, FTE (Full-Time Equivalent) data is typically stored and managed in Oracle Fusion HCM using a combination of tables and attributes within the application’s database schema.

The FTE data is often associated with employee records and is used for various purposes, such as payroll calculations, benefits administration, and workforce planning. The specific tables and attributes used to store FTE-related information may vary depending on the version of Oracle Fusion HCM and the configured modules.

Here are some of the critical tables and attributes that are commonly used to manage FTE-related data in Oracle Fusion HCM:

1. PER_ALL_PEOPLE_F: This is one of the primary tables that store employee information, including employee type (full-time, part-time, etc.), hire date, termination date, and other key attributes.
2. PER_TIME_PERIODS: This table contains information about time periods, such as the start and end dates of a pay period or reporting period. FTE calculations might be performed over specific time periods.
3. PAY_ELEMENT_ENTRIES_F: This table stores payroll element entries, including details about earnings and deductions, which may be used in FTE calculations.
4. PAY_ELEMENT_LINKS_F: This table holds information about the links between payroll elements and various employee attributes, which could be used to determine FTE eligibility.
5. PAY_INPUT_VALUES_F: This table stores input values that are used in payroll calculations, including any data relevant to FTE calculations.
6. ABS_ABSENCE_ATTENDANCES: This table holds data related to employee absences and attendance, which might be utilized in absence-related FTE calculations.

It’s important to note that the specific data model and tables used in Oracle Fusion HCM might change with updates and releases. Therefore, the actual tables and attributes may be subject to change, and new features related to FTE management might have been introduced in later versions of the application.

If you are working with Oracle Fusion HCM and need to perform FTE-related operations or reporting, refer to the official Oracle Fusion HCM documentation or consult with your organization’s technical experts to identify the appropriate tables and attributes for FTE-related data in your specific implementation.