PPM_WEB_HOOKS

This table stores the configuration for the Web Hooks. Currently, only Request Type web hooks are implemented.

In this topic:

Foreign keys

There are no foreign keys for this table.

Back to top

Column descriptions

Column Name	Null?	Data Type	Description
WEB_HOOK_ID	NOT NULL	NUMBER	System generated unique ID. Created from sequence PPM_WEB_HOOKS_S
ENTITY_TYPE_ID	NULLABLE	NUMBER	ID of the Entity Type for which the Web Hook is created. Currently, this can only be 19 (Request Type Entity ID)
ENTITY_ID	NULLABLE	VARCHAR2(50)	ID of the entity for which this Web Hook is created. Currently, this can only contain the request type ID.
DESCRIPTION	NULLABLE	VARCHAR2(2000)	Description of the web hook.
WEB_HOOK_CONFIG	NULLABLE	CLOB	JSon of the configuration of the Web Hook. Structure of the JSon might vary depending on the ENTITY_TYPE_ID.
CREATED_BY	NULLABLE	NUMBER	User ID of the user who created the Web Hook.
CREATION_DATE	NULLABLE	DATE	Date and time when the Web Hook was created.
ENABLED_FLAG	NULLABLE	VARCHAR2(1)	Whether the Web Hook is enabled (‘Y’) or not (‘N’).

Back to top

Indexes

Index Name	Index Type	Sequence	Column Name
PPM_WEB_HOOKS_IX1	UNIQUE	PPM_WEB_HOOKS_S	WEB_HOOK_ID

Back to top

Sequences

Sequence Name	Sequence Type
PPM_WEB_HOOKS_S	Sequence for Unique ID

Back to top