By default, the PowerCenter Integration Service extracts all rows from PeopleSoft records. However, you can specify to select only the current rows from the effective dated PeopleSoft record. Use the following transformation options in the Application Source Qualifier to alter the default query for effective dated PeopleSoft Records:

When you select Extract Current Rows, the default query includes a WHERE clause to select rows from records that meet the current date requirements. Use the Extract Date option to specify the current date when extracting current rows. Leave the option blank to use the PowerCenter Integration Service current date.