RSC_POSITION_FORECAST

This table stores daily forecast effort values for the position.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

LAST_UPDATED_BY

RSC_POSITIONS

POSITION_ID

POSITION_ID

RSC_STAFF_PROF_MANAGERS

STAFFING_PROFILE_ID

STAFFING_PROFILE_ID

RSC_STAFFING_PROFILES

STAFFING_PROFILE_ID

STAFFING_PROFILE_ID

KNTA_USERS

USER_ID

CREATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

POSITION_FORECAST_ID

NOT NULL

NUMBER

System-generated identifier

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

VERSION

NOT NULL

NUMBER

Hibernate OCA

STAFFING_PROFILE_ID

NOT NULL

NUMBER

Indicates the position this forecast demand belongs to. It is a foreign key to the RSC_STAFFING_PROFILES table.

POSITION_ID

NULLABLE

NUMBER

Indicates the staffing profile this forecast demand belongs to. It is a foreign key to the RSC_POSITIONS table

FORECAST_DATE

NOT NULL

DATE

Date for estimated forecast.

FORECAST_VALUE

NOT NULL

NUMBER

Estimated effort in hours for forecast date. Forecast hours per day. Forecast value of 0 is not stored.

UNMET_DEMAND

NULLABLE

NUMBER

Unmet demand hours per day

Indexes

Index Name

Index Type

Sequence

Column Name

RSC_POSITION_FORECAST_N1

NONUNIQUE

1

POSITION_ID

RSC_POSITION_FORECAST_N2

NONUNIQUE

1

STAFFING_PROFILE_ID

SYS_C005201575

UNIQUE

1

POSITION_FORECAST_ID

RSC_POSITION_FORECAST_N7 NONUNIQUE 1 POSITION_ID
RSC_POSITION_FORECAST_N7 NONUNIQUE 2 UNMET_DEMAND
RSC_POSITION_FORECAST_N7 NONUNIQUE 3 FORECAST_DATE

Sequences

Sequence Name

Sequence Type

RSC_POSITION_FORECAST_S

POSITION_FORECAST_ID