EGI_BATCH_PUB_OPTIONS
Table to store the publication options associated with a Source System or Batch
Details
-
Schema: FUSION
-
Object owner: EGI
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
EGI_BATCH_PUB_OPTIONS_PK |
OPTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OPTION_ID | NUMBER | 18 | Yes | Unique identifier for batch options | |
| PROCESS_IN_SEQUENCE | VARCHAR2 | 1 | Indicates if the publication process can be run in sequence or in parallel. | ||
| ITEM_CATEGORY_ASSIGN_FLAG | VARCHAR2 | 1 | Stores the unique identifier for the Item Category assignment record. | ||
| FUTURE_HORIZON_DAYS | NUMBER | 9 | Indicates the number of days in the future when the revision will become active. | ||
| REVISIONS | VARCHAR2 | 30 | Identifies the revision of an item. | ||
| PUBLISH_CHANGED_ENTITIES_ONLY | VARCHAR2 | 1 | An option that will only publish entities that have changed from the last publication. | ||
| UNAPPROVED_ITEMS_FLAG | VARCHAR2 | 1 | Determines whether unapproved items would be included/excluded from publication | ||
| DELETED_ITEMS_FLAG | VARCHAR2 | 1 | Determines whether deleted items would be included/excluded from publication | ||
| DIGITAL_ASSET_FILES_FLAG | VARCHAR2 | 1 | Flag to determine whether digital asset files would be included/excluded from publication | ||
| SYSTEM_ATTRIBUTES_FLAG | VARCHAR2 | 1 | Determines whether system attributes would be included/excluded from publication | ||
| SOURCE_SYSTEM_ID | NUMBER | 18 | Yes | source / spoke system identifier | |
| BATCH_ID | NUMBER | 18 | A unique identifier of a item batch. | ||
| RULE_SET_ID | NUMBER | 18 | stores Identifier for rule setting. | ||
| ESS_SCHEDULE_ID | NUMBER | 18 | Identifier for ESS scheduler jobs | ||
| ITEM_FILTER_MATCH_OPTION | VARCHAR2 | 30 | column to store filters all or any to filter out items. | ||
| PUBLISH_ITEM_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate pulish of items | |
| PUBLISH_IC_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate pulish of item clases | |
| PUBLISH_CATALOG_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate pulish of catalogs | |
| PUBLISH_CRITERIA_DATE | TIMESTAMP | item publication Criteria date for publication | |||
| PUBLICATION_RUN_DATE | TIMESTAMP | item, item class and catalog published date. | |||
| SS_DEFAULT_BATCH_ID | NUMBER | 18 | Default batch identifier for spoke/source system | ||
| TPI_SYSTEM_ATTRIBUTES | VARCHAR2 | 1 | Flag to determine whether system attributes would be included/excluded from Trading Partner Items publication | ||
| TPI_PUBLISH_ATTACHMENTS | VARCHAR2 | 1 | Flag to determine whether attachments would be included/excluded from Trading Partner Items publication | ||
| TPI_DIGITAL_ASSETS | VARCHAR2 | 1 | Flag to determine whether digital assets would be included/excluded from Trading Partner Items publication | ||
| TPI_FILTER_MATCH_OPTION | VARCHAR2 | 30 | Specifies the Match option for the Selection rules to be used during publish of Trading Partner Items | ||
| 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. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Yes | 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. | |
| 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 |
|---|---|---|
| EGI_BATCH_PUB_OPTIONS | egi_import_batches_b | BATCH_ID |
| EGI_BATCH_PUB_OPTIONS | egi_import_batches_b | SS_DEFAULT_BATCH_ID |
| egi_pub_attch_catgs | egi_batch_pub_options | OPTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EGI_BATCH_PUB_OPTIONS_U1 | Unique | Default | OPTION_ID, ORA_SEED_SET1 |
| EGI_BATCH_PUB_OPTIONS_U11 | Unique | Default | OPTION_ID, ORA_SEED_SET2 |