KNTA_USER_PAGE_TABS

This table stores information that defines what user or role a tab and a page belongs.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_PAGES_NLS

PAGE_ID

PAGE_ID

KNTA_USERS

USER_ID

PARENT_ID

KDSH_MODULES

MODULE_ID

PARENT_ID

Column Descriptions

Column Name

Null?

Data Type

Description

USER_PAGE_TAB_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

PARENT_TYPE_CODE

NOT NULL

VARCHAR2(40)

Parent type can be ROLE_ID or USER_ID. Role ID is currently used for internal purpose only.

PARENT_ID

NOT NULL

NUMBER

If the type is USER_ID then the user's actual ID If the type is ROLE_ID then the role ID

PAGE_ID

NOT NULL

NUMBER

This is the page on the dashboard. Currently only two are supported, home and project detail.

TAB_SEQ

NOT NULL

NUMBER

Sequence of the tab on the home page

TAB_NAME

NOT NULL

VARCHAR2(80)

Name of the tab

DESCRIPTION

NULLABLE

VARCHAR2(240)

Tab description. Currently unused.

MODULE_ID

NULLABLE

NUMBER

If the module was published, this column points back to the module from which this page was generated.

DASHBOARD_UPDATE_FLAG

NOT NULL

VARCHAR2(1)

Indicates whether the user's dashboard is updated by module distribution

ENTITY_LAST_UPDATE_DATE

NOT NULL

DATE

Date a record in the entity was last updated

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_USER_PAGE_TABS_N1

NONUNIQUE

1

PARENT_ID

KNTA_USER_PAGE_TABS_N1

NONUNIQUE

2

PARENT_TYPE_CODE

KNTA_USER_PAGE_TABS_N1

NONUNIQUE

3

PAGE_ID

KNTA_USER_PAGE_TABS_N2

NONUNIQUE

1

MODULE_ID

KNTA_USER_PAGE_TABS_U1

UNIQUE

1

USER_PAGE_TAB_ID

Sequences

Sequence Name

Sequence Type

KNTA_USER_PAGE_TABS_S

USER_PAGE_TAB_ID