JIRA Reference:
Report Purpose
This query is used by UMS - Campus Solutions Security Liaisons and provides information on users who have the security role provided at the prompt. There are also prompts for Institution and Current Term. When entering the role name at the prompt, the query allows the use of a wildcard '%'. For example, to search for any role name that contains 'SUPERUSER' enter '%SUPERUSER%' at the Role Name prompt.
The Current Term is used for gathering information for users who may be teaching. The query results also provide employee job information.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Campus Solutions-9.2 > PS Query tile > Query Manager or Query Viewer
Report Name
UMS_SEC_AUDIT_BY_ROLE_BY_INST
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
Security Liaisons: for the list of roles currently in use, see the Managing Campus Solutions Security page and access the Security Liaisons Team Drive (restricted).
Data Fields Generated
Role Name | User ID | Name | Pay Status | Instr/Advisor? | Teaching? | Other UMS | Oth UMS Pay Status | Oth UMS Dept Desc | Oth UMS Position Descr | Term Date | Reg/Temp | Rehire Dt | DeptID | Dept Desc | Position Descr |
---|
Tables Use
- ROLEUSER_VW - Role User View
- UM_FGLEMPLOY_VW
- PSOPRDEFN - Operator Definition
- CLASS_INSTR - Class Instructor Table
- INSTR_ADVISOR - Instructor/Advisor
New to PeopleSoft Query?
Click on Getting Started and begin with the Query Basics video
Need help running a report?
Click on Running Reports with Query Viewer & Query Manager or How to Run an SQR for simple how-to guides for running reports. If you've followed the path to an SQR location and cannot see the report, your PeopleSoft settings may need adjustments. Please see Security Questions (PS Query/Discoverer).
HELP IS AT HAND!
Question, comment, critique? We are here to help and we strive to make our site a comprehensive, user friendly experience. Contact us at DARTS@maine.edu.