PJS_SUM_SCOPE_PROJECT_GT
This table stores the projects which come under the scope of the current request.
Details
-
Schema: FUSION
-
Object owner: FUSION
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| PROJECT_ID | NUMBER | 18 | PROJECT_ID | |
| PROJECT_NUMBER | VARCHAR2 | 240 | PROJECT_NUMBER | |
| WORKER_ID | NUMBER | 18 | WORKER_ID | |
| BATCH_ID | NUMBER | 18 | BATCH_ID | |
| PLANNING_PROJECT_FLAG | VARCHAR2 | 1 | Indicates whether the project is a planning project. | |
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | 15 | Project functional currency code | |
| PRJ_CURRENCY_CODE | VARCHAR2 | 15 | Project currency code | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Business unit ID | |
| PROJECT_UNIT_ID | NUMBER | 18 | Project unit ID | |
| PROJECT_TYPE_ID | NUMBER | 18 | Project type ID | |
| EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates which type of summarization, if any, has been run | |
| COST_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 | |
| IDL_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates which type of summarization, if any, has been run | |
| RDL_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates which type of summarization, if any, has been run | |
| PLAN_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates which type of summarization, if any, has been run | |
| HALFWAY_FLAG | VARCHAR2 | 1 | Internal flag | |
| ONLINE_FLAG | VARCHAR2 | 1 | Internal flag | |
| PROJ_ELEMENT_ID | NUMBER | 18 | The unique identifier for the project element | |
| 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. |