EGP_TPI_ACL_GT
Temporary table for TPI Access Control List relationship.
Details
-
Schema: FUSION
-
Object owner: EGP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
EGP_TPI_ACL_GT_PK |
TPI_ACL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TPI_ACL_ID | NUMBER | 18 | Yes | Attribute indicating unique identifier of TPI access control list data. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Attribute representing inventory_item_id of the TPI. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | Attribute representing organization_id of the TPI. | |
| ITEM_CLASS_ID | NUMBER | 18 | Yes | Attribute representing the TPI Class Id. | |
| PERMISSION_SET_ID | NUMBER | 18 | Yes | Attribute indicating unique identifier of Permission Set Id. | |
| ACCESS_LEVEL_CODE | VARCHAR2 | 30 | Yes | Attribute indicating access level allowed on TPI object. | |
| ACCESS_BITMAP | VARCHAR2 | 2000 | Attribute representing the accessible Attribute or Attribute Groups of the TPI. | ||
| USER_GUID | VARCHAR2 | 64 | Attribute indicating global user id of member having access on TPI object. | ||
| CONTEXT_ACL_RULE_COUNT | NUMBER | 18 | Attribute indicating count of context access control list rules. | ||
| ACL_RULES_COUNT | NUMBER | 18 | Attribute indicating count of access control list rules. | ||
| PROD_ACL_ID | NUMBER | 18 | Attribute indicating unique identifier of production access control list. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| EGP_TPI_ACL_GT_U1 | Unique | TPI_ACL_ID |
| EGP_TPI_ACL_GT_U2 | Unique | INVENTORY_ITEM_ID, ORGANIZATION_ID, PERMISSION_SET_ID, ACCESS_LEVEL_CODE, USER_GUID, ITEM_CLASS_ID |