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 |