Share this page
RSC_SIMPLE_ASK_EFFORTS
This table stores the forecast demand range and effort (in FTE) for positions in the Gantt view of staffing profile.
Foreign Keys
Primary Key Table | Primary Key Column | Foreign Key Column |
|---|---|---|
RSC_POSITIONS | POSITION_ID | POSITION_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
ID |
NOT NULL |
NUMBER(20) |
System-generated identifier |
|
START_DATE |
NOT NULL |
DATE |
Start date of the range |
|
FINISH_DATE |
NOT NULL |
DATE |
Finish date of the range |
|
EFFORT |
NOT NULL |
NUMBER |
Forecast demand value (in FTE) |
|
POSITION_ID |
NULLABLE |
NUMBER |
Identifier for the position |
|
CREATED_BY |
NOT NULL |
NUMBER(19) |
Identifier for the user who created the record |
|
CREATION_DATE |
NOT NULL |
DATE |
Date when the record was created |
| LAST_UPDATED_BY | NOT NULL | NUMBER(19) | Identifier for the user who last updated the record |
| LAST_UPDATE_DATE | NOT NULL | DATE | Date when the record was last updated |
| VERSION | NULLABLE | NUMBER | System-generated version for the entity |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
RSC_SIMPLE_ASK_EFFORTS_N1 |
NONUNIQUE |
1 |
POSITION_ID |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
RSC_SIMPLE_ASK_EFFORTS_S |
ID |
