Campus Solutions Security

Campus Solutions Security

Campus Solutions row-level security governs application-level data access for academic institutions, careers, programs, plans, and student administrative domains. Unlike PeopleTools row-security permission lists (PSCLASSDEFN assigned via ROWSECCLASS), Campus Solutions security grants granular row-level data authorizations per user ID (OPRID) across 19 application tables.

What It Inspects

psLens queries the underlying Campus Solutions security tables to display effective user authorizations inline on the User detail page (/users/{oprid}):

• User Defaults (OPR_DEF_TBL_CS, OPR_DEFAULT_TBL): User-level default parameters for Academic Institution, Academic Career, Academic Program, Academic Plan, Term, Aid Year, Business Unit, SetID, Campus, Admission Application Center, and Recruiter Center.
• Academic Structure Security (SCRTY_TBL_INST, SCRTY_TBL_CAR, SCRTY_TBL_PROG, SCRTY_TBL_PLAN, SCRTY_TBL_ACAD): Authorizations for Academic Institutions, Academic Careers, Academic Programs, Academic Plans, and Academic Organizations.
• 3C Group Security (OPR_GRP_3C_TBL): Administrative access for Checklists, Comments, and Communications 3C security groups.
• Student & Administrative Domain Security: Authorizations for Student Groups (SCRTY_TBL_STGP), Service Indicators (SCRTY_TBL_SRVC), Milestones (SCRTY_TBL_MLSTN), Campus (SCC_STY_TBL_CMP), Admissions Actions (SCRTY_ADM_ACTN), Program Actions (SCRTY_PROG_ACTN), Application Centers (SCRTY_APPL_CTR), Recruiting Centers (SCRTY_RECR_CTR), Test Loads (SAD_TEST_SCTY), Transcripts (SCRTY_TSCRPT, SSR_SCRTY_TSRPT), and Advisement Reports (SAA_SCRTY_AARPT).

Access & Export Paths

• User Detail Page Toggle: Turn on the Campus Solutions Security switch under Related Data on any user detail page (/users/{oprid}) to fetch and render CS security grants inline.
• Full User Access Report: Includes Campus Solutions row-level security tables when generating on-demand or scheduled user access reports.
• Markdown Export: Incorporates all active Campus Solutions user defaults and security table grants into the user definition Markdown export (/users/{oprid}/export).

When It’s Useful

• Auditing what student data, academic structures, or administrative centers an advisor, registrar staff member, or admissions officer can access.
• Verifying user default values (OPR_DEF_TBL_CS) when troubleshooting transaction failures or missing prompt list entries in PIA.
• Reviewing effective user access during security audits without querying 19 separate security tables in SQL.