TM_TIME_SHEETS

ITG_TRUSTEE

TRUSTEE_ID

BASE_TRUSTEE_ID

KNTA_SECURITY_GROUPS_NLS

SECURITY_GROUP_ID

BILLING_APPROVER_SEC_GRP_ID

ITG_CALENDAR

CALENDAR_ID

CALENDAR_ID

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KTMG_PERIODS

PERIOD_ID

PERIOD_ID

RSC_RESOURCES

RESOURCE_ID

RESOURCE_ID

TIME_SHEET_ID

NOT NULL

NUMBER

System-generated identifier

VERSION

NOT NULL

NUMBER

System-generated version for the entity. This column must not be updated manually

RESOURCE_ID

NOT NULL

NUMBER

Identifies the Resource that this time sheet belongs to.

PERIOD_ID

NULLABLE

NUMBER

Identifies the period for which this time sheet tracks actuals

CALENDAR_ID

NOT NULL

NUMBER

Identifies the unique internal calendar for the time sheet. It is used by the system to keep track of actual information and must not be modified. This calendar does not reference the Resource's calendar.

STATUS_CODE

NULLABLE

NUMBER

Indicates the status of the time sheet

DESCRIPTION

NULLABLE

VARCHAR2(650)

Describes the time sheet. This value defaults to the format "Resource - Period".

SEQ

NULLABLE

NUMBER

Contains the internal order of time sheets for display when a Resource has multiple time sheets for a given period.

EXCEPTION_MESSAGE

NULLABLE

VARCHAR2(650)

Stores the policy exceptions for display in the time sheet, if any exceptions exist.

BASE_TRUSTEE_ID

NULLABLE

NUMBER

Identifies the billing approver of the time sheet if it is configured to be a participant group.

BILLING_APPROVER_SEC_GRP_ID

NULLABLE

NUMBER

Identifies the billing approver of the time sheet if it is configured to be a Security Group.

TIME_ENTRY_DURATION_CODE

NULLABLE

VARCHAR2(255)

Indicates the granularity of effort entered into the time sheet. This is controlled by the time sheet Policy. Valid values are DAY and PERIOD.

TIME_ENTRY_UNIT_CODE

NULLABLE

VARCHAR2(255)

Indicates the unit of measurement for time entry into the time sheet. This is controlled by the time sheet Policy. Valid values are HOURS and PERCENT.

PERIOD_HOURS_CALC_TYPE_CODE

NULLABLE

VARCHAR2(255)

Indicates the setting for calculating the number of hours in a period. This is controlled by the time sheet policy. Valid values are WORKDAY and FIXED.

PERIOD_HOURS

NULLABLE

NUMBER

If PERIOD_HOURS_CALC_TYPE_CODE is set to FIXED, this column indicates the fixed number of hours in a period.

WORKDAY_HOURS

NULLABLE

NUMBER

If PERIOD_HOURS_CALC_TYPE_CODE is set to WORKDAY, this column indicates the number of hours in a working day.

DUPLICATE_ALLOWED_FLAG

NULLABLE

VARCHAR2(1)

Indicates whether multiple time sheets are allowed in a given period.

MIN_MAX_HOURS_CALC_TYPE_CODE

NULLABLE

VARCHAR2(255)

Indicates the setting for calculating the number of hours when checking for minimum and maximum requirements. This is controlled by the time sheet Policy.

TIME_SHEET_REQUIRED_FLAG

NULLABLE

VARCHAR2(1)

Indicates whether a Resource must submit a time sheet for every period.

MAX_HOURS_PER_DAY

NULLABLE

NUMBER

Indicates the maximum number of hours per day a Resource may log time for in the time sheet.

MAX_HOURS_PER_TIME_SHEET

NULLABLE

NUMBER

Indicates the maximum number of hours per time sheet a Resource may log.

MIN_HOURS_PER_TIME_SHEET

NULLABLE

NUMBER

Indicates the minimum number of hours per time sheet a Resource must log.

MAX_PERCENT_PER_TIMESHEET

NULLABLE

NUMBER

Indicates the maximum percentage allowed on the time sheet.

MIN_PERCENT_PER_TIMESHEET

NULLABLE

NUMBER

Indicates the minimum percentage required on the time sheet.

PREVENT_VIOLATION_FLAG

NULLABLE

VARCHAR2(1)

Indicates whether a Resource is prevented from submitting a time sheet if there are policy violations.

REQ_ACTIVITIES_REQUIRED_FLAG

NULLABLE

VARCHAR2(1)

Indicates whether Activities are required to be added to Request items on the time sheet.

TSK_ACTIVITIES_REQUIRED_FLAG

NULLABLE

VARCHAR2(1)

Indicates whether Activities are required to be added to Task items on the time sheet.

PRJ_ACTIVITIES_REQUIRED_FLAG

NOT NULL

VARCHAR2(4)

Indicates whether Activities are required to be added to Project items on the time sheet.

PKG_ACTIVITIES_REQUIRED_FLAG

NULLABLE

VARCHAR2(1)

Indicates whether Activities are required to be added to Package items on the time sheet.

MISC_ACTIVITIES_REQUIRED_FLAG

NULLABLE

VARCHAR2(1)

Indicates whether Activities are required to be added to Miscellaneous items on the time sheet.

WORKITEM_REQ_ENABLED_FLAG

NOT NULL

VARCHAR2(4)

Indicates whether Requests can be added as work item to the time sheet.

WORKITEM_TSK_ENABLED_FLAG

NOT NULL

VARCHAR2(4)

Indicates whether Tasks can be added as work item to the time sheet.

NOT NULL

VARCHAR2(4)

Indicates whether Programs can be added as work item to the time sheet.

WORKITEM_PRJ_ENABLED_FLAG

NOT NULL

VARCHAR2(4)

Indicates whether Projects can be added as work item to the time sheet.

WORKITEM_PKG_ENABLED_FLAG

NOT NULL

VARCHAR2(4)

Indicates whether Packages can be added as work item to the time sheet.

WORKITEM_MSC_ENABLED_FLAG

NOT NULL

VARCHAR2(4)

Indicates whether Miscellaneous can be added as work item to the time sheet.

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date the record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

ALLOW_EMPTY_LINE

NOT NULL

NUMBER

Level how to deal with empty time sheet lines in this time sheet

FKF38627E05BD31FCB_I

NONUNIQUE

1

BASE_TRUSTEE_ID

FKF38627E05F1CC5BE_I

NONUNIQUE

1

CALENDAR_ID

FKF38627E0A1B1A5A3_I

NONUNIQUE

1

RESOURCE_ID

FKF38627E0A7DB71D8_I

NONUNIQUE

1

BILLING_APPROVER_SEC_GRP_ID

SYS_C005201597

UNIQUE

1

TIME_SHEET_ID

TM_TIME_SHEETS_N1

NONUNIQUE

1

PERIOD_ID

TM_TIME_SHEETS_S

TIME_SHEET_ID