ITG_TRUSTEE

This table stores a list of users who are identified by their relationship with an entity.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

PM_PROJECTS

PROJECT_ID

PROJECT_ID

PM_PROJECT_TYPES

PROJECT_TYPE_ID

PROJECT_TYPE_ID

PM_INDICATOR_POLICIES

PROJECT_TYPE_ID

PROJECT_TYPE_ID

PM_SYNCHED_FIELDS

PROJECT_TYPE_ID

PROJECT_TYPE_ID

PM_PROJECT_TYPE_CUSTOM_FIELDS

PROJECT_TYPE_ID

PROJECT_TYPE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

TRUSTEE_ID

NOT NULL

NUMBER

System-generated identifier. Must match a USER_ID in KNTA_USERS.

ENTITY_TYPE

NOT NULL

VARCHAR2(255)

Type of entity for which the specified user is a Trustee.

VERSION

NOT NULL

NUMBER

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

IS_ENABLED_FLAG

NULLABLE

VARCHAR2(1)

Indicates whether the specified trustee is enabled.

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

TRUSTEE_TYPE_CODE

NULLABLE

NUMBER

Indicates the type of trustee. Allowed values are: 1 STAKEHOLDERS_GROUP 2 PROJECT_MANAGERS_GROUP 3 RESOURCE_PARTICIPANTS_GROUP 4 SUMMARY_TASK_OWNER_PARTICIPANTS_GROUP

PROJECT_ID

NULLABLE

NUMBER

For trustees of projects, indicates the associated project. Must match a PROJECT_ID in PM_PROJECTS.

PROJECT_TYPE_ID

NULLABLE

NUMBER

For trustees specified for project types, indicates the associated project type. Must match a PROJECT_TYPE_ID in PM_PROJECT_TYPES.

Indexes

Index Name

Index Type

Sequence

Column Name

FKB8AEF85588B8FB3A_I

NONUNIQUE

1

PROJECT_TYPE_ID

FKB8AEF85595D2EB1E_I

NONUNIQUE

1

PROJECT_ID

SYS_C005201549

UNIQUE

1

TRUSTEE_ID

Sequences

Sequence Name

Sequence Type

ITG_TRUSTEE_S

TRUSTEE_ID