PJF_PROJECTS_ALL_B
This table stores the non-translatable fields in a project.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
PJF_PROJECTS_ALL_B_PK |
PROJECT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
|---|---|---|---|---|---|---|---|
| PROJECT_ID | NUMBER | 18 | Yes | The system-generated number that uniquely identifies a project. | Active | ||
| BUDGETARY_CONTROL_FLAG | VARCHAR2 | 1 | Budgetary Control Flag: Indicates whether transactions on the project will undergo funds checking | Active | |||
| 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. | Active | ||
| SEGMENT1 | VARCHAR2 | 25 | Yes | Key Flexfield: segment of the key flexfield. | Active | ||
| PROJECT_TYPE_ID | NUMBER | 18 | Yes | The project type that classifies the project and defaults project information upon project entry. | Active | ||
| CARRYING_OUT_ORGANIZATION_ID | NUMBER | 18 | Yes | The identifier of the organization that is responsible for the project work | Active | ||
| PUBLIC_SECTOR_FLAG | VARCHAR2 | 1 | Yes | Flag that indicates whether the project is in the public sector or the private sector | Active | ||
| PROJECT_STATUS_CODE | VARCHAR2 | 30 | Yes | The status of the project. | Active | ||
| START_DATE | DATE | Yes | The date on which the project starts; expenditure items with item dates before the start date cannot be entered for the project | Active | |||
| COMPLETION_DATE | DATE | The date on which the project is completed; expenditure items with item dates after the completion date cannot be entered for the project | Active | ||||
| CLOSED_DATE | DATE | The date that the project was closed by changing the project status to Closed | Active | ||||
| CLIN_LINKED_CODE | VARCHAR2 | 1 | Indicates whether the project is linked and if the linkage is at the Project or Task level. | Active | |||
| LIMIT_TO_TXN_CONTROLS_FLAG | VARCHAR2 | 1 | Flag that indicates if users can only charge expenditures to the project that are listed in the transaction controls. If flag =Y, then only items listed in the controls are allowed. If flag =N or null, then items not listed are allowed | Active | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Active | |||
| PROGRAM_ID | NUMBER | 18 | Standard Who Column | Active | |||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Standard Who Column | Active | |||
| PROGRAM_UPDATE_DATE | DATE | Standard Who Column | Active | ||||
| SUMMARY_FLAG | VARCHAR2 | 1 | Yes | Flag used with the project key flexfield. The project key flexfield is not implemented | Active | ||
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Flag used with the key flexfield. The project key flexfield is not implemented | Active | ||
| SEGMENT2 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | Active | |||
| SEGMENT3 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | Active | |||
| SEGMENT4 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | Active | |||
| SEGMENT5 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | Active | |||
| SEGMENT6 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | Active | |||
| SEGMENT7 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | Active | |||
| SEGMENT8 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | Active | |||
| SEGMENT9 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | Active | |||
| SEGMENT10 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | Active | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Project Descriptive Flexfield (PJF_PROJECTS_DESC_FLEX) | Active | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Descriptive Flexfield (PJF_PROJECTS_DESC_FLEX) | Active | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Descriptive Flexfield (PJF_PROJECTS_DESC_FLEX) | Active | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Descriptive Flexfield (PJF_PROJECTS_DESC_FLEX) | Active | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Descriptive Flexfield (PJF_PROJECTS_DESC_FLEX) | Active | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Descriptive Flexfield (PJF_PROJECTS_DESC_FLEX) | Active | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Descriptive Flexfield (PJF_PROJECTS_DESC_FLEX) | Active | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Descriptive Flexfield (PJF_PROJECTS_DESC_FLEX) | Active | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Descriptive Flexfield (PJF_PROJECTS_DESC_FLEX) | Active | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Descriptive Flexfield (PJF_PROJECTS_DESC_FLEX) | Active | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Descriptive Flexfield (PJF_PROJECTS_DESC_FLEX) | Active | ||
| COST_IND_RATE_SCH_ID | NUMBER | 18 | The identifier of default costing burden schedule | Active | |||
| COST_IND_SCH_FIXED_DATE | DATE | The schedule fixed date of firm costing burden schedule | Active | ||||
| OVR_COST_IND_RATE_SCH_ID | NUMBER | 18 | This column is not used | Active | |||
| TEMPLATE_FLAG | VARCHAR2 | 1 | Indicates whether the project is a Template or Not | Active | |||
| VERIFICATION_DATE | DATE | Not currently used | Active | ||||
| CREATED_FROM_PROJECT_ID | NUMBER | 18 | Holds the Project_id of the template corresponding to the source project. This value would be null for templates | Active | |||
| TEMPLATE_START_DATE_ACTIVE | DATE | The Effective start date of the Template | Active | ||||
| TEMPLATE_END_DATE_ACTIVE | DATE | Last effective date of the template | Active | ||||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | Active | ||
| PROJECT_UNIT_ID | NUMBER | 18 | Yes | Project unit assigned to the project. | Active | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Yes | Legal entity assigned to the project. | Active | ||
| PM_PRODUCT_CODE | VARCHAR2 | 30 | The identifier of the external project management system from which the project was imported. | Active | |||
| PM_PROJECT_REFERENCE | VARCHAR2 | 25 | The identifier of the project in the external project management system from which the project was imported. | Active | |||
| ACTUAL_START_DATE | DATE | The actual start date of the project. Applicable only for a project that has originated from an external system. | Active | ||||
| ACTUAL_FINISH_DATE | DATE | The actual end date of the project. Applicable only for a project that has originated from an external system. | Active | ||||
| EARLY_START_DATE | DATE | The early start date of the project. Applicable only for a project that has originated from an external system. | Active | ||||
| EARLY_FINISH_DATE | DATE | The early finish date of the project. Applicable only for a project that has originated from an external system. | Active | ||||
| LATE_START_DATE | DATE | The late start date of the project. Applicable only for a project that has originated from an external system. | Active | ||||
| LATE_FINISH_DATE | DATE | The late finish date of the project. Applicable only for a project that has originated from an external system. | Active | ||||
| SCHEDULED_START_DATE | DATE | The scheduled start date of the project. Applicable only for a project that has originated from an external system. | Active | ||||
| SCHEDULED_FINISH_DATE | DATE | The scheduled finish date of the project. Applicable only for a project that has originated from an external system. | Active | ||||
| PROJECT_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code of the project | Active | ||
| ALLOW_CROSS_CHARGE_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate whether cross charge are allowed | Active | ||
| CC_PROCESS_LABOR_FLAG | VARCHAR2 | 1 | Yes | Flag that indicates cross charge processing is to be performed for labor transactions charged to the project. Default value for the project template is N. This is defaulted to a project from the project template. This value for the projec | Active | ||
| LABOR_TP_SCHEDULE_ID | NUMBER | Identifier for transfer price schedule to use for cross charged labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date. It cc_process_labor_flag is set t | Active | ||||
| LABOR_TP_FIXED_DATE | DATE | Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the | Active | ||||
| CC_PROCESS_NL_FLAG | VARCHAR2 | 1 | Yes | Flag that indicates cross charge processing is to be performed for n on-labor transactions charged to the project. Default value for the project template is N. This is defaulted to a project from the project template. This value for the pr | Active | ||
| NL_TP_SCHEDULE_ID | NUMBER | Identifier for transfer price schedule to use for cross charged non-labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date. If cc_process_nl_flag is set | Active | ||||
| NL_TP_FIXED_DATE | DATE | Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for non-labor transactions. This is defaulted to a project from the project template. This value for the project isa default for | Active | ||||
| WORK_TYPE_ID | NUMBER | 18 | Work_Types are predefined types of work, for example, Vacation, Training, and Administration. | Active | |||
| SERVICE_TYPE_CODE | VARCHAR2 | 30 | A classification of the service or activity associated with a project. | Active | |||
| PROJECT_VALUE | NUMBER | The OPPORTUNITY_VALUE converted to the project functional currency. | Active | ||||
| EXPECTED_APPROVAL_DATE | DATE | The expected date of the project approval. This is used for information purposes only. | Active | ||||
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | 15 | Project functional currency. The default value is the value entered for the associated ledger. | Active | |||
| PRIORITY_CODE | VARCHAR2 | 30 | Indicates priority of the project. | Active | |||
| TARGET_START_DATE | DATE | The Target Start Date for the project. | Active | ||||
| TARGET_FINISH_DATE | DATE | The Target Finish Date for the project. | Active | ||||
| BASELINE_START_DATE | DATE | The baseline start date of the project. | Active | ||||
| BASELINE_FINISH_DATE | DATE | The baseline finish date of the project. | Active | ||||
| SCHEDULED_AS_OF_DATE | DATE | The publish date for the Scheduled Start and Finish dates for the project. | Active | ||||
| BASELINE_AS_OF_DATE | DATE | The baseline date for the Baseline Start and Finish Dates for the project. | Active | ||||
| ACTUAL_AS_OF_DATE | DATE | The publish date for the project Actual Start and Actual Finish Dates. | Active | ||||
| SCHEDULED_DURATION | NUMBER | Duration between the Scheduled Start and Finish Dates using the project work calendar. | Active | ||||
| BASELINE_DURATION | NUMBER | Duration between the Baseline Start and Finish Dates using the project work calendar. | Active | ||||
| ACTUAL_DURATION | NUMBER | Duration between the Actual Start and Finish Dates using the project work calendar. | Active | ||||
| ASSET_ALLOCATION_METHOD | VARCHAR2 | 30 | Identifies the method used to allocate indirect and common costs across the assets assigned to a grouping level. | Active | |||
| CAPITAL_EVENT_PROCESSING | VARCHAR2 | 30 | Capital Event Processing method. Used to determine when cost and assets are grouped for capitalization or retirement adjustment processing. | Active | |||
| CINT_RATE_SCH_ID | NUMBER | 18 | Capital Interest Rate Schedule identifier. | Active | |||
| CINT_ELIGIBLE_FLAG | VARCHAR2 | 1 | Flag used to determine whether the project is eligible for capitalized interest. | Active | |||
| CINT_STOP_DATE | DATE | Stop date for capital interest calculation. | Active | ||||
| STRUCTURE_SHARING_CODE | VARCHAR2 | 30 | Indicates how the financial and workplan structures are split or shared. | Active | |||
| 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 | |||
| CURRENCY_CONV_RATE_TYPE | VARCHAR2 | 30 | The source for the project currency exchange rate, such as user-defined, spot or corporate rate. | Active | |||
| CURRENCY_CONV_DATE_TYPE_CODE | VARCHAR2 | 1 | The type of date that will be used in order to look up the currency conversion rates to convert transaction currencies into the project currency. | Active | |||
| CURRENCY_CONV_DATE | DATE | The date from which the system will take currency conversion rates in order to convert transaction currencies into project currency. This date is used when the date type is Fixed Date. | Active | ||||
| OUTLINE_LEVEL | NUMBER | 18 | This column is now obsolete. | Active | |||
| PLANNING_PROJECT_FLAG | VARCHAR2 | 1 | Indicates whether the project is a planning project. | Active | |||
| IC_CLIN_LINKED_CODE | VARCHAR2 | 1 | IC_CLIN_LINKED_CODE | Active | |||
| KPI_NOTIFICATION_INCLUDE_NOTES | VARCHAR2 | 5 | KPI_NOTIFICATION_INCLUDE_NOTES | Active | |||
| KPI_NOTIFICATION_ENABLED | VARCHAR2 | 5 | KPI_NOTIFICATION_ENABLED | Active | |||
| KPI_NOTIFICATION_RECIPIENTS | VARCHAR2 | 30 | KPI_NOTIFICATION_RECIPIENTS | Active | |||
| BPEL_STATUS_CODE | VARCHAR2 | 30 | BPEL_STATUS_CODE | Active | |||
| GROUP_SPACE_TEMPLATE_NAME | VARCHAR2 | 256 | Identifier that represents the Project space template that is associated to the project. | Active | |||
| PROJECT_CALENDAR_ID | NUMBER | Project level schedule_id to store ZMM calendar Id (FK), ZMM_SR_SCHEDULES_B.SCHEDULE_ID | Active | ||||
| PROJECT_CATEGORY | VARCHAR2 | 30 | Yes | Category to indicate FINANCIAL, EXECUTION, TODO, FIN_EXEC projects | Active | ||
| HOURS_PER_DAY | NUMBER | Conversion factor (from days to hours and viceversa) for Effort/Duration as a preference at the project level. Typically, it would be 8 hours per day. | Active | ||||
| EXTERNAL_PROJECT_ID | VARCHAR2 | 240 | A unique project identifier from an external system. | Active | |||
| PUBLIC_TEMPLATE_FLAG | VARCHAR2 | 1 | Flag to indicate whether an execution project template is publicly accessible | Active | |||
| TEMPL_CREATED_BY_RES_ID | NUMBER | 18 | Enterprise resource ID of the person who created the execution project template | Active | |||
| GROUP_SPACE_NAME | VARCHAR2 | 256 | Identifier of the Groupspace used for managing documents for a project. | Active | |||
| ATTRIBUTE1_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE2_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE3_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE4_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE5_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE6_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE7_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE8_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE9_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE10_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE11_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE12_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE13_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE14_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE15_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE1_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE2_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE3_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE4_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE5_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE6_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE7_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE8_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE9_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE10_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE11_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE12_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE13_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE14_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE15_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE31 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE32 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE33 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE34 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE35 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE36 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE37 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE38 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE39 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE40 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE41 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE42 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE43 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE44 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE45 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE46 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE47 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE48 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE49 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| ATTRIBUTE50 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
| PROJECT_PLAN_VIEW_ACCESS | VARCHAR2 | 30 | Access level to the view-only project plan in Oracle Fusion Task Management. Example values are ALL_USERS and PROJECT_TEAM. | ||||
| INTEGRATED_PRODUCT_CODE | VARCHAR2 | 30 | The identifier of the external project management system from which the project is integrated. | ||||
| INTEGRATED_PROJECT_REFERENCE | VARCHAR2 | 240 | The identifier of the project in the external project management system from which the project is integrated. | ||||
| WORKFLOW_COUNTER | NUMBER | 2 | If project statuses have been configured to have one workflow-enabled status transition to another workflow-enabled status, this column stores a numeric counter that increments with each transition. If the counter value in this column exceeds 10, the workflow will terminate and return the project to the last status that was not workflow enabled (stored in the column INITIAL_WF_STATUS_CODE). This is a failsafe mechanism to protect against infinite loops. | ||||
| INITIAL_WF_STATUS_CODE | VARCHAR2 | 30 | When a project is transitioned to a workflow-enabled status, this column records the last status that was not workflow enabled. If the approval workflow completes in error, the project will be returned to this status. For example, if the configuration of project statuses and workflow rules result in a loop, and the number of iterations of the loop exceed 10, the workflow will exit and return the project to this status. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJF_PROJECTS_ALL_B | pjf_project_statuses_b | PROJECT_STATUS_CODE |
| PJF_PROJECTS_ALL_B | pjc_cint_rate_sch_b | CINT_RATE_SCH_ID |
| PJF_PROJECTS_ALL_B | pjf_tp_schedules | NL_TP_SCHEDULE_ID |
| PJF_PROJECTS_ALL_B | pjf_tp_schedules | LABOR_TP_SCHEDULE_ID |
| PJF_PROJECTS_ALL_B | pjf_work_types_b | WORK_TYPE_ID |
| PJF_PROJECTS_ALL_B | pjf_project_types_b | PROJECT_TYPE_ID |
| PJF_PROJECTS_ALL_B | pjf_ind_rate_sch_b | COST_IND_RATE_SCH_ID |
| PJF_PROJECTS_ALL_B | pjf_ind_rate_sch_b | OVR_COST_IND_RATE_SCH_ID |
| fa_adj_src_lines_t | pjf_projects_all_b | PROJECT_ID |
| fa_asset_invoices | pjf_projects_all_b | PROJECT_ID |
| pjo_plan_versions_b | pjf_projects_all_b | PROJECT_ID |
| pjf_ind_rate_sch_b | pjf_projects_all_b | PROJECT_ID |
| pjf_ind_rate_sch_b | pjf_projects_all_b | AWARD_PROJECT_ID |
| pjc_cc_dist_lines_all | pjf_projects_all_b | PROJECT_ID |
| pjb_cntrct_proj_links | pjf_projects_all_b | PROJECT_ID |
| pjc_prj_asset_asgs | pjf_projects_all_b | PROJECT_ID |
| pjo_project_plan_actuals | pjf_projects_all_b | PROJECT_ID |
| pjf_projects_mru | pjf_projects_all_b | PROJECT_ID |
| zx_rec_nrec_dist | pjf_projects_all_b | PROJECT_ID |
| pjf_proj_structure_attr | pjf_projects_all_b | PROJECT_ID |
| fa_mass_retirements | pjf_projects_all_b | PROJECT_ID |
| pjf_proj_elem_ver_struct | pjf_projects_all_b | PROJECT_ID |
| pjf_rate_overrides_int | pjf_projects_all_b | PROJECT_ID |
| pjc_prj_asset_lns_all | pjf_projects_all_b | PROJECT_ID |
| pjf_eps_hierarchies | pjf_projects_all_b | PROJECT_ID |
| pjf_object_images | pjf_projects_all_b | OBJECT_ID |
| pjt_requirements_b | pjf_projects_all_b | PROJECT_ID |
| pjc_cost_dist_overrides | pjf_projects_all_b | PROJECT_ID |
| pjc_xcc_burden_dists | pjf_projects_all_b | PROJECT_ID |
| pjc_bc_packets_t | pjf_projects_all_b | PROJECT_ID |
| pjo_project_progress | pjf_projects_all_b | PROJECT_ID |
| ap_invoice_lines_all | pjf_projects_all_b | PJC_PROJECT_ID |
| pjf_project_classes | pjf_projects_all_b | PROJECT_ID |
| pjc_cc_prj_bu_relationships | pjf_projects_all_b | PROJECT_ID |
| pjf_project_options | pjf_projects_all_b | PROJECT_ID |
| pjc_bc_packets_h | pjf_projects_all_b | PROJECT_ID |
| pjf_proj_elements_tl | pjf_projects_all_b | PROJECT_ID |
| fa_mc_asset_invoices | pjf_projects_all_b | PROJECT_ID |
| pjo_commitment_controls | pjf_projects_all_b | PROJECT_ID |
| pjc_cap_exceptions | pjf_projects_all_b | PROJECT_ID |
| pjo_xcc_ctrl_bdgt_segments | pjf_projects_all_b | PROJECT_ID |
| pjs_perf_kpa_summary_det | pjf_projects_all_b | OBJECT_ID |
| pjc_alloc_txn_details | pjf_projects_all_b | PROJECT_ID |
| pjf_project_set_lines | pjf_projects_all_b | PROJECT_ID |
| pjc_commitment_txns | pjf_projects_all_b | PROJECT_ID |
| ap_invoice_lines_interface | pjf_projects_all_b | PJC_PROJECT_ID |
| pjc_prj_assets_all | pjf_projects_all_b | PROJECT_ID |
| pjc_alloc_target_lines | pjf_projects_all_b | PROJECT_ID |
| pjf_proj_copy_overrides_b | pjf_projects_all_b | PROJECT_ID |
| pjs_perf_transactions | pjf_projects_all_b | PROJECT_ID |
| ap_distribution_set_lines_all | pjf_projects_all_b | PJC_PROJECT_ID |
| pjc_txn_mass_adjust | pjf_projects_all_b | PROJECT_ID |
| pjc_alloc_missing_costs | pjf_projects_all_b | PROJECT_ID |
| pjc_capital_events | pjf_projects_all_b | PROJECT_ID |
| pjf_project_parties | pjf_projects_all_b | PROJECT_ID |
| pjc_exp_items_all | pjf_projects_all_b | PROJECT_ID |
| ap_invoices_all | pjf_projects_all_b | PROJECT_ID |
| pjf_proj_elements_b | pjf_projects_all_b | PROJECT_ID |
| fa_mass_additions | pjf_projects_all_b | PROJECT_ID |
| pjo_xbs_denorm | pjf_projects_all_b | PROJECT_ID |
| pjc_txn_xface_audit_all | pjf_projects_all_b | PROJECT_ID |
| pjf_rate_overrides | pjf_projects_all_b | PROJECT_ID |
| pjo_planning_elements | pjf_projects_all_b | PROJECT_ID |
| pjs_perf_kpa_summary | pjf_projects_all_b | OBJECT_ID |
| pjf_projects_all_tl | pjf_projects_all_b | PROJECT_ID |
| pjc_txn_xface_all | pjf_projects_all_b | PROJECT_ID |
| pjf_comp_ot_defaults_all | pjf_projects_all_b | PROJECT_ID |
| pjo_pricing_intg_debug | pjf_projects_all_b | PROJECT_ID |
| pjc_alloc_source_lines | pjf_projects_all_b | PROJECT_ID |
| ap_invoice_distributions_all | pjf_projects_all_b | PJC_PROJECT_ID |
| pjf_rbs_prj_assignments | pjf_projects_all_b | PROJECT_ID |
| pjf_project_opp_attrs | pjf_projects_all_b | PROJECT_ID |
| pjs_perf_object_rules | pjf_projects_all_b | OBJECT_ID |
| pjs_plan_types | pjf_projects_all_b | PROJECT_ID |
| pjc_cost_dist_lines_all | pjf_projects_all_b | PROJECT_ID |
| pjc_transaction_controls | pjf_projects_all_b | PROJECT_ID |
| pjb_billing_events | pjf_projects_all_b | PROJECT_ID |
| jv_project_value_sets | pjf_projects_all_b | PROJECT_ID |
| pjc_alloc_rules_all | pjf_projects_all_b | OFFSET_PROJECT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| PJF_PROJECTS_ALL_B_N10 | Non Unique | FUSION_TS_TX_IDX | LAST_UPDATE_DATE, PROJECT_TYPE_ID | Active |
| PJF_PROJECTS_ALL_B_N11 | Non Unique | FUSION_TS_TX_IDX | PM_PROJECT_REFERENCE, PM_PRODUCT_CODE | Active |
| PJF_PROJECTS_ALL_B_N12 | Non Unique | FUSION_TS_TX_IDX | ORG_ID, PROJECT_UNIT_ID | |
| PJF_PROJECTS_ALL_B_N13 | Non Unique | Default | INTEGRATED_PRODUCT_CODE, INTEGRATED_PROJECT_REFERENCE | |
| PJF_PROJECTS_ALL_B_N2 | Non Unique | FUSION_TS_TX_IDX | CARRYING_OUT_ORGANIZATION_ID, PROJECT_STATUS_CODE, COMPLETION_DATE, START_DATE | Active |
| PJF_PROJECTS_ALL_B_N3 | Non Unique | FUSION_TS_TX_IDX | SEGMENT1 | Active |
| PJF_PROJECTS_ALL_B_N4 | Non Unique | FUSION_TS_TX_IDX | PROJECT_STATUS_CODE | Active |
| PJF_PROJECTS_ALL_B_N6 | Non Unique | FUSION_TS_TX_IDX | TEMPLATE_FLAG | Active |
| PJF_PROJECTS_ALL_B_N7 | Non Unique | FUSION_TS_TX_IDX | CREATED_BY | Active |
| PJF_PROJECTS_ALL_B_PK | Unique | FUSION_TS_TX_IDX | PROJECT_ID | Active |
| PJF_PROJECTS_ALL_B_U2 | Unique | FUSION_TS_TX_IDX | UPPER("SEGMENT1") | Active |
| PJF_PROJECTS_ALL_B_U4 | Unique | FUSION_TS_TX_IDX | ORG_ID, PROJECT_ID | Active |
| PJF_PROJECTS_ALL_B_U5 | Unique | FUSION_TS_TX_IDX | SEGMENT1 | Active |