# Campus Solutions Security

> Audit Campus Solutions row-level security grants across user defaults, academic structure, 3C groups, and administrative domain tables.

---

LLMS index: [llms.txt](/llms.txt)

---

## 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.

<figure><img src="/images/screenshots/campus-solutions-security.png"
			alt="Campus Solutions Security panel on User detail page showing Academic Institution, Career, and Program access"><figcaption>
			<p>Campus Solutions Security panel on the User detail page with the sidebar toggle enabled</p>
		</figcaption>
</figure>


### 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.