PJO_PLANNING_OPTIONS
This table is used to store the planning options of plan types and plan versions.
Details
-
Schema: FUSION
-
Object owner: PJO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
PJO_PLANNING_OPTIONS_PK |
PLANNING_OPTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| PLANNING_OPTION_ID | NUMBER | 18 | Yes | PLANNING_OPTION_ID ***** | ||
| PROG_FCST_PLAN_TYPE_ID | NUMBER | PROG_FCST_PLAN_TYPE_ID | ||||
| PROG_AUTO_GEN_FCST_VER | VARCHAR2 | 1 | Yes | PROG_AUTO_GEN_FCST_VER | ||
| PROG_UPD_PLAN_QTY_WITH_EAC | VARCHAR2 | 1 | Yes | PROG_UPD_PLAN_QTY_WITH_EAC | ||
| PROG_AUTO_APPR_FCST_VER | VARCHAR2 | 1 | Yes | PROG_AUTO_APPR_FCST_VER | ||
| EXL_DISP_COMMITTMENTS | VARCHAR2 | 1 | EXL_DISP_COMMITTMENTS ***** | |||
| EXL_DISP_CUR_CON_MULT_TRA | VARCHAR2 | 1 | EXL_DISP_CUR_CON_MULT_TRA ***** | |||
| EXL_DISP_PLAN_VER_COMP_VAL | VARCHAR2 | 1 | EXL_DISP_PLAN_VER_COMP_VAL ***** | |||
| EXL_DISP_BSLN_PLAN_VALUES | VARCHAR2 | 1 | EXL_DISP_BSLN_PLAN_VALUES ***** | |||
| AMOUNT_TYPE | NUMBER | AMOUNT_TYPE ***** | ||||
| CURRENCY_TYPE | VARCHAR2 | 30 | CURRENCY_TYPE ***** | |||
| ENABLE_COSTS_FOR_PROJ_PLAN | VARCHAR2 | 1 | ENABLE_COSTS_FOR_PROJ_PLAN ***** | |||
| TARGET_RES_FORMAT_LEVEL | VARCHAR2 | 30 | TARGET_RES_FORMAT_LEVEL ***** | |||
| GEN_OVR_ETC_METHOD_CODE | VARCHAR2 | 30 | GEN_OVR_ETC_METHOD_CODE ***** | |||
| COPY_SRC_VERSION_ID | NUMBER | 22 | COPY_SRC_VERSION_ID ***** | |||
| GEN_OVR_ETC_MTHD_FLAG | VARCHAR2 | 1 | GEN_OVR_ETC_MTHD_FLAG ***** | |||
| RET_OVER_RATES_FRM_SRC_FLAG | VARCHAR2 | 1 | RET_OVER_RATES_FRM_SRC_FLAG ***** | |||
| SPEC_PC_REV_AT_PROJ_LEVEL | VARCHAR2 | 1 | Yes | Flag indicating whether the PC Revenue conversion attributes will be provided for a Project Project Plan Type only after it is attached to a Project.(This column is not required for Task Assignments) ***** | ||
| SPEC_PFC_REV_AT_PROJ_LEVEL | VARCHAR2 | 1 | Yes | Flag indicating whether the PFC Revenue conversion attributes will be provided for a Project Project Plan Type only after it is attached to a Project. (This column is not required for Task Assignments) ***** | ||
| PLAN_OPTION_LEVEL_CODE | VARCHAR2 | 30 | Yes | PLAN_OPTION_LEVEL_CODE ***** | ||
| RA_TASK_DATES_SAME | VARCHAR2 | 1 | Yes | This corresponds to the "Set Task Assignment the same as task date" field in the project plan type's Task Settings tab. The valid values are `Y' and `N'. If the value is `Y', then task assignment dates will always be same as the task planning dates. ***** | ||
| AUTO_ROLLUP_TASK_DATE | VARCHAR2 | 1 | Yes | This corresponds to the "Automatically rollup task dates" field in the project plan type's Task Settings tab. The valid values are `Y' and `N'. If the value is `Y' then the task dates are rolled up to the hierarchy. ***** | ||
| SYNC_TASK_TXN_PLAN_DATES | VARCHAR2 | 1 | Yes | This corresponds to the "Synchronize task transaction dates with plan dates" field in the project plan type's Task Settings tab. The valid values are `Y' and `N'. If the value is `Y', the task transaction dates will be same as the task planning dates. ***** | ||
| SYNC_TXN_DATE_BUFFER | NUMBER | This corresponds to the "Date adjustment buffer" field in the project plan type's Task Settings tab. The value is used in conjunction with the above sync up column. ***** | ||||
| GEN_BDGT_DURING_BASELINE | VARCHAR2 | 1 | Yes | This corresponds to the "Generate budget version when setting baseline for project plan" field in the project plan type's Task Settings tab. The valid values are `Y' and `N'. If the value is `Y', the generate budget API is called during the project plan baseline. ***** | ||
| RA_PLAN_TYPE_ID | NUMBER | This corresponds to the "Financial Plan Type" field in the project plan type's Task Settings tab. The valid financial plan types are shown in the single select drop down. The valid value consists of COST_ONLY plan types. These are used while generating a budget during the project plan baseline. This column will have value only if the column GEN_BUDG_DURING_BASELINE is `Y'. ***** | ||||
| AUTO_BDGT_BASELINE | VARCHAR2 | 1 | Yes | This corresponds to the "Automatically designate budget version as baseline" field in the project plan type's Task Settings tab. The valid values are `Y' and `N'. If the value is `Y', the generated budget should be baselined as well during the project plan baseline. This column will have value only if the column GEN_BUDG_DURING_BASELINE is `Y'. ***** | ||
| PERCENT_COMP_CALC_METHOD | VARCHAR2 | 30 | Default Physical Percent Complete calculation method for tasks. Calculation method can be `Cost', `Effort' or `Manual Entry'. ***** | |||
| PERCENT_COMP_ROLLUP_METHOD | VARCHAR2 | 30 | Percent Complete method used to rollup percent complete for summary level tasks. Rollup method can be `Cost' and `Effort'. ***** | |||
| PLAN_TYPE_CODE | VARCHAR2 | 30 | Yes | This column will be used to store the Plan Type. The valid values are `FINANCIAL_PLAN' and `PROJECT_PLAN'. ***** | ||
| PLAN_TYPE_ID | NUMBER | 18 | Yes | PLAN_TYPE_ID ***** | ||
| OBJECT_TYPE_CODE | VARCHAR2 | 30 | Yes | OBJECT_TYPE_CODE ***** | ||
| PROJECT_ID | NUMBER | 18 | Yes | The identifier of the project | ||
| OBJECT_ID1 | NUMBER | 18 | Yes | OBJECT_ID1 ***** | ||
| PLAN_VERSION_ID | NUMBER | 18 | Yes | PLAN_VERSION_ID ***** | ||
| PLANNED_FOR_CODE | VARCHAR2 | 30 | Yes | PLANNED_FOR_CODE ***** | ||
| APPROVED_COST_PLAN_TYPE_FLAG | VARCHAR2 | 1 | Indicates whether this plan type is used as an approved cost budget | |||
| APPROVED_REV_PLAN_TYPE_FLAG | VARCHAR2 | 1 | This flag indicates whether this plan type is used as an approved revenue budget | |||
| PRIMARY_COST_FORECAST_FLAG | VARCHAR2 | 1 | Indicates if the plan type is a primary cost forecast. | |||
| PRIMARY_REV_FORECAST_FLAG | VARCHAR2 | 1 | Indicates if the plan type is a primary revenue forecast. | |||
| PLAN_IN_MULTI_CURR_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the plan amounts can be entered in any currency | ||
| AMOUNT_SET_ID | NUMBER | 18 | AMOUNT_SET_ID ***** | |||
| PLAN_LEVEL_CODE | VARCHAR2 | 30 | PLAN_LEVEL_CODE ***** | |||
| TIME_PHASED_CODE | VARCHAR2 | 30 | TIME_PHASED_CODE ***** | |||
| CURRENT_PLANNING_PERIOD | VARCHAR2 | 15 | CURRENT_PLANNING_PERIOD ***** | |||
| PERIOD_PROFILE_ID | NUMBER | 18 | PERIOD_PROFILE_ID ***** | |||
| FACTOR_BY_CODE | VARCHAR2 | 30 | Yes | Indicates the quantum by which amounts will be factored during display. Set at the project planning option level only | ||
| PFC_COST_RATE_TYPE | VARCHAR2 | 30 | PFC_COST_RATE_TYPE ***** | |||
| PFC_COST_RATE_DATE_TYPE | VARCHAR2 | 30 | PFC_COST_RATE_DATE_TYPE ***** | |||
| PFC_COST_RATE_DATE | DATE | PFC_COST_RATE_DATE ***** | ||||
| PC_COST_RATE_TYPE | VARCHAR2 | 30 | PC_COST_RATE_TYPE ***** | |||
| PC_COST_RATE_DATE_TYPE | VARCHAR2 | 30 | PC_COST_RATE_DATE_TYPE ***** | |||
| PC_COST_RATE_DATE | DATE | PC_COST_RATE_DATE ***** | ||||
| PFC_REV_RATE_TYPE | VARCHAR2 | 30 | PFC_REV_RATE_TYPE ***** | |||
| PFC_REV_RATE_DATE_TYPE | VARCHAR2 | 30 | PFC_REV_RATE_DATE_TYPE ***** | |||
| PFC_REV_RATE_DATE | DATE | PFC_REV_RATE_DATE ***** | ||||
| PC_REV_RATE_TYPE | VARCHAR2 | 30 | PC_REV_RATE_TYPE ***** | |||
| PC_REV_RATE_DATE_TYPE | VARCHAR2 | 30 | PC_REV_RATE_DATE_TYPE ***** | |||
| PC_REV_RATE_DATE | DATE | PC_REV_RATE_DATE ***** | ||||
| RATE_SCH_COST_RATE_TYPE | VARCHAR2 | 30 | RATE_SCH_COST_RATE_TYPE***** | |||
| RATE_SCH_COST_RATE_DATE_TYPE | VARCHAR2 | 30 | RATE_SCH_COST_RATE_DATE_TYPE***** | |||
| RATE_SCH_COST_RATE_DATE | DATE | RATE_SCH_COST_RATE_DATE***** | ||||
| RATE_SCH_REV_RATE_TYPE | VARCHAR2 | 30 | RATE_SCH_REV_RATE_TYPE***** | |||
| RATE_SCH_REV_RATE_DATE_TYPE | VARCHAR2 | 30 | RATE_SCH_REV_RATE_DATE_TYPE***** | |||
| RATE_SCH_REV_RATE_DATE | DATE | RATE_SCH_REV_RATE_DATE***** | ||||
| MARGIN_DERIVED_FROM_CODE | VARCHAR2 | 30 | Indicates if margin is calculated from raw cost or burdened cost. Also indicates if raw cost or burdened cost is to be reported in the pages.. | |||
| GEN_SRC_CODE | VARCHAR2 | 30 | GEN_SRC_CODE ***** | |||
| GEN_ACT_AMTS_THRU_CODE | VARCHAR2 | 30 | GEN_ACT_AMTS_THRU_CODE ***** | |||
| GEN_SRC_PLAN_TYPE_ID | NUMBER | 18 | GEN_SRC_PLAN_TYPE_ID ***** | |||
| GEN_SRC_PLAN_VERSION_ID | NUMBER | 18 | GEN_SRC_PLAN_VERSION_ID ***** | |||
| GEN_SRC_PLAN_VER_CODE | VARCHAR2 | 30 | GEN_SRC_PLAN_VER_CODE ***** | |||
| GEN_INCL_OPENCOMM_FLAG | VARCHAR2 | 1 | GEN_INCL_OPENCOMM_FLAG ***** | |||
| GEN_RET_MAN_LINE_FLAG | VARCHAR2 | 1 | GEN_RET_MAN_LINE_FLAG ***** | |||
| GEN_INCL_BILL_EVENT_FLAG | VARCHAR2 | 1 | GEN_INCL_BILL_EVENT_FLAG ***** | |||
| ALLOW_NEG_ETC_FLAG | VARCHAR2 | 1 | ALLOW_NEG_ETC_FLAG ***** | |||
| RBS_VERSION_ID | NUMBER | 18 | Indicates the RBS version | |||
| NTP_RATE_DATE_TYPE | VARCHAR2 | 30 | NTP_RATE_DATE_TYPE ***** | |||
| NTP_RATE_DATE | DATE | NTP_RATE_DATE ***** | ||||
| COMMITMENT_CONTROL_FLAG | VARCHAR2 | 1 | COMMITMENT_CONTROL_FLAG ***** | |||
| INTEGRATION_TYPE | VARCHAR2 | 1 | INTEGRATION_TYPE ***** | |||
| CUMULATIVE_BUDGET_OPTION | VARCHAR2 | 30 | CUMULATIVE_BUDGET_OPTION ***** | |||
| AUTO_APPROVE_FLAG | VARCHAR2 | 1 | AUTO_APPROVE_FLAG ***** | |||
| REV_CLASSIFICATION_METHOD | VARCHAR2 | 30 | REV_CLASSIFICATION_METHOD ***** | |||
| ETC_METHOD_FLAG | VARCHAR2 | 1 | ETC_METHOD_FLAG ***** | |||
| ETC_METHOD_CODE | VARCHAR2 | 30 | This is an existing column in this table. This column will be used to store the Generation Override ETC method code in case of Financial Plan and it will be used to store Progress ETC Method code in case of Project Plan. Both Generation Override ETC Method Code (in case of Financial Plan) and Progress ETC Method (in case of Project Plan) mean the same. But in UI they will be displayed with different labels. If it is Financial Plan the value in this column will be fetched and shown as Generation Override ETC Method Code. If it is Project Plan the value in this column will be fetched and shown as Progress ETC Method Code. ***** | |||
| USE_THIRD_PARTY_SOFTWARE | VARCHAR2 | 1 | Yes | Flag indicating whether third party software can be used to create the schedule in the project plan. ***** | ||
| SPEC_PC_COST_AT_PROJ_LEVEL | VARCHAR2 | 1 | Yes | Flag indicating whether the PC Cost conversion attributes will be provided for a Project Project Plan Type only after it is attached to a Project. ***** | ||
| SPEC_PFC_COST_AT_PROJ_LEVEL | VARCHAR2 | 1 | Yes | Flag indicating whether the PFC Cost conversion attributes will be provided for a Project Project Plan Type only after it is attached to a Project. ***** | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| ALLOW_FCST_AMT_CARRY_FLAG | VARCHAR2 | 1 | Yes | ALLOW_FCST_AMT_CARRY_FLAG ***** | ||
| FORECAST_PERIOD_NAME | VARCHAR2 | 30 | FORECAST_PERIOD_NAME ***** | |||
| USE_PLANNING_RATES_FLAG | VARCHAR2 | 1 | Yes | Indicates if the planning options uses the planning rates. When N, schedules for class and organization need to be selected by the user.. | ||
| RES_CLASS_RAW_COST_SCH_ID | NUMBER | 18 | Indicates the raw cost rate schedule for resource class. | |||
| RES_CLASS_BILL_RATE_SCH_ID | NUMBER | 18 | Indicates the bill rate schedule for resource class. | |||
| COST_EMP_RATE_SCH_ID | NUMBER | 18 | Indicates the employee rate schedule id for cost. | |||
| COST_JOB_RATE_SCH_ID | NUMBER | 18 | Indicate the job rate schedule id for cost. | |||
| COST_NON_LBR_RES_RATE_SCH_ID | NUMBER | 18 | COST_NON_LBR_RES_RATE_SCH_ID ***** | |||
| COST_BRDND_RATE_SCH_ID | NUMBER | 18 | COST_BRDND_RATE_SCH_ID ***** | |||
| REV_EMP_RATE_SCH_ID | NUMBER | 18 | Indicates the employee rate schedule id for revenue. | |||
| REV_JOB_RATE_SCH_ID | NUMBER | 18 | Indicate the job rate schedule id for revenue. | |||
| REV_NON_LBR_RES_RATE_SCH_ID | NUMBER | 18 | REV_NON_LBR_RES_RATE_SCH_ID ***** | |||
| BUDGET_CREATION_METHOD | VARCHAR2 | 30 | BUDGET_CREATION_METHOD ***** | |||
| COPY_SRC_PLAN_TYPE_ID | NUMBER | 18 | COPY_SRC_PLAN_TYPE_ID ***** | |||
| COPY_SRC_PLAN_VERSION_ID | NUMBER | 18 | COPY_SRC_PLAN_VERSION_ID ***** | |||
| RETAIN_SOURCE_SPREAD_FLAG | VARCHAR2 | 1 | Indicates if the planned amounts spread in the source is retained during forecast generation. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE20 | VARCHAR2 | 1500 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE25 | VARCHAR2 | 1500 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Planning Options (PJO_PLANNING_OPTIONS_DFF) | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| EXL_PERIODIC_LAYOUT | VARCHAR2 | 30 | EXL_PERIODIC_LAYOUT ***** | |||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | |||
| ADDL_ATTRIBUTE_NUM_1 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_2 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_3 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_4 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_5 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_6 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_7 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_8 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_9 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_10 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_VAR_1 | VARCHAR2 | 30 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_VAR_2 | VARCHAR2 | 30 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_VAR_3 | VARCHAR2 | 30 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_VAR_4 | VARCHAR2 | 80 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_VAR_5 | VARCHAR2 | 80 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_VAR_6 | VARCHAR2 | 80 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_VAR_7 | VARCHAR2 | 240 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_VAR_8 | VARCHAR2 | 240 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_VAR_9 | VARCHAR2 | 240 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_VAR_10 | VARCHAR2 | 240 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_DATE_1 | DATE | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_DATE_2 | DATE | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_DATE_3 | DATE | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_DATE_4 | DATE | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_DATE_5 | DATE | Oracle internal use only. | ||||
| RESOURCE_TYPE_OPTION | VARCHAR2 | 1000 | Indicates the selected Labor resource type options. | |||
| AUTO_PLAN_ASMT_FLAG | VARCHAR2 | 1 | Option to create a task assignment instead of marking it as unplanned. | |||
| ASGN_RES_IN_SINGLE_CURR_FLAG | VARCHAR2 | 1 | Indicates if a resource and task combination can exist only in single currency for financial plan types that allow planning in multiple transaction currencies. | |||
| MANUAL_SPREAD_FLAG | VARCHAR2 | 1 | Indicates whether system spread has been modified by user. | |||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | ||
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. | ||
| MAP_ACT_SUMMARY_FLAG | VARCHAR2 | 1 | Indicates whether the incurred costs or revenue for resources are associated on the task hierarchy at the level planned. | |||
| MAP_ACT_SUMMARY_PRECD | VARCHAR2 | 15 | Indicates the precedence that's considered while associating costs or revenue for resources on the task hierarchy at the level planned. While associating costs or revenue, the resource hierarchy is considered first and then the task hierarchy. This column is currently unused. | |||
| COST_PROJ_ROLE_RATE_SCH_ID | NUMBER | 18 | Identifier of the rate schedule associated to derive cost rates for project roles. | |||
| REV_PROJ_ROLE_RATE_SCH_ID | NUMBER | 18 | Identifier of the rate schedule associated to derive revenue rates for project roles. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJO_PLANNING_OPTIONS | pjo_plan_types_b | PLAN_TYPE_ID |
| PJO_PLANNING_OPTIONS | pjo_fin_plan_amt_sets | AMOUNT_SET_ID |
| pjo_excel_export_options | pjo_planning_options | PLANNING_OPTION_ID |
| pjo_xcc_settings | pjo_planning_options | PLANNING_OPTION_ID |
| pjo_planning_currencies | pjo_planning_options | PLANNING_OPTION_ID |
| pjo_xcc_prj_hchy_seed | pjo_planning_options | PJO_XCC_PRJ_HCHY_SEED_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJO_PLANNING_OPTIONS_N1 | Non Unique | FUSION_TS_TX_DATA | PLAN_VERSION_ID |
| PJO_PLANNING_OPTIONS_N2 | Non Unique | Default | LAST_UPDATE_DATE |
| PJO_PLANNING_OPTIONS_N3 | Non Unique | Default | PROJECT_ID |
| PJO_PLANNING_OPTIONS_U1 | Unique | Default | PLANNING_OPTION_ID, ORA_SEED_SET1 |
| PJO_PLANNING_OPTIONS_U11 | Unique | Default | PLANNING_OPTION_ID, ORA_SEED_SET2 |
| PJO_PLANNING_OPTIONS_U2 | Unique | FUSION_TS_TX_DATA | PLAN_TYPE_ID, OBJECT_ID1, PLAN_VERSION_ID, PLANNED_FOR_CODE, PROJECT_ID, ORA_SEED_SET1 |
| PJO_PLANNING_OPTIONS_U21 | Unique | FUSION_TS_TX_DATA | PLAN_TYPE_ID, OBJECT_ID1, PLAN_VERSION_ID, PLANNED_FOR_CODE, PROJECT_ID, ORA_SEED_SET2 |