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