Using the Dynamic Role User Queries

Use one of the three dynamic Structured Query Reports (SQRs) that query your live human resources database when a workflow involving a Supervisor role is triggered. You select and assign a role user query to the Supervisor routings based on whether you're driving your PeopleSoft Human Resources system by full, partial, or no Position Management. The following table lists the role queries from which you can select. Select the one that is appropriate for your human resources implementation.

Functionality	Query
Full Position Management	[ROLE] Supervisor-Full Posn Mgt (supervisor - full position management)
Position Management turned off	[ROLE] Supervisor-No Posn Mgt
Partial Position Management	[ROLE] Supervisor-Part Posn Mgt

Using the dynamic role user query method ensures that the Supervisor role user assignment is as accurate as your live human resources data. The dynamic query also frees you from maintaining two sets of human resources supervisor data, one in your human resources system and the other in the Role User Table.

The default query is [ROLE] Supervisor-Part Posn Mgt Role User Query. All generic PeopleTools workflows use that query. The query does not run against your live human resources database, but against the Role User Table.

To use one of the other Supervisor role user queries in PeopleSoft Workflow, you must modify all routings involving supervisors.