1. Tables and Views for Project Management
  2. PJF_PROJECTS_ALL_B_

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_

LAST_UPDATE_DATE, LAST_UPDATED_BY, PROJECT_ID

Columns

Name Datatype Length Precision Not-null Comments 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 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 Key Flexfield: segment of the key flexfield. Active
PROJECT_TYPE_ID NUMBER 18 The project type that classifies the project and defaults project information upon project entry. Active
CARRYING_OUT_ORGANIZATION_ID NUMBER 18 The identifier of the organization that is responsible for the project work Active
PUBLIC_SECTOR_FLAG VARCHAR2 1 Flag that indicates whether the project is in the public sector or the private sector Active
PROJECT_STATUS_CODE VARCHAR2 30 The status of the project. Active
START_DATE DATE 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 Flag used with the project key flexfield. The project key flexfield is not implemented Active
ENABLED_FLAG VARCHAR2 1 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. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. 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 Indicates the identifier of the business unit associated to the row. Active
PROJECT_UNIT_ID NUMBER 18 Project unit assigned to the project. Active
LEGAL_ENTITY_ID NUMBER 18 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 Currency code of the project Active
ALLOW_CROSS_CHARGE_FLAG VARCHAR2 1 Flag to indicate whether cross charge are allowed Active
CC_PROCESS_LABOR_FLAG VARCHAR2 1 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 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 Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 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 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.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.

Indexes

Index Uniqueness Tablespace Columns
PJF_PROJECTS_ALL_B_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, PROJECT_ID