Implementing SQLViews

To implement a registered sqlView interface:

Note:

Implement registered sqlView interfaces as PeopleSoft record definitions with a type of view.

1. Create fields on the record definition to correspond to each field in the registered sqlView interface.

2. Run SQL Create to create the view in the database.

3. Open the sqlView registry entry and add the implementation record name to the registry entry.

   When you are creating a new interface view, you must use the Registry Wizard component. When you are updating an existing view, you must use access the registry and click the Update button. The system then displays the Registry Wizard component.

   See Registering New Interfaces.