Administrative Actions Guides

The following information details how to issue permission numbers to students wishing to add a course and how to drop students from a course.

Log into SFSU Gateway
Navigate to your LaunchPad
Click the Campus Solutions tile
- If tile is not present, click the See all apps button
- Navigate to the Tools header
- Select the Campus Solutions tile from the options presented
Select Campus wide reporting
Select Enrollment analysis report
Enter the report parameters

Note: Any parameter with a search icon (magnifying glass) can be looked up by selecting the icon.
- Institution (SFCPM for SFSU)
- Term (e.g., 2153 for Spring 2015)
- College (e.g., 40)
- Academic Organization (e.g., 476 - MKTG)
- Subject (e.g., CHEM)
- Catalog/Course Number (use % before the number, e.g., %115)
- Session (e.g., R1)
Click View results
Optional: Click Excel spreadsheet, CSV text file, or XML file to download the results to a file of that type

SFSU uses a naming schema for queries. All queries use the following format:

The name should be a single word
Names are limited to 30 characters
Query names begin with SFO_CS_
The next two letters indicate the data area (SR = Student Records, AA = Academic Advising, SF = Student Financials, AD = Admissions, FA = Financial Aid, etc.)
The final characters should abbreviate what the query is for or the type of data returned

Log into SFSU Gateway
Navigate to your LaunchPad
Click the Campus Solutions tile
- If tile is not present, click the See all apps button
- Navigate to the Tools header
- Select the Campus Solutions tile from the options presented
Select Reporting Tools > Query > Query Viewer
Enter a full or partial query name in the Search by field (for incomplete query names use % as a wildcard)
Click Search
Select how to view results:
- On the Web: Click the HTML link for the correct query
- In Excel: Click the Excel link for the correct query
If prompted to enter extra parameters, enter requested items (e.g., Term).

Note: For format assistance, click the magnifying glass icon.
Click View Results
Wait while the query processes (processing icon will appear). When processing finishes, results will be displayed at the bottom of the page
Optional: Click the Excel Spreadsheet link to download
Optional: Click the Favorite link for a particular query to have the query appear every time you launch Query Viewer

Frequently Used Queries
Name	Descriptions
SFO_CS_SR_CRSE_SUM_ENRL	Enrollment numbers by Class and Section
SFO_CS_SR_DEPT_ADVISING_RSTR	Department advising roster
SFO_CS_SR_ELIGIB_NOT_ENRL	List of students who are term activated but not enrolled
SFO_CS_SR_DEPT_ADVISE_RSTR_MAJ	Advising Roster by Major
SFO_CS_SR_CRSE_ENRL_BY_ORG	Enrollment numbers by Class, Section and Academic Org
SFO_CS_SR_COLL_ADVISING_RST	Roster by College (e.g., HSS)
SFO_CS_SR_COLL_ADV_PLAN_RST	Roster by College with Plan (e.g., all HSS with Plan, Email, Mail, Phone, Probation, First Gen, Acad Level, Enroll Status, Admit Data, Pell)
SFO_CS_SR_CLASS_EMAIL_RSTR	List of students, name and email, of a class section
SFO_CS_SR_EXPECTED_GRAD	List of students expected grad term
SFO_CS_SR_ACCEPTED_APPLS	Accepted applicants by Dept and Academic Org
SFO_CS_SR_DEPT_ENROLLMENTS	Enrollments by Term and Dept
SFO_CS_SR_ESP_GLOBDB_ENRL_SRVC	List of early start service students with payment record
SFO_CS_SR_CRSE_ENRL_AD	Enrollment numbers by Class and Section
SFO_CS_SR_STDNT_WAITLIST	List of students on waitlist by STRM, Session Code, ID, Last Name, First Name, Subject, Catalog Number, Class_nbr, Section, Enroll Status, Status Reason, Student Position
SFO_CS_SR_STDNT_WAIT_BY_DEPT	List of students on waitlist by Dept, STRM, Session Code, ID, Last Name, First Name, Subject, Catalog Number, Class_nbr, Section, Enroll Status, Status Reason, Student Position