PJF_PROJ_ELEMENTS_XFACE
PJF_PROJ_ELEMENTS_XFACE table is used to import tasks from an external application into Oracle Fusion Project Financial Management. The Import Project Tasks process validates and imports data from the interface table to Oracle Fusion Project Financial Management transaction tables.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJF_PROJ_ELEMENTS_XFACE_PK |
PROJ_ELEMENT_XFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROJ_ELEMENT_XFACE_ID | NUMBER | 18 | Yes | Unique identifier of the interface table row. | |
| LIMIT_TO_TXN_CONTROLS_FLAG | VARCHAR2 | 1 | Type of transaction controls, inclusive or exclusive, defined for the selected project or task. Valid code values are: Y - Inclusive and N - Exclusive | ||
| SOURCE_APPLICATION_CODE | VARCHAR2 | 30 | Identifier of the source application from which the project and tasks originate. The source application must be defined in the Source Application lookup type. | ||
| IMPORT_STATUS | VARCHAR2 | 30 | Status of the record load from the interface table to the database. Valid values are SUBMITTED,PROCESSING,SUCCESS and ERROR. | ||
| SOURCE_TASK_REFERENCE | VARCHAR2 | 100 | Identifier of the task in the source system from which the task is imported. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Identifier of the process that populated the interface table from a file. | ||
| PROJECT_NAME | VARCHAR2 | 240 | Name of the project to which the task belongs. | ||
| PROJECT_NUMBER | VARCHAR2 | 25 | Number of the project to which the task belongs. | ||
| LOAD_STATUS | VARCHAR2 | 30 | Status of the record load from the interface table to the database. Valid values are ON HOLD,COMPLETE and ABORTED. | ||
| PROJECT_ID | NUMBER | 18 | Identifier of the project to which the task belongs. | ||
| TASK_NAME | VARCHAR2 | 255 | Name of the task being imported. | ||
| TASK_NUMBER | VARCHAR2 | 100 | Number of the task being imported. | ||
| TASK_DESCRIPTION | VARCHAR2 | 2000 | Description of the task being imported. | ||
| PARENT_TASK_NUMBER | VARCHAR2 | 100 | User-defined number of the parent task. This column should be null if the task is a top level task. | ||
| PLANNING_START_DATE | DATE | Date on which the task is planned to start. | |||
| PLANNING_END_DATE | DATE | Date on which the task is planned to complete. | |||
| MILESTONE_FLAG | VARCHAR2 | 1 | Indicates if the task is a milestone task. | ||
| CRITICAL_FLAG | VARCHAR2 | 1 | Indicates if the task is part of the critical path. | ||
| CHARGEABLE_FLAG | VARCHAR2 | 1 | Indicates if expenditure items can be charged to the task. Only the lowest-level tasks can be chargeable. | ||
| BILLABLE_FLAG | VARCHAR2 | 1 | Indicates if transactions charged to the task can accrue revenue. | ||
| CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Indicates if expenditure items charged to the task can create capital assets. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or 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_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. | |
| 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. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE31 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE32 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE33 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE34 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE35 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE36 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE37 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE38 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE39 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE40 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE41 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE42 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE43 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE44 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE45 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE46 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE47 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE48 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE49 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE50 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE1_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE2_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE3_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE4_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE5_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE6_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE7_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE8_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE9_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE10_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE11_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE12_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE13_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE14_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE15_NUMBER | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE1_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE2_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE3_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE4_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE5_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE6_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE7_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE8_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE9_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE10_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE11_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE12_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE13_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE14_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE15_DATE | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SERVICE_TYPE_CODE | VARCHAR2 | 30 | The type of work performed on the task ***** | ||
| WORK_TYPE_ID | NUMBER | 18 | Work Types are predefined types of work, for example, Vacation, Training, and Administration. ***** | ||
| MANAGER_PERSON_ID | NUMBER | 18 | The identifier of the person who manages the task. This is a task-specific attribute. ***** | ||
| ALLOW_CROSS_CHARGE_FLAG | VARCHAR2 | 1 | Flag to indicate whether cross charge are allowed ***** | ||
| 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 project is a default for the task fixed date ***** | ||
| RECEIVE_PROJECT_INVOICE_FLAG | VARCHAR2 | 1 | Flag that indicates that the task may receive charges from internal supplies via inter-project billing ***** | ||
| CC_PROCESS_NL_FLAG | VARCHAR2 | 1 | Flag that indicates cross charge processing is to be performed for non-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 project is a default for the task fixed date ***** | ||
| FINANCIAL_TASK | VARCHAR2 | 1 | Specifies whether the task is FINANCIAL or EXECUTION. Valid values are Y and N. | ||
| SPRINT | VARCHAR2 | 240 | Sprint in which the task is completed or expected to be complete. Valid values are configured during application setup. | ||
| REQMNT_CODE | VARCHAR2 | 30 | Requirement Code | ||
| SCHEDULE_MODE | VARCHAR2 | 240 | SCHEDULE MODE | ||
| CONSTRAINT_TYPE | VARCHAR2 | 240 | Type of the Constraint | ||
| CONSTRAINT_DATE | DATE | Date of the Constraint | |||
| PLANNED_EFFORT | NUMBER | Planned effort for the task. | |||
| PLANNED_DURATION | NUMBER | Number of calendar days from the Task start date to the Task finish date. | |||
| PRIORITY | NUMBER | Priority of the task. | |||
| BASELINE_START_DATE | DATE | Baseline start date of the task. | |||
| BASELINE_FINISH_DATE | DATE | Baseline finish date of the task. | |||
| BASELINE_EFFORT | NUMBER | Baseline effort spent on the task. | |||
| BASELINE_DURATION | NUMBER | Number of calendar days from the Baseline start date to the Baseline finish date. | |||
| BASELINE_ALLOCATION | NUMBER | Allocation Percentage for baseline | |||
| BASELINE_LABOR_COST_AMOUNT | NUMBER | Labor Cost Amount for Baseline | |||
| BASELINE_LABOR_BILLED_AMOUNT | NUMBER | Labor Bill Amount for Baseline | |||
| BASELINE_EXPENSE_COST_AMOUNT | NUMBER | Expense Cost Amount for a Baseline | |||
| RECORD_STATUS | VARCHAR2 | 1 | Indicates the status of this record, either 'C' or 'U'. | ||
| TASK_ID | NUMBER | 18 | Unique identifier of the task. | ||
| TASK_VERSION_ID | NUMBER | 18 | Identifier of the task version. | ||
| TOP_TASK_ID | NUMBER | 18 | Identifier of the top level task to which this task belongs. | ||
| PARENT_TASK_ID | NUMBER | 18 | Identifier of the parent task. | ||
| PARENT_TASK_VER_ID | NUMBER | 18 | Identifier of the parent task version. | ||
| PARENT_STRUCTURE_ID | NUMBER | 18 | Unique identifier of the structure. | ||
| PARENT_STRUCT_VER_ID | NUMBER | 18 | Identifier of the structure version. | ||
| OBJECT_TYPE | VARCHAR2 | 30 | Type of the object. | ||
| PARENT_OBJECT_TYPE | VARCHAR2 | 30 | Type of the parent object. | ||
| WBS_LEVEL | NUMBER | 3 | Level of task in the hierarchy. | ||
| DISPLAY_SEQUENCE | NUMBER | 18 | Sequence of task in the hierarchy. | ||
| LEAF_NODE_FLAG | VARCHAR2 | 1 | Indicates whether financial task is a lowest level task. | ||
| EXECUTION_LEAF_FLAG | VARCHAR2 | 1 | Indicates whether execution task is the lowest level task. | ||
| START_DATE | DATE | Transaction start date. | |||
| COMPLETION_DATE | DATE | Transaction completion date. | |||
| ETC_CALC_METHOD | VARCHAR2 | 30 | ETC calculation method used for this task. | ||
| PERCENT_COMP_CALC_METHOD | VARCHAR2 | 30 | Percent complete calculation method used for this task. | ||
| ORGANIZATION_NAME | VARCHAR2 | 240 | Name of the task organization. | ||
| CARRYING_OUT_ORGANIZATION_ID | NUMBER | 18 | Identifier of the task organization. | ||
| CLIN_ELEMENT_ID | NUMBER | 18 | Identifier of the parent task, which is derectly linked to the contract line. | ||
| IC_CLIN_ELEMENT_ID | NUMBER | 18 | Identifier of the Inter-company contract linkage. | ||
| CINT_ELIGIBLE_FLAG | VARCHAR2 | 1 | Flag determines whether project is eligible for capitalized interest. | ||
| CINT_STOP_DATE | DATE | Stop date for capital interest calculation. | |||
| 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. | |||
| NL_TP_SCHEDULE_ID | NUMBER | 18 | Identifier of transfer price schedule to use for cross charged non-labor transactions. | ||
| 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. | |||
| LABOR_TP_SCHEDULE_ID | NUMBER | 18 | Identifier of transfer price schedule to use for cross charged labor transactions. | ||
| LABOR_COST_MULTIPLIER_NAME | VARCHAR2 | 20 | The labor cost multiplier defined for the task of a project. | ||
| OVR_COST_IND_RATE_SCH_ID | NUMBER | 18 | Overridden identifier of costing burden schedule. | ||
| COST_IND_SCH_FIXED_DATE | DATE | The schedule fixed date of firm costing burden schedule. | |||
| COST_IND_RATE_SCH_ID | NUMBER | 18 | The identifier of default costing burden schedule. | ||
| GEN_ETC_SOURCE_CODE | VARCHAR2 | 30 | ETC source code. | ||
| RETIREMENT_COST_FLAG | VARCHAR2 | 1 | Retirement cost flag. | ||
| PLANNING_DATES_ROLLUP_FLAG | VARCHAR2 | 1 | Flag to indicate if rollup of dates is required. | ||
| SPRINT_ID | NUMBER | 18 | Identifier of the sprint in which the task is completed or expected to be complete. | ||
| RQMT_ID | NUMBER | 18 | Identifier of the requirement | ||
| BATCH_ID | NUMBER | 18 | Internal Identifier of the batch in which this record is being processed. | ||
| PROCESSING_MODE | VARCHAR2 | 10 | Indicates the processing mode. Valid values are Create, Update, and Delete. The default value is Create. | ||
| STATUS | VARCHAR2 | 20 | The status of the milestone. Valid values for the status of a nonbillable milestone are Not started, In progress, and Complete. Valid values for the status of a billable milestone are Not started, In progress, Rejected, and Completion approval requested. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_PROJ_ELEMENTS_XFACE_N1 | Non Unique | Default | REQUEST_ID, PROJECT_ID, TASK_NUMBER |
| PJF_PROJ_ELEMENTS_XFACE_N2 | Non Unique | Default | PROJECT_NAME |
| PJF_PROJ_ELEMENTS_XFACE_N3 | Non Unique | Default | PARENT_TASK_ID |
| PJF_PROJ_ELEMENTS_XFACE_U1 | Unique | Default | PROJ_ELEMENT_XFACE_ID |