PJS_PJF_EVENTS_GT

This global temporary table contains non-persistent events data when dimension changes occur in the source system. It is used during online summarization.

Details

• Schema: FUSION

• Object owner: PJS

• Object type: TABLE

Columns

Name

WORKER_IDNUMBER18A WORKER_ID is unique for each instance of summarization and is used to identify the data for that intance. EVENT_IDNUMBER18Unique event identifier EVENT_TYPEVARCHAR230Internal event attribute EVENT_OBJECTVARCHAR230Internal event attribute PRIORITYVARCHAR210Internal event attribute STATUSVARCHAR210Internal event attribute ATTRIBUTE1VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE2VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE3VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE4VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE5VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE6VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE7VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE8VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE9VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE10VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE11VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE12VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE13VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE14VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE15VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE16VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE17VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE18VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE19VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE20VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield.

Indexes

Index	Uniqueness	Columns
PJS_PJF_EVENTS_GT_N1	Non Unique	WORKER_ID, EVENT_OBJECT