Work Definition

The Work Definition view object contains information about how to produce a product, or process a batch in manufacturing, or execute a maintenance work with a predefined ordered set of operations. It also contains information about the material and labor required at every operation step.

Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WorkDefinitionExtractPVO

Primary Keys : WorkDefinitionId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
AttributeCategory Context name for the Work Definition descriptive flexfield.
AttributeChar1 Character segment for the Work Definition descriptive flexfield.
AttributeChar10 Character segment for the Work Definition descriptive flexfield.
AttributeChar11 Character segment for the Work Definition descriptive flexfield.
AttributeChar12 Character segment for the Work Definition descriptive flexfield.
AttributeChar13 Character segment for the Work Definition descriptive flexfield.
AttributeChar14 Character segment for the Work Definition descriptive flexfield.
AttributeChar15 Character segment for the Work Definition descriptive flexfield.
AttributeChar16 Character segment for the Work Definition descriptive flexfield.
AttributeChar17 Character segment for the Work Definition descriptive flexfield.
AttributeChar18 Character segment for the Work Definition descriptive flexfield.
AttributeChar19 Character segment for the Work Definition descriptive flexfield.
AttributeChar2 Character segment for the Work Definition descriptive flexfield.
AttributeChar20 Character segment for the Work Definition descriptive flexfield.
AttributeChar3 Character segment for the Work Definition descriptive flexfield.
AttributeChar4 Character segment for the Work Definition descriptive flexfield.
AttributeChar5 Character segment for the Work Definition descriptive flexfield.
AttributeChar6 Character segment for the Work Definition descriptive flexfield.
AttributeChar7 Character segment for the Work Definition descriptive flexfield.
AttributeChar8 Character segment for the Work Definition descriptive flexfield.
AttributeChar9 Character segment for the Work Definition descriptive flexfield.
AttributeDate1 Date segment for the Work Definition descriptive flexfield.
AttributeDate2 Date segment for the Work Definition descriptive flexfield.
AttributeDate3 Date segment for the Work Definition descriptive flexfield.
AttributeDate4 Date segment for the Work Definition descriptive flexfield.
AttributeDate5 Date segment for the Work Definition descriptive flexfield.
AttributeNumber1 Number segment for the Work Definition descriptive flexfield.
AttributeNumber10 Number segment for the Work Definition descriptive flexfield.
AttributeNumber2 Number segment for the Work Definition descriptive flexfield.
AttributeNumber3 Number segment for the Work Definition descriptive flexfield.
AttributeNumber4 Number segment for the Work Definition descriptive flexfield.
AttributeNumber5 Number segment for the Work Definition descriptive flexfield.
AttributeNumber6 Number segment for the Work Definition descriptive flexfield.
AttributeNumber7 Number segment for the Work Definition descriptive flexfield.
AttributeNumber8 Number segment for the Work Definition descriptive flexfield.
AttributeNumber9 Number segment for the Work Definition descriptive flexfield.
AttributeTimestamp1 Date and Time segment for the Work Definition descriptive flexfield.
AttributeTimestamp2 Date and Time segment for the Work Definition descriptive flexfield.
AttributeTimestamp3 Date and Time segment for the Work Definition descriptive flexfield.
AttributeTimestamp4 Date and Time segment for the Work Definition descriptive flexfield.
AttributeTimestamp5 Date and Time segment for the Work Definition descriptive flexfield.
BillSequenceId Value that uniquely identifies the item structure used in the work definition to define material requirements.
CostingPriority Value used in costing planning scenario to determine which work definition to use when rolling up costs for an item.
CreatedBy User who created the work definition.
CreationDate Date when the work definition was created.
InactiveDate Date when this work definition has become inactive.
InventoryItemId Value that uniquely identifies the primary output, assembly, subassembly, or model item in the inventory organization.
LastUpdateDate Date and time when the user last updated the work definition.
LastUpdateLogin Session login associated with the user who last updated the work definition.
LastUpdatedBy User who last updated the work definition.
MinimumTransferQuantity Indicates the minimum quantity defined in order for an item in the Work Definition to schedule overlapping and sequential operations of work orders.
ObjectVersionNumber Number of times the object row was updated. This attribute is 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.
OrganizationId Value that uniquely identifies the manufacturing plant to which this work definition belongs.
PreassignLotFlag Indicates if work orders created from this work definition can have preassigned lot numbers for primary product and outputs.
ProductionPriority Indicates the relative rank of the work definition compared to other work definitions for the item. The work definition with a priority of 1 for an item is considered the primary work definition.
Quantity Quantity of the production batch used for batch sizing and scaling based on which all input and output quantities are defined.
ResequenceFlag Indicates if the work definition has resequence enabled operations.
SerialTrackingFlag Indicates if the work definition is serial tracked where the item is tracked by serial numbers during work execution.
StatusCode Indicates the status of the work definition. A list of accepted values is defined in the lookup type ORA_WIS_WD_APPROVAL_STATUS.
SystemGeneratedFlag Indicates if the work definition was automatically created by the application.
TransformFromItemId Value that uniquely identifies the item that's transformed to a new item on a Transform work definition.
UomCode Unit of measure code of the work definition quantity.
WdMntNameId Value that uniquely identifies the name of the maintenance work definition. This is a foreign key to the Maintenance Work Definition Name view object.
WorkDefinitionHeaderName Name of the process associated to the process manufacturing work definition.
WorkDefinitionId Value that uniquely identifies the work definition. This is the primary key of the Work Definition view object.
WorkDefinitionNameId Value that uniquely identifies the work definition name assigned to the work definition. This is a foreign key to the Work Definition Name view object.
WorkDefinitionType Indicates the type of work definition. A list of accepted values is defined in the lookup type ORA_WIS_WORK_DEFINITION_TYPE.
WorkMethodId Value that uniquely identifies the work method of the work definition. This is a foreign key to the Work Method view object.
WorkOrderSubType Work order subtype associated to the work definition that's defaulted at the time of creating a maintenance work order. A list of accepted values is defined in the lookup type ORA_WIE_WO_SUB_TYPE.
WorkOrderType Work order type associated to the work definition that's defaulted at the time of creating a maintenance work order. A list of accepted values is defined in the lookup type ORA_WIE_WO_TYPE.