RSC_SP_PERIOD_COST

This table stores monthly forecast cost of staffing profile positions.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

DataType

Description

ID

NOT NULL

NUMBER

System-generated identifier

PERIOD_ID

NOT NULL

NUMBER

Identifier for the period

STAFFING_PROFILE_ID

NOT NULL

NUMBER

Identifier of the staffing profile

POSITION_ID

NOT NULL

NUMBER

Identifier of the position

ASSIGNMENT_ID

NULLABLE

NUMBER

Identifier of the staffing profile assignment.

CAPEX_BSE

NOT NULL

NUMBER

Total for the capitalized planned values in system base currency for the monthly period referenced by this row.

CAPEX_LCL

NOT NULL

NUMBER

Total for the capitalized planned values in system local currency for the monthly period referenced by this row.

OPEX_BSE

NOT NULL

NUMBER

Total for the operational planned values in system base currency for the monthly period referenced by this row.

OPEX_LCL

NOT NULL

NUMBER

Total for the operational planned values in system base currency for the monthly period referenced by this row.

Indexes

Index Name

Index Type

Sequence

Column Name

RSC_SP_PERIOD_COST_PK

UNIQUE

1

ID

RSC_SP_PERIOD_COST_U1

UNIQUE

1

POSITION_ID

RSC_SP_PERIOD_COST_U1

UNIQUE

2

ASSIGNMENT_ID

RSC_SP_PERIOD_COST_U1

UNIQUE

3

PERIOD_ID

RSC_SP_PERIOD_COST_N1

NONUNIQUE

1

ASSIGNMENT_ID

RSC_SP_PERIOD_COST_N1

NONUNIQUE

2

PERIOD_ID

Sequences

Sequence Name

Sequence Type

RSC_SP_PERIOD_COST_S

ID