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 |