Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: