When you import a PeopleSoft record, you connect to the PeopleSoft system to access the PeopleSoft metadata tables. The Designer uses metadata in these tables to create the source definition. You cannot configure this metadata manually.

You can import the following PeopleSoft record definitions into the repository:

You can import records from two tabs in the Import from PeopleSoft dialog box:

In the Import from PeopleSoft dialog box, the Designer displays the record name as it appears in the underlying database. Since the record name might differ from the PeopleSoft business name, the Import from PeopleSoft dialog box also displays the PeopleSoft business name for each record.

When you import a PeopleSoft record with an effective date, the Designer adds a new column to the source definition, TO_EFFDT. The TO_EFFDT column defines the end date for a range of valid dates.