Share this page
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 |
