PJS_FP_DNGL_PLAN_B
This table contains persistent planning data that could not be prorated due to missing time dimension periods. This table is only used by bulk summarization.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| RECORD_TYPE | VARCHAR2 | 4 | Internal data source identifier | Active | ||
| TXN_ACCUM_HEADER_ID | NUMBER | 18 | Each TXN_ACCUM_HEADER_ID corresponds to a unique combination of resource attributes and is used for RBS mapping | Active | ||
| PROJECT_ID | NUMBER | 18 | Contains the PROJECT_ID, not the Project Number (SEGMENT1) | Active | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Business Unit ID | Active | ||
| TASK_ID | NUMBER | 18 | Task ID | Active | ||
| PLAN_VERSION_ID | NUMBER | 18 | Plan Version ID | Active | ||
| PLAN_CLASS_CODE | VARCHAR2 | 1 | Indicates whether the plan is a budget or forecast plan | Active | ||
| PLAN_CURRENT_FLAG | VARCHAR2 | 1 | Inernal flag | |||
| CALENDAR_ID | NUMBER | 18 | Time dimension calendar ID | Active | ||
| CALENDAR_TYPE | VARCHAR2 | 1 | Indicates whether PA or GL calendar | Active | ||
| RESOURCE_CLASS_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | Active | ||
| PERIOD_NAME | VARCHAR2 | 30 | Period name | Active | ||
| START_DATE | DATE | Start date | Active | |||
| END_DATE | DATE | End date | Active | |||
| CURRENCY_TYPE | VARCHAR2 | 1 | Currency type | Active | ||
| CURRENCY_CODE | VARCHAR2 | 3 | Currency code | Active | ||
| RAW_COST | NUMBER | Raw cost | Active | |||
| BRDN_COST | NUMBER | Burdened cost | Active | |||
| REVENUE | NUMBER | Revenue | Active | |||
| QUANTITY | NUMBER | Quantity | Active | |||
| PRJ_RAW_COST | NUMBER | Project raw cost | ||||
| PRJ_BRDN_COST | NUMBER | Project burdened cost | ||||
| PRJ_REVENUE | NUMBER | Project revenue | ||||
| FUN_RAW_COST | NUMBER | Project functional raw cost | ||||
| FUN_BRDN_COST | NUMBER | Project functional burdened cost | ||||
| FUN_REVENUE | NUMBER | Project functional revenue | ||||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure code | |||
| 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 |