ResourceAssignment

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.

Related Topics

E-Business Suite Business Objects

Activity

BudgetDetails

BudgetHeader

ExpenseCategory

FinancialPeriod

Project

Relationship

Resource

ResourceRate

Role

RoleRate

WBS



Legal Notices
Copyright © 2013, 2015, Oracle and/or its affiliates. All rights reserved.

Last Published Thursday, March 26, 2015