Configure the Employee Data Columns

Data columns show the calculated number of hours an employee is scheduled for the week. As of release 2024.10, users cannot add new configurations.

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.
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

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.