1. Tables and Views
  2. PSC_COM_CC_EVENTS_B

PSC_COM_CC_EVENTS_B

Contains communication event definition data.

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

PSC_COM_CC_EVENTS_B_PK

EVENT_ID

Columns

Name Datatype Length Precision Not-null Comments Status
EVENT_ID NUMBER 18 Yes System generated primary key column. Active
EVENT_TYPE VARCHAR2 30 Yes Determines the Event Type.On-Demand and Scheduled. Active
RUN_EXPRESSION CLOB Specifies the run expression for either a scheduled expression complying to rfc2445. For example: FREQ=YEARLY;INTERVAL=1;BYMONTH=5;BYDAY=2MO; Active
SCHEDULED_REQUEST_ID NUMBER 18 Specifies the ESS Request ID for a schedule. If a schedule recurrence has been defined, this is the Absolute Parent ID request (i.e. the top level ESS request). Active
SCHEDULED_START TIMESTAMP Specifies the ESS start for a schedule. Active
SCHEDULED_END TIMESTAMP Specifies the ESS end for a schedule. Active
ENABLED_FLAG VARCHAR2 1 Yes Indicates whether the Communication Event is enabled or not. Active
FILTER_EXPRESSIONS CLOB This column is used to indicate filter expressions. Active
RESOURCE_ID NUMBER 18 Business object reference for the communication Active
EVENT_RUN_TYPE VARCHAR2 18 Yes This column is used to store event run type. 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
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
AGENCY_ID NUMBER 8 Yes Agency ID from COM_AGENCY. Included as it is mandatory for all tables. 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
EVENT_CODE VARCHAR2 32 Yes Specifies an event code which can be used to identify an event Active
SEED_DATA_LOCK NUMBER 1 Yes Indicates wheher the row is a seed data. Valid values are 0 for data that is for customer data, 1 for data that can not be modified , and 2 indicates that the seed data can be modified.
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.
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.
EM_ENABLED VARCHAR2 1 Yes Flag to show if this Event is enabled for Event Management.
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_COM_CC_EVENTS_B psc_com_cc_resources_b RESOURCE_ID
psc_com_cc_logs psc_com_cc_events_b EVENT_ID
psc_com_cc_brf_logs psc_com_cc_events_b EVENT_ID
psc_com_cc_rules psc_com_cc_events_b EVENT_ID
psc_com_cc_events_tl psc_com_cc_events_b EVENT_ID
psc_com_cc_templates_b psc_com_cc_events_b EVENT_ID

Indexes

Index Uniqueness Tablespace Columns Status
PSC_COM_CC_EVENTS_B_FK1 Non Unique FUSION_TS_SEED RESOURCE_ID Active
PSC_COM_CC_EVENTS_B_PK Unique FUSION_TS_SEED EVENT_ID, ORA_SEED_SET1 Active
PSC_COM_CC_EVENTS_B_PK1 Unique FUSION_TS_SEED EVENT_ID, ORA_SEED_SET2
PSC_COM_CC_EVENTS_B_U1 Unique Default EVENT_CODE, ORA_SEED_SET1
PSC_COM_CC_EVENTS_B_U11 Unique Default EVENT_CODE, ORA_SEED_SET2