PJS_SUM_SCOPE_CONTRACT

This partitioned table contains non-persistent lists of all contracts in scope for existing summarization runs used during all methods of summarization. Each summarization run has a unique WORKER_ID.

Details

  • Schema: FUSION

  • Object owner: PJS

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Columns

Name Datatype Length Precision 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
CONTRACT_ID NUMBER 18 Contains the Contract ID, not the Contract Number. Active
BUSINESS_UNIT_ID NUMBER 18 Business Unit ID Active
EXTRACTION_STATUS VARCHAR2 30 Indicates which type of summarization, if any, has been run Active
HALFWAY_FLAG VARCHAR2 1 Inernal flag Active
ONLINE_FLAG VARCHAR2 1 Inernal flag Active
REV_EXTRACTION_STATUS VARCHAR2 30 Indicates which type of summarization, if any, has been run
INV_EXTRACTION_STATUS VARCHAR2 30 Indicates which type of summarization, if any, has been run
ADDL_ATTR_CHAR_1 VARCHAR2 150 Oracle internal use only.
ADDL_ATTR_CHAR_2 VARCHAR2 150 Oracle internal use only.
ADDL_ATTR_CHAR_3 VARCHAR2 150 Oracle internal use only.
ADDL_ATTR_CHAR_4 VARCHAR2 150 Oracle internal use only.
ADDL_ATTR_CHAR_5 VARCHAR2 150 Oracle internal use only.
ADDL_ATTR_CHAR_6 VARCHAR2 150 Oracle internal use only.
ADDL_ATTR_CHAR_7 VARCHAR2 150 Oracle internal use only.
ADDL_ATTR_CHAR_8 VARCHAR2 150 Oracle internal use only.
ADDL_ATTR_CHAR_9 VARCHAR2 150 Oracle internal use only.
ADDL_ATTR_CHAR_10 VARCHAR2 150 Oracle internal use only.
ADDL_ATTR_NUM_1 NUMBER Oracle internal use only.
ADDL_ATTR_NUM_2 NUMBER Oracle internal use only.
ADDL_ATTR_NUM_3 NUMBER Oracle internal use only.
ADDL_ATTR_NUM_4 NUMBER Oracle internal use only.
ADDL_ATTR_NUM_5 NUMBER Oracle internal use only.
ADDL_ATTR_NUM_6 NUMBER Oracle internal use only.
ADDL_ATTR_NUM_7 NUMBER Oracle internal use only.
ADDL_ATTR_NUM_8 NUMBER Oracle internal use only.
ADDL_ATTR_NUM_9 NUMBER Oracle internal use only.
ADDL_ATTR_NUM_10 NUMBER Oracle internal use only.

Indexes

Index Uniqueness Tablespace Columns
PJS_SUM_SCOPE_CONTRACT_N1 Non Unique Default WORKER_ID, CONTRACT_ID