PJS_PROG_PROJ_SCOPE_GT
This table stores the projects and programs which come under the scope of the current request.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| WORKER_ID | NUMBER | 18 | Unique identifier for each instance of summarization. | |
| PROJECT_ID | NUMBER | 18 | Unique identifier of the project. | |
| PROGRAM_ID | NUMBER | 18 | Unique identifier of the program. | |
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | |
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | 15 | ISO code associated with the project ledger currency. | |
| GL_CALENDAR_ID | NUMBER | 18 | Unique identifier of the ledger calendar. | |
| GL_PERIOD_SET_NAME | VARCHAR2 | 15 | Name of the accounting calendar. | |
| GL_PERIOD_TYPE | VARCHAR2 | 15 | Accounting period type such as, weekly, monthly, quarterly, and so on. | |
| EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates which type of summarization was run. | |
| PLAN_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates what type of summarization was run for the planning data. | |
| CMT_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates what type of summarization was run for the commitments data. | |
| COST_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates what type of summarization was run for the costing data. | |
| RDL_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates which type of summarization was run for the revenue data. | |
| IDL_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates which type of summarization was run for the invoice data. | |
| SCH_EXTRACTION_STATUS | VARCHAR2 | 30 | Indicates which type of summarization was run for the scheduling data. | |
| DIRTY_FLAG | VARCHAR2 | 1 | Indicates whether any changes are made to the project or program since last processing run. Valid values are Y and N. Y indicates new changes. | |
| PLAN_DIRTY_FLAG | VARCHAR2 | 1 | Indicates whether any changes are made to the budget, forecast or financial plan since last processing run. | |
| CMT_DIRTY_FLAG | VARCHAR2 | 1 | Indicates whether any changes are made to the commitments since last processing run. | |
| COST_DIRTY_FLAG | VARCHAR2 | 1 | Indicates whether new costs were incurred since last processing run. | |
| RDL_DIRTY_FLAG | VARCHAR2 | 1 | Indicates whether new revenue occurred since last processing run. | |
| IDL_DIRTY_FLAG | VARCHAR2 | 1 | Indicates whether new invoices occurred since last processing run. | |
| SCH_DIRTY_FLAG | VARCHAR2 | 1 | Indicates whether any schedule changes are made since last processing run. | |
| 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. |