Enabling and Disabling Period Types

Up to four period types can be enabled. Enabling period types makes them available to Time Management. For information about selecting an enabled period type to use in a time sheet policy, see Time Sheet Policies.

Enabling or disabling period types requires knowledge of SQL and DBA privileges. See your application administrator regarding selecting and enabling period types. The supported period types are listed in Table 2-1. Period types and supported duration_code values. Supported values for the associated duration_code are case-sensitive.

Table 2-1. Period types and supported duration_code values

Period Type

Supported duration_code Values

Weekly

WEEKLY

Bi-Weekly

BI_WEEKLY

Semi-Monthly

SEMI_MONTHLY

Monthly

MONTHLY

By default, only the Semi-Monthly period type is enabled.

To enable or disable a period type:

  1. Connect to the database schema containing the PPM installation (using SQL*Plus or your choice of SQL editor).

  2. Run the following query to check the supported options:

    SQL> SELECT * FROM KTMG_PERIOD_TYPES

    This query should return the four period types.

  3. To enable a period type, set the enabled flag to Y for the period types.

    For example:

    SQL> UPDATE ktmg_period_types
    SQL> SET enabled_flag = 'Y'
    SQL> WHERE duration_code = '<Supported Value>'

    where <Supported Value> is one of the supported values listed in Table 2-1. Period types and supported duration_code values.

    Each period type can be enabled or disabled. For example, to enable Weekly and Monthly period types and disable Bi-Weekly and Semi-Monthly period types, use the following:

    SQL> UPDATE ktmg_period_types
    SQL> SET enabled_flag = 'Y'
    SQL> WHERE duration_code = 'WEEKLY'

    SQL> UPDATE ktmg_period_types
    SQL> SET enabled_flag = 'N'
    SQL> WHERE duration_code = 'BI_WEEKLY'

    SQL> UPDATE ktmg_period_types
    SQL> SET enabled_flag = 'N'
    SQL> WHERE duration_code = 'SEMI_MONTHLY'

    SQL> UPDATE ktmg_period_types
    SQL> SET enabled_flag = 'Y'
    SQL> WHERE duration_code = 'MONTHLY'

  4. For the Weekly and Bi-Weekly period types, you can change the day of the week that starts the time period, as specified by start_day_code. By default, the start day is Monday, but you can use SQL to change it to any day of the week. For example, to set start_day_code to Sunday for the Weekly period type, use the following:

    SQL> UPDATE ktmg_period_type
    SQL> SET start_day_code = 'SUNDAY'
    SQL> WHERE duration_code = 'WEEKLY'

    The possible values for start_day_code are as follows:

    • Sunday
    • Monday
    • Tuesday
    • Wednesday
    • Thursday
    • Friday
    • Saturday