Period Start Dates for Extraction

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

Data Store Key : FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.PeriodStartDateExtractPVO

Primary Keys : PrdStartDateId

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 period 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.
PrdStartDate Start date for a period in the schedule.
PrdStartDateId Value that uniquely identifies a period start date for a schedule. This is the primary key of the Period Start Dates view object.
PriorDate Value that identifies the prior period start date.
RequestId Request ID of the job that created or last updated the row.
ScheduleId Value that uniquely identifies the schedule that the period 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 period start date in the schedule.