KRSC_RSC_POOL_PERIOD_SUM

This table stores the resource pool sum by monthly period, resource pool, and role ID

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

PPM_FISCAL_PERIODS_NLS

FISCAL_PERIOD_ID

PERIOD_ID

RSC_RESOURCE_POOLS

RESOURCE_POOL_ID

RESOURCE_POOL_ID

RSC_ROLES_NLS

ROLE_ID

ROLE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

RSC_POOL_PERIOD_SUM_ID

NOT NULL

NUMBER

Unique ID for the 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

PERIOD_ID

NOT NULL

NUMBER

Monthly period ID

TOTAL_FTE

NOT NULL

NUMBER

Total FTE of this resource pool

ROLLUP_FTE

NOT NULL

NUMBER

Total FTE from the children

ROLE_ID

NOT NULL

NUMBER

Role this sum is associated with

RESOURCE_POOL_ID

NOT NULL

NUMBER

Resource pool this sum is associated with
TOTAL_HOUR NOT NULL NUMBER Total hours of this resource pool
ROLLUP_HOUR NOT NULL NUMBER Total hours from the children

Indexes

Index Name

Index Type

Sequence

Column Name

KRSC_RSC_POOL_PERIOD_SUM_U1

UNIQUE

1

RSC_POOL_PERIOD_SUM_ID

KRSC_RSC_POOL_PERIOD_SUM_U2

UNIQUE

1

RESOURCE_POOL_ID

KRSC_RSC_POOL_PERIOD_SUM_U2

UNIQUE

2

ROLE_ID

KRSC_RSC_POOL_PERIOD_SUM_U2

UNIQUE

3

FISCAL_PERIOD_ID

Sequences

Sequence Name

Sequence Type

KRSC_RSC_POOL_PERIOD_SUM_S

RSC_POOL_PERIOD_SUM_ID