Schedule Details for Extraction

The Schedule Details for Extraction view object collects the details for working and nonworking dates and times in a schedule.

Data Store Key : FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.ScheduleDetailExtractPVO

Primary Keys : ScheduleDetailId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
AvlExceptionId	Value that uniquely identifies the schedule exception used to define the details. This is a foreign key to the Schedule Exception view object.
CreatedBy	User who created the row.
CreationDate	Date and time of the creation of the row.
EndDateTime	End date and time of the shift or exception that specifies the details.
LastUpdateDate	Date and time of the last update of the row.
LastUpdateLogin	Session login associated to the user who last updated the row.
LastUpdatedBy	User who last updated the row.
ObjectVersionNumber	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.
RequestId	Request ID of the job that created or last updated the row.
ScheduleDetailId	Value that uniquely identifies a detail record for a schedule. This is the primary key of the Schedule Details view object.
ScheduleId	Value that uniquely identifies the schedule that the details are for. This is a foreign key to the Schedules view object.
ShiftId	Value that uniquely identifies the shift used to define the details. This is a foreign key to the Shifts view object.
StartDateTime	Start date and time for the shift or exception that specifies the details.