RSC_RP_DISTRIBUTION_ENTRIES

This table stores the resource's percentage of participation in this resource pool. This is also an association table between RSC_RESOURCES table and RSC_RESOURCE_POOLS table.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

RSC_RESOURCES

RESOURCE_ID

RESOURCE_ID

RSC_RESOURCE_POOLS

RESOURCE_POOL_ID

RESOURCE_POOL_ID

Column Descriptions

Column Name

Null?

Data Type

Description

RP_DISTRIBUTION_ENTRY_ID

NOT NULL

NUMBER

System-generated identifier

VERSION

NOT NULL

NUMBER

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

START_TIME

NULLABLE

DATE

Indicates the start date of the resource in the associated resource pool.

FINISH_TIME

NULLABLE

DATE

Indicates the end date of the resource in this resource pool

DISTRIBUTION_PERCENT

NULLABLE

FLOAT

The percentage participation of the resource in this resource pool

RESOURCE_POOL_ID

NULLABLE

NUMBER

Foreign key to RSC_RESOURCE_POOLS table

RESOURCE_ID

NULLABLE

NUMBER

Foreign key to RSC_RESOURCES table

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_DIST_SEQ

NULLABLE

NUMBER

The seq used to know the order as the distributions were created. Useful to show the data in order of creation on UI.

Indexes

Index Name

Index Type

Sequence

Column Name

FK63EC4E39A1B1A5A3_I

NONUNIQUE

1

RESOURCE_ID

FK63EC4E39A85CA660_I

NONUNIQUE

1

RESOURCE_POOL_ID

SYS_C005201584

UNIQUE

1

RP_DISTRIBUTION_ENTRY_ID

Sequences

Sequence Name

Sequence Type

RSC_RP_DISTRIBUTION_ENTRIES_S

RP_DISTRIBUTION_ENTRY_ID