PJS_PJF_EVENTS_NEW

This table contains non-persistent events data when dimension changes occur in the source system. It is used during incremental and delete and re-summarize summarization.

Details

• Schema: FUSION

• Object owner: PJS

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
WORKER_ID	NUMBER		18		A WORKER_ID is unique for each instance of summarization and is used to identify the data for that intance.	Active
ATTRIBUTE_CATEGORY	VARCHAR2	30			Descriptive Flexfield: structure definition of the user descriptive flexfield.
EVENT_ID	NUMBER		18		Unique event identifier	Active
EVENT_TYPE	VARCHAR2	30			Internal event attribute	Active
EVENT_OBJECT	VARCHAR2	30			Internal event attribute	Active
PRIORITY	VARCHAR2	10			Internal event attribute	Active
STATUS	VARCHAR2	10			Internal event attribute	Active
ATTRIBUTE1	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE2	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE3	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE4	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE5	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE6	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE7	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE8	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE9	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE10	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE11	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE12	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE13	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE14	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE15	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE16	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE17	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE18	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE19	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE20	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
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
PJS_PJF_EVENTS_NEW_N1	Non Unique	Default	WORKER_ID, EVENT_OBJECT
PJS_PJF_EVENTS_NEW_U1	Unique	Default	EVENT_ID