Skip to Main Content
Return to Navigation

Setting Up Approval Framework for Data Migration

Approval Framework is included in PeopleSoft applications as part of Enterprise Components. A set of approvals is included for Data Migration Workbench. If activated and configured, this approval process is triggered when the user clicks the Submit for Copy button.

The ProcessID MigrateData contains all of the information necessary to route approvals to the appropriate approvers and take the necessary action when a transaction is approved, denied, or pushed back.

To configure and activate the Approval Framework process for MigrateData:

  1. Assign the appropriate role in the user profile for the approvers.

  2. Define workflow for user profile.

  3. Create and maintain user list definition.

  4. Set up the Approval Process for Data Migration.


Assigning Data Migration Roles

Two roles are delivered for Data Migration approvals:



You can use these roles or create new roles as needed for your approvers.

To assign data migration roles to a user profile:

  1. Select select PeopleTools, then select Security, then select User Profiles, then select User Profiles, then select Roles (USER_ROLES).

  2. Insert the role or roles.

  3. Save the page.

Defining Workflow for User Profile

In order to receive approval notifications, the user must have the worklist option selected in the user profile.

To set up a workflow user:

  1. Select select PeopleTools, then select Security, then select User Profiles, then select User Profiles

  2. Select the user profile, or create a new one.

  3. Access the Workflow (USER_WORKFLOW) page.

  4. Select the Worklist check box.

Creating and Maintaining User List Definition

A user list is a collection of users (PeopleSoft User IDs) expressed as the result of a SQL statement, PeopleSoft role, or PeopleSoft Application Class. User lists are used to represent the business process of your approval hierarchy on a transaction-by-transaction basis. PeopleSoft delivers pre-defined user lists. If none of the delivered user lists apply to your organization's hierarchy, then you can define your own using the User List Setup component (Enterprise Components, Approvals, Approvals, User List Setup).

There are two delivered User Lists for Data Migration Workbench, however you can use any of the user lists that apply for your applications.

User List



Based on the role EOMW_REVIEWER. The transaction will be routed to any user that has the role EOMW_REVIEWER defined in the user profile.


Based on the role EOMW_APPROVER. The transaction will be routed to any user that has the role EOMW_APPROVER defined in the user profile.

For more information on setting up user lists see Approval Framework, Defining Notification Templates and Users for Approval Framework.

Setting up the Approval Process for Data Migration

To set up approval process definitions, use the Setup Process Definitions (EOAW_PRCS) component.

Business analysts use this component to define an approval process definition. The process is made up of stages and their paths and steps. The approval steps that you place on the approval path represent the approval levels that are required for a transaction.

Approval Flow



A stage is one part of an approval process that can contain multiple paths. The system executes stages in sequence where one must complete the stage before the next one begins. A stage can be at the header or line level. For Data Migration only the header level is used.


A path contains a sequence of steps. Within a stage, paths execute in parallel. Path entry criteria determines whether or not a path executes for a given transaction.


A step represents one or more approvers or reviewers. Steps within a path execute in sequence. Separate criteria for each step determines whether or not that step executes. Each step can also have a set of reviewers.

Typical approval processes for Data Migration might include:

  • Supervisor or Manager to review data that will be copied to the database.

  • Manager to approve the data migration before it is copied to the database.

  • Two different approvers for each step, where both approvers at a step must approve the request for it to advance to the next step.

Example Approval Process Definition

This section provides an example of how to set up an approval process definition for a transaction that is specific to MigrateData.

To set up the approval process definition:

  1. Select select Enterprise Components, then select Approvals, then select Approvals, then select Setup Process Definitions.

  2. Select ProcessID MigrateData.

Image: Set Up Process Definition page

This example illustrates the fields and controls on the Set Up Process Definition page. You can find definitions for the fields and controls later on this page.

Set Up Process Definition page

In the Definition Options section, the process definition needs to be set to Active.

In this example the approval process contains two stages – Supervisor and Copy Scheduler. Each stage has one path and one step. The first stage requires supervisor approval before the data migration project can be routed to the Copy Scheduler. When the copy scheduler approves the request (final approval), the data migration project will be scheduled for copy in the Process Scheduler.

You can define multiple stages, paths, and steps for an approval process definition. For example, perhaps you require administrator approval for the copy request. In this case, you would create an additional path within the existing stage that contains one step requiring administrator approval.

The Approval Framework processes multiple stages and steps sequentially. The engine cannot advance to the next step until you complete the preceding step in the given path. Likewise, the engine cannot advance to the next stage until you complete all paths within a given stage. For paths, however, you can define them as static (processed sequential) or dynamic (processed in parallel).


By default, the criteria will be Always True, which means if the process definition for MigrateData is active, Approval Framework will always be invoked.

You can add logic that the Approval Framework evaluates at runtime for a Boolean result. You can define criteria at the definition, path, or step level. To set up criteria, click the Definition Criteria link at the top of the Setup Process Definitions page for the definition, for path and step criteria, click the associated criteria icon for that path or step.

Image: Criteria Definition page

This example illustrates the fields and controls on the Criteria Definition page.

Criteria Definition page

Refer to the Approval Framework PeopleBook, Setting Up Approval Framework Process Definitions, Defining Criteria for Approval Framework Processes for details on how to define the criteria.