PJS_PROJECT_EXTR_STATUS
This table contains a persistent list of all projects eligible for summarization, as well as how and when they have been summarized.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJS_PROJECT_EXTR_STATUS_PK |
PROJECT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| PROJECT_ID | NUMBER | 18 | Yes | Contains the PROJECT_ID, not the Project Number (SEGMENT1) | Active | |
| PROJECT_UNIT_ID | NUMBER | 18 | Project unit ID | 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 | ||
| EXTRACTION_STATUS_PLAN | VARCHAR2 | 30 | Stores extraction status of planning data | |||
| EXTRACTION_STATUS_CMT | VARCHAR2 | 30 | Stores extraction status of committments data | |||
| EXTRACTION_STATUS_COST | VARCHAR2 | 30 | Stores extraction status of actuals data | |||
| EXTRACTION_STATUS_REV | VARCHAR2 | 30 | Stores extraction status of revenue data | |||
| HALFWAY_FLAG | VARCHAR2 | 1 | Inernal flag | Active | ||
| ONLINE_FLAG | VARCHAR2 | 1 | Inernal flag | Active | ||
| CLOSED_DATE | DATE | Contract closed date | Active | |||
| PROJECT_NAME | VARCHAR2 | 240 | Contains the Project Name | Active | ||
| PURGE_STATUS | VARCHAR2 | 30 | Contract purge status | Active | ||
| LAST_SUM_PLAN_DATE | DATE | Indicates the last time summarization has been run for the planning area. | ||||
| LAST_AVAILABLE_PLAN_DATE | DATE | Indicates the time before which transaction data is available in Essbase. | ||||
| LAST_SUM_PLAN_GL_PERIOD | VARCHAR2 | 30 | Contains the latest period for which plan data has been extracted | |||
| LAST_SUM_PLAN_PA_PERIOD | VARCHAR2 | 30 | Contains the latest period for which plan data has been extracted | |||
| LAST_SUM_CMT_DATE | DATE | Indicates the last time summarization has been run for the commitments area. | ||||
| LAST_AVAILABLE_CMT_DATE | DATE | Indicates the time before which transaction data is available in Essbase. | ||||
| LAST_SUM_CMT_GL_PERIOD | VARCHAR2 | 30 | Contains the latest period for which commitments data has been extracted | |||
| LAST_SUM_CMT_PA_PERIOD | VARCHAR2 | 30 | Contains the latest period for which commitments data has been extracted | |||
| LAST_SUM_COST_DATE | DATE | Indicates the last time summarization has been run for the costing area. | ||||
| LAST_AVAILABLE_COST_DATE | DATE | Indicates the time before which transaction data is available in Essbase. | ||||
| LAST_SUM_COST_GL_PERIOD | VARCHAR2 | 30 | Contains the latest period for which cost data has been extracted | |||
| LAST_SUM_COST_PA_PERIOD | VARCHAR2 | 30 | Contains the latest period for which cost data has been extracted | |||
| LAST_SUM_REV_DATE | DATE | Indicates the last time summarization has been run for the revenue area. | ||||
| LAST_AVAILABLE_REV_DATE | DATE | Indicates the time before which transaction data is available in Essbase. | ||||
| LAST_SUM_REV_GL_PERIOD | VARCHAR2 | 30 | Contains the latest period for which revenue data has been extracted | |||
| LAST_SUM_REV_PA_PERIOD | VARCHAR2 | 30 | Contains the latest period for which revenue data has been extracted | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
| 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_PROJECT_EXTR_STATUS_U1 | Unique | Default | PROJECT_ID |