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 |