Description: The ResourceAssignment object stores the Resource Assignment at the lowest level task.
Field | Description |
---|---|
ACTIVITY_ID | The unique identifier of the associated activity. |
ACTUAL_COST | The actual cost in the resource assignment. |
ACTUAL_QUANTITY | The actual quantity in the resource assignment (related to actual cost). |
ALIAS | Resource Name |
ASSIGNMENT_DESCRIPTION | It stores the description of the assignment. |
ATTRIBUTE_CATEGORY | Descriptive flexfield context field |
ATTRIBUTE1 | Descriptive flexfield. |
ATTRIBUTE10 | Descriptive flexfield. |
ATTRIBUTE11 | Descriptive flexfield. |
ATTRIBUTE12 | Descriptive flexfield. |
ATTRIBUTE13 | Descriptive flexfield. |
ATTRIBUTE14 | Descriptive flexfield. |
ATTRIBUTE15 | Descriptive flexfield. |
ATTRIBUTE16 | Descriptive flexfield. |
ATTRIBUTE17 | Descriptive flexfield. |
ATTRIBUTE18 | Descriptive flexfield. |
ATTRIBUTE19 | Descriptive flexfield. |
ATTRIBUTE2 | Descriptive flexfield. |
ATTRIBUTE20 | Descriptive flexfield. |
ATTRIBUTE21 | Descriptive flexfield. |
ATTRIBUTE22 | Descriptive flexfield. |
ATTRIBUTE23 | Descriptive flexfield. |
ATTRIBUTE24 | Descriptive flexfield. |
ATTRIBUTE25 | Descriptive flexfield. |
ATTRIBUTE26 | Descriptive flexfield. |
ATTRIBUTE27 | Descriptive flexfield. |
ATTRIBUTE28 | Descriptive flexfield. |
ATTRIBUTE29 | Descriptive flexfield. |
ATTRIBUTE3 | Descriptive flexfield. |
ATTRIBUTE4 | Descriptive flexfield. |
ATTRIBUTE5 | Descriptive flexfield. |
ATTRIBUTE6 | Descriptive flexfield. |
ATTRIBUTE7 | Descriptive flexfield. |
ATTRIBUTE8 | Descriptive flexfield. |
ATTRIBUTE9 | Descriptive flexfield. |
BASELINED_BY_PERSON_ID | The identifier of the person who baselined the budget |
BASELINED_BY_PERSON_NAME | Name of the person who baselined the budget |
BASELINED_DATE | The baselined date of the budget version |
BUD_LINE_ATTRIBUTE_CATEGORY | Budget Line Descriptive flexfield context field |
BUD_LINE_ATTRIBUTE1 | Budget Line Descriptive flexfield segment |
BUD_LINE_ATTRIBUTE10 | Budget Line Descriptive flexfield segment |
BUD_LINE_ATTRIBUTE11 | Budget Line Descriptive flexfield segment |
BUD_LINE_ATTRIBUTE12 | Budget Line Descriptive flexfield segment |
BUD_LINE_ATTRIBUTE13 | Budget Line Descriptive flexfield segment |
BUD_LINE_ATTRIBUTE14 | Budget Line Descriptive flexfield segment |
BUD_LINE_ATTRIBUTE15 | Budget Line Descriptive flexfield segment |
BUD_LINE_ATTRIBUTE2 | Budget Line Descriptive flexfield segment |
BUD_LINE_ATTRIBUTE3 | Budget Line Descriptive flexfield segment |
BUD_LINE_ATTRIBUTE4 | Budget Line Descriptive flexfield segment |
BUD_LINE_ATTRIBUTE5 | Budget Line Descriptive flexfield segment |
BUD_LINE_ATTRIBUTE6 | Budget Line Descriptive flexfield segment |
BUD_LINE_ATTRIBUTE7 | Budget Line Descriptive flexfield segment |
BUD_LINE_ATTRIBUTE8 | Budget Line Descriptive flexfield segment |
BUD_LINE_ATTRIBUTE9 | Budget Line Descriptive flexfield segment |
BUD_LINE_BURDENED_COST | The burdened cost of the budget line |
BUD_VER_ATTRIBUTE_CATEGORY | Budget Version Descriptive flexfield context field |
BUD_VER_ATTRIBUTE1 | Budget Version Descriptive flexfield segment |
BUD_VER_ATTRIBUTE10 | Budget Version Descriptive flexfield segment |
BUD_VER_ATTRIBUTE11 | Budget Version Descriptive flexfield segment |
BUD_VER_ATTRIBUTE12 | Budget Version Descriptive flexfield segment |
BUD_VER_ATTRIBUTE13 | Budget Version Descriptive flexfield segment |
BUD_VER_ATTRIBUTE14 | Budget Version Descriptive flexfield segment |
BUD_VER_ATTRIBUTE15 | Budget Version Descriptive flexfield segment |
BUD_VER_ATTRIBUTE2 | Budget Version Descriptive flexfield segment |
BUD_VER_ATTRIBUTE3 | Budget Version Descriptive flexfield segment |
BUD_VER_ATTRIBUTE4 | Budget Version Descriptive flexfield segment |
BUD_VER_ATTRIBUTE5 | Budget Version Descriptive flexfield segment |
BUD_VER_ATTRIBUTE6 | Budget Version Descriptive flexfield segment |
BUD_VER_ATTRIBUTE7 | Budget Version Descriptive flexfield segment |
BUD_VER_ATTRIBUTE8 | Budget Version Descriptive flexfield segment |
BUD_VER_ATTRIBUTE9 | Budget Version Descriptive flexfield segment |
BUD_VER_BURDEN_COST | The burdened cost budget of the project. It is a denormalized column |
BUDGET_CURRENT_COST | The current budget cost for the assignment. |
BUDGET_CURRENT_QUANTITY | The current budget quantity for the assignment. |
BUDGET_ENTRY_METHOD | The method name used to enter the budget version |
BUDGET_ENTRY_METHOD_CODE | The method used to enter the budget version |
BUDGET_LINE_ID | Unique identifier of budget line |
BUDGET_ORIGINAL_COST | The original budget cost for the assignment. |
BUDGET_ORIGINAL_QUANTITY | The original budget quantity for the assignment. |
BUDGET_PROPOSED_COST | The proposed budget cost for the assignment. |
BUDGET_PROPOSED_QUANTITY | The proposed budget quantity for the assignment. |
BUDGET_STATUS_CODE | The budget status code for the assignment. |
BUDGET_TYPE | The Name of budget type |
BUDGET_TYPE_CODE | The type of budget |
BUDGET_VERSION_NAME | The budget version name for the assignment. |
BUDGET_VERSION_NUMBER | The budget version number for the assignment. |
CHANGE_REASON_CODE | The reason to create this budget version |
CHANGE_REASON_NAME | The reason to create the budget line |
CURRENT_ORIGINAL_FLAG | Flag that indicates whether the budget version is the current original budget |
CURRENT_PLANNING_PERIOD | Indicates anchoring period for a budget versions. |
END_DATE | The assignment end date. |
EXPENDITURE_CATEGORY | The expenditure category that classifies the expenditure type into a cost group. |
FIN_PLAN_TYPE_ID | The identifier of financial plan type |
FIN_PLAN_TYPE_NAME | Financial plan type name |
FIRST_BUDGET_PERIOD | First period for which to display amounts in budget matrix window |
IS_PRIMARY_RESOURCE | EBS Task Manager Flag. If true, the associated resource is marked as Task Manager for the Task. |
JOB_ID | The role element ID. |
LABOR_QUANTITY | The number of labor hours budgeted for the project. This is a denormalized column which sums the quantities for all labor resources budgeted. |
LABOR_UNIT_OF_MEASURE | The unit of measure of labor hours for the project. This is always set to Hours. |
LOCKED_BY_PERSON_ID | Identifier of the person who has locked the plan version |
LOCKED_BY_PERSON_NAME | Name of the person who has locked the plan version |
NON_LABOR_RESOURCE | Indicates the project non labor resource. |
PARENT_PLAN_VERSION_ID | The identifier of the parent plan version. Applicable only for Organization forecast versions belonging to Sub-organizations. |
PARENT_TASK_ID | The unique identifier of the task parent. |
PARENT_TASK_NUMBER | The parent wbs code of the associated activity. |
PERIOD_MASK_ID | The identifier of the period mask that is used for the plan version |
PERIOD_MASK_NAME | The period mask that is used for the plan version |
PERIOD_NAME | The period of the budget line |
PERSON_ID | The resource element ID. |
PLANNED_COST | The assignment planned cost. |
PLANNED_EFFORT | The planned working time for the resource assignment on the operation, from the resource's planned start date to the planned finish date. |
PLANNING_END_DATE | The assignment planned end date. |
PLANNING_START_DATE | The assignment planned start date. |
PM_PRODUCT_CODE | The identifier of the external project management system from which the budget was imported. |
PROJECT_BURDENED_COST | The project burdened cost |
PROJECT_COST_EXCHANGE_RATE | The project cost exchange rate |
PROJECT_COST_RATE_DATE | The cost rate date for project currency |
PROJECT_COST_RATE_DATE_TYPE | The project cost rate date type |
PROJECT_COST_RATE_TYPE | The project cost rate type |
PROJECT_CURRENCY_CODE | The project currency code |
PROJECT_ID | The unique identifier of the associated project. |
PROJECT_RAW_COST | The project raw cost |
PROJECT_ROLE_ID | Indicates the project role. |
PROJECT_ROLE_MEANING | Project role meaning |
PROJECT_STRUCTURE_VERSION_ID | The identifier of the project structure version. Applicable only if the version is in the context of an organization project or workplan version. |
PROJFUNC_COST_EXCHANGE_RATE | The project functional cost exchange rate |
PROJFUNC_COST_RATE_DATE | The cost rate date for project functional currency |
PROJFUNC_COST_RATE_DATE_TYPE | The project functional cost rate date type |
PROJFUNC_COST_RATE_TYPE | The project functional cost rate type |
PROJFUNC_CURRENCY_CODE | The project functional currency code |
RATE_BASED_FLAG | Indicates whether transactional is rate based |
RATE_EXPENDITURE_TYPE | Y indicates that planned effort is being held at task and resource level, N indicates that planned effort is being held at task level. |
RESOURCE_ASSIGNMENT_ID | The unique identifier of the assignment. |
RESOURCE_CLASS_CODE | The resource type: "PEOPLE", "EQUIPMENT", or "MATERIAL_ITEMS". |
RESOURCE_ID | The unique identifier the resource. |
RESOURCE_LIST_ID | The identifier of the resource list used by the budget version |
RESOURCE_LIST_NAME | Resource List Name |
RESOURCE_NUMBER | The name that uniquely identifies the resource. |
REVENUE_CATEGORY_CODE | The revenue category that classifies the expenditure type into a revenue group. |
ROLE_ID | The unique identifier the role. |
ROLE_NUMBER | The name that uniquely identifies the role. |
ROLLED_UP_TASK_ID | Rolled up Task Ids after filtering either by levels or tagging. |
SCHEDULE_END_DATE | Scheduled end date of the planning transaction |
SCHEDULE_START_DATE | Scheduled start date of the planning transaction |
SPREAD_CURVE_CODE | Spread Curve Code |
SPREAD_CURVE_ID | Indicates the spread curve ID. |
SPREAD_CURVE_NAME | Spread Curve Name |
START_DATE | The assignment start date. |
TASK_ID | The unique identifier of the associated Task. |
TASK_NUMBER | The activity code of the associated activity. |
TOTAL_PLAN_BURDENED_COST | This column applies to Project Forecasting. It Stores the total raw cost for the relevant project assignment. |
TOTAL_PLAN_QUANTITY | This column applies to Project Forecasting. It Stores the total quantity for the relevant project assignment. In current release, only labor hours are stored. |
TOTAL_PLAN_RAW_COST | This column applies to Project Forecasting. It Stores the total raw cost for the relevant project assignment. |
TXN_BURDENED_COST | The burdened cost in transaction currency |
TXN_COST_RATE_OVERRIDE | It stores the overriding cost rate of the assignment. |
TXN_CURRENCY_CODE | The transaction currency code of the amount |
TXN_DISCOUNT_PERCENTAGE | The discount percentage |
TXN_MARKUP_PERCENT | The markup percent. |
TXN_MARKUP_PERCENT_OVERRIDE | The override markup percent |
TXN_RAW_COST | The raw cost in transaction currency |
TXN_STANDARD_COST_RATE | It stores the standard cost rate |
VERSION_NAME | Budget Version Name |
VERSION_NUMBER | Budget Version Number |
VERSION_TYPE | The planning type of the financial plan. Valid values are COST, REVENUE, ALL and ORG_FORECAST |
WBS_ELEMENT_VERSION_ID | Indicates the work breakdown structure element version ID. Maintained only for workplan versions. |
E-Business Suite Business Objects
Legal Notices
Copyright © 2013, 2015,
Oracle and/or its affiliates. All rights reserved.
Last Published Thursday, March 26, 2015