Example to Create a User-Defined Table for Matched Row Values
User-defined tables store a date effective list of values that you can use in a formula. Set up your own structured tables to hold data such as wage codes or shift differentials.
In this example, you create a user-defined table to store values forworkers' schedules. To create a new table, use the User-Defined Tables task in the My Clients Group tab.
Scenario
Your organization works on a 10 hour a day, four day a week rotating schedule. The employees work for four consecutive days, 10 hours a day.
User-Defined Table Components
These are the main components of the user-defined table.
-
Basic details
-
Columns
-
Rows
-
Values
As this figure shows, the user-defined table contains the schedules available in your organization.
Resulting User-Defined Table Components
This table shows the resulting user-defined table components for this scenario.
Component |
In This Example |
---|---|
Basic Details |
The Unit of measure is a text since the row values are Days of the Week. The row title is Days of the Week. |
Rows |
Contain the name of a day of the week. |
Columns |
These are the schedules, such as Monday - Thursday. The data type for each column is number because they hold a number of hours. |
Values |
Represent the number of hours to work each day in each schedule. |