Schedule Workday Patterns

The Schedule Pattern view object is used to assign one or more workday patterns to the schedule.

Data Store Key : FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.SchedulePatternExtractPVO

Primary Keys : SchedulePatternId

Initial Extract Date : SchedulePatternPEOCreationDate

Incremental Extract Date : SchedulePatternPEOLastUpdateDate

Attributes

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

Name	Description
SchedulePatternId	Value that uniquely identifies the pattern assignment to the parent schedule. It's a primary key that the application generates when a pattern is assigned to a schedule. This attribute is required.
SchedulePatternPEOCreatedBy	User who created the row.
SchedulePatternPEOCreationDate	Date and time of the creation of the row.
SchedulePatternPEOLastUpdateDate	Date and time of the last update of the row.
SchedulePatternPEOLastUpdateLogin	Session login associated to the user who last updated the row.
SchedulePatternPEOLastUpdatedBy	User who last updated the row.
SchedulePatternPEOObjectVersionNumber	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.
SchedulePatternPEOPatternId	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.
SchedulePatternPEOPatternSeqNum	Number that identifies the sequence order of each pattern assigned to a schedule.
SchedulePatternPEOScheduleId	Value that uniquely identifies the schedule. It's a primary key that the application generates when it creates a schedule. This attribute is required.