PJO_PLAN_VERSIONS_XFACE
PJO_PLAN_VERSIONS_XFACE table is used to import budgets and forecasts from an external application into Oracle Fusion Project Control. The Import Project Budgets and Import Project Forecasts processes validate and import data from this interface table into Oracle Fusion Project Control transaction tables.
Details
-
Schema: FUSION
-
Object owner: PJO
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJO_PLAN_VERSION_XFACE_PK |
PLAN_VERSION_XFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PLAN_VERSION_XFACE_ID | NUMBER | 18 | Yes | Identifier of the interface table row. | |
| TEMP_RBS_ELEMENT_ID | NUMBER | 18 | This is to store the unique reference id for each create resource row sent to pjf create resource api. | ||
| RESOURCE_FORMAT | VARCHAR2 | 240 | Resource format name as specified in the PRBS for the resource to be created. | ||
| FIRSTLEVEL_RSRC_NAME | VARCHAR2 | 300 | Name of the first level resource | ||
| SECONDLEVEL_RSRC_NAME | VARCHAR2 | 300 | Second level resource name | ||
| THIRDLEVEL_RSRC_NAME | VARCHAR2 | 300 | Third level resource name | ||
| SPREAD_CURVE_NAME | VARCHAR2 | 240 | Name of the spread curve for the resource | ||
| RESOURCE_CLASS_NAME | VARCHAR2 | 240 | Name of the resource class | ||
| FUNDING_SOURCE_NUMBER | VARCHAR2 | 50 | Funding source number along with id is used to sponsor the project for which the award budget is being created. | ||
| AWARD_ID | NUMBER | 18 | Award id along with award number is used to identify the award which is being used to sponsor the project for which the budget is being created. | ||
| FUNDING_SOURCE_NAME | VARCHAR2 | 240 | Funding source name along with id is used to sponsor the project for which the award budget is being created. | ||
| FUNDING_SOURCE_ID | NUMBER | 18 | Funding source id is used to sponsor the project for which the award budget is being created. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Identifier of the process that populated the interface table from a file. | ||
| AWARD_NUMBER | VARCHAR2 | 120 | Award number is used to identify the award which is being used to sponsor the project for which the budget is being created. | ||
| FINANCIAL_PLAN_TYPE | VARCHAR2 | 240 | Financial plan type that the budget or forecast uses as a template for generating cost and revenue amounts. | ||
| PROJECT_NAME | VARCHAR2 | 240 | Name of the project to which the budgets or forecasts belong. | ||
| PROJECT_NUMBER | VARCHAR2 | 240 | Number of the project to which the budgets or forecasts belong. | ||
| PROJECT_ID | NUMBER | 18 | Identifier of the project to which the budgets or forecasts belong. | ||
| TASK_NAME | VARCHAR2 | 255 | Name of the task. | ||
| TASK_NUMBER | VARCHAR2 | 100 | Number of the task. | ||
| TASK_ID | NUMBER | 18 | Identifier of the task. | ||
| PLAN_VERSION_NAME | VARCHAR2 | 225 | Name of the plan version | ||
| PLAN_VERSION_DESCRIPTION | VARCHAR2 | 2000 | Description of the plan version | ||
| RESOURCE_NAME | VARCHAR2 | 240 | Name of the resource assigned to the budget or forecast. | ||
| RBS_ELEMENT_ID | NUMBER | 18 | Identifier of the resource in the planning resource breakdown structure. | ||
| RESOURCE_CLASS_CODE | VARCHAR2 | 30 | Code for the resource class to which the planning resource belongs. | ||
| PRBS_NAME | VARCHAR2 | 240 | Name of the planning resource breakdown structure used for the plan version. | ||
| PLANNING_START_DATE | DATE | Planned date for the resource to begin an assignment on a project task. | |||
| PLANNING_END_DATE | DATE | Planned date for the resource to finish an assignment on a project task. | |||
| PERIOD_NAME | VARCHAR2 | 15 | Name of the planning period. | ||
| PERIOD_START_DATE | DATE | First day of the planning period for the resource. | |||
| PERIOD_END_DATE | DATE | Last day of the planning period for the resource. | |||
| PLANNING_CURRENCY | VARCHAR2 | 15 | Project currency code for the resource. | ||
| TOTAL_QUANTITY | NUMBER | Planned amount of work, money, or units for the specified period. Hours indicates work, transaction currency indicates money, and unit of measure indicates units. | |||
| TOTAL_TC_RAW_COST | NUMBER | Planned costs plus burdened markups for the specified period. | |||
| TOTAL_TC_REVENUE | NUMBER | Amounts recognized as income or the expected billing to be received for work or sales in the specified period. | |||
| SRC_BUDGET_LINE_REFERENCE | VARCHAR2 | 25 | Identifier of the budget or forecast line detail in the source application from which the budget or forecast was imported. | ||
| PLAN_VERSION_STATUS | VARCHAR2 | 20 | Status for the new budget or forecast version that was created. | ||
| LOAD_STATUS | VARCHAR2 | 30 | Status of the record load from the interface table to the database. Valid values are PROCESSING, ERROR, and PROCESSED. | ||
| 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. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to 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. | |
| TOTAL_TC_BRDND_COST | NUMBER | Planned costs plus burdened markups for the specified period. | |||
| PROCESS_CODE | VARCHAR2 | 50 | Identifier for the process that can import either budgets or forecasts. | ||
| ACT_QUANTITY | NUMBER | Actual amount of work, money, or units for the specified period. Hours indicates work, transaction currency indicates money, and unit of measure indicates units. | |||
| TC_ACT_RAW_COST | NUMBER | Actual raw cost for the specified period. | |||
| TC_ACT_BRDND_COST | NUMBER | Actual burdened cost for the specified period. | |||
| TC_ACT_REVENUE | NUMBER | Actual amounts recognized as income or the expected billing to be received for work or sales in the specified period. | |||
| PC_RAW_COST | NUMBER | Raw costs for the specified period, in the project currency. | |||
| PFC_RAW_COST | NUMBER | Raw costs for the specified period, in the project functional currency. | |||
| PC_BRDND_COST | NUMBER | Burdened costs for the specified period, in the project currency. | |||
| PFC_BRDND_COST | NUMBER | Burdened costs for the specified period, in the project functional currency. | |||
| PC_REVENUE | NUMBER | Amounts recognized as income or the expected billing to be received for work or sales in the specified period, in the project currency. | |||
| PFC_REVENUE | NUMBER | Amounts recognized as income or the expected billing to be received for work or sales in the specified period, in the project functional currency. | |||
| LINE_TYPE | VARCHAR2 | 20 | Indicates if the record is assignment level or periodic data. | ||
| 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. | ||
| 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. | ||
| TASK_START_DATE | DATE | Start date of the financial task. | |||
| TASK_END_DATE | DATE | End date of the financial task. | |||
| PERSON_ID | NUMBER | 18 | Person identifier of the labor resource. | ||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | Expenditure type identifier of the expense resource. | ||
| PHYSICAL_PERCENT_COMPLETE | NUMBER | Physical percent complete of the lowest level financial task.Should be null for other tasks. | |||
| TASK_OR_ASGMT_FLAG | VARCHAR2 | 1 | Flag indicates whether the row is a task row or assignment row.'T' for task row and 'R' for resource assignment row. | ||
| RATE_BASED_FLAG | VARCHAR2 | 1 | Flag indicates whether the resource is rate based.'Y' for rate based row and 'N' for non rate based row. | ||
| ENABLED_FLAG | VARCHAR2 | 1 | Flag indicates whether the resource is enabled or disabled. Valid values are 'Y' or 'N' . | ||
| PC_ACT_RAW_COST | NUMBER | To provide Actual Raw cost in Project Currency | |||
| PC_ACT_BRDND_COST | NUMBER | To provide Actual Burdened cost in Project Currency | |||
| PC_ACT_REVENUE | NUMBER | To provide Actual Revenue in Project Currency | |||
| PFC_ACT_RAW_COST | NUMBER | To provide Actual Raw cost in Project Ledger Currency | |||
| PFC_ACT_BRDND_COST | NUMBER | To provide Actual Burdened cost in Project Ledger Currency | |||
| PFC_ACT_REVENUE | NUMBER | To provide Actual Revenue in Project Ledger Currency | |||
| 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. | |||
| BATCH_ID | NUMBER | 18 | Internal Identifier of the batch in which this record is being processed. | ||
| ORGANIZATION_ID | NUMBER | 18 | Indicates the organization of the resource. | ||
| JOB_ID | NUMBER | 18 | Indicates the job of the resource. | ||
| EXPENDITURE_CATEGORY_ID | NUMBER | 18 | Indicates the expenditure category of the resource. | ||
| PROCESSING_MODE | VARCHAR2 | 10 | Indicates the processing mode. Valid values are Create, Update, and Delete. The default value is Create. | ||
| PROJECT_ROLE_ID | NUMBER | 18 | Unique identifier of the project role. | ||
| PLAN_VERSION_NUMBER | NUMBER | 18 | Number of the budget or forecast version. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJO_PLAN_VERSION_XFACE_N1 | Non Unique | FUSION_TS_TX_DATA | LOAD_REQUEST_ID, PROJECT_NAME, PLAN_VERSION_NAME |
| PJO_PLAN_VERSION_XFACE_N2 | Non Unique | Default | REQUEST_ID, PROJECT_ID, PLAN_VERSION_NAME |
| PJO_PLAN_VERSION_XFACE_U1 | Unique | FUSION_TS_TX_DATA | PLAN_VERSION_XFACE_ID |