Work Definition Name
The Work Definition Name view object contains information about the work definition names that are used to define the different ways of making a given product. They're used in both discrete manufacturing and process manufacturing work definitions.
Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WDNameExtractPVO
Primary Keys : WorkDefinitionNameId, WorkDefinitionNameTranslationPEOLanguage, WorkDefinitionNameTranslationPEOWorkDefinitionNameId
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 Name descriptive flexfield. |
| AttributeChar1 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar10 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar11 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar12 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar13 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar14 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar15 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar16 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar17 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar18 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar19 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar2 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar20 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar3 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar4 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar5 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar6 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar7 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar8 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeChar9 | Character segment for the Work Definition Name descriptive flexfield. |
| AttributeDate1 | Date segment for the Work Definition Name descriptive flexfield. |
| AttributeDate2 | Date segment for the Work Definition Name descriptive flexfield. |
| AttributeDate3 | Date segment for the Work Definition Name descriptive flexfield. |
| AttributeDate4 | Date segment for the Work Definition Name descriptive flexfield. |
| AttributeDate5 | Date segment for the Work Definition Name descriptive flexfield. |
| AttributeNumber1 | Number segment for the Work Definition Name descriptive flexfield. |
| AttributeNumber10 | Number segment for the Work Definition Name descriptive flexfield. |
| AttributeNumber2 | Number segment for the Work Definition Name descriptive flexfield. |
| AttributeNumber3 | Number segment for the Work Definition Name descriptive flexfield. |
| AttributeNumber4 | Number segment for the Work Definition Name descriptive flexfield. |
| AttributeNumber5 | Number segment for the Work Definition Name descriptive flexfield. |
| AttributeNumber6 | Number segment for the Work Definition Name descriptive flexfield. |
| AttributeNumber7 | Number segment for the Work Definition Name descriptive flexfield. |
| AttributeNumber8 | Number segment for the Work Definition Name descriptive flexfield. |
| AttributeNumber9 | Number segment for the Work Definition Name descriptive flexfield. |
| AttributeTimestamp1 | Date and Time segment for the Work Definition Name descriptive flexfield. |
| AttributeTimestamp2 | Date and Time segment for the Work Definition Name descriptive flexfield. |
| AttributeTimestamp3 | Date and Time segment for the Work Definition Name descriptive flexfield. |
| AttributeTimestamp4 | Date and Time segment for the Work Definition Name descriptive flexfield. |
| AttributeTimestamp5 | Date and Time segment for the Work Definition Name descriptive flexfield. |
| CreatedBy | User who created the work definition name record. |
| CreationDate | Date when the work definition name record was created. |
| EffectiveFromDate | Date from when this work definition name is effective. |
| EffectiveToDate | Date from when this work definition name is no longer effective. |
| Language | Code of the language into which the contents of the translatable columns are translated. |
| LastUpdateDate | Date and time when the user last updated the work definition name record. |
| LastUpdateLogin | Session login associated with the user who last updated the work definition name record. |
| LastUpdatedBy | User who last updated the work definition name record. |
| 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. |
| SeedDataSource | Source of seed data record. The value BULK_SEED_DATA_SCRIPT indicates that record was bulk loaded. Otherwise, it specifies the name of the seed data file. |
| SeededFlag | Indicates if the work definition name is seeded.. |
| UsedInPlanningFlag | Indicates if the work definition using the associated work definition name is used for planning. |
| WorkDefinitionCode | Alphanumeric value that uniquely identifies the work definition name. |
| WorkDefinitionNameId | Value that uniquely identifies the work definition name. This is the primary key of the Work Definition Name view object. |
| WorkDefinitionNameTranslationPEOCreatedBy | User who created the work definition name record. |
| WorkDefinitionNameTranslationPEOCreationDate | Date when the work definition name record was created. |
| WorkDefinitionNameTranslationPEOLanguage | Code of the language into which the contents of the translatable columns are translated. |
| WorkDefinitionNameTranslationPEOLastUpdateDate | Date and time when the user last updated the work definition name record. |
| WorkDefinitionNameTranslationPEOLastUpdateLogin | Session login associated with the user who last updated the work definition name record. |
| WorkDefinitionNameTranslationPEOLastUpdatedBy | User who last updated the work definition name record. |
| WorkDefinitionNameTranslationPEOObjectVersionNumber | 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. |
| WorkDefinitionNameTranslationPEOSeedDataSource | Source of seed data record. The value BULK_SEED_DATA_SCRIPT indicates that record was bulk loaded. Otherwise, it specifies the name of the seed data file. |
| WorkDefinitionNameTranslationPEOSourceLang | Code of the language in which the contents of the translatable columns were originally created. |
| WorkDefinitionNameTranslationPEOWorkDefName | Name of the work definition. |
| WorkDefinitionNameTranslationPEOWorkDefNameDescription | Description of the work definition name. |
| WorkDefinitionNameTranslationPEOWorkDefinitionNameId | Value that uniquely identifies the work definition name. This is the primary key of the Work Definition Name view object. |
| WorkDefinitionType | Indicates the type of this work definition. A list of accepted values is defined in the lookup type ORA_WIS_WORK_DEFINITION_TYPE. |