KPFM_SCEN_COMP_CAPACITIES

This table stores capacity information on budget and staffing for scenario comparisons.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KPFM_SCENARIO_COMPARISONS

SCEN_COMPARISON_ID

SCEN_COMPARISON_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

CREATED_BY

KNTA_ENTITIES_NLS

ENTITY_ID

ENTITY_ID

Column Descriptions

Column Name

Null?

Data Type

Description

SCEN_COMP_CAPACITY_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

ENTITY_LAST_UPDATE_DATE

NOT NULL

DATE

Date a record in the entity was last updated

SCEN_COMPARISON_ID

NOT NULL

NUMBER

Scenario comparison ID

ENTITY_ID

NULLABLE

NUMBER

Entity of capacity. This is either budget or resource pool entity ID.

ENTITY_PRIMARY_KEY

NULLABLE

NUMBER

Primary key of capacity. This is either BUDGET_D or RSC_POOL_ID.

Indexes

Index Name

Index Type

Sequence

Column Name

KPFM_SCEN_COMP_CAPACITIES_N1

NONUNIQUE

1

SCEN_COMPARISON_ID

KPFM_SCEN_COMP_CAPACITIES_N2

NONUNIQUE

1

ENTITY_ID

KPFM_SCEN_COMP_CAPACITIES_N2

NONUNIQUE

2

ENTITY_PRIMARY_KEY

KPFM_SCEN_COMP_CAPACITIES_U1

UNIQUE

1

SCEN_COMP_CAPACITY_ID

Sequences

Sequence Name

Sequence Type

KPFM_SCEN_COMP_CAPACITIES_S

SCEN_COMP_CAPACITY_ID