Workday Patterns
The Pattern view object defines how to apply one or more shifts to define the working time for any business object using the associated schedule. Workday patterns have length in days, and have associated shifts that detail what days are active within a pattern. Patterns repeat as part of a schedule definition from the schedule start date to the schedule end date, resulting in the shifts forming repeated patterns within the schedule.
Data Store Key : FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.PatternExtractPVO
Primary Keys : PatternId
Initial Extract Date : PatternPEOCreationDate
Incremental Extract Date : PatternPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| PatternId | Value that uniquely identifies the workday pattern. It's a primary key that the application generates when it creates a pattern. This attribute is required. |
| PatternPEOAttribute1 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute10 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute11 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute12 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute13 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute14 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute15 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute16 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute17 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute18 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute19 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute2 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute20 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute21 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute22 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute23 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute24 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute25 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute26 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute27 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute28 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute29 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute3 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute30 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute4 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute5 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute6 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute7 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute8 | Segment of the user-descriptive flexfield. |
| PatternPEOAttribute9 | Segment of the user-descriptive flexfield. |
| PatternPEOAttributeCategory | Structure definition of the user descriptive flexfield. |
| PatternPEOCreatedBy | User who created the row. |
| PatternPEOCreationDate | Date and time of the creation of the row. |
| PatternPEOLastUpdateDate | Date and time of the last update of the row. |
| PatternPEOLastUpdateLogin | Session login associated to the user who last updated the row. |
| PatternPEOLastUpdatedBy | User who last updated the row. |
| PatternPEOLengthDaysNum | Value of the number of days in a workday pattern. Specifies how many days the pattern will consume in a schedule and the assigned shifts in the pattern filling in this set of days, before the pattern repeats. This attribute is required. |
| PatternPEOObjectVersionNumber | Used to implement optimistic locking. This number is incremented every time that 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. |
| PatternPEOPatternTypeCode | Abbreviation that identifies the type of pattern being created. Valid values are time, duration, and elapsed. This attribute is required. |
| PatternTranslationPEOLanguage | Indicates the code of the language into which the contents of the translatable columns are translated. |
| PatternTranslationPEOPatternDesc | Description of the pattern that you provide when creating an instance. |
| PatternTranslationPEOPatternName | Name of the pattern that you provide when creating an instance. This attribute is required. |