Forum Stats

  • 3,825,929 Users
  • 2,260,581 Discussions
  • 7,896,738 Comments

Discussions

User Defined Tables In FUSION HCM

Abid Hussain
Abid Hussain Member Posts: 7 Blue Ribbon
edited Aug 24, 2016 7:03AM in HCM Cloud Service

Hello All,

Is there any possibility to have "User Defined Tables" In FUSION HCM?

Please Help

HolgerHSurendar Babu

Answers

  • Basem.Q
    Basem.Q Member Posts: 1
    edited Aug 24, 2016 4:43AM

    User Defined Tables

    User Defined Tables are a feature by which users can create their own table structure to store values. They are used when a table structure is required for values depending on the user’s needs.

    There are four components to a user-defined table: basic details (datatype, unit of measure, etc.), columns (column headings), rows (number of rows in the table), and values (values of the rows).

    There are two types of row values: Matched Row Values, where you define a specific value to be matched for each row and column; and Range of Row Values, where you specify a range of values that the rows and columns take.

    For example, there might be a hike or bonus applicable for employees depending on their years of service. User defined tables can be used to assign a value for the hike or bonus applicable to a certain range of values for years of service. For instance, a hike of 20% could be applied to the years of service ranging from 3-5.

    The values can be validated through User Table Validation Formula.

    The task associated with it is Manage User-Defined Tables.

    http://www.apps2fusion.com/oracle-fusion-online-training/fusion-applications/fusion-payroll/1256-oracle-fusion-payroll-f…

    HolgerHSurendar Babu
  • Abid Hussain
    Abid Hussain Member Posts: 7 Blue Ribbon
    edited Aug 24, 2016 7:03AM
This discussion has been closed.