Week Start Dates for Extraction

The Week Start Dates for Extraction view object collects the start date for each week in a schedule.

Data Store Key : FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.WeekStartDateExtractPVO

Primary Keys : WeekStartDateId

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 row.
CreationDate Date and time of the creation of the row.
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.
NextDate Value that identifies the next week start date.
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.
PriorDate Value that identifies the prior week start date.
RequestId Request ID of the job that created or last updated the row.
ScheduleId Value that uniquely identifies the schedule that the week start date is for. This is a foreign key to the Schedules view object.
SeqNum Value that starts from 0 and increases by 1 for every week start date in the schedule.
WeekStartDate Start date for a work week in the schedule.
WeekStartDateId Value that uniquely identifies the work week start date for a schedule. This is the primary key of the Week Start Dates view object.