KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KTMG_PERIOD_TYPES_NLS

PERIOD_TYPE_ID

PERIOD_TYPE_ID

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.

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

KTMG_POLICIES_U1

UNIQUE

1

POLICY_ID

KTMG_POLICIES_U2

UNIQUE

1

POLICY_NAME

KTMG_POLICIES_S

POLICY_ID