RSC_RESOURCE_DELEGATIONS

This table stores the delegated users for a resource to create, modify, approve, reject their time sheets.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

CREATED_BY

RSC_RESOURCES

RESOURCE_ID

RESOURCE_ID

KNTA_USERS

USER_ID

DELEGATED_TO_USER_ID

Column Descriptions

Column Name

Null?

Data Type

Description

RESOURCE_DELEGATION_ID

NOT NULL

NUMBER

System-generated identifier

VERSION

NOT NULL

NUMBER

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

DELEGATED_TO_USER_ID

NULLABLE

NUMBER

Indicates the user to whom the right are given to create, edit and submit time sheets, approve or reject time, and freeze or close time sheets for the given resource.

START_DATE

NULLABLE

DATE

Indicates the date the delegation starts for this delegated user.

END_DATE

NULLABLE

DATE

Indicates the date the delegation starts for this delegated user.

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date 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

RESOURCE_ID

NULLABLE

NUMBER

Indicates the resource to whom the delegated user is assigned.

Indexes

Index Name

Index Type

Sequence

Column Name

FK417133772F1F4DF6_I

NONUNIQUE

1

DELEGATED_TO_USER_ID

FK41713377A1B1A5A3_I

NONUNIQUE

1

RESOURCE_ID

SYS_C005201578

UNIQUE

1

RESOURCE_DELEGATION_ID

Sequences

Sequence Name

Sequence Type

RSC_RESOURCE_DELEGATIONS_S

RESOURCE_DELEGATION_ID