Mass Change

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:

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
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License