KNTA_ENTITY_RESTRICTIONS

This table stores restricted entities for: a) Workflows on Packages based on Security Group, b) Object Types on Workflows in Packages, c) App Codes on Package Lines in Packages, d) Security Groups on Report Types.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_ENTITIES_NLS

ENTITY_ID

CHILD_ENTITY_ID

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_ENTITIES_NLS

ENTITY_ID

PARENT_ENTITY_ID

Column Descriptions

Column Name

Null?

Data Type

Description

ENTITY_RESTRICTION_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

RESTRICTION_TYPE

NOT NULL

VARCHAR2(30)

For example, indicates if we are restricting workflow based on sec group (SG_WF), app_code based on sec group (SG_APP) or object type based on workflow (WF_OBJ)

PARENT_ENTITY_ID

NOT NULL

NUMBER

Entity upon which the restriction is based (for example, SG,WF)

CHILD_ENTITY_ID

NOT NULL

NUMBER

Entity which is restricted based on the parent (for example, for example, WF,OBJ,APP)

PARENT_VALUE

NOT NULL

VARCHAR2(80)

Primary key ID of the parent entity instance

CHILD_VALUE

NOT NULL

VARCHAR2(80)

Primary key ID of the child entity instance

EXCLUDE_FLAG

NOT NULL

VARCHAR2(1)

Indicates whether this is an exclusion or an inclusion (currently all are exclusions)

SOURCE_TYPE_CODE

NULLABLE

VARCHAR2(30)

For records that have been updated by an interface or migrator, indicates the type of external update (specific interface or migrator name, and so on)

SOURCE

NULLABLE

VARCHAR2(100)

For records that have been updated by an interface or migrator, provides additional information about the source of the external update

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_ENTITY_RESTRICTIONS_N1

NONUNIQUE

1

CHILD_VALUE

KNTA_ENTITY_RESTRICTIONS_N1

NONUNIQUE

2

PARENT_VALUE

KNTA_ENTITY_RESTRICTIONS_N1

NONUNIQUE

3

RESTRICTION_TYPE

KNTA_ENTITY_RESTRICTIONS_N2

NONUNIQUE

1

PARENT_VALUE

KNTA_ENTITY_RESTRICTIONS_N2

NONUNIQUE

2

RESTRICTION_TYPE

KNTA_ENTITY_RESTRICTIONS_U1

UNIQUE

1

ENTITY_RESTRICTION_ID

Sequences

Sequence Name

Sequence Type

KNTA_ENTITY_RESTRICTIONS_S

ENTITY_RESTRICTION_ID