Overview
You can set up your own structured tables to maintain a date effective lists of values or data, such as wage codes. A user-defined table consists of rows and columns and stores the values as cells for a specific row and column combination.
For example, you can define a table that shows the bonus amounts in the columns, for the years of services in the rows.
Using HCM Data Loader, you can either create a user-defined table to store a range of values or match a specific value. You can use this table with a formula to store tabular data.
Rows, Columns, and Values
To start with, you define the column and row details. Let's understand what user-defined rows and columns are.
-
A table row is a definition that stores row details. For example, a row that stores the years of service details for bonus payments. Define rows to accept either an exact value, such as a grade value, or a range of values, such as a range of salary values.
-
A table column stores the column details, such as a column could capture bonus amounts. You can also use a fast formula to validate entries in the user-defined table. For example, you can validate if your bonus entries fall within a specified range.
Then, you load the values for a date-effective combination of a user-defined row and column.