Work Center Calendar

The Work Center Calendar view object contains the plant and override calendars associated to the work center for an effective date range.

Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WorkCenterProductionCalendarExtractPVO

Primary Keys : WcProdCalendarId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name Description
CreatedBy User who created the work center calendar record.
CreationDate Date and time when the user created the work center calendar record.
EffectiveFromDate Date and time from when the work center calendar is effective.
EffectiveToDate Date and time when the work center calendar is effective.
LastUpdateDate Date and time when the user last updated the work center calendar record.
LastUpdateLogin Session login associated with the user who most recently updated the work center calendar record.
LastUpdatedBy User who last updated the work center calendar record.
MfgCalendarId Value that uniquely identifies the calendar in the resource shift. This is a foreign key to the Schedule view object.
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.
WcProdCalendarId Value that uniquely identifies the work center calendar. This is the primary key of the Work Center Calendar view object.
WorkCenterId Value that uniquely identifies the work center in the resource shift. This is a foreign key to the Work Center view object.