1. Tables and Views
  2. PSC_OPA_ENTITY_B

PSC_OPA_ENTITY_B

This table contains Oracle Policy Automation entity information.

Details

  • Schema: FUSION

  • Object owner: PSC_TS

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

PSC_OPA_ENTITY_B_PK

ENTITY_MODEL_NAME, ENTITY_NAME

Columns

Name Datatype Length Precision Not-null Comments Status
ENTITY_MODEL_NAME VARCHAR2 30 Yes This column is used to indicate entity model name Active
ENTITY_NAME VARCHAR2 40 Yes This column is used to indicate entity name Active
VIEW_OBJECT_ID NUMBER 18 Yes This column is used to indicate view object id Active
IS_TOP_LEVEL VARCHAR2 1 This column is used to indicate is top level Active
OPA_HIDDEN VARCHAR2 1 This column is used to indicate opa hidden Active
SUPPORTS_DYNAMIC_LOAD VARCHAR2 1 This column is used to indicate supports dynamic load Active
DYN_LOAD_ADF_VO_ID NUMBER This column is used to indicate dyn load adf vo id Active
CAN_BE_INPUT VARCHAR2 1 This column is used to indicate can be input Active
CAN_BE_OUTPUT VARCHAR2 1 This column is used to indicate can be output Active
SUPPORTS_ATTACHMENT VARCHAR2 1 This column is used to indicate supports attachment Active
PARENT_EO_NAME VARCHAR2 40 This column is used to indicate parent eo name Active
BELONGS_TO_TECHSTACK VARCHAR2 1 This column is used to indicate belongs to techstack Active
CARDINALITY_WITH_PARENT VARCHAR2 5 C_11 : One to one C_1M : One to many C_M1 : Many to one C_MN : Many to many Active
NOTIFICATION_ID VARCHAR2 15 This column is used to indicate notification id Active
OWNER_ID VARCHAR2 10 This column is used to indicate owner id Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
SEED_DATA_LOCK NUMBER 1 Yes Indicates whether the row is seed data. Valid values are 0 for data that is customer data, 1 for seed data that cannot be modified, and 2 indicates that the seed data can be modified.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
DELETED_FLAG VARCHAR2 1 Yes Indicates whether the record is logically deleted (Y or N). Valid values are Y for deleted record, and N for active record. Default value is N.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table Foreign Table Foreign Key Column
PSC_OPA_ENTITY_B psc_opa_view_object_meta VIEW_OBJECT_ID
PSC_OPA_ENTITY_B psc_opa_entity_model_b ENTITY_MODEL_NAME
psc_opa_entity_tl psc_opa_entity_b ENTITY_MODEL_NAME, ENTITY_NAME
psc_opa_entity_attr_b psc_opa_entity_b ENTITY_MODEL_NAME, ENTITY_NAME

Indexes

Index Uniqueness Tablespace Columns Status
PSC_OPA_ENTITY_B_FK1 Non Unique Default VIEW_OBJECT_ID Active
PSC_OPA_ENTITY_B_PK Unique Default ENTITY_MODEL_NAME, ENTITY_NAME, ORA_SEED_SET1 Active
PSC_OPA_ENTITY_B_PK1 Unique Default ENTITY_MODEL_NAME, ENTITY_NAME, ORA_SEED_SET2