PeopleSoft Campus Solutions provides a functionality known as /mass change/ which allows online development of batch processing SQL. Mass change is used in a number of delivered areas of Campus Solutions including:
- User Profile Management and creation
- 3Cs (Communications/Checklists/Comments)
Mass Change Type
Mass Change Template
Mass Change Definition
Mass Change Group
Mass Change Security
Mass change security is defined using mass change operator security which is a misnomer. Mass change security is in fact associated with permission lists. You can use the following query to determine the role and permission lists associated with a mass change template.
Note that mass change security is based on the primary permission list of the user logged into the system. If your primary permisison list doesn't have the mass change security you require, you will not be able to access the mass change templates regardless of whether they are in other permission lists in your user profile.
select RC.ROLENAME, RC.CLASSID, MOS.MC_TEMPLATE_ID from PS_MC_OPR_SECURITY MOS inner join PSROLECLASS RC on MOS.OPRID = RC.CLASSID order by RC.ROLENAME
