PJS_SUM_SCOPE_PROJECT
This partitioned table contains non-persistent lists of all projects 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 | |
| PROJECT_ID | NUMBER | 18 | Contains the PROJECT_ID, not the Project Number (SEGMENT1) | Active | |
| PROJ_ELEMENT_ID | NUMBER | 18 | The PROJECT_ELEMENT_ID can be either the TASK_ID or the structure level ELEMENT_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 | |
| PROJECT_TYPE_ID | NUMBER | 18 | Project Type ID | Active | |
| PROJECT_UNIT_ID | NUMBER | 18 | Project unit ID | Active | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Business Unit ID | Active | |
| PRJ_CURRENCY_CODE | VARCHAR2 | 15 | Project currency code | Active | |
| PLAN_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates which type of summarization, if any, has been run | ||
| CMT_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates which type of summarization, if any, has been run | ||
| COST_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates what type of summarization has been run for the costing area. | ||
| RDL_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates which type of summarization, if any, has been run | ||
| IDL_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates which type of summarization, if any, has been run | ||
| PLANNING_PROJECT_FLAG | VARCHAR2 | 1 | Indicates whether the project is a planning project. | ||
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | 15 | Project functional currency code | ||
| 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_PROJECT_N1 | Non Unique | Default | WORKER_ID, PROJECT_ID |