Creating additional hour columns

You can create additional hour columns to be displayed in the LFSO Schedule screen.

  1. Select Scheduling > Schedule Optimization > Setup > Scheduling Columns Definition.
  2. Click Create New Entry.
  3. Specify this information:
    Column Name
    Specify the default label for the column.
    Column Description
    Optionally, specify a description of the column.
    Date Selection
    Select WEEKLY, MONTHLY, QUARTERLY, or ANNUALLY to specify the time period unit that is used to calculate the hours displayed in the column.
    Period Root Date
    Optionally, select a date to use as the start date for the first time period. If this option is not specified, the default start date is used. This is how the start date is determined for each time period option:
    • WEEKLY: Select the start day of the week. If this option is not specified, the start day is determined by the DAY_WEEK_STARTS registry parameter.
    • MONTHLY: Select the start day of the month. If this option is not specified, the first of the month is used.
    • QUARTERLY: Select the start day of the quarter. If this option is not specified, the quarterly start dates are January 1, April 1, July 1, and October 1.
    • ANNUALLY: Select the start day of the year. If this option is not specified, the annual start date is January 1.
    No. Of Units in Period
    Specify the number of time units, based on the option selected in the Date Selection field, that are included in the time period for the column. For example, you can configure a column to display the hours for bi-weekly periods by specifying 2 in this field and specifying WEEKLY in the Date Selection field.
    Display Order
    Specify a number to define the position of the column, from left to right.
    Include Unpublished in Totals
    Select this check box to combine hours from published and unpublished schedules in the column totals. When this check box is not selected, the published hours and unpublished hours are displayed separately. The values are separated by a slash, with the published hours being displayed first.
    Exclude Time Code
    Select this check box to include hours from all time codes in the system except the specified time codes. When this check box is not selected, only the specified time codes are included.
    Exclude Hour Type
    Select this check box to include hours from all hour types in the system except the specified hour types. When this check box is not selected, only the specified hour types are included.
    Exclude Premium
    Select this check box to exclude premium hours. For example, this excludes hours added by pay rule adjustments in the column totals. When this check box is not selected, premium hours are included.
    Active
    Select this check box to enable the column in the Daily tab. When this check box is not selected, the column is not displayed in the Daily tab.
    Weekly Active
    Select this check box to enable the column in the Weekly tab. When this check box is not selected, the column is not displayed in the Weekly tab.
    Monthly Active
    Select this check box to enable the column in the Monthly tab. When this check box is not selected, the column is not displayed in the Monthly tab.
  4. Click Save.
  5. In the Scheduling Column - Time Codes section, click New Row to add a time code to the column. Then, select the time code from the look up field and click Save.
  6. In the Scheduling Column - Hour Types section, click New Row to add a hour type to the column. Then, select the hour type from the look up field and click Save.
  7. Add additional time codes or hour types to the column as required.
The additional hours column is saved and is displayed to users in the LFSO Schedule screen.