Attributes for Worker Assignment Work Measure

This table lists the main attributes of the Worker Assignment Work Measure business object and exceptions for any attribute, if any.

Attribute

Field Name

Description

ACTION_OCCURRENCE_ID

When and Why ID

Foreign Key to PER_ACTION_OCCURRENCES.

ADDS_TO_BUDGET

Adds to Budget

Determines whether an actual assignment is considered as part of the total budget.

ASSIGN_WORK_MEASURE_ID

Work Measure ID

System-generated primary key column.

ASSIGNMENT_ID

Assignment ID

Foreign key to PER_ALL_ASSIGNMENTS_M.

BUSINESS_GROUP_ID

Business Group ID

Identifier of enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS.

CALCULATE_WORKMEASURE_FLAG

Calculate Work Measure

Capture the option whether to recalculate the FTE HeadCount value.

CREATED_BY

Created By

Who column: Indicates the user who created the row.

CREATION_DATE

Creation Date

Who column: Indicates the date and time of the creation of the row.

EFFECTIVE_END_DATE

End Date

Date Effective Entity: Indicates the date at the end of the date range within which the row is effective.

EFFECTIVE_START_DATE

Start Date

Date Effective Entity: Indicates the date at the beginning of the date range within which the row is effective.

LAST_UPDATE_DATE

Last Update Date

Who column: Indicates the date and time of the last update of the row.

LAST_UPDATE_LOGIN

Last Updated Login

Who column: Indicates the session login associated with the user who last updated the row.

LAST_UPDATED_BY

Last Updated By

Who column: Indicates the user who last updated the row.

LEGISLATION_CODE

Legislation Code

The unique code identifying legislation.

OBJECT_VERSION_NUMBER

Object Version Number

Used to implement optimistic locking. This number is incremented every time 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.

UNIT

Budget Unit

Budget measurement units, for example, headcount, FTE, points.

VALUE

Budget Value

Budget measurement value.

For more information about the Worker Assignment Work Measure attributes, refer to the Tables and Views for HCM guide on the Oracle Help Center.