PJS_PROG_PROJ_SCOPE_PROJECT
This partitioned table contains non-persistent lists of all projects and programs in scope for existing program 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: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WORKER_ID | NUMBER | 18 | Unique identifier for each instance of summarization used to identify the data for that instance. | ||
| PROJECT_ID | NUMBER | 18 | Unique identifier of the project. | ||
| PROGRAM_ID | NUMBER | 18 | Identifier of the program that falls into the scope of current worker. | ||
| 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 for the planning data. | ||
| CMT_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates which type of summarization, if any, has been run for the commitment data. | ||
| 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 for the revenue data. | ||
| IDL_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates which type of summarization, if any, has been run for the invoice data. | ||
| SCH_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates which type of summarization, if any, has been run for the scheduling data. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ADDL_ATTRIBUTE1 | VARCHAR2 | 150 | Column supporting alphanumeric characters reserved for internal use. | ||
| ADDL_ATTRIBUTE2 | VARCHAR2 | 150 | Column supporting alphanumeric characters reserved for internal use. | ||
| ADDL_ATTRIBUTE3 | VARCHAR2 | 150 | Column supporting alphanumeric characters reserved for internal use. | ||
| ADDL_ATTRIBUTE4 | VARCHAR2 | 150 | Column supporting alphanumeric characters reserved for internal use. | ||
| ADDL_ATTRIBUTE5 | VARCHAR2 | 150 | Column supporting alphanumeric characters reserved for internal use. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJS_PROG_PROJ_SCOPE_PROJECT_U1 | Unique | Default | WORKER_ID, PROJECT_ID, PROGRAM_ID |