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