KPFM_SCEN_COMPARISON_ACCESS

This table stores users who have access to a particular scenario comparison. Any users specified here must also have at least PFM edit or view access grants. By having a row here automatically give them view permission

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KPFM_SCENARIO_COMPARISONS

SCEN_COMPARISON_ID

SCEN_COMPARISON_ID

KNTA_USERS

USER_ID

USER_ID

Column Descriptions

Column Name

Null?

Data Type

Description

SCEN_COMPARISON_ACCESS_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

SCEN_COMPARISON_ID

NOT NULL

NUMBER

Scenario comparison ID

USER_ID

NOT NULL

NUMBER

User ID

EDIT_BASIC_INFO_FLAG

NOT NULL

VARCHAR2(1)

Indicates whether the user can edit basic info for the scenario comparison

EDIT_CONTENT_FLAG

NOT NULL

VARCHAR2(1)

Indicates whether the user can edit PFM entity content for the scenario comparison.

EDIT_SECURITY_FLAG

NOT NULL

VARCHAR2(1)

Indicates whether the user can edit security info for the scenario comparison

DELETE_SCEN_COMP_FLAG

NOT NULL

VARCHAR2(1)

Indicates whether the user can delete the scenario comparison

Indexes

Index Name

Index Type

Sequence

Column Name

KPFM_SCEN_COMPARISON_ACCESS_N1

NONUNIQUE

1

SCEN_COMPARISON_ID

KPFM_SCEN_COMPARISON_ACCESS_N2

NONUNIQUE

1

USER_ID

KPFM_SCEN_COMPARISON_ACCESS_U1

UNIQUE

1

SCEN_COMPARISON_ACCESS_ID

Sequences

Sequence Name

Sequence Type

KPFM_SCEN_COMPARISON_ACCESS_S

SCEN_COMPARISON_ACCESS_ID