WBS

Description: The WBS object is used to store the work breakdown structure (WBS).

Field

Description

ACTUAL_DURATION

Duration between the Actual Start and Finish Dates using the project work calendar.

ACTUAL_FINISH_DATE

Task Actual Finish Date

ACTUAL_FINISH_DATE_ROLLUP

Rollup difference for actual finish date.

ACTUAL_START_DATE

Task Actual Start Date

ACTUAL_START_DATE_ROLLUP

Rollup difference for actual start date.

ATTRIBUTE_CATEGORY

Descriptive flexfield context field

ATTRIBUTE1

Descriptive flexfield segment

ATTRIBUTE10

Descriptive flexfield segment

ATTRIBUTE11

Descriptive flexfield segment

ATTRIBUTE12

Descriptive flexfield segment

ATTRIBUTE13

Descriptive flexfield segment

ATTRIBUTE14

Descriptive flexfield segment

ATTRIBUTE15

Descriptive flexfield segment

ATTRIBUTE2

Descriptive flexfield segment

ATTRIBUTE3

Descriptive flexfield segment

ATTRIBUTE4

Descriptive flexfield segment

ATTRIBUTE5

Descriptive flexfield segment

ATTRIBUTE6

Descriptive flexfield segment

ATTRIBUTE7

Descriptive flexfield segment

ATTRIBUTE8

Descriptive flexfield segment

ATTRIBUTE9

Descriptive flexfield segment

BASELINE_FINISH_DATE

Baseline finish date for the task or the workplan.

BASELINE_START_DATE

Baseline start date for the task or the workplan.

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

BILLABLE_FLAG

Default flag for items charged to the task that indicates if the item can accrue revenue (Y or N). For capital projects this flag is used as capitalizable_flag. For indirect projects this flag is set to N and is not used.

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 task.

BUDGET_CURRENT_QUANTITY

The current budget quantity for the task.

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 task.

BUDGET_ORIGINAL_QUANTITY

The original budget quantity for the task.

BUDGET_PROPOSED_COST

The proposed budget cost for the task.

BUDGET_PROPOSED_QUANTITY

The proposed budget quantity for the task.

BUDGET_STATUS_CODE

The budget status code for the task.

BUDGET_TYPE

The Name of budget type

BUDGET_TYPE_CODE

The type of budget

BUDGET_VERSION_NAME

The budget version name for the task.

BUDGET_VERSION_NUMBER

The budget version number for the task.

CALENDAR_ID

The identifier of the work calendar used to schedule the task. This is a task-specific attribute

CARRYING_OUT_ORGANIZATION

The identifier of the organization that is responsible for the work. The task organization is copied from the project organization when the task is created. This is a task-specific attribute.

CARRYING_OUT_ORGANIZATION_ID

The identifier of the organization that is responsible for the work. The task organization is copied from the project organization when the task is created. This is a task-specific attribute.

CHANGE_REASON_CODE

The reason to create this budget version

CHANGE_REASON_NAME

The reason to create the budget line

CHARGEABLE_FLAG

Flag that indicates if expenditure items can be charged to the task. Only lowest level tasks can be chargeable

CLOSED_DATE

The date that the element status was set to Closed. This is a task-specific attribute.

COMPLETION_DATE

The date on which the task is completed; expenditure items with item dates after the task completion date cannot be entered for the task. You must enter a start date to enter a completion date.

CONSTRAINT_DATE

Constraint Date for the task version.

CONSTRAINT_TYPE_CODE

Constraint Type for the task version.

COST_IND_SCH_FIXED_DATE

The schedule fixed date of firm costing burden schedule

CRITICAL_FLAG

Flag that indicates if the task version is part of the critical path. This is a task-specific attribute

CST_COST_PLUS_STRUCTURE

Costing burden structure

CST_IND_RATE_SCH_NAME

The Name of default costing burden schedule

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.

DESCRIPTION

Description of the element

DURATION

Planned duration for the task.

EARLY_FINISH_DATE

The early finish date of the workplan version

EARLY_START_DATE

The early start date of the workplan version

ELEMENT_VERSION_ID

The unique identifier for the element version

ESTIMATED_DURATION

Duration between the Estimated Start and Finish Dates using the project work calendar.

ESTIMATED_FINISH_DATE

The estimated finish date of the workplan version

ESTIMATED_FINISH_DATE_ROLLUP

Rollup difference for estimated finish date.

ESTIMATED_START_DATE

The estimated start date of the workplan version

ESTIMATED_START_DATE_ROLLUP

Rollup difference for estimated start date

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

FREE_SLACK

Free Slack for the task version.

LABOR_BILL_RATE_ORG_ID

The identifier of the organization that owns the labor standard bill rate schedule

LABOR_BILL_RATE_ORG_NAME

The Name of the organization that owns the labor standard bill rate schedule

LABOR_COST_MULTIPLIER_NAME

The labor cost multiplier defined for the task of a premium project. The labor cost multiplier is populated for all overtime expenditure items charged to the task upon manual entry of the items or in the Overtime Calculation program

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_SCH_TYPE

The schedule type of labor expenditure items

LABOR_SCHEDULE_DISCOUNT

The percentage to be discounted from the task standard labor bill rate schedule

LABOR_SCHEDULE_FIXED_DATE

The date used to determine the effective bill rates of the task standard labor bill rate schedule. If no fixed date is entered, the expenditure item date is used to determine the effective bill rate for the item

LABOR_UNIT_OF_MEASURE

The unit of measure of labor hours for the project. This is always set to Hours.

LATE_FINISH_DATE

The late finish date of the workplan version

LATE_START_DATE

The late start date of the workplan version

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

LONG_TASK_NAME

Task Long Name

MANAGER_PERSON_ID

The identifier of the person who manages the task. This is a task-specific attribute.

MILESTONE_FLAG

Flag that indicates if the task version is a milestone. This is a task-specific attribute

NON_LABOR_BILL_RATE_ORG_ID

The identifier of the organization that owns the non-labor standard bill rate schedule

NON_LABOR_BILL_RATE_ORG_NAME

The Name of the organization that owns the non-labor standard bill rate schedule

NON_LABOR_SCH_TYPE

The schedule type of non-labor expenditure items

NON_LABOR_SCHEDULE_DISCOUNT

The percentage to be discounted from the task standard non-labor bill rate schedule

NON_LABOR_SCHEDULE_FIXED_DATE

The fixed date used to determine the effective bill rates of the standard non-labor bill rate schedule. If no fixed date is entered, the expenditure item date is used to determine the effective bill rate of the item

OBLIGATION_FINISH_DATE

The obligation finish date of the workplan version

OBLIGATION_START_DATE

The obligation start date of the workplan version

OVR_COST_PLUS_STRUCTURE

The identifier of Override Costing burden structure

OVR_IND_RATE_SCH_NAME

The identifier of Override costing burden schedule

PARENT_PLAN_VERSION_ID

The identifier of the parent plan version. Applicable only for Organization forecast versions belonging to Sub-organizations.

PARENT_TASK_ID

EBS unique identifier for task parent.

PERCENT_COMPLETE

Task Percent Complete.

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

PLANNED_COST

The planned cost for the task.

PLANNED_EFFORT

The Planned Effort for the task

PM_PRODUCT_CODE

The identifier of the external project management system from which the budget was imported.

PM_SOURCE_REFERENCE

The identifier of the element version in the source system from which the element was imported

PM_TASK_REFERENCE

The identifier of the task in 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

Project Id of the associated project.

PROJECT_RATE_DATE

Task level default value for project rate date

PROJECT_RATE_TYPE

Task level default value for project rate type

PROJECT_RAW_COST

The project raw cost

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

READY_TO_BILL_FLAG

Flag that indicates whether the task is authorized to be invoiced. The flag is set only for top tasks, defaults to 'Y' upon creation of the task and is set to 'Y' or 'N' in the Control Revenue and Billing by Top Task form

READY_TO_DISTRIBUTE_FLAG

Flag that indicates whether the task is authorized for revenue accrual. The flag is set only for top tasks, defaults to 'Y' upon creation of the task, and is set to 'Y' or 'N' in the Control Revenue and Billing by Top Task form

RESOURCE_LIST_ID

The identifier of the resource list used by the budget version

RESOURCE_LIST_NAME

Resource List Name

RETIREMENT_COST_FLAG

Flag to identify tasks for retirement cost collection.

SCHEDULED_FINISH_DATE

Task Planned Finish Date.

SCHEDULED_FINISH_DATE_ROLLUP

Rollup difference for scheduled finish date.

SCHEDULED_START_DATE

Task Planned Start Date.

SCHEDULED_START_DATE_ROLLUP

Rollup difference for scheduled start date.

SERVICE_TYPE_CODE

The type of work performed on the task

START_DATE

The date on which the task starts; expenditure items with item dates before the start date cannot be entered for the task

STATUS_CODE

The status of the project element

TASK_ID

EBS Unique Identifier for Task.

TASK_LEVEL

The level of the task in WBS hierarchy. A value of 'L' indicates leaf level, 'M' indicate Middle Level and 'T' indicates top task.

TASK_MANAGER

The person who manages the task. This is a task-specific attribute.

TASK_NAME

EBS Task Name.

TASK_NUMBER

EBS Task Number.

TASK_STATUS

This column stores the status of tasks created using the Change Management flow.

TASK_TYPE

The type that the user specifies for the task. This is a task-specific attribute.

TASKFUNC_COST_RATE_DATE

Task level default value for project functional cost rate date.

TASKFUNC_COST_RATE_TYPE

Task level default value for project functional cost rate type.

TOP_TASK_ID

The identifier of the top task to which this tasks rolls up. If the task is a top task, the top_task_id is set to its own task_id.

TOP_TASK_NUMBER

Top Task Number

TOTAL_SLACK

Total Slack for the task version.

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

TYPE_ID

The type that the user specifies for the task. This is a task-specific attribute.

VERSION_TYPE

The planning type of the financial plan. Valid values are COST, REVENUE, ALL and ORG_FORECAST

WORK_TYPE_NAME

Work Type name are predefined types of work, for example, Vacation, Training, and Administration.

Related Topics

E-Business Suite Business Objects

Activity

BudgetDetails

BudgetHeader

ExpenseCategory

FinancialPeriod

Project

Relationship

Resource

ResourceAssignment

ResourceRate

Role

RoleRate



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

Last Published Thursday, March 26, 2015