PJS_SUM_ROWID_GT

This global temporary table contains non-persistent rowid data during online summarization, and is used during batch processing transaction data access more efficient.

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.Active

LEFT_ROWIDROWIDRowid access used for better efficiencyActive

RIGHT_ROWIDROWIDRowid access used for better efficiencyActive

BATCH_IDNUMBER18Used when summarization work is broken into batches to be processed in parallel.Active

ATTRIBUTE1VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield.Active

ATTRIBUTE2VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield.Active

ATTRIBUTE3VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield.Active

ATTRIBUTE4VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield.Active

ATTRIBUTE5VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield.Active