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.

User-defined table structure for matched row values. Rows represent the days of week and columns represent the scheduled work days.

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.