[Home] [Help] [Dependency Information]
Object Name: | ZPB_SECURITY_RULE_DEFINITION_T |
---|---|
Object Type: | TABLE |
Owner: | ZPB |
Subobject Name: | |
Status: | VALID |
This table stores user-defined security rule definitions that will be read by the security maintenance batch procedure.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ZPB_SECURITY_RULE_DEF_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RULE_NAME
RULE_TYPE SEQUENCE USER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_NAME | VARCHAR2 | (80) | Yes | Rule name |
RULE_TYPE | VARCHAR2 | (32) | Yes | Rule type |
SEQUENCE | NUMBER | Yes | Rule step sequence number | |
SELECTION_TYPE | VARCHAR2 | (32) | Rule step selection type | |
ACTION | VARCHAR2 | (32) | Rule step selection action | |
OPERATOR | VARCHAR2 | (16) | Rule step operator | |
BUSINESS_AREA | NUMBER | Business area identifier | ||
USER_ID | NUMBER | Yes | User identifier | |
DIMENSION_ID | NUMBER | Dimension identifier | ||
HIERARCHY_ID | NUMBER | Hierarchy identifier | ||
LEVEL_ID | NUMBER | Level identifier | ||
ATTRIBUTE_ID | NUMBER | Attribute identifier | ||
MEMBER_ID | VARCHAR2 | (64) | Member identifier | |
ADMIN_USER_NAME | VARCHAR2 | (100) | Admin user | |
LAST_APPLY_DATE | DATE | Last application date | ||
STATUS | VARCHAR2 | (16) | Rule step status | |
ERROR | VARCHAR2 | (256) | Rule step error message | |
SELECTION_NAME | VARCHAR2 | (80) | Rule step selection name | |
INCLUDE_VALUE | NUMBER | (1) | Include value flag for metadata rule steps | |
ATTR_DIMENSION_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_NAME
, RULE_TYPE
, SEQUENCE
, SELECTION_TYPE
, ACTION
, OPERATOR
, BUSINESS_AREA
, USER_ID
, DIMENSION_ID
, HIERARCHY_ID
, LEVEL_ID
, ATTRIBUTE_ID
, MEMBER_ID
, ADMIN_USER_NAME
, LAST_APPLY_DATE
, STATUS
, ERROR
, SELECTION_NAME
, INCLUDE_VALUE
, ATTR_DIMENSION_ID
FROM ZPB.ZPB_SECURITY_RULE_DEFINITION_T;
ZPB.ZPB_SECURITY_RULE_DEFINITION_T does not reference any database object
ZPB.ZPB_SECURITY_RULE_DEFINITION_T is referenced by following:
|
|
|