Configure the Employee Data Columns

Data columns show the calculated number of hours an employee is scheduled for the week. As of 2025.12, you can add custom schedule data columns using extension scripts and java callouts.

See the Infor Workforce Management User and Administration Library and select Developer > Custom Scripting > Custom scripting framework.

Schedule data columns maintenance form

You can access the maintenance form in the Admin Portal under Forms > Schedule Data Columns and configure how the data columns are displayed in Manage Schedule. This form includes several key attributes shown in this table:

Field name Description
Schedule Data Name Required field, up to 40 characters. Specify the name of the schedule data.
Column Title

Optional field, up to 100 characters.

Define the column header title. If the name exceeds the character limit, an ellipsis and a tooltip with the full name is displayed.

Users can also define the naming pattern. For example, W@{count} which defines how the columns are displayed in a series are titled such as, weekly or monthly.
Sum Of Other Data

The check box determines whether the calculation is based on the employee's scheduled hours or already calculated schedule data columns.

If set to True, selecting the Period, Calculate Full Period is not available. If cleared, selecting Calculate Sum From Data is not available.

This check box is cleared by default.

If set to True, a calculation is based on other columns and a user needs to specify based on which schedule data columns using the field Calculate Sum From Data. If set to False, then a calculation is based on employee scheduled hours based on the Period selected.

If set to true and theExtension Script or Java Callout fields are populated, a message is displayed. This message indicates that the script cannot be specified for data columns that aggregate values from other data columns. You must remove the script or set the Sum Of Other Data to False.
Calculate Sum From Data

Single select database lookup that shows all the existing Schedule Data Columns entries where Sum Of Other Data = False. This field defines the columns for which the total value is calculated.

For example, if you select the other schedule data column calculated on a weekly basis (with Period = Weekly), then the Schedule Data Column that is created aggregates (sum) the value from all the columns created from this weekly configuration
Period

Defines the time period the calculation is performed. It is a database lookup with the values weekly and monthly.

  • Weekly - Calculate per week and display the number of columns = number of weeks selected
  • Monthly - Calculate per month and display the number of columns = number of months selected
Calculate Full Period

This check box is cleared by default.

If selected, the weekly or monthly calculations are done for the whole period, regardless of the period you selected. For example, if you select only 3 days, you can still see the calculation for the whole week.

If cleared, the period calculations are done only for the selected days.
Display Order

Required field. Specify a numeric value.

This field defines the order of the columns. If two columns have the same number, they are displayed according to the ID order.
Data Format

Required field. Uses DURATION_FORMAT to define the format such as DECIMAL and HOURS & MINUTES.

The default value is DECIMAL.

The DECIMAL option shows hours in a decimal value up to two decimal places. For example, 12.85. The HOURS & MINUTES option shows the value in 00h00m format. For example, 12h:43m.
Column Width
Required field. Select one of these values to define the width of the column:
  • Small: 44px
  • Medium: 80px
  • Large: 120px
Extension Script

Specify an extension script for the custom schedule data column. This script is a database lookup for extension scripts with the value schedule-data-columns-period-logic.

When you specify a value in this field, the Java Callout field must remain empty. If both fields are filled, a message is displayed indicating that you cannot specify both Extension Script and Java Callout.

You must also clear the Sum Of Other Data check box when you specify an extension script.

This field is optional and hidden by default. You can show this field by configuring the security settings in Config mode.
Java Callout

Specify a java class.

When you specify a value in this field, the Extension Script field must remain empty. You must also clear the Sum Of Other Data check box when you specify a java class.

This field is optional and hidden by default. You can show this field by configuring the security settings in Config mode.

Schedule Data Columns Groups

If you click Edit next to an entry, the form to edit the attributes is opened to show the sub-form Schedule Data Columns Groups. The form contains the attributes listed in this table:

Field name Description
Security Group Required field. This database lookup enables you to search and specify all the security groups.
Permissions Required field. Select VIEW or DENY.

Additional configuration highlights

This list shows the configuration logic behind the hours calculation:

  • Only Activities with Is working Activity = Y are calculated.
  • Activities configured with Time Code that Is BRK = Y are excluded.
  • Hours are allocated to the correct week based on the system’s DAY_WEEK_STARTS registry or user locale settings if configured.
  • Non-MVS shifts are excluded from the calculation.
  • Core calculation logic does not include Details Day (Prev/Next), splitting hours overnight, Day Start Time.
  • After upgrading, existing customers should run the full recalculation task to see the total hours calculation for existing shifts.
  • Every time the configuration is changed, Is Working Activity or Is BRK or Day Week Start configuration, the full recalculation task should be run to recalculate the total hours for existing shifts.