Share this page

# KTMG_POLICIES

This table stores information about time sheet policies that can be associated with time sheet users.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KTMG_PERIOD_TYPES_NLS | PERIOD_TYPE_ID | PERIOD_TYPE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
POLICY_ID | NOT NULL | NUMBER | System-generated identifier
CREATION_DATE | NOT NULL | DATE | Date record was created
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
ENTITY_LAST_UPDATE_DATE | NOT NULL | DATE | Date a record in the entity was last updated
POLICY_NAME | NOT NULL | VARCHAR2(80) | User defined name for the policy
DESCRIPTION | NULLABLE | VARCHAR2(240) | Description of the policy
PERIOD_TYPE_ID | NOT NULL | NUMBER | Foreign key to KTMG_PERIOD_TYPES table that determines the duration of the period
TIME_ENTRY_DURATION_CODE | NOT NULL | VARCHAR2(30) | Whether the user will be logging time by the day or some other defined period
TIME_ENTRY_UNIT_CODE | NOT NULL | VARCHAR2(30) | If entering time by a Period, whether entering the time in hours or as a percent of the hours in the period.
PERIOD_HOURS_CALC_TYPE_CODE | NULLABLE | VARCHAR2(30) | Lookup code for 'TMG - Time Period Calculation Types'. Determines how the number of hours in a period are calculated.
PERIOD_HOURS | NULLABLE | NUMBER | Number of hours in the Period if the PERIOD_HOURS_CALC_TYPE_CODE is fixed.
WORKDAY_HOURS | NULLABLE | NUMBER | Number of hours in a day if the PERIOD_HOURS_CALC_TYPE_CODE is the number of days times the hours in each day.
OVERRIDE_WORK_ALLOC_CC_FLAG | NOT NULL | VARCHAR2(1) | Either 'Y' or 'N'. Determines whether any existing charge codes for the Work Allocation will be overridden by the resource charge code.
DUPLICATE_ALLOWED_FLAG | NOT NULL | VARCHAR2(1) | Flag to specify duplicate time sheets (multiple time sheets for the same period) is allowed or not.
TIMESHEET_REQUIRED_FLAG | NOT NULL | VARCHAR2(1) | Flag to specify if the resource is required to fill in a time sheet
MAX_HOURS_PER_DAY | NULLABLE | NUMBER | Specifies allowed maximum total hours per day
MAX_HOURS_PER_TIMESHEET | NULLABLE | NUMBER | Specifies allowed maximum total hours per time sheet
MIN_HOURS_PER_TIMESHEET | NULLABLE | NUMBER | Specifies allowed minimum total hours per time sheet
MIN_MAX_HOURS_CALC_TYPE_CODE | NULLABLE | VARCHAR2(30) | Lookup code for 'TMG - Time Period Calculation Types'. Determines how the number of hours in a period are calculated.
PREVENT_VIOLATION_FLAG | NOT NULL | VARCHAR2(1) | Flag to determine whether the time sheet can be released when there is a violation on the policy
GLOBAL_POLICY_FLAG | NOT NULL | VARCHAR2(1) | Specifies if the policy is the default policy for all resources without a policy
AUTO_APPROVAL_FLAG | NOT NULL | VARCHAR2(1) | Indicates whether the user's time is automatically approved
MAX_PERCENT_PER_TIMESHEET | NULLABLE | NUMBER | If entering in percent, what is the maximum percentage allowed.
MIN_PERCENT_PER_TIMESHEET | NULLABLE | NUMBER | If entering in percent, what is the minimum percentage allowed.
PGM_ACTIVITIES_REQUIRED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether the user is required to enter activities on their time sheet for programs (Y/N)
REQ_ACTIVITIES_REQUIRED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether the user is required to enter activities on their time sheet for requests (Y/N)
TSK_ACTIVITIES_REQUIRED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether the user is required to enter activities on their time sheet for tasks (Y/N)
PKG_ACTIVITIES_REQUIRED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether the user is required to enter activities on their time sheet for packages (Y/N)
MISC_ACTIVITIES_REQUIRED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether the user is required to enter activities on their time sheet for misc items (Y/N)
ACTIVITIES_DISPLAY_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether the user is allowed to specify activities on their time sheet for work items (Y/N)
EXP_HRS_DISPLAY_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether the time sheet is showing the expected hours (Y/N)
WORKITEM_REQ_ENABLED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether the user is allowed to have requests as work items on their time sheet (Y/N)
WORKITEM_PGM_ENABLED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether the user is allowed to have programs as work items on their time sheet (Y/N)
WORKITEM_PRJ_ENABLED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether the user is allowed to have projects as work items on their time sheet (Y/N)
WORKITEM_TSK_ENABLED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether the user is allowed to have tasks as work items on their time sheet (Y/N)
WORKITEM_PKG_ENABLED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether the user is allowed to have packages as work items on their time sheet (Y/N)
WORKITEM_MSC_ENABLED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether the user is allowed to have misc as work items on their time sheet (Y/N)
PRJ_ACTIVITIES_REQUIRED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether the user is required to enter activities on their time sheet for project items (Y/N)
ALLOW_EMPTY_LINE_FLAG | NULLABLE | NUMBER | Level how to deal with the empty time sheet line in a time sheet
ITG_ACTIVITIES_REQUIRED_FLAG | NOT NULL | VARCHAR2(1) | (Added in 9.22) Flag to show whether the activity is required on Item type External Data of the time sheet policy
WORKITEM_ITG_ENABLED_FLAG | NOT NULL | VARCHAR2(1) | (Added in 9.22) Flag to show whether External Data is enabled as an work item of the time sheet policy

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KTMG_POLICIES_U1 | UNIQUE | 1 | POLICY_ID
KTMG_POLICIES_U2 | UNIQUE | 1 | POLICY_NAME

## Sequences

Sequence Name | Sequence Type
--- | ---
KTMG_POLICIES_S | POLICY_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: