FFS_EVENT_SUBSCRIPTION

Contains Event/History API subscriptions.

Details

• Schema: FUSION

• Object owner: FFS

• Object type: TABLE

• Tablespace: DATA

Primary Key

Name	Columns
FFS_EVENT_SUBSCRIPTION_PK	SUBSCRIPTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SEQUENCE_ID	NUMBER		10	Yes	Event subscription sequence unique identifier.
SUBSCRIPTION_ID	VARCHAR2	240		Yes	Unique identifier for a subscription. It is generated during subscription creation and depends on all attributes of the subscription. A subscription that is identical to an existing one will not be created, but the identifier of the existing one is returned.
SUBSCRIPTION_TYPE	VARCHAR2	9			Indicates whether a subscription is created internally for integrated applications or via public API.
SUBSCRIPTION_CONFIG	CLOB				Subscription configuration in json format.
SUBSCRIPTION_FIELDS	CLOB				List of fields that the subscription needs for filtering events and for adding to the events.
SUBSCRIPTION_TITLE	VARCHAR2	1020			Optional human-readable title of the subscription.
PUSH_TO_URL	VARCHAR2	1020			URL of an integrated system to which the events are to be pushed. It is used by an internal service for the integration that do not pull events but rather expect the events to be periodically pushed to them.
APPLICATION_ID	NUMBER		10	Yes	Identifier of a REST Application that was used to create the subscription. Only application that created the subscription may request the events.
USER_ID	NUMBER		18	Yes	Reference to FFS_USER associated with API application used to create the subscription.
CREATED_TIME	TIMESTAMP			Yes	Date and time when the subscription was created. Unix timestamp format.
EXPIRATION_TIME	TIMESTAMP			Yes	Subscription expiration date and time. Unix timestamp format.
LAST_REQUESTED_PAGE	VARCHAR2	128			Last value of the 'page' parameter used by 'get events' that was successfully processed for this subscription.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
FFS_EVENT_SUBSCRIPTION_PK	Unique	DATA	SUBSCRIPTION_ID
FFS_EVENT_SUBSCRIPTION_U1	Unique	DATA	SEQUENCE_ID